eNPS: Promoters, Passives and Detractors by Team
This lesson is part of the course
In this lesson
You count promoters and detractors from 0–10 answers for each team with COUNTIFS, turn them into an eNPS between −100 and +100 and find the team that needs a closer look.
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