Regression Analysis for Business Insight – Consulting Case

Learn how to use regression analysis and econometrics to answer business questions in a consulting engagement scenario

Created by: Tashvique Khandaker
Econometrician, Consultant, Instructor

What Will I Learn?

• Learn how to answer real world business questions using model results
• Learn how to conduct residual analysis to test for autocorrelation, heteroscedasticity and normality and validate model
• Brief theoretical overview of OLS and the Gauss Markov Theorem
• Learn how data is collected in a typical consulting engagement
• Understand the difference between causality and correlation
• Learn how to conduct seasonality analysis for your dependent variable
• Understand model statistics (R-SQ, Durbin Watson and MAPE) and how that is used to evaluate the model
• Learn how to decomp the model to get the daily incremental values for each explanatory variable
• Understand how to use the Actual vs Predicted graph to improve the model
• Learn how to effectively use essential excel formulas (Index Match, Sumifs, RSQ) and build graphs (Line Graphs, Scatter Plots, Histogram)

Requirements

• No requirements or prerequisites. All course content such as workbook, syntax files and raw data file will be provided

Target audience

• Anyone interested in learning about regression analysis
• Consulting
• Data Analytics/ Data Science
• Economist & Econometricians
• Academic Research