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