Ranking Questions: Average Rank, First Choices and Points per Rank
This lesson is part of the course
In this lesson
You summarise a ranking question three ways – average rank, first-choice share and points per rank with SUMPRODUCT and COUNTIF – and see why a polarising feature can win first places but lose on average.
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
- Ranking Questions: Average Rank, First Choices and Points per Rank Locked
- Best–Worst Counts: Scores per Appearance and the Top Perk Locked
- Best–Worst Shares: From Scores to Share of Preference Locked
- Segments: Rank Differences, Largest Gaps and a Weighted Total Locked
- TURF Reach: Unduplicated Reach and the Value of One More Item Locked
- TURF Line-Up: Compare All Combinations, Pick the Best, Check Frequency Locked
- Kano Categories: Evaluation Table, Main Category and Better–Worse Locked
- Prioritisation Matrix: Importance vs Satisfaction and a Roadmap Score Locked