Insert Arial 10 AA = = ab General Ex Ap O 1x Delete Paste Sort & Find & Analyze Sensitivity Money BIUVV MAV I V $ ~ % 9 08 28 Conditional Format as Cell Formatting " Table Styles Format D Filter ~ Select Data in Excel Clipboard V Font Alignment Number Styles Cells Editing Analysis Sensitivity | Money in Excel K47 X V fx B C D E F G H I J K L M N P Q R S T U V W X Time Series #1 Time Series #1 MAD 19.47 5 0 VOU A WN 160 Period Data MA Forecast Absolute Error 92 107 105 140 11 108 122 50 0 VOUIAN- 106 120 99 84 97 10 88 100 104 102 129 82 Data 80 104 -MA Forecast 110 60 40 20 0- 103.4 26.4 03.6 39.6 95 50 107 96 11 81 100 19 111 94.8 16.2 93 101.6 8.6 95 107.4 12.4 91 97.4 6.4 136 94.2 41.8 104 105.2 1.2 11 103.8 14.2 108.8 36.8 104.2 15.2 102 103.8 18 Time Series #1 |Time Series #2 + 1 4E Insert LO Arial 10 AA ab General Ex A O x Delete Paste BIUVV MAV I V $ % 9 Conditional Format as Cell Sort & Find & Analyze Sensitivity Money Formatting Table v Styles Format Filter ~ Select Data in Excel Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity I Money in Excel G49 X V C D E F G H K M N O P Q R S T U V W X 97 1 82 95.4 13.4 133 88.2 44.8 107 100.4 6 6 102 104 2 70 104 34 98.8 36.2 109.4 27.4 99.2 32 97 18 99.6 8.6 103.8 9.8 95.6 21.4 02.6 31 .6 97.6 23.4 98.8 22.2 04.8 49 8 97 16 39.8 28.8 37.8 9 .8 79.2 13.2 68.2 54 .8 1.8 1 .8 31.6 16.4 11 93.4 38.4 31.2 1.2 84 .6 15.4 88 .6 4.4 37.6 13.4 37.8 25.8 39.2 26.8 34.4 4.6 34.2 5.2 93.4 6.6 93.2 42 98.6 23.4 99.8 34 8 93 16 90.6 10.4 79 90.8 11.8 93 8 8 .8 4.2 101 83 18 141 90.2 50.8 83 103 20 74 99.4 25.4 120 98.4 21.6 85 103.8 18.8 123 100.6 22.4 92 97 84 98.8 14.8 Time Series #1 |Time Series #2 +Insert Arial v 10 A A = = = 27 v General Ex APO PX Delete Paste BIUV $ ~ % 9 00 20 Conditional Format as Cell Sort & Find & Analyze Sensitivity Money MYAv Formatting Table Styles v Format Filter ~ Select v Data in Excel Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity | Money in Excel G49 X V fx B C D E F G H J K L M N O P Q R S T U V W X 77 100 89 11 55 93.4 38.4 90 91.2 1.2 100 34.6 15.4 74 93 38.6 4.4 75 101 37.6 13.4 62 37.8 25.8 116 89.2 26.8 99 94.4 4.6 89 94 .2 5.2 100 93. 4 6 .6 89 93.2 4.2 122 98.6 23.4 65 99.8 34 .8 93 16 101 90.6 10.4 90.8 11.8 93 88.8 4.2 101 83 18 141 90.2 50 8 83 103 20 74 99.4 25.4 120 98.4 21.6 85 103 .8 18.8 123 100.6 22.4 92 97 5 84 98.8 14.8 131 100.8 30.2 145 103 42 86 115 29 120 107.6 12.4 101 113.2 113 114 115 116 119 120 121 122 123 124 126 127 Time Series #1 |Time Series #2 +Insert Arial 10 A A General EV AY X Delete Conditional Format as Cell Sort & Find & Analyze Sensitivity Money Paste BIU v MVA v $ ~ % 9 08 28 Formatting " Table Styles v Format D. Filter ~ Select Data in Excel Analysis Sensitivity | Money in Excel Clipboard Font Alignment Number Styles Cells Editing D14 X V fx D E F G H I J K L M N O P Q R S T U V W X B C Time Series #2 Time Series #2 MAD 9.32 180 - CO VOUT A WIN Period Data MA Forecast Absolute Error 108 93 160 10 112 11 113 101 140 99 110 117 112 120 121 125 120 100 117 Data 128 114 -MA Forecast 118 80 119 111 111 60 119 13 143 140 40 143 153 20 130 14 148 143 132 139. 7.6 124 14.6 119 137.4 18.4 139 133.2 5 .8 129 131.4 2.4 120 128.6 8.6 130 126.2 3.8 114 127.4 134 123 126.4 3.4 124 123.2 0.8 116 122.2 6 2 10 121.4 18.4 111 116 5 103 115.4 12.4 97 111.4 14.4 Time Series #1 Time Series #2 +Insert Arial 10 ab EV AY O LO AA = =: General X Delete Conditional Format as Cell Sort & Find & Analyze Sensitivity Money Paste BIUV MVAv I V $ ~ % 9 00 -20 Formatting Table Styles v Format Filter ~ Select v Data in Excel Styles Cells Editing Analysis Sensitivity | Money in Excel Clipboard Font Alignment Number D14 X V fx F G H K L M N O P Q R S T U V W X Y C E 101 106 NOT 105 103 92 103.4 11.4 105 99.6 5.4 96 100 4 99.8 96.4 6.4 93.4 3.6 94.4 16 32.6 10.6 89.8 10.8 38.8 78 87 8 83.4 3.6 31.6 25.4 36.6 30.4 34.2 14.8 39.8 8.2 105.6 13.6 106.6 5.6 105.4 4.4 102.2 17.8 133 104.4 28.6 112 109.4 2.6 110 113.4 3.4 115.2 4.2 117.2 20.2 112.6 28.6 102.8 0.2 101 8 100.8 0.8 98.6 20.6 94.8 48 12 92.2 5.2 37.8 6.8 11 87.4 12.4 34.4 0.6 84.6 13.6 31.4 24 81 4 79 17 76.4 6.4 73.4 8.6 75.6 6.4 76.2 6 .8 75.8 5.2 79.6 0.4 31.6 2.4 82 3 Time Series #1 Time Series #2 +Insert Ex Ap O Arial 10 A A General Delete Conditional Format as Cell Sort & Find & Analyze Sensitivity Money Paste BIU LY I V $ ~ % 9 08 20 D Formatting Table Styles Format Filter ~ Select v Data in Excel Styles Cells Editing Analysis Sensitivity | Money in Excel Font Number Clipboard Alignment D14 X V fx E F G H J K L M N 0 P Q R S T U V W X B C D 67 60 107 81.6 25.4 68 61 117 86.6 30.4 62 109 94.2 148 63 108 9 9 .8 8.2 92 105.6 13.6 101 106.6 5.6 101 105.4 4.4 120 102.2 17.8 8 898 133 104. 28.6 112 109.4 2.6 110 113.4 3.4 111 115.2 42 117.2 20.2 112.6 28.6 102.8 0.2 109 101 8 100 00.8 0.8 78 98.6 20.6 94.8 4.8 96 12 92.2 5.2 37.8 6.8 84 11 87.4 12.4 84.4 0.6 84.6 13.6 81.4 2.4 81 4 79 17 76.4 6.4 73.4 8.6 75.6 6.4 76.2 6 .8 75.8 5.2 79.6 0.4 2.4 3 12.6 2.4 83 6 $ 4.6 17.4 118 89 29 101 95.8 111 112 113 114 115 116 117 Time Series #1 Time Series #2 +