Segments: Rank Differences, Largest Gaps and a Weighted Total
This lesson is part of the course
In this lesson
You compare best–worst scores of two member segments with RANK.EQ, find the perks with the largest gaps using ABS, MAX and LARGE, and build a total weighted by segment size.
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