SOLVE USING EXCEL SHOWING STEP BY STEP

Problem 5. The closing prices of Apple stocks (AAPL) for each trading day from July 1 until August 23, 2016 are presented below. Using moving averages method with a span of 3, complete the 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. Date 7/1/16 7/5/16 7/6/16 7/7/16 7/8/16 7/11/16 7/12/16 7/13/16 7/14/16 7/15/16 7/18/16 7/19/16 7/20/16 7/21/16 7/22/16 7/25/16 7/26/16 7/27/16 7/28/16 7/29/16 8/1/16 8/2/16 Close $95.89 $94.99 $95.53 $95.94 $96.68 $96.98 $97.42 $96.87 $98.79 $98.78 $99.83 $99.87 $99.96 $99.43 $98.66 $97.34 $96.67 $102.95 $104.34 $104.21 $106.05 $104.48 8/3/16 $105.79 8/4/16 $105.87 8/5/16 $107.48 8/8/16 $108.37 8/9/16 $108.81 8/10/16 $108.00 8/11/16 $107.93 8/12/16 $108.18 8/15/16 $109.48 8/16/16 $109.38 8/17/16 $109.22 8/18/16 $109.08 8/19/16 $109.36 8/22/16 $108.51 8/23/16 $108.85 8/24/16 Problem 5. The closing prices of Apple stocks (AAPL) for each trading day from July 1 until August 23, 2016 are presented below. Using moving averages method with a span of 3, complete the 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. Date 7/1/16 7/5/16 7/6/16 7/7/16 7/8/16 7/11/16 7/12/16 7/13/16 7/14/16 7/15/16 7/18/16 7/19/16 7/20/16 7/21/16 7/22/16 7/25/16 7/26/16 7/27/16 7/28/16 7/29/16 8/1/16 8/2/16 Close $95.89 $94.99 $95.53 $95.94 $96.68 $96.98 $97.42 $96.87 $98.79 $98.78 $99.83 $99.87 $99.96 $99.43 $98.66 $97.34 $96.67 $102.95 $104.34 $104.21 $106.05 $104.48 8/3/16 $105.79 8/4/16 $105.87 8/5/16 $107.48 8/8/16 $108.37 8/9/16 $108.81 8/10/16 $108.00 8/11/16 $107.93 8/12/16 $108.18 8/15/16 $109.48 8/16/16 $109.38 8/17/16 $109.22 8/18/16 $109.08 8/19/16 $109.36 8/22/16 $108.51 8/23/16 $108.85 8/24/16