Excel: Economic Analysis and Data Analytics

Find out how to use big data to perform regression analysis for economic forecasting in Microsoft Excel.

Introduction

• Economic forecasting
• What you should know before watching this course
• Using the exercise files

1. The Basics

• Basics of economic analysis
• Sources of economic data
• Economic forecasting methods
• Regression analysis in economics
• Predicting values with regressions
• Economic forecasting in the research literature

2. Economic Data Analysis

• Trend analysis in forecasting
• Serial correlation in data
• Analyzing results

3. Forecasting Economic Trends

• Advanced forecasting methods
• Binomial regressions
• Fixed effects regressions
• Difference in differences analysis
• Stata and economic forecasting
• Interpreting Stata results

4. Using Economic Forecasts

• What do the results mean?
• Testing accuracy in economic forecasts
• Scenario analysis in economics

5. Economic Data

• Common economic variables
• Lead and lag relationships
• Seasonality and data cleaning
• Interpreting other's economic forecasts

Conclusion

• Projects to try next