Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Forecasting is an important process in almost all businesses and is an important skill to possess as an employee or as a business owner. They are required for business plans, developing sales...

1 answer below »
Forecasting is an important process in almost all businesses and is an important skill to possess as an employee or as a business owner. They are required for business plans, developing sales strategies, determining resource requirements, etc. Developing the skills to forecast and to professionally present forecast results will be critical to your career. Many times in your career you will certainly be required to either develop a forecast or evaluate forecasts developed by others.
The objective of the project is to simulate a problem you might face in your first job or business. That is to develop and present the best forecast for a single data series. You will explore at least 4 methods of forecasting an objective data series and select the best forecast result from among them. .
The project is due the last day scheduled for class during finals week. You are strongly encouraged to spread the work throughout the semester. After each forecasting technique is covered you should apply it to your forecast project data.
  1. Selecting a Topic for your project[1]
You need to pick a monthly or quarterly objective data set (call it Y) that is of interest to you. Make sure it is NOT seasonally adjusted. You will need at least 80 observations for any data series used in your analysis. The objective data series should be a topic of your interest since you are stuck with it the entire semester. Stay away from Macroeconomic variables such a Money Supply, GDP, CPI, etc... If you have not picked a topic or want to change it, contact me as soon as possible.
In this course you will learn and apply several forecasting techniques to a single data series that is your forecast objective. Most of these techniques will only use your objective data series. There is one technique you will use that will require at least 2 other data series for the same period and length. These additional data series should be related or “cause” your objective data series. You may use Macroeconomic variables for these 2 related or “causal” data sets or X data sets. Note that they should be of same length and time covered as the objective data set (Y). You need to start looking for
those explanatory variables now!! This information will be requested from you in the form of a class project proposal (See Project Proposal Description in Doc Sharing.)
  1. Writing an Introduction

After you pick your topic, it is a good idea to write-up a brief abstract to help you focus your thoughts. It should include the following points.
  1. State your forecasting problem relative to Y data series and why you picked it.
  2. State your hypothesis relative to the Y and each X variable relationship. (Why you believe that X causes Y)
  3. Information about and description of your data
  4. Description of your proposed approach

The abstract should then be developed or expanded into a Project Proposal. Hopefully, you will have the proposal that answers each of the points above.
  1. Methodology
The your project will include the application of all four major forecasting techniques:
  1. Exponential Smoothing (Chapter 4): You need explain which model you selected and why and how you selected it, etc.
(ii) Decomposition (Chapter 5): You need explain what, why, how etc
(iv) Box-Jenkins (ARIMA) (Chapter 9):
(iii) Regression (Chapter 6, 7 and 8): You will need other variable(s) to help
explain the variation in your variable of interest. You need to start looking for
those explanatory variables now
The methodology of obtaining the best forecast from each method includes error measure and residual analysis. When possible you will select the best model form based on this analysis.
Your methodology for selecting the best forecast of the objective or Y variable will be based on the lowest error measures for the forecast period.
  1. Body of the Project Paper
The paper will contain detailed explanations of your thought processes and methodology. At every stage you need to answer the following questions:
  1. What did you do? (eg. Winter’s method with these parameter values…)
  2. Why did you do it? (Why you chose each specific forecast model used)
  3. What did you find? (Interpretation of your results)
    1. Fit period Error Measures (RMSE and MAPE)
    2. Fit period Residual Analysis (Are they random, if not why not?)
    3. Hold out period Error Measures (RMSE and MAPE)
    4. Hold out period Residual Analysis (Are they random, if not why not?)
  1. What is your conclusion? Which method produced the best forecast?

In part iv above include a table with RMSE and MAPE for the fit period and the forecast period for each of the four forecast methods. Clearly point out the best forecast model results in that table for the forecast period error measures.
Do not leave any tables, plots or statistics stranded without narrative. Tell the ready why you are showing each table or plot and what it indicates.
  1. Appendix
Your appendix should contain all the relevant supporting information such as the original Y and X data (along with exact web page citations), any data transformations, tests, plots, graphs, diagrams, etc. It is better to divide the appendix into parts where each part is representing the output from each methodology (ex: Appendix A: Smoothing outputs, Appendix B: Decomposition outputs, etc.) Don’t forget to label or number them. You will need to refer to them when you are talking about a specific methodology. It is best to include s short description of each item in the appendix to avoid confusion.
  1. Final Report
Your final report should include an Executive Summary of your findings that will include the conclusions (Which of the techniques works best and why?). You can add the results to your introduction and summarize the result into an
executive summary. You need to have an Introduction to talk about your
topic in above section 2 in greater length (Your proposal should fit well for this). It will include the reference of your data source in above section 2. The Conclusion should clearly identify the best estimation methodology and model and explain why it is the best. Be detailed and complete in all your sections. This is a case of more is better than less as you explain to me what you have done. The Appendix should follow showing your work that you did not show in the body of the project including the data used. Repeat the reference of the data source in the Appendix where the data is shown.
Use 12 point New Times Roman double spaced type style for your document. Use upper case centered type for your title and upper/lower case centered type for your major headings (Executive Summary, Introduction, etc.) and upper/lower case left justified for any subheadings.
The project report should be sent to me as an uploaded Word document at our eCollege site or as an email attachment. Do not send raw Minitab files in the project. You should include copied and pasted Minitab results and graphs in your project paper.
Make sure that you spell check and grammar check the project. You must use the type style and heading format that is mentioned above. Do not include charts or graphs that are “stranded” without explanatory headings and statements.
Include a cover page with the Title of your study, the course title (Economics 309 Section #), the date and your name. Place my name below yours as your instructor for the course. Upload the finished project with a filename that has your first initial and last name embedded in it. The format for the upload should be (first initial, last name, Eco309Fall2012Project).
This project report will contribute a maximum of 20 Points of the Final Course Grade. Remember this is a formal report and you will be graded not only on the required forecast elements but how you organize and report the results of your findings. Be clear and concise. DO NOT waste your time and overload the project report with work that is not relevant. [1] Please remember that there is NOT one right way of preparing a paper. Be precise, explain everything in detail and be structured. The outline is ONLY to remind you about the required parts; its arrangement is completely up to you. If you want to see project samples, I will be happy to show you examples.
Answered Same Day Dec 23, 2021

Solution

Robert answered on Dec 23 2021
140 Votes
Economics 309
The Standard & Poor's 500, better known as S&P 500 is a stock market index based on 500 leading companies in the U.S. stock market. It differs in method of weighting from other U.S. stock market indices like the Dow Jones or the Nasdaq. It is one of the most commonly used equity indices and many consider it the best representation of the market for the U.S. economy. This study involves the recent trend of S&P 500 and to make a prediction of this stock market index in near future and how it related with unemployment rate and Labor Force Participation Rate (LFP). We use the monthly data of S&P 500 stock market index, unemployment rate and LFP from 1997 to June, 2013 for this analysis.
The time series plot of S&P 500 series excluding the hold out period of 12 months is presented in Fig 1. The series plotted in Fig 1 shows that there is no such long term upward or downward trend but a small term increasing and decreasing trend is present. Also, there is no seasonality present in the data. However, there is no such cyclical variation exist in the data. As the amplitude of both the seasonal and i
egular variations do not change as the level of the trend rises or fall, the series is an additive type. The series is not stationary.
The autoco
elation function of the S&P 500 series is given in Fig 3. This shows that the data is not stationary as the autoco
elation functions of different orders are dying out very slowly.
The exponential smoothing method is applied to the series S&P 500. We have used both single and double exponential smoothing method. The details of single exponential smoothing method are given in Fig 2 and double exponential smoothing method are given in Fig 3. We can see from these figures that single exponential smoothing method is better as it has smaller MAPE, MAD and MSD. Therefore, single exponential smoothing is the better forecasting method for this S&P 500 series.
First order difference is applied to the series to make it trend stationary. The differenced series is presented in Fig 5 which is now becomes stationary. The autoco
elation and partial autoco
elation function of the differenced series are presented in Fig 6. These show that the ACF plot of differenced series has one significant spike at lag 1. Also, the PACF plot of differenced series has one significant spike at lag 1. These suggest that the differenced series have both AR and MA process of order 1. Therefore, the order of the ARIMA(p,d,q) are 1, 1 and 1 respectively. The ARIMA model finally proposed is ARIMA(1,1,1) and the estimates of the model is presented in Table 1.
From the estimation result, it can be seen that the coefficient of MA of order 1 is statistically significant. We analyze the properties of the residuals from the estimated model. The residual analysis is presented. The...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here