Statistical Formulas: RANK, PERCENTRANK, LARGE and Conditional MEDIAN
This lesson is part of the course
In this lesson
You rank the sales team, show each rep's percentile, average the top three and find the median revenue of one region.
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
- Advanced Lookups: Two-Way, Multi-Criteria and Tiers Locked
- Multi-Criteria SUMIFS, COUNTIFS, AVERAGEIFS and MAXIFS Locked
- SUMPRODUCT with Boolean Arrays Locked
- Array Math inside SUM, AVERAGE, MAX and MATCH Locked
- Nested Logic: IFS, SWITCH, CHOOSE and IFERROR Locked
- Text Formulas: FIND, MID, SUBSTITUTE, TEXT and TEXTJOIN Locked
- Date & Time Formulas: EOMONTH, NETWORKDAYS, WEEKNUM, HOUR Locked
- Statistical Formulas: RANK, PERCENTRANK, LARGE and Conditional MEDIAN Locked
- Financial Formulas: PMT, PPMT, NPV and XNPV Locked
- Capstone: Audit and Repair a Broken Report Locked