A firm is interested in forecasting the level of gas sales based on 16 periods of historical data. The data file for this problem is gassales. csv. (a.) Develop a predicted sales column using a 2-month moving average.
(b.)Develop a predicted sales column using a 3-month moving average.
(c.) Develop 4 predicted sales columns using exponential smoothing. (Use values of alpha of .2, .4, .6, and .8 for this exercise.)
(d.)For each of the predicted sales columns above, please produce forecasts for period 17 through period 20.
(e.) Using the Root MSE metric in assessing accuracy, which of the techniques produced the most accurate forecasts?
Time Perio Gasoline Sales
1 39
2 37
3 61
4 58
5 18
6 56
7 82
8 27
9 41
10 69
11 49
12 66
13 54
14 42
15 55
16 66