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

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


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


b. Repeat part a with a span of 10.


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