In: Math
Consider the following time series data:
Month 1 2 3 4 5 6 7
Value 23 15 20 12 18 22 15
(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 α = 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: | |
(e) | Use trial and error to find a value of the exponential smoothing coefficient α that results in the smallest MSE. |
If required, round your answer to two decimal places. | |
α = |