Question: In the Data Analysis & Decision Making with Microsoft® Excel textbook, review the answer provided here for the following Chapter 13 problem:

? Problem 36 (A and B), page 752.

The problem was - How well does the moving average method track this series when the span is 4 day; whenthe span is 12 days? Using the more appropriate span, forecast the closing value of this index on the next trading day with the moving average method. (The second assignment template is the solutions to this problem.)

Then use the StatTools solution provided to answer the following two questions:

? Which is the better predictor – the Four Day Span or the Twelve Day Span?

? Justify your reason for selecting a Four Day or Twelve Day Span.

Instructions

1. It is important that you use the Excel template provided with this assignment to answer this problem.