Question
Using the time series data in the table, respond to the following items. Period Sales 1 1001 2 1129 3 841 4 1044 5 1012
Using the time series data in the table, respond to the following items.
Period | Sales |
1 | 1001 |
2 | 1129 |
3 | 841 |
4 | 1044 |
5 | 1012 |
6 | 703 |
7 | 682 |
8 | 712 |
9 | 646 |
10 | 686 |
11 | 909 |
12 | 469 |
13 | 566 |
14 | 488 |
15 | 688 |
16 | 675 |
17 | 305 |
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 | ? | ? |
2 | 1,129 | ? | ? |
3 | 841 | ? | ? |
4 | 1,044 | ? | ? |
5 | 1,012 | ? | ? |
6 | 703 | ? | ? |
7 | 682 | ? | ? |
8 | 712 | ? | ? |
9 | 646 | ? | ? |
10 | 686 | ? | ? |
11 | 909 | ? | ? |
12 | 469 | ? | ? |
13 | 566 | ? | ? |
14 | 488 | ? | ? |
15 | 688 | ? | ? |
16 | 675 | ? | ? |
17 | 305 | ? | ? |
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
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.)
Predicted Sales | |
Sales (19) | ? |
Sales (20) | ? |
Sales (21) | ? |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started