Use the data in the Excel file Baseball Attendance to do the following:

a). Develop spreadsheet models for forecasting attendance using single moving average and single exponential smoothing.

b). Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing.

Answer rating: 100% (QA)

Excel ... View the full answer