👤
Answered

Using the time series data in the table, respond to the following items.Period Sales1 $ 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 303 18 381 Click here for the Excel Data Filed-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.)

Answer :

Forecast Absolute is (d-1)

What is Forecast Absolute?

Absolute value refers to the fact that even a negative gap between the actual and anticipated demand turns positive. 25 divided by 4 equals 6.25, so. Since the demand error is not proportional, the MAD computation performs best when applied to a single product.

1026.62 25.62

990.38 138.62

954.15 113.15

917.91 126.09

881.67 130.33

845.44 142.44

809.20 127.20

772.97 60.97

736.73 90.73

700.49 14.49

664.26 244.74

628.02 159.02

591.78 25.78

555.55 67.55

519.31 168.69

483.07 191.93

446.84 143.84

410.60 29.60

(d-2) 111.15

(d-3) y = 1062.86 + (-36.24)*x

(e) decrease by 36.24

(f)

374.37

338.13

301.89

To learn more about Forecast Absolute visit

https://brainly.com/question/15173326

#SPJ4

Go Teaching: Other Questions