Module 3 Worksheet: Counts, Rates, Percentages, and Proportions

Scenario

Two groups report the same raw count and a manager is about to treat them as equal performers.

Data

Dataset: support-denominator-rates.csv

Your Task

Calculate ticket rates and escalation rates before writing the comparison.

Questions

1. What is the denominator for each group?
2. Convert both to a rate. Which group performs better?
3. Which figure would each group prefer quoted, and why?
4. Is there a situation here where the raw count matters more than the rate?
5. What would a percentage change hide that the rate does not?
6. What does the comparison support?
7. What would you need to know before ranking the groups?

Write Your Conclusion

Report both the counts and the rates, and say which one answers the manager's question.

Self-Check

• Did I find the denominator before comparing?
• Did I report both the count and the rate?
• Did I say which figure answers the actual question?
• Did I avoid ranking on the count alone?