The attached file contains the daily closing prices of American Express stock for a one-year period.

1 - Using a span of 3, forecast the price of this stock for the next trading day with the moving average method.How well does this methodwith span 3 forecast the known observations in this series?

2- Repeat the moving average method with a span of 10.

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

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

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

11-Aug-17 83.36

14-Aug-17 84.53

15-Aug-17 85.83

16-Aug-17 86.42

17-Aug-17 85.14

18-Aug-17 84.44

21-Aug-17 84.36

22-Aug-17 84.36

23-Aug-17 84.34

24-Aug-17 84.42

25-Aug-17 84.53

28-Aug-17 84.47

29-Aug-17 84.48

30-Aug-17 84.74

31-Aug-17 85.15

1-Sep-17 85.19

5-Sep-17 84.37

6-Sep-17 84.29

7-Sep-17 83.48

8-Sep-17 83.32

11-Sep-17 84.74

12-Sep-17 85.59

13-Sep-17 85.68

14-Sep-17 85.24

15-Sep-17 86.03

18-Sep-17 86.90

19-Sep-17 88.02

20-Sep-17 87.45

21-Sep-17 87.44

22-Sep-17 87.42

25-Sep-17 87.23

26-Sep-17 87.71

27-Sep-17 88.50

28-Sep-17 89.14

29-Sep-17 89.46

2-Oct-17 89.54

3-Oct-17 90.42

4-Oct-17 90.00

5-Oct-17 90.50

6-Oct-17 90.89

9-Oct-17 91.03

10-Oct-17 91.22

11-Oct-17 91.29

12-Oct-17 90.95

13-Oct-17 92.19

16-Oct-17 91.29

17-Oct-17 91.03

18-Oct-17 91.41

19-Oct-17 91.23

20-Oct-17 91.42

23-Oct-17 91.71

24-Oct-17 93.18

25-Oct-17 92.85

26-Oct-17 95.00

27-Oct-17 95.10

30-Oct-17 94.38

31-Oct-17 94.83

1-Nov-17 95.10

2-Nov-17 95.29

3-Nov-17 95.73

6-Nov-17 95.59

7-Nov-17 94.68

8-Nov-17 94.44

9-Nov-17 93.07

10-Nov-17 92.84

13-Nov-17 93.22

14-Nov-17 93.08

15-Nov-17 92.59

16-Nov-17 92.88

17-Nov-17 93.01

20-Nov-17 93.27

21-Nov-17 93.73

22-Nov-17 93.14

24-Nov-17 92.80

27-Nov-17 92.79

28-Nov-17 94.59

29-Nov-17 95.90

30-Nov-17 97.00

1-Dec-17 97.15

4-Dec-17 97.88

5-Dec-17 98.00

6-Dec-17 97.50

7-Dec-17 97.87

8-Dec-17 97.84

11-Dec-17 98.28

12-Dec-17 98.65

13-Dec-17 97.07

14-Dec-17 96.45

15-Dec-17 97.81

18-Dec-17 98.96

19-Dec-17 98.43

20-Dec-17 97.80

21-Dec-17 97.79

22-Dec-17 98.03

26-Dec-17 97.86

27-Dec-17 98.41

28-Dec-17 98.98

29-Dec-17 98.59

2-Jan-18 98.22

3-Jan-18 98.83

4-Jan-18 100.47

5-Jan-18 100.70

8-Jan-18 99.78

9-Jan-18 100.14

10-Jan-18 100.84

11-Jan-18 100.35

12-Jan-18 100.59

16-Jan-18 99.97

17-Jan-18 100.38

18-Jan-18 99.49

19-Jan-18 97.66

22-Jan-18 97.95

23-Jan-18 97.61

24-Jan-18 98.93

25-Jan-18 99.32

26-Jan-18 99.26

29-Jan-18 99.04

30-Jan-18 98.34

31-Jan-18 99.03

1-Feb-18 99.63

2-Feb-18 96.32

5-Feb-18 91.67

6-Feb-18 93.83

7-Feb-18 93.26

8-Feb-18 88.01

9-Feb-18 91.38

12-Feb-18 94.35

13-Feb-18 94.21

14-Feb-18 95.87

15-Feb-18 96.20

16-Feb-18 96.43

20-Feb-18 96.83

21-Feb-18 97.14

22-Feb-18 96.99

23-Feb-18 98.43

26-Feb-18 101.26

27-Feb-18 99.21

28-Feb-18 97.15

1-Mar-18 94.78

2-Mar-18 95.24

5-Mar-18 96.30

6-Mar-18 95.71

7-Mar-18 95.28

8-Mar-18 96.23

9-Mar-18 98.68

12-Mar-18 97.31

13-Mar-18 95.01

14-Mar-18 94.18

15-Mar-18 94.04

16-Mar-18 95.25

19-Mar-18 94.49

20-Mar-18 94.60

21-Mar-18 94.39

22-Mar-18 91.07

23-Mar-18 90.11

26-Mar-18 92.27

27-Mar-18 91.08

28-Mar-18 91.87

29-Mar-18 92.93

2-Apr-18 90.66

3-Apr-18 92.39

4-Apr-18 93.23

5-Apr-18 94.20

6-Apr-18 91.91

9-Apr-18 92.14

10-Apr-18 93.00

11-Apr-18 91.60

12-Apr-18 93.35

13-Apr-18 93.03

16-Apr-18 93.60

17-Apr-18 93.86

18-Apr-18 95.15