Raw vs Grade-Adjusted Pay Gaps
This lesson is part of the course
In this lesson
You calculate the raw gender pay gap, then the gap inside each grade with AVERAGEIFS, flag the grades above a review threshold and see why the two numbers tell different stories.
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
- Point-Factor Job Evaluation: From Factor Levels to Grades Locked
- Aging and Blending Market Survey Data Locked
- Designing Salary Ranges: Midpoints, Spreads & Overlap Locked
- Compa-Ratios, Range Penetration & Green/Red Circles Locked
- Raw vs Grade-Adjusted Pay Gaps Locked
- The Merit Matrix: Rating × Compa-Ratio → Increase Locked
- Costing Green Circles and Red-Circle Freezes Locked
- Capstone: Pay Structure Summary & Scatter Chart Locked