1. (POSSIBLY USE STATTOOL IN EXCEL)
2. 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 _________________

3. 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: _______________________

Date	Adjusted Close
19-Apr-17	74.43
20-Apr-17	78.84
21-Apr-17	78.41
24-Apr-17	79.26
25-Apr-17	79.44
26-Apr-17	79.33
27-Apr-17	79.14
28-Apr-17	78.08
1-May-17	78.06
2-May-17	78.36
3-May-17	77.67
4-May-17	77.17
5-May-17	77.16
8-May-17	77.01
9-May-17	77.28
10-May-17	77.49
11-May-17	76.77
12-May-17	76.35
15-May-17	77.17
16-May-17	76.98
17-May-17	75.24
18-May-17	75.25
19-May-17	75.67
22-May-17	75.84
23-May-17	76.06
24-May-17	75.98
25-May-17	76.30
26-May-17	76.32
30-May-17	75.95
31-May-17	75.80
1-Jun-17	77.12
2-Jun-17	77.33
5-Jun-17	77.80
6-Jun-17	77.69
7-Jun-17	78.63
8-Jun-17	78.77
9-Jun-17	79.12
12-Jun-17	78.99
13-Jun-17	79.40
14-Jun-17	79.65