Scoring Scales & Normalisation: Min-Max, Higher vs Lower Is Better
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Criteria & Weights: Making Them Add Up to 100%Free
- Scoring Scales & Normalisation: Min-Max, Higher vs Lower Is Better Pro
- Weighted Score with SUMPRODUCT, RANK.EQ & a SORTBY Leaderboard Pro
- Must-Have Knock-Out Criteria with IF and AND Pro
- Pairwise Comparison Weights (AHP-Style Row Averages) Pro
- Sensitivity: How Far Must a Weight Move to Flip the Winner? Pro
- Multiple Evaluators: Averages, Spread & Disagreement Flags Pro
- Final Decision Dashboard: Score, Rank, Budget Cut-Off & Sorted Bar Chart Pro