Using a span of 3, forecast the price of this stock for the next trading day with the moving average method. Round your answer to the nearest cent, if necessary.

$

How well does this method with span 3 forecast the known observations in this series? Round your answer to three decimal places, if necessary.

Root mean square error:  

1. Using a span of 6, forecast the price of this stock for the next trading day with the moving average method. Round your answer to the nearest cent, if necessary.

   $

   How well does this method with span 6 forecast the known observations in this series? Round your answer to three decimal places, if necessary.

   Root mean square error:  

2. Which of these two spans appears to be more appropriate? Justify your choice.

   The more appropriate span is Select36Item 5  because it has the Select higher lower Item 6  root mean square error.

Date	Adjusted Close
15-Jun-17	79.51
16-Jun-17	80.25
19-Jun-17	80.67
20-Jun-17	81.29
21-Jun-17	81.00
22-Jun-17	81.03
23-Jun-17	81.01
26-Jun-17	81.73
27-Jun-17	81.85
28-Jun-17	82.73
29-Jun-17	82.39
30-Jun-17	83.00
3-Jul-17	83.84
5-Jul-17	83.95
6-Jul-17	82.81
7-Jul-17	83.40
10-Jul-17	83.37
11-Jul-17	83.23
12-Jul-17	83.88
13-Jul-17	84.43
14-Jul-17	84.34
17-Jul-17	84.28
18-Jul-17	84.57
19-Jul-17	84.98
20-Jul-17	84.41
21-Jul-17	84.64
24-Jul-17	84.06
25-Jul-17	84.47
26-Jul-17	84.36
27-Jul-17	82.92
28-Jul-17	83.86
31-Jul-17	84.29
1-Aug-17	84.30
2-Aug-17	84.36
3-Aug-17	84.59
4-Aug-17	85.02
7-Aug-17	84.90
8-Aug-17	84.99
9-Aug-17	84.74
10-Aug-17	83.63