Practical Stats
Learn statistics in plain English from a patient tutor and experienced business professional. Lessons are focus on practical applications, not hardcore mathematics. We’ll use Excel to do the math and make graphs, and leverage my two decades of large enterprise marketing experience to build skills for managerial decision making. Topics can include:
VISUALIZING DATA
Histograms
Scatter plots
Residual plots
Histograms
Scatter plots
Residual plots
DESCRIPTIVE STATISTICS
Conditional Means
Percentiles
Variance
Standard Deviation
Outliers
Correlation
Analysis Toolpak in Excel
Conditional Means
Percentiles
Variance
Standard Deviation
Outliers
Correlation
Analysis Toolpak in Excel
SAMPLING AND ESTIMATION
Normal Distribution
Central Limit Theorem
Confidence Intervals
Population Proportion
Normal Distribution
Central Limit Theorem
Confidence Intervals
Population Proportion
HYPOTHESIS TESTING
Null and Alternative Hypotheses
Type I and Type II Errors
P-values
One-Sided Testing
A/B Testing
Null and Alternative Hypotheses
Type I and Type II Errors
P-values
One-Sided Testing
A/B Testing
LINEAR REGRESSION
Forecasting
Explanatory Power
R2 and Adjusted R Squared
Sum of Squares
Multiple Regression
Dummy Variables
Lagged Variables
Multicollinearity
Residual Analysis
Heteroskedasticity
Forecasting
Explanatory Power
R2 and Adjusted R Squared
Sum of Squares
Multiple Regression
Dummy Variables
Lagged Variables
Multicollinearity
Residual Analysis
Heteroskedasticity
SAMPLE EXCEL FUNCTIONS
IF(S)
AVERAGEIF
SUMPRODUCT
PERCENTILE.INC
STDEV.S
CORREL
NORM.DIST
NORM.S.DIST
NORM.INV
CONFIDENCE.NORM
CONFIDENCE.T
T.TEST
IF(S)
AVERAGEIF
SUMPRODUCT
PERCENTILE.INC
STDEV.S
CORREL
NORM.DIST
NORM.S.DIST
NORM.INV
CONFIDENCE.NORM
CONFIDENCE.T
T.TEST
EDUCATION HIGHLIGHTS
HBX | Harvard Business School, Certificate in Business Analytics, October 2018
Graduate degrees: MBA and MS in Personal Financial Planning
B.S. in Management from Georgia Tech
HBX | Harvard Business School, Certificate in Business Analytics, October 2018
Graduate degrees: MBA and MS in Personal Financial Planning
B.S. in Management from Georgia Tech