Discuss the below:
1. The Excel file Closing Stock Prices provides data for four stocks over a six-month period.
a. Develop spreadsheet models for forecasting each of the stock prices 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. (You might consider using data tables to facilitate your search.)
2. For the data in the Excel file Baseball Attendance 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.
4. For the data in the Excel file Gasoline Prices do the following:
a. Develop spreadsheet models for forecasting prices 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.
5. Construct a line chart for the data in the Excel file Arizona Population.
a. Suggest the best-fitting functional form for forecasting these data.
Baseball Attendance |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 = San Francisco Giants (1958-1967 seasons) |
|
Year |
Attendance |
1 = Giants plus Oakland A's after A's move to Oakland (1968-1978 seasons) |
1958 |
1273 |
0 |
|
|
|
|
|
1959 |
1422 |
0 |
|
|
|
|
|
1960 |
1795 |
0 |
|
|
|
|
|
1961 |
1391 |
0 |
|
|
|
|
|
1962 |
1593 |
0 |
|
|
|
|
|
1963 |
1571 |
0 |
|
|
|
|
|
1964 |
1504 |
0 |
|
|
|
|
|
1965 |
1546 |
0 |
|
|
|
|
|
1966 |
1657 |
0 |
|
|
|
|
|
1967 |
1242 |
0 |
|
|
|
|
|
1968 |
1674 |
1 |
|
|
|
|
|
1969 |
1652 |
1 |
|
|
|
|
|
1970 |
1519 |
1 |
|
|
|
|
|
1971 |
2021 |
1 |
|
|
|
|
|
1972 |
1569 |
1 |
|
|
|
|
|
1973 |
1835 |
1 |
|
|
|
|
|
1974 |
1366 |
1 |
|
|
|
|
|
1975 |
1601 |
1 |
|
|
|
|
|
1976 |
1408 |
1 |
|
|
|
|
|
1977 |
1196 |
1 |
|
|
|
|
|
1978 |
2267 |
1 |
|
|
|
|
|