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. | |
| α = |