RANK.EQ vs RANK.AVG and Top-N with LARGE and SMALL
This lesson is part of the course
In this lesson
You rank Orchard Row's reps by deals with RANK.EQ and RANK.AVG, see how ties are treated, and list the top-3 and bottom-3 revenues with LARGE and SMALL.
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