Please show all work and use EXCEL to solve. Thank you

Problem 4: Forecasting American Express closing prices are presented in the Template for Span of 5 tab. Create a moving averages forecasting model for a span of 5. Also complete the following: Calculate Forecasted prices, Errors, Absolute Errors, Absolute Percentage Errors, MAE, and MAPE. b. Create three graphs: i. Original observation ii. Forecasted and Original Observations iii. Forecast error Date Close Forecast Error Absolute Absolute Error Percentage Error Span of 5 MAE MAPE 15-Oct-03 16-Oct-03 17-Oct-03 20-Oct-03 21-Oct-03 22-Oct-03 23-Oct-03 24-Oct-03 27-Oct-03 $48.30 $48.38 $47.84 $47.92 $48.40 $47.04 $47.63 $47.62 $46.75 $47.54 $47.35 $46.52 $46.93 $47.23 $47.12 $47.31 $47.37 $46.50 28-Oct-03 29-Oct-03 30-Oct-03 31-Oct-03 3-Nov-03 4-Nov-03 5-Nov-03 6-Nov-03 7-Nov-03 A B 10-NOy03 $46.08 $45.48 l-NOV-03 12-NOV-03 $46.02 25 13-NOV-03 $45.80 14-NOV-03 $45.33 12-Nov-03 $43.93 16-Nov-03 $44.48 29 15 NOV- $44.88 3) 20-NOV-03 $44.40 21-Nov-03 $44.90 24-NOV-03 $45.15 25-NOV-03 $45.35 34 2-NOV-03 $45.73 35 28-NOV-03 $45.71 1 DECO3 $46.05 - LE) $45.80 38 3-Dec-03 $45.99 39 - PC-03 $46.07 4) E-DRC-03 $45.50 41 BDEE - 03 $46.15 42 9-Dec-03 $45.70 43 1 - LDL 3 $45.19 11-Dec-03 $45.25 45 12-Dec-03 46 15-Dec-03 16-Dec-03 $45.20 $45.31 $45.27 $45.00 $46.77 $47.21 17-Dec-03 18-Dec-03 50 19-Dec-03 51 22-Dec-03 $47.44 52 23-Dec-03 $47.68 24-Dec-03 $47.88 26-Dec-03 $47.83 55 29-Dec-03 $48.50 56 30-Dec-03 $48.29 31-Dec-03 $48.23 58 2-Jan-04 $47.75 $48.17 59 5-Jan-04 60 6-Jan-04 $48.25 61 7-Jan-04 $48.39 62 8-Jan-04 $48.25 9-Jan-04 $47.89 64 12-Jan-04 $47.70 65 13-Jan-04 $47.87 66 14-Jan-04 $48.75 67 15-Jan-04 $49.68 68 16-Jan-04 $49.91 69 20-Jan-04 $50.24 70 21-Jan-04 $50.40 22-Jan-04 $50.00 72 23-Jan-04 $49.96 26-Jan-04 $50.95 27-Jan-04 $50.48 28-Jan-04 $49.75 29-Jan-04 $50.95 30-Jan-04 $51.84 78 2-Feb-04 $52.54 3-Feb-04 $52.51 80 4-Feb-04 $52.26 5-Feb-04 $52.08 HD 6-Feb-04 $53.06 83 9-Feb-04 $53.11 10-Feb-04 $52.85 11-Feb-04 $53.71 86 12-Feb-04 $53.35 13-Feb-04 $53.65 88 17-Feb-04 $53.68 $53.40 89 18-Feb-04 90 19-Feb-04 $53.40 91 20-Feb-04 $53.16 92 23-Feb-04 $53.06 93 24-Feb-04 $53.18 94 25-Feb-04 $53.58 95 26-Feb-04 $53.39 96 27-Feb-04 $53.42 97 1-Mar-04 $53.65 2-Mar-04 $53.41 99 3-Mar-04 $53.49 100 4-Mar-04 $53.36 101 5-Mar-04 $52.77 102 8-Mar-04 $53.14 103 9-Mar-04 $53.18 $52.19 $51.53 104 10-Mar-04 105 11-Mar-04 106 12-Mar-04 107 15-Mar-04 $52.12 $50.95 108 16-Mar-04 $50.65 $51.00 109 17-Mar-04 110 18-Mar-04 $51.56 19-Mar-04 $51.08 22-Mar-04 $50.21 $50.21 113 23-Mar-04 24-Mar-04 $50.03 115 25-Mar-04 $49.95 116 26-Mar-04 $50.03 29-Mar-04 $50.86 118 30-Mar-04 $51.91 119 31-Mar-04 $51.85 120 $52.20 121 $52.43 122 $52.59 1-Apr-04 2-Apr-04 5-Apr-04 6-Apr-04 7-Apr-04 8-Apr-04 123 $52.40 $52.38 125 $52.14 126 12-Apr-04 $52.26 127 $51.40 128 $49.80 13-Apr-04 14-Apr-04 15-Apr-04 16-Apr-04 129 $49.75 130 $50.58 $50.21 $49.51 $49.88 $50.78 $50.27 $50.28 $50.15 $49.04 $49.04 $48.95 $49.39 131 19-Apr-04 132 20-Apr-04 133 21-Apr-04 134 22-Apr-04 135 23-Apr-04 136 26-Apr-04 137 27-Apr-04 138 28-Apr-04 139 29-Apr-04 140 30-Apr-04 141 3-May-04 4-May-04 143 5-May-04 6-May-04 145 7-May-04 146 10-May-04 147 11-May-04 - 148 12-May-04 149 13-May-04 150 14-May-04 151 17-May-04 152 18-May-04 153 19-May-04 142 $49.31 $49.52 $49.18 $48.49 $48.25 $48.14 $48.21 $48.47 $48.86 $48.77 $48.99 $48.84 $49.33 $49.63 $49.93 154 20-May-04 155 21-May-04 156 24-May-04 157 25-May-04 158 26-May-04 159 27-May-04 160 28-May-04 $50.46 $50.25 $51.02 $50.70 161 1-Jun-04 $50.60 162 2-Jun-04 $50.92 163 3-Jun-04 $50.75 164 4-Jun-04 $50.98 165 7-Jun-04 $51.45 166 8-Jun-04 $51.67 167 9-Jun-04 $51.23 168 10-Jun-04 $51.20 169 14-Jun-04 $51.05 170 15-Jun-04 $51.22 171 16-Jun-04 $51.51 172 17-Jun-04 $51.46 173 18-Jun-04 $51.96 21-Jun-04 $51.50 175 22-Jun-04 $51.50 176 23-Jun-04 $51.39 177 24-Jun-04 $50.96 178 25-Jun-04 $51.35 179 28-Jun-04 $50.94 180 29-Jun-04 $51.27 181 30-Jun-04 $51.38 182 1-Jul-04 $51.33 183 2-Jul-04 $51.24 184 6-Jul-04 $50.83 185 7-Jul-04 $51.01 186 8-Jul-04 $50.27 187 9-Jul-04 $50.01 188 12-Jul-04 $49.71 189 13-Jul-04 $49.49 190 14-Jul-04 $49.25 191 15-Jul-04 $48.90 192 16-Jul-04 $48.73 193 19-Jul-04 $48.45 194 20-Jul-04 $49.12 21-Jul-04 $48.35 196 22-Jul-04 $48.33 23-Jul-04 $48.11 198 26-Jul-04 $48.90 $49.44 $49.89 $49.96 $50.25 $50.28 $49.91 $50.21 $49.55 $49.34 $49.30 199 27-Jul-04 200 28-Jul-04 201 29-Jul-04 202 30-Jul-04 203 2-Aug-04 204 3-Aug-04 205 4-Aug-04 206 5-Aug-04 207 6-Aug-04 208 9-Aug-04 20910-Aug-04 210 11-Aug-04 211 12-Aug-04 212 13-Aug-04 213 16-Aug-04 214 17-Aug-04 215 18-Aug-04 216 19-Aug-04 217 20-Aug-04 218 23-Aug-04 219 24-Aug-04 220 25-Aug-04 $50.09 $50.13 $49.47 $49.35 $49.42 $49.73 $50.03 $49.83 $50.00 $49.70 $49.75 $49.95 $50.12 $50.00 $49.63 $50.02 $50.11 $50.47 $50.26 $50.99 $50.94 $50.90 $51.33 221 26-Aug-04 222 27-Aug-04 223 30-Aug-04 224 31-Aug-04 225 1-Sep-04 226 2-Sep-04 227 3-Sep-04 228 7-Sep-04 229 8-Sep-04 230 9-Sep-04 231 10-Sep-04 232 13-Sep-04 233 14-Sep-04 234 15-Sep-04 235 16-Sep-04 236 17-Sep-04 237 20-Sep-04 238 21-Sep-04 239 22-Sep-04 240 23-Sep-04 241 24-Sep-04 242 27-Sep-04 $51.49 $51.33 $50.90 $50.90 $51.40 $51.16 $51.48 $50.87 $50.87 $51.21 $50.65 243 28-Sep-04 244 29-Sep-04 245 30-Sep-04 $50.83 $51.38 $51.46 $51.65 $52.63 246 1-Oct-04 4-Oct-04 248 5-Oct-04 $52.76 249 6-Oct-04 $53.27 250 7-Oct-04 $53.07 251 8-Oct-04 $52.25 252 11-Oct-04 $52.53 253 12-Oct-04 $52.71 254 13-Oct-04 $52.15 255 14-Oct-04 $51.71 256 15-Oct-04 $52.50