Microsoft Excel – Level 4 Statistical Analysis
Laptops are provided to use in on-site training
Everyone receives a physical workbook, 8 hours, $225 per person

Anova (Analysis of Variance)
F value
Sum of Squares Between groups
Sum of Squares Within groups
Degrees of Freedom
Null hypothesis
Mean squares due to treatments
Mean squares of errors
Variance formula
Covariance
Correlation
Descriptive Statistics
Exponential Smoothing
F-Test Two-Sample for Variances
Fourier Analysis
Histogram
Moving Average
Rank and Percentile
Regression
Sampling
t-Test Paired Two Sample for Means
t-Test: Two-Sample Assuming Equal Variances
t-Test: Two-Sample Assuming Unequal Variances
z-Test: Two Sample for Means

Line charts, chart shortcuts, formatting
Pie Charts
Pareto chart
KPI (Key Performance Indicators)
Gantt chart
Control chart
Scatter chart