Join Michael McDonald for an in-depth discussion in this video Next steps, part of Excel: Economic Analysis and Data Analytics.
- In this course, we've talked about…using economic data in forecasting.…And a number of different methods…and techniques you can use to do those forecasts.…We've demonstrated using the FRED Excel add-in…to pull in a variety of data,…based on different project needs.…And we've explained how to make forecasts…with serially correlated data…and techniques like exponential smoothing.…We've also discussed advanced forecasting tools,…like binary and fixed effects regressions.…If you keep these lessons in mind,…I forecast a bright future ahead for you…in the dismal science.…
So, where should we go from here?…Well, remember economic forecasting is imperfect…and there are always new challenges arising.…So, keep developing your skills and be creative,…when looking at questions you can answer with a forecast.…Look for ways to use macro and microeconomic data…in forecasts, for your day to day role.…Think about how forecasting fits…into the broader data analytics world.…And of course, keep an eye out…for new courses to come, in the future, in the library.…
Professor Michael McDonald demonstrates how to harness the wealth of information available on the Internet to forecast statistics such as industry growth, GDP, and unemployment rates, as well as factors that directly affect your business, like property prices and future interest rate hikes. All you need is Microsoft Excel. Michael uses the built-in formulas, functions, and calculations to perform regression analysis, calculate confidence intervals, and stress test your results. He also covers time series exponential smoothing, fixed effects regression, and difference estimators. You'll walk away from the course able to immediately begin creating forecasts for your own business needs.
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Identify a good source of free data.
- Name the term for the estimate of the impact of an X variable on a Y variable.
- Tell which statistic offers a bounds on the estimate of the impact of an X variable on a Y variable.
- Assess the type of variable that can be used to capture fixed effects.
- Cite the method by which a forecast can be done with a regression.