Favourability: Turning 1–5 Answers into % Favourable, Neutral and Unfavourable
This lesson is part of the course
In this lesson
You count favourable, neutral and unfavourable answers for five items with COUNTIFS, divide by the people who actually answered each item, and find the item that needs attention.
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
- Response Rates: By Team, by Location and Overall Locked
- Favourability: Turning 1–5 Answers into % Favourable, Neutral and Unfavourable Locked
- Index Scores: From Items to Themes and a Weighted Engagement Index Locked
- eNPS: Promoters, Passives and Detractors by Team Locked
- Confidentiality: Minimum Group Sizes, Suppression and an «Other» Group Locked
- Year-over-Year Change: Score Deltas, a Meaningful-Change Threshold and a Heatmap Locked
- Driver Analysis: Correlation from z-Scores and an Importance × Gap Matrix Locked
- Capstone: Action Priorities per Team and the Survey Report Locked