Homework SourseI need the MSE for five week moving average Weeks Actual Va
I need the MSE for five week moving average =
| Weeks | Actual Value | Forecast Value | Forecast Error | Squared Forecast Error | |
| 6 | 15.000 | 19.400 | -4400 | ? | |
| 7 | 21.000 | 18.800 | 2200 | ? | |
| 8 | 19.000 | 18.600 | 400 | ? | |
| 9 | 21.000 | 19.400 | 1600 | ? | |
| 10 | 20.000 | 18.800 | 1200 | ? | |
| 11 | 16.000 | 19.200 | -3200 | ? | |
| 12 | 22.000 | 19.000 | 3000 | ? |
Solution
week actual value forecast value Forecast error Error^2 6 15000 19400 -4400 19360000 7 21000 18800 2200 4840000 8 19000 18600 400 160000 9 21000 19400 1600 2560000 10 20000 18800 1200 1440000 11 16000 19200 -3200 10240000 12 22000 19000 3000 9000000 MSE= Suma(error^2) 47600000= 6800000 n 7
