Level 5 – Statistical Analysis in Excel
We provide computers to use
Everyone receives a paperback workbook, 8 hours
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
Pivot Tables and Pivot Charts
Macros to format data and create charts
