File Home Insert Page Layout Formulas Data Review View Help Calibri Paste 11 A A Wrap Text General BIU v Av Merge & Center $ % 9 Clipboard Font Alignment Number 1 AutoSum Fill Conditional Format as Cell Formatting Table Styles Insert Delete Format Clear Filter Sort & Find & Select Styles Cells Editing Q45 fx A B C D E F G H J K L M N P Q R 1 2 3 NAIVE Two-Period MA EXPOENTIAL SMOOTHING 4 Period, t ales (Actua Forecast Error |Error] Error %Error Forecast Error [Error] Error %Error Forecast Error |Error] Error %Error 5 1 (Mon) 488.57 6 2 (Tue) 492.71 488.57 7 3 (Wed) 506.5 492.71 8 4 (Thu) 496.29 506.5 9 5 (Fri) 489 10 6(Sat) 461.93 11 7 (Sun) 508.64 12 496.29 489 461.93 2935.00 4.14 13.79 -10.21 -7.29 -27.07 46.71 4.14 13.79 10.21 7.29 27.07 46.71 20.07 109.21 3279.30 17.14 190.16 104.24 0.84 2.72 2.06 490.64 499.61 15.86 15.86 251.54 3.13 488.57 488.98 4.14 17.52 4.14 17.52 17.14 0.84 306.81 3.46 -3.32 3.32 10.99 0.67 490.74 5.55 5.55 30.85 1.12 53.14 1.49 501.40 -12.40 12.40 153.64 2.53 491.29 -2.29 2.29 5.25 0.47 732.78 2181.82 5.86 492.65 -30.72 30.72 9.18 22.15 475.47 2459.75 33.18 2.61 33.18 95.46 943.41 1100.58 2460.16 6.65 491.06 -29.13 29.13 848.67 6.31 6.52 19.51 488.15 20.49 2938.79 16.28 20.49 419.89 79.12 1628.61 16.22 4.03 13 14 15 16 MAD= 15.60 MSE= 546.55 MAPE= 3.16 MAD= 19.09 MSE= 615.04 MAPE= 3.90 MAD= 13.19 MSE= 325.72 MAPE= 2.70 17 18 19 20