Rating Distribution vs the Target Curve
This lesson is part of the course
In this lesson
You count the year-end ratings per manager with COUNTIFS, compare the company distribution with the target curve in percentage points and flag the manager whose top ratings run far above target: the starting point of every calibration meeting.
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