Distribution Questions: Mean vs Median vs p90 and the Effect of One Outlier
This lesson is part of the course
In this lesson
You describe 20 basket values with the mean, the median and the 90th percentile, then show how one large business order moves the mean but hardly the median.
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
- Warm-Up: Clarifying the Question, Points vs Percent and Share-of-Total Traps Locked
- SQL-Style Questions: Joins with XLOOKUP, Unmatched Rows and GROUP BY with SUMIFS Locked
- Metric Definitions: Active Users, Conversion and Why the Denominator Decides Locked
- Distribution Questions: Mean vs Median vs p90 and the Effect of One Outlier Locked
- Quick A/B Read: Conversion per Variant, Lift in Points and "Is It Worth Shipping?" Locked
- Cohort Retention: Months Since Signup, the Cohort Grid and Pooled vs Average Rates Locked
- Sanity Checks: Duplicated Rows, Impossible Rates and Totals That Don't Add Up Locked
- Capstone: A Timed Take-Home – Net Revenue, Refund Rate, Revenue by Channel and One Chart Locked