Instructions: Create an Excel workbook. Put your answers for each part in a different worksheet

1) The Excel file Closing Stock Prices provides data for four stocks and the Dow Jones Industrial Average over a one-month period.

a) Develop a spreadsheet for forecasting CSCO using simple two-period and simple three period moving average models. b) Develop a spreadsheet for forecasting CSCO using simple exponential smoothing withconstants of 0.3 and 0.8. c) Compute MAD, MSE, and MAPE for each model and determine the best model.

Closing Stock Prices