Using the time series data in the table, respond to the following items. Period Sales 1 $ 615 2 678 3 761 4 710 5 784 6 801 7 852 8 698 9 1,193 10 1,115 11 1,231 12 1,259 13 1,495 14 1,229 15 1,652 16...


Using the time series data in the table, respond to the following items.
























































































































PeriodSales
1$615
2678
3761
4710
5784
6801
7852
8698
91,193
101,115
111,231
121,259
131,495
141,229
151,652
161,337
171,673
181,613





d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression?(Round your answers to 3 decimal places.)


























































































































PeriodSalesPredicted SalesAbsolute Error
1615
2678
3761
4710
5784
6801
7852
8698
91,193
101,115
111,231
121,259
131,495
141,229
151,652
161,337
171,673
181,613







d-2. What is the MAD?(Round your answer to 3 decimal places.)











d-3. What is the trend equation based on the regression analysis?(Round your answers to 3 decimal places.)





Sales =  __________ + _______________ time period






e. What is the predicted annual change of industry sales?(Round your answer to 3 decimal places.)











f. Predict sales for the next three periods.(Round your answer to 3 decimal places.)
























Predicted Sales
Sales (19)
Sales (20)
Sales (21)



Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here