Exponential Smoothing Absolute Squared Absolute Percentage Month Demand (alpha 0
ID: 418754 • Letter: E
Question
Exponential Smoothing Absolute Squared Absolute Percentage Month Demand (alpha 0.4) Error Error Error Error 530 552 653 687 680 702 768 515 529.8 579.08 622.25 645.35 668.01 708.01 735.6 737.76 785.06 803.03 810.62 8139.57 225 492.84 5464.17 4192.82 1200.7 1155.37 3599.33 1713.68 10.48 5032.88 727.15 129.49 458.4323943.92 15 22.2 73.92 64.75 34.65 33.99 59.99 41.4 3.24 70.94 26.97 11.38 15 22.2 73.92 64.75 34.65 33.99 59.99 41.4 3.24 70.94 26.97 11.38 458.43 2.83% 4.02% 11.32% 9.43% 5.10% 4.84% 7.81% 5.33% 0.44% 8.29% 3.25% 1.38% 64.03% 4 5 741 856 830 822 9098 10 12 TotalExplanation / Answer
here n=12
CFE=sum of error= 458.43
MFE=Mean Forecast error= summation (error)/n=458.43/12=38.20
MSE= mean suqared error= sum of squared error/n= 23943.92/12= 1995.32
standard deviation=A=0.4
MAD=mean absoute deviation= sum of absolute error/n = 458.43/12= 38.20
MAPE= mean absolute percentage error= sum of absolute percentage error/n= 64.03%/12= 5.33%
(note here sum ie total is already caluculated in the table given in the question)