Clipboard Font Alignment - X fx Problem 5. The closing prices of Apple stocks (AAPL) for each tr G A B C D E F H 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. Paste B I U .. . A Clipboard Font X V fr Problem 5. The closing prices of - w 14 17 AB CDE Date Close 7/1/2016 $95.89 7/5/2016 $94.99 7/6/2016 $95.53 7/7/2016 $95.94 7/8/2016 $96.68 9 7/11/2016 $96.98 10 7/12/2016 $97.42 11 7/13/2016 $96.87 12 7/14/2016 $98.79 13 7/15/2016 $98.78 7/18/2016 $99.83 15 7/19/2016 $99.87 16 7/20/2016 $99.96 7/21/2016 $99.43 18 7/22/2016 $98.66 19 7/25/2016 $97.34 20 7/26/2016 $96,67 7/27/2016 $102.95 22 7/28/2016 $104.34 23 7/29/2016 $104.21 24 8/1/2016 $106.05 8/2/2016 $104.48 8/3/2016 $105.79 8/4/2016 $105.87 28 8/5/2016 $107.48 8/8/2016 $108.37 30 8/9/2016 $108.81 31 8/10/2016 $108.00 32 8/11/2016 $107.93 33 8/12/2016 $108.18 34 8/15/2016 $109.48 35 8/16/2016 $109.38 36 8/17/2016 $10971 21 Paste BI ULOA , Font Clipboard fx Problem 5. The closing prices E B 30 8 8/5/2016 $107.48 29 8/8/2016 $108.37 8/9/2016 $108.81 31 8/10/2016 $108.00 32 8/11/2016 $107.93 33 8/12/2016 $108.18 34 8/15/2016 $109.48 35 8/16/2016 $109.38 36 8/17/2016 $109.22 8/18/2016 $109.08 38 8/19/2016 $109.36 39 8/22/2016 $108.51 40 8/23/2016 $108.85 41 8/24/2016 37