2016
2 hours
00 – Introduction
Welcome
Need to know
Exercise files
01 – Excel Statistics Essentials
Use Excel statistical functions
Use the Analysis Toolpak
Use statistical charts
Use 3D maps
02 – Visualize Sampling Distributions
Simulate the central limit theorem
Visualize the standard normal and t
Visualize F and chi square
03 – ANOVA: A Closer Look
Analyze between groups ANOVA
Perform simple comparisons
Perform complex comparisons
Perform unplanned comparisons
Perform repeated measures ANOVA
04 – ANOVA: A Complex Look
Perform two-way analysis of variance
Perform comparisons after two-way ANOVA
05 – Linear Regression: A Closer Look
Visualize scatter plot and regression line
Analyze the regression line
06 – Multiple Regression
Perform multiple regression
07 – Nonlinear Regression
Define natural logs and exponentials
Perform exponential regression analysis
Perform logarithmic regression analysis
Perform power regression analysis
Perform polynomial regression analysis
08 – Time Series
Forecast and make predictions
09 – Advanced Correlation
Perform correlation
Compare two correlation coefficients
Perform multiple correlation
Perform partial correlation
10 – Frequency Hypothesis Testing
Test independence of two variables
Test goodness of fit
11 – Simulation
Perform Monte Carlo simulation
Perform business simulations
12 – Conclusion
Next steps
Exercise Files