Refer to the gasoline sales time series data in Table 171 of

Refer to the gasoline sales time series data in Table 17.1 of the Text Book (12^th Edition). (Use Excel for this problem. Copy paste Excel Tables into your report for answering questions). Compute two- week, three-week, and four- week moving average forecasts for the time series data. Compute Measures of Forecast Accuracy like MAE, MSE, and MAPE. Which method of forecasting of the three (two, three, or four- week moving average models) would you prefer to use for future forecasting purposes? Justify your answer.

Solution