This is all there is to this question.

The Excel table must include:

1) Time period

2) Observation

3) Forecast

4) Dev

5) (Dev)^2

6) Absolute Dev

7) Absolute Percent Dev

Given the quarterly sales data for a particular brand of sports shoes at a sporting goods store shown below: (a) Develop a four-period moving average model and compute MSE for your forecasts. Provide the relevant screenshots of the Excel spreadsheet. (10 marks) (b) Find a good value of for a single exponential smoothing model and compare your results to part (a). (15 marks) (c) The store manager asks you whether to use time-series or regression-based forecasting models. Illustrate the key similarities and differences between these two methods. (15 marks)