1. Compute moving average forecasts of interval 3 (MA(2). Use GasolineRevised.xlsx

1. What is the forecast for week 22?
2. What is MAE?
3. What is MSE?
4. What is MAPE?

2. Compute moving average forecasts of interval 3 (MA(3). Use GasolineRevised.xlsx

5. What is the forecast for week 22?
6. What is MAE?
7. What is MSE?
8. What is MAPE?

3. Compute moving average forecasts of interval 3 (MA(5). Use GasolineRevised.xlsx

1. What is the forecast for week 22?

10. What is MAE?
11. What is MSE?

50. What is MAPE?

4. Compute exponential smoothing forecasts with smoothing constant a=0. Use GasolineRevised.xlsx

1000. What is the forecast for week 22?
14. What is MAE?
15. What is MSE?
16. What is MAPE?

5. Compute exponential smoothing forecasts with smoothing constant a=.3. Use GasolineRevised.xlsx

17. What is the forecast for week 22?
18. What is MAE?
19. What is MSE?
20. What is MAPE?

6. Compute exponential smoothing forecasts with smoothing constant a=1. Use GasolineRevised.xlsx

21. What is the forecast for week 22?

5. What is MAE?

23. What is MSE?

10. What is MAPE?

7. Compute regression modeling forecasts. Use a significance level of .05. Use GasolineRevised.xlsx

25. What is the forecast for week 22?
26. What is MAE?
1. What is MSE?
28. What is MAPE?
55. Is there a trend in the data?

Week	Sales (1000s of gallons)
1	17
2	21
3	19
4	23
5	18
6	16
7	20
8	18
9	22
10	20
11	15
12	22
13	31
14	34
15	31
16	33
17	28
18	32
19	30
20	29
21	34
22	33

thank you