Scoring Scales & Normalisation: Min-Max, Higher vs Lower Is Better
This lesson is part of the course
In this lesson
You turn five vendors’ raw data (dollars, weeks, feature counts, star ratings) into comparable 0–10 scores, flipping the scale where lower is better.
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
- Criteria & Weights: Making Them Add Up to 100% Locked
- Scoring Scales & Normalisation: Min-Max, Higher vs Lower Is Better Locked
- Weighted Score with SUMPRODUCT, RANK.EQ & a SORTBY Leaderboard Locked
- Must-Have Knock-Out Criteria with IF and AND Locked
- Pairwise Comparison Weights (AHP-Style Row Averages) Locked
- Sensitivity: How Far Must a Weight Move to Flip the Winner? Locked
- Multiple Evaluators: Averages, Spread & Disagreement Flags Locked
- Final Decision Dashboard: Score, Rank, Budget Cut-Off & Sorted Bar Chart Locked