The file P14_22.xlsx contains the daily closing prices of American Express stock for a one-year period. a. Using a span of 3, forecast the price of this stock for the next trading day with the moving...

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

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

b. Repeat part a with a span of 10.

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