The attached spreadsheet contains demand for a period of 24 months. Use this data set to
answer the following questions:
1. Plot the data. Just by looking at the plot, do you think a 3-week simple moving average
would be a better forecast, or a 6-week simple moving average? Just by looking at the plot,
do you think an exponential smoothing with value of α = 0.1 would be better forecast or
would α = 0.3 be better? Explain your reasoning.