MGS 3100 Project 2: Data Description and Forecasting

Collect data on any topic of interest to you, preferably something related to your work (application of the techniques from this course to your work will add value to your organization and to you.) You may choose to do eitherTime Series Forecasting orCausal Forecasting.

Time Series Forecasting

1   Pick a variable you want to forecast, and collect data on its values in the past (at least 25 time periods, preferably closer to 50). The data should NOT be annual, since that will prevent the study of seasonality, if any. Choose monthly or quarterly or daily or hourly data.

2   Create a scatter plot showing the data over time. Discuss what approach is most appropriate for forecasting.

3   Regardless of the above, forecast using all the methods discussed in class – Naïve, Moving Average, Exponential Smoothing, Regression, and Classical Decomposition.

4   Compare all methods using appropriate evaluation criteria (Bias, MAD, MAPE, MSE, Standard Error)

Causal Forecasting

You must have at least 5 independent variables (can be a mix of categorical and numeric) and a dependent variable (numeric). The number of observations will depend on the circumstances, but in general, the more the better – rule of thumb is to get at least 10 times as many observations as variables (so for 5 variables, you need 50 observations).

1   For each variable, show distribution of observations with frequency charts, mean and standard deviation computations, etc.

2   Show relationships of each independent variable individually with the dependent using scatter plots.

3   Perform regression analysis to show overall model for predicting the value of the dependent. Remember to eliminate variables that are not significant, and run regression analysis multiple times until your model has only significant variables, or until you conclude that nothing is significant.

Interpret the results and write a report. The report must first briefly describe the background, what you are trying to predict, what the variables are, and how you collected the data, before showing the analyses and results. The report must stand alone – one should be able to understand the salient points of everything you did without having to look at your spreadsheet.

Report Format

Introduction: What motivates this study? Who is it important to? Provide general background

Data: How much data was collected? Number of Observations, the variable(s), the way the variables were measured, the source of the data

Preliminary Analysis:Scatter Plot(s), and interpretation of the plots. For time series, what does the plot tell you about the relationships and the method of forecasting that might work best? For causal forecasting, draw multiple plots, and interpret each. How does each X seem to relate to Y?

Forecasting: Forecast Y using all the methods. Draw graphs of actual vs. forecasted value.

Evaluation: Compute Errors, compute Bias and at least one of MAD, MAPE, MSE (SE). Compare the values across methods.

Conclusion: What is the forecast for the next time period using the best of the methods for this data?

*****Excel sheet is only a reference!!!

...

## Â Management...

Provide short answers to the following six questions. Your answers should be clear, concise and to the point. Prepare single document (MS Word or...

## Managing quality often means addressing small issu...

Managing quality often means addressing small issues so that they do not escalate into risks for the orga...

## article review...

Choose one article about the civil right movement from Jastor web and make a review about itWrite 600 words write the bibliography...

## Environmental Science : Econ 2...

Running Head: ECONOMIC DECISIONS1Economic DecisionsNameInstitutionECONOMIC DECISIONS2Economic DecisionsIntroductionThe challenge in the contemporary...

## Carroll et al. (2005) discuss trends in serum lipi...

Carroll et al. (2005) discuss trends in serum lipids and lipoproteins for US adults for the period 1960 to 2002. In this study, the population mean...

## Most European countries have nationalized their un...

This needs to be in APA format.All sources must be cited and verifiable by professor and all online links added to...

...

## Statistics : Central Tendency Variability.edited...

Surname 1Running Head: MEASURES OF CENTRAL TENDENCY AND VARIABILITYMEASURES OF CENTRAL TENDENCY AND VARIABILITYStudentInstructorInstitutionCourse Nam...

## Relativism and situation ethics Philosophy homewo...

Relativism and situation ethics | Philosophy homework help...

## I need help with Technology Management Core...

Building and maintaining customers with an emphasis on developing a market identity and sales for technology-based and innovative enterprises....

### Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
\$65
Order a paper. Study better. Sleep tight. Calculate Price!
Calculate Price
Approx. price
\$65