FORCASTING Three Weighted Moving Average (3WMA) = (0.10), (0.
20) (0.70) Compute:
MAE, MSE, MAPE
Month SALES
80 1
140 2
200 3
260 4
320 5
380 6
440 7
500 8
560 9
720 10
Weighted average forecast x't = w1*xt-1+w2*xt+w3*xt+1
Month | Sales | Forecasts |
1 | 80 | |
2 | 140 | 176 |
3 | 200 | 236 |
4 | 260 | 296 |
5 | 320 | 356 |
6 | 380 | 416 |
7 | 440 | 476 |
8 | 500 | 536 |
9 | 560 | 666 |
10 | 720 |
excel formulas
Month | Sales | Forecasts | Error | Absolute error | Square error | Percentage error |
1 | 80 | |||||
2 | 140 | 176 | -36 | 36 | 1296 | 25.71429 |
3 | 200 | 236 | -36 | 36 | 1296 | 18 |
4 | 260 | 296 | -36 | 36 | 1296 | 13.84615 |
5 | 320 | 356 | -36 | 36 | 1296 | 11.25 |
6 | 380 | 416 | -36 | 36 | 1296 | 9.473684 |
7 | 440 | 476 | -36 | 36 | 1296 | 8.181818 |
8 | 500 | 536 | -36 | 36 | 1296 | 7.2 |
9 | 560 | 666 | -106 | 106 | 11236 | 18.92857 |
10 | 720 | |||||
MAE = 44.75 | MSE = 2538.5 | MAPE = 14.07 |
Get Answers For Free
Most questions answered within 1 hours.