Question

# Please use SPSS for analysis if available Will give positive feedback for answering all questions! Question:...

Please use SPSS for analysis if available

Will give positive feedback for answering all questions!

Question:

The sales data of a company's sales records is provided.

a. Plot a time-series plot of the data

b. Fit a Linear trend line to these data

c. Conduct a hypothesis test of the linear trend model developed in part b. Use significance level of 0.05

d. State the predicted value of sales from 2005 to 2020

e. Calculate MAD and MSE for the linear trend forecasts developed

DATASET:

 Year Sales 2005 878 2006 983 2007 1085 2008 1276 2009 1502 2010 1738 2011 2044 2012 2238 2013 2388 2014 2488 2015 2978 2016 3267 2017 3375 2018 3575 2019 3866 2020 3980

The time series plot is b) The linear model is

Sales=442548-221.07(year)

C) the hypothesis is

H0:-slope=0

The regression Coefficient is equal to zero

D)

H1:- slope=/0

The regression coefficient is not equal to zero E) the value of MAD is 885.76

And MSE is 1.567

#### Earn Coins

Coins can be redeemed for fabulous gifts.