Question: Using the time series data in the table, respond to the following items. Period Sales 1 $ 1 , 0 0 1 2 1 ,

Using the time series data in the table, respond to the following items.
Period Sales
1 $ 1,001
21,129
3843
41,044
51,012
6703
7682
8712
9646
10686
11909
12469
13566
14488
15688
16675
17303
18381
Click here for the Excel Data File
d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 2 decimal places.)
d-2. What is the MAD? (Round your answer to 2 decimal places.)
d-3. What is the trend equation based on the regression analysis? (Round your answers to 2 decimal places.)
e. What is the predicted annual change of industry sales? (Round your answer to 2 decimal places.)
f. Predict sales for the next three periods. (Round your answers to 2 decimal places.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!