Normalize Counts into Fair Rates and Ratios

Part 1 taught you to compute the core quantities of a single dataset: totals and shares, an honest average, and percentages and change. Part 2 shifts the job from working out one number to putting numbers side by side, reading what they mean, and checking them before you trust them. The very first comparison you will make is also the one people get wrong most often: setting two groups of different sizes against each other. This chapter shows how a raw count can quietly favor the bigger group, and how turning that count into a fair rate fixes it.

Why a Bigger Count Is Not Always the Bigger Deal

Imagine you follow two hobby podcasts and want to know which one has the more engaged audience. Last month, Podcast A collected 300 listener comments and Podcast B collected 1,200. Four times as many comments, so Podcast B wins, surely?

Not so fast. Podcast A has 2,000 subscribers; Podcast B has 12,000. Podcast B did not necessarily earn more engagement, it simply has a far larger audience to draw comments from. Comparing the raw comment counts is like saying a swimming pool caught more rain than a bucket: of course it did, because it is bigger. The size of the thing behind the number is doing the talking, not the engagement you actually care about.

If one show got four times as many comments, why can’t I just say it is the more engaging one? 

Because “more engaged” is a question about engagement per listener, not total comments. Podcast B has six times the audience, so four times the comments could actually mean each of its listeners comments less often. To compare fairly, you have to account for the different audience sizes, and that is exactly what a rate does.

What a Rate, a Ratio, and a Denominator Are

Three plain words turn an unfair count comparison into a fair one.

The move from a count to a rate is called normalization: dividing a count by the size of the thing it came from, so that groups of different sizes can be compared on equal footing. Normalizing the podcast comments by subscribers answers the real question, how talkative a typical listener is, rather than the misleading one, which show is simply bigger.

Turn a Count into a Fair Rate, Step by Step

Whatever the subject, the procedure is the same four moves.

  • Name the question, and decide what “per what” would make the comparison fair. This chooses your denominator.

  • For each group, take the count you care about.

  • Divide that count by the denominator for the same group.

  • Multiply by a convenient unit (per 100, per 1,000) if the raw rate is an awkward decimal, so the result is easy to read and compare.

Do those in order for every group, using the same denominator each time, and the comparison becomes fair. Use a different denominator for each group and you are back to comparing apples with oranges.

See It in Action: Two Podcasts of Very Different Sizes

Here are the two shows side by side.

Podcast

Comments last month

Subscribers

A

300

2,000

B

1,200

12,000

The count comparison is the tempting, wrong one: 1,200 against 300, so B looks four times better. Now normalize each count by its subscriber base to get a rate of comments per subscriber.

  • Podcast A: 300 ÷ 2,000 = 0.15 comments per subscriber.

  • Podcast B: 1,200 ÷ 12,000 = 0.10 comments per subscriber.

Those small decimals are easier to read multiplied up to a shared unit, comments per 1,000 subscribers:

  • Podcast A: 0.15 × 1,000 = 150 comments per 1,000 subscribers.

  • Podcast B: 0.10 × 1,000 = 100 comments per 1,000 subscribers.

Read as a rate, the story flips. Measured per listener, Podcast A’s audience is the more engaged one, 150 comments per thousand against 100, even though B collected far more comments in total. The raw count answered “which show is bigger?”; the rate answered the question you actually asked, “which show has the more engaged audience?”

Choose the Right “Per What”

A rate is only as fair as its denominator, so the “per what” has to match the question you are asking.

Suppose you are choosing how to pay for a climbing gym: a 60 euro monthly pass, or 9 euros per single visit. The 60 looks bigger than the 9, but that is another count-versus-rate trap, because the two prices are not measured per the same thing. Normalize the pass to a cost per use by dividing by how often you go. Visit 5 times a month and the pass costs 60 ÷ 5 = 12 euros per visit, so pay-per-visit (9 euros) is cheaper. Visit 10 times and the pass costs 60 ÷ 10 = 6 euros per visit, so now the pass wins. Same numbers, opposite conclusion, decided entirely by the denominator: how often you actually go.

One caution keeps a rate honest. Normalizing makes a comparison fairer, but it does not erase every difference between groups. Podcast A and B still differ in audience, topic, and how long each has run, and a rate cannot capture all of that. A fair rate sharpens one comparison; it does not turn two different things into the same thing.

Your Turn!

Two food banks report last week’s work.

  • Food Bank North: 15 volunteers served 900 meals.

  • Food Bank South: 40 volunteers served 2,000 meals.

Do the following, writing your answers down before you check:

  1. Which food bank served more meals in total? Name the quantity you are comparing.

  2. Compute meals per volunteer for each food bank, the fair rate for “which team was more productive per person.”

  3. Say which team was more productive per volunteer, and add one sentence on what this rate does not tell you.

Then check your answer against the model solution found at the end of this chapter.

Let’s Recap!

  • A raw count comparison quietly favors the bigger group, because the size of the group is baked into the number.

  • A rate normalizes a count by dividing it by a denominator, the “per what,” so different-sized groups can be compared fairly.

  • The denominator must match the question you are asking, or the rate answers the wrong one.

  • A count and a rate answer different questions: total size versus per-unit intensity.

  • Normalizing makes one comparison fairer, but it does not remove every difference between the groups.

You can now turn raw counts into fair, comparable rates. But a correct rate can still be over-read, so the next chapter turns to interpretation: stating clearly what a number you have computed does, and does not, actually mean.

Model Solution

  1. Food Bank South served more meals in total, 2,000 against 900. The quantity compared is a raw count of meals, which rewards the team that is simply larger.

  2. Divide each meal count by that food bank’s number of volunteers: North is 900 ÷ 15 = 60 meals per volunteer; South is 2,000 ÷ 40 = 50 meals per volunteer.

  3. Measured per volunteer, North was more productive, 60 meals each against South’s 50, even though South served more meals overall. What the rate does not tell you: it says nothing about total impact (South still fed more people), nor about differences in shift length, donations, or how the meals were counted, so it sharpens one fair comparison without settling everything.

Et si vous obteniez un diplôme OpenClassrooms ?
  • Formations jusqu’à 100 % financées
  • Date de début flexible
  • Projets professionnalisants
  • Mentorat individuel
Trouvez la formation et le financement faits pour vous