The file P12_16.xlsx contains the daily closing prices of American Express stock for an eight-week period.

1. Using a span of 3, forecast the price of this stock for the next trading day with the moving average method. Round your answer to the nearest cent, if necessary.

$__________

How well does this method with span 3 forecast the known observations in this series? Round your answer to three decimal places, if necessary.

Root mean square error: __________

1. Using a span of 6, forecast the price of this stock for the next trading day with the moving average method. Round your answer to the nearest cent, if necessary.

$________

How well does this method with span 6 forecast the known observations in this series? Round your answer to three decimal places, if necessary.

Root mean square error: __________

https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fcnow.apps.ng.cengage.com%2Filrn%2Fbooks%2Falba07h%2Fdatafile%2Fresource%2Fch12%2F12_16%2F12_16_1%2FP12_16.xlsx&wdOrigin=BROWSELINK