ons Problem 08-06 Algo (Moving Averages and Exponential Smoothing) Question 2 of 5 Hint(s) Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 15 20 12 18 22 15 (a) Choose the correct time series plot. (i) Value 30 20 22 25 15 10 OU Month Graph (ii) What type of pattern exists in the data? Horizontal pattern (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation. MSE: The forecast for month 8: (c) Use a 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation. MSE: The forecast for month 8: (d) Compare the three-month moving average forecast with the exponential smoothing forecast using a = 0.2. Which appears to provide the better forecast based on MSE? 3-month moving average v (e) Use trial and error to find a value of the exponential smoothing coefficient a that results in the smallest MSE. Do not round intermediate calculations. Use a two-decimal digit precision for the exponential smoothing coefficient. a O Leon Key Hint(s)