Relative Ranking: Percent Ranks and Rating Bands
This lesson is part of the course
In this lesson
You turn calibrated z-scores into a percent rank with PERCENTRANK.INC, map it to a 1–5 rating with an approximate XLOOKUP, rank the group with RANK.EQ and find the z-score cut-off for the top quarter.
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
- Rating Distribution vs the Target Curve Locked
- Calibration: Z-Scores Within Each Manager Locked
- Relative Ranking: Percent Ranks and Rating Bands Locked
- Funding the Pool: Threshold, Target and Maximum Locked
- Individual Payouts: Salary × Target × Company Factor × Multiplier Locked
- Pro-Rating for Joiners, Leavers and Part-Timers Locked
- Fitting Payouts to the Budget: Scale, Round, Fix the Residual Locked
- Payout Summary: Cost vs Pool by Department and Fairness by Grade Locked