Homework SourseThe table above is to be used as an aidtemplate The table be
The table above is to be used as an aid/template.
The table below has to be filled out. Can someone help me with this? I don\'t understand it.
| n | CFE | |Dt-Ft| | |Dt-Ft|/n | |||
| PERIOD | (Dt-Ft) BIAS | (Dt-Ft)/n BIAS mean | ABSOLUTE DEVIATION | ABSOLUTE DEVIATION mean | MAPE | |
| 1. Simple Moving Average | 9 | 716.7 | 79.63 | 3,396.7 | 377.4 | 39.1% |
| 2. Weighted Moving Average | 9 | 658.8 | 73.19 | 3,315.3 | 368.4 | 37.4% |
| 3. Exponential Smoothing | ||||||
| = 0.1 | 12 | 1.09 | 0.09 | 3,566.4 | 297.2 | 33.7% |
| = 0.3 | 12 | -47.6 | -3.97 | 2,961.1 | 246.8 | 28.2% |
| 4. Trend-Adjusted Exponential Smoothing | 11 | -599.4 | -54.49 | 3,120.1 | 283.6 | 30.0% |
| 5. Seasonal Influenced | 5 | -399.0 | -79.8 | 399.0 | 79.8 | 3.1% |
Solution
Time C1 Smooth Predict Error
1 10696 10008.8 9971.6 724.44
2 9665 9991.1 10008.8 -343.84
3 10179 10000.8 9991.1 187.86
4 11760 10091.3 10000.8 1759.19
5 9150 10042.9 10091.3 -941.35
6 9571 10018.6 10042.9 -471.90
7 8375 9934.0 10018.6 -1643.62
8 11826 10031.4 9934.0 1891.97
9 10696 10065.6 10031.4 664.60
10 11212 10124.6 10065.6 1146.40
11 9750 10105.3 10124.6 -374.60
12 9380 10068.0 10105.3 -725.32
MAPE 9
MAD 906
MSD 1132108
