Use big data to forecast economic trends. Find out how to perform regression analysis for economic forecasting using Microsoft Excel.
- Hello, I'm Dr. Michael McDonald. I'm a professor of finance and consultant to industry. I've been teaching forecasting, using data, for more than a decade, to financial firms, Fortune 500 companies and government agencies. In this course, I'm going to show you how to effectively use economic data in practical business forecasting settings. Data analytics is one of the hottest growth areas in business and it is a key opportunity for those looking to develop their career.
In this course I will demonstrate how to gather data from government sources, like the Federal Reserve, and use that data to forecast critical variables, like property prices and interest rate hikes. We'll explore a variety of different types of forecasts, from time series exponential smoothing, to fixed effects regressions, to difference in difference estimators. Please join me know, and let's get started.
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.
- 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.