Statistical Formulas: RANK, PERCENTRANK, LARGE and Conditional MEDIAN
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Advanced Lookups: Two-Way, Multi-Criteria and TiersFree
- Multi-Criteria SUMIFS, COUNTIFS, AVERAGEIFS and MAXIFS Pro
- SUMPRODUCT with Boolean Arrays Pro
- Array Math inside SUM, AVERAGE, MAX and MATCH Pro
- Nested Logic: IFS, SWITCH, CHOOSE and IFERROR Pro
- Text Formulas: FIND, MID, SUBSTITUTE, TEXT and TEXTJOIN Pro
- Date & Time Formulas: EOMONTH, NETWORKDAYS, WEEKNUM, HOUR Pro
- Statistical Formulas: RANK, PERCENTRANK, LARGE and Conditional MEDIAN Pro
- Financial Formulas: PMT, PPMT, NPV and XNPV Pro
- Capstone: Audit and Repair a Broken Report Pro