Share
Explore BrainMass

Forecast Analysis

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.

Attachments

Solution Preview

Please refer to the EXCEL attachment.

I have used number of ...

Solution Summary

This solution is comprised of detailed step-by-step calculation and analysis of various Forecast Techniques like Moving Average Forecast, Exponentially Smoothed Forecast etc. and various Forecast Accuracy Measures like Error, Absolute Error, MAD, MAPE etc. in EXCEL. Comparison of these Forecast Techniques based on these Forecast Accuracy measures has also been shown in details.

$2.19