AVERAGE vs MEDIAN vs MODE.SNGL and a Trimmed Mean
This lesson is part of the course
In this lesson
You describe a typical Orchard Row sales rep with the mean, the median, the mode and a trimmed mean, and see how one star performer pulls the average.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- AVERAGE vs MEDIAN vs MODE.SNGL and a Trimmed Mean Locked
- Conditional Statistics: AVERAGEIFS, MAXIFS, MINIFS and COUNTIFS Locked
- Spread: Range, STDEV.S vs STDEV.P, VAR and the IQR Locked
- PERCENTILE, PERCENTRANK and Quartile Bands Locked
- RANK.EQ vs RANK.AVG and Top-N with LARGE and SMALL Locked
- Frequency Tables and Histograms with COUNTIFS Locked
- CORREL, COVARIANCE and STANDARDIZE z-Scores Locked
- Capstone: Outlier Flags and a Summary Statistics Table Locked