1. Use the simple moving average model for forecasting using 5 weeks and 3 weeks past data. Please include calculations on excel. Evaluate the forecasts that would have been made over the 13 weeks using the overall (at the end of the 13 weeks) mean absolute deviation for each of the cities.Please include calculations on excel.
2. Use the exponential smoothing model for forecasting. In your analysis, test two alpha values, 0.2 and 0.4. For the model using an alpha of 0.4, assume that the forecast for week 1 is the past five-week average. Evaluate the forecasts that would have been made over the 13 weeks using the overall (at the end of the 13 weeks) mean absolute deviation for each of the cities.Please include calculations on excel.
3. Use the linear regression model on the data provided. Evaluate the forecasts that would have been made over the 13 weeks using the overall (at the end of the 13 we (week 1 is the week before week 1 in the table, 2 is two weeks before week 1, etc.).eks) mean absolute deviation for each of the cities.Please include calculations on excel.