Using the time series data in the table, respond to the following items. Period Sales 1 $ 1,001 2 1,129 3 841 4 1,044 5 1,014 6 703 7 682 8 712 9 646 10 686 11 909 12 469 13 566 14 488 15 688 16 675 17 303 18 381 d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 2 decimal places.) Period Sales Predicted Sales Absolute Error 1 1,001 1,026.85 25.85 2 1,129 990.60 138.40 3 841 954.35 113.35 4 1,044 918.10 125.90 5 1,014 881.85 130.24 6 703 845.53 ______ 7 682 809.30 127.30 8 712 773.07 61,07 9 646 736.84 90.84 10 686 700.61 14.61 11 909 664.38 _____ 12 469 628.15 159.15 13 566 591.92 25.92 14 488 _____ _______ 15 688 ______ ______ 16 675 _______ ______ 17 303 _______ _______ 18 381 ________ ________ d-2. What is the MAD? (Round your answer to 2 decimal places. MAD____________ d-3. What is the trend equation based on the regression analysis? (Round your answers to 2 decimal places.) Sales = __________ - ___________ time period
Using the time series data in the table, respond to the following items.
Period | Sales | ||
1 | $ | 1,001 | |
2 | 1,129 | ||
3 | 841 | ||
4 | 1,044 | ||
5 | 1,014 | ||
6 | 703 | ||
7 | 682 | ||
8 | 712 | ||
9 | 646 | ||
10 | 686 | ||
11 | 909 | ||
12 | 469 | ||
13 | 566 | ||
14 | 488 | ||
15 | 688 | ||
16 | 675 | ||
17 | 303 | ||
18 | 381 | ||
d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 2 decimal places.)
Period Sales Predicted Sales Absolute Error
1 1,001 1,026.85 25.85
2 1,129 990.60 138.40
3 841 954.35 113.35
4 1,044 918.10 125.90
5 1,014 881.85 130.24
6 703 845.53 ______
7 682 809.30 127.30
8 712 773.07 61,07
9 646 736.84 90.84
10 686 700.61 14.61
11 909 664.38 _____
12 469 628.15 159.15
13 566 591.92 25.92
14 488 _____ _______
15 688 ______ ______
16 675 _______ ______
17 303 _______ _______
18 381 ________ ________
d-2. What is the MAD? (Round your answer to 2 decimal places.
MAD____________
d-3. What is the trend equation based on the
Sales = __________ - ___________ time period
e. What is the predicted annual change of industry sales? (Round your answer to 2 decimal places.)
Predicted annual change of industry sales ____________
f. Predict sales for the next three periods. (Round your answers to 2 decimal places.)
Sales (19) _____________
Sales (20 _______________
Sales (21) _______________
Trending now
This is a popular solution!
Step by step
Solved in 4 steps