Purchase Solution

Forecast Analysis

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution

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.

Solution Preview

Please refer to the EXCEL attachment.

I have used number of ...

Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.