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.
- 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.)
- 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.
- State your forecasting problem relative to Y data series and why you picked it.
- State your hypothesis relative to the Y and each X variable relationship. (Why you believe that X causes Y)
- Information about and description of your data
- 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.
- Methodology
The your project will include the application of all four major forecasting techniques:
- 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.
- 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:
- What did you do? (eg. Winter’s method with these parameter values…)
- Why did you do it? (Why you chose each specific forecast model used)
- What did you find? (Interpretation of your results)
- Fit period Error Measures (RMSE and MAPE)
- Fit period Residual Analysis (Are they random, if not why not?)
- Hold out period Error Measures (RMSE and MAPE)
- Hold out period Residual Analysis (Are they random, if not why not?)
- 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.
- 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.
- 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 C
onclusion 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.