Descriptive Statistics: Mean, Median & Sample Spread
Diagnose skewed salary or sales distributions cleanly by comparing Mean vs Median and sample standard deviation (STDEV.S).
Key takeaways while you watch
- Compare AVERAGE vs MEDIAN immediately: large gaps expose outlier skewness.
- Prefer STDEV.S (sample, n-1) over STDEV.P when analyzing sample business cohorts.
- Enable the built-in Data Analysis ToolPak add-in for instant 13-stat summary tables.
Drill: Compute Sample Standard Deviation
Write a formula calculating the sample standard deviation of salaries in B2:B6.
| Employee | Salary (B) |
|---|---|
| Emp-1 | 68000 |
| Emp-2 | 72000 |
| Emp-3 | 74000 |
| Emp-4 | 71000 |
| Emp-5 | 135000 |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.