The closing value of the Dow Jones Industrial Index for each trading day for a 1-year period is provided in the file P16_24.xlsx.   a. Using a span of 2 days, forecast this index for the next trading...

The closing value of the Dow Jones Industrial Index for each trading day for a 1-year period is provided in the file P16_24.xlsx.


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


b. Repeat part a with a span of 5 days; with a span of 15 days. c. Which of these three spans appears to be most appropriate? Explain your choice.