Develop spreadsheet models for forecasting

Question

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