Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 1 13 21 14 20 23 15 (a) Choose the correct time series plot. (i) 30 25 20 Value 15 10 7 1 2 3 4 5 6 Month (ii) 30 20 Value 15 10 6 2 5 7 1 3 4 Month (iii) 30(iii) 30 25 20 Value 15 10 1 2 3 4 5 6 7 Month (iv) 30 25 20 Value 10 1 2 3 4 5 6 Month Graph (iii) v 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.Month Graph (iii) 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? - Select your answer - (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. 0 =