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

Answer 1

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

D)the preadicate values is

E) the value of MAD is 885.76

And MSE is 1.567