Skip to course content
Free statistics course

Basic Statistics for Data Analysis / Module 3

Module 3 worksheet

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

Scenario

You are helping a beginner analyst review a small synthetic dataset. Your job is not to sound impressive. Your job is to make the safest useful statement.

Data

Dataset: support-denominator-rates.csv

monthplan_typeticketsactive_accountsescalations
JanuaryBasic428405
JanuaryPro283506
FebruaryBasic489607
FebruaryPro304004
MarchBasic5412008
MarchPro364509

Your Task

Calculate ticket rates and escalation rates before writing the comparison.

Questions

  1. What is the statistical question?
  2. What is the unit of analysis?
  3. Which variables matter most?
  4. What summary, comparison, or visual check is suitable?
  5. What does the evidence suggest?
  6. What should not be claimed?
  7. What limitation should be mentioned?

Write Your Conclusion

Write two to four careful sentences. Use plain English. Do not use words like proves, guarantees, or always unless the evidence truly supports them.

Self-Check

  • Did I name the question?
  • Did I use the right denominator or comparison?
  • Did I avoid claiming more than the data can support?
  • Did I mention uncertainty, bias, assumptions, or limits where needed?