I need help with C MSE answer and E. Please.

Problem 15-05 (Algorithmic) Consider the following time series data. 4 5 6 Week 1 2 3 Value 19 14 17 12 1 17 14 What type of pattern exists in the data? Horizontal Pattern b. Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. Time Series Week Forecast Value 1 19 2 14 3 17 4 12 16.67 5 17 14.33 6 14 15.33 MSE: 10.22 The forecast for week 7: 14.33 C. Use a = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. Time Series Week Value Forecast 1 19 2 14 19.00 3 17 18.00 4 12 17.80 5 17 16.64 6 14 16.71 MSE: 11.19 X The forecast for week 7: 16.17 d. Compare the three-week moving average forecast with the exponential smoothing forecast using a = 0.2. Which appears to provide the better forecast based on MSE? Three-week moving average e. Use trial and error to find a value of the exponential smoothing coefficient a that results in a smaller MSE than what you calculated for a = 0.2. Find a value of a for the smallest MSE. Round your answer to three decimal places. a = 0.44 X