1) Consider the following time series data Month Value 1 20 2 14 3 25 4 16 5 30 6 24 7 16 a Compute MSE using the average of last two values as the forecast for the next period. What is the forecast for month 82 B. Compute MSE using the average of all the data available as the forecast for the next period. What is the forecast for month 82 C Do you have any explanations for it? 2) Consider the following time series data Month Value 1 24 2 23 3 19 4 25 5 20 6 23 7 25 a Using excel, construct a time series plot. What type of pattern exists in the data? b. Develop a three-week moving average for this time series. Compute MSE and a forecast for week 8. Use a = 0.3 to compute the exponential smoothing values for the time series Compute MSE and a forecast for C week: 8 d. Compare the three-week moving average forecast with the exponential smoothing forecast using a = 0.3. Which appears to provide the better forecast based on MSE