PLEASE SHOW FORMULAS USING EXCEL

following: a) Forecast the closing price of the stock for the next trading day, i.e., for August 24, 2016. b) Forecast the closing prices of the stock from July 11 through August 23 and calculate errors, absolute errors and absolute percentage errors c) Calculate MAE and MAPE for July 11 through August 23. d) Plot the actual and forecasted closing prices on a single graph. Error Foreca Absolute errol Absolute percentage errors mos 96.53 97.03 97.09 197.69 98.15 99.13 99.94 99.89 99.75 -0.45 -0.39 0.22 11 -0.63 -0.7 -0.38 -0.07 0.32 0.59 1.14 Date Close Forecast 7/1/16 $95.89 7/5/16 $94.99 7/6/16 $95.53 7/7/16 $95.94 8 7/8/16 $95,68 7/11/16 $96.98 10 7/12/16 $97.42 11 7/13/16 $95.87 12 7/14/16 $98.79 13 7/15/16 $98.78 14 7/18/16 $99.83 15 7/19/16 $99.87 16 7/20/16 $99.96 17 7/21/16 $99.43 18 7/22/16 $98.65 7/25/16 $97.34 20 7/26/16 $96.67 21 7/27/16 $102.95 22 7/28/16 $104.34 7/29/16 $104.21 24 8/1/16 $106.05 B/2/16 $104.45 26 8/3/16 $105.79 27 8/4/16 $105.87 28 8/5/16 $107.48 29 8/8/16 $108.37 30 8/9/16 $108,81 31 8/10/16 S108.00 32 8/11/16 S107.93 33 8/12/16 $108.18 34 8/15/16 $109.46 35 8/16/16 $109.38 36 B/17/16 5109.22 37 B/18/16 $109.08 38 8/19/16 $109.36 39 8/22/16 S108.51 40 8/23/15 $IORS Error Foreca Absolute erro Absolute percentage errors SNM 96.53 97.03 97.09 97.69 98.15 99.13 99.94 99.89 99.75 -0.45 -0.39 0.22 -1.1 -0.63 -0.7 -0.38 -0.07 0,32 0.69 1.14 - 3 Date Close Forecast 4 7/1/16 $95.89 5 7/5/16 $94.99 6 7/6/16 $95.53 7 7/7/16 $95.94 & 7/8/16 $96.68 9 7/11/16 $96.98 10 7/12/16 $97.42 11 7/13/16 $96.87 12 7/14/16 $98.79 13 7/15/16 $98.78 14 7/18/16 $99.83 15 7/19/16 $99.87 16 7/20/16 $99.96 17 7/21/16 $99.43 18 7/22/16 $98.66 19 7/25/16 $97.34 20 7/26/16 $96.67 21 7/27/16 $102.95 22 7/28/16 $104.34 23 7/29/16 $104.21 24 8/1/16 $106.05 25 8/2/16 $104.48 8/3/16 $105.79 27 8/4/16 $105.87 28 8/5/16 $107.48 29 8/8/16 $108.37 30 B/9/15 $108.81 31 8/10/16 $108.00 32 8/11/16 $107.93 33 8/12/16 $108.18 34 8/15/16 $109.48 35 8/16/16 $109.38 36 8/17/16 $109.22 37 8/18/16 $109.08 98 8/19/16 $109.36 39 8/22/16 $108.51 40 8/23/16 $108.85 41 8/24/16 S108.91 42 43 44 45 46 42 NNNN SMS 45 an Esa ra