Point-Factor Job Evaluation: From Factor Levels to Grades
This lesson is part of the course
In this lesson
You score eight jobs on four weighted factors with SUMPRODUCT, place each job in a grade with an approximate-match lookup and check how much of a senior job's score comes from one factor.
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