By Dollar Tech Tools
How to Correctly Calculate the Average of Percentages
A Step-by-Step Guide for Analysts, Marketers and Anyone Who Works with Data
Part 1: The Hook and The Trap
The Dangerous Shortcut Hidden in Every Spreadsheet
You are in a Monday morning meeting.
The slide deck is up.
A colleague points to a number in Excel: 75%.
She says confidently, “Our average conversion rate across both campaigns was 75% last quarter.”
The room nods.
The number looks clean and meaningful.
But it is almost certainly wrong.
This mistake is extremely common in analytics, marketing reports, and dashboards.
It happens when people calculate the average of percentages by simply adding them and dividing.
It looks correct.
It feels correct.
But in many cases, it is mathematically meaningless.
This guide explains when that method fails, and how to fix it.
Why Simple Averages Lead to Wrong Decisions
Let’s understand the problem clearly.
A percentage is not a raw number.
It is a ratio made from a numerator and a denominator.
When you ignore that structure, errors happen.
Example: Two Campaigns
Campaign A
50 conversions out of 100 visitors = 50%
Campaign B
100 conversions out of 100 visitors = 100%
Simple average
(50% + 100%) ÷ 2 = 75%
This looks fine.
But now change the second campaign.
Campaign B
100 conversions out of 1,000 visitors = 100%
Simple average is still 75%.
But the reality is very different.
Total conversions = 150
Total visitors = 1,100
True conversion rate = 150 ÷ 1,100 = 13.6%
So the real answer is 13.6%, not 75%.
That is not a small mistake.
That is a completely wrong conclusion.
The Core Problem: Denominators Matter
Every percentage has a hidden base value.
That base is the denominator.
For example:
Conversion rate → visitors
Test score → total questions
Market share → total market size
If all bases are equal, simple averages can work.
But in real life, bases are almost never equal.
That is why simple averaging fails.
Key Insight
Chronological rule:
Equal denominators → simple average is valid
Unequal denominators → simple average is wrong
The correct method is weighting.
Comparison Table
Equal bases (100 and 100)
50% and 100% → 75% ✔ correct
Unequal bases (100 and 500)
50% and 100% → 75% ✘ wrong
True value = 91.7%
Unequal bases (100 and 1,000)
50% and 100% → 75% ✘ wrong
True value = 95.5%
The simple average never changes.
But reality changes completely.
Part 2: Methods and Formulas
The Weighted Average of Percentages
The correct solution is the weighted average.
It accounts for different sample sizes.
Formula
Weighted Average (%) =
(P₁ × N₁ + P₂ × N₂ + … + Pₙ × Nₙ) ÷ (N₁ + N₂ + … + Nₙ)
Where:
P = percentage
N = base value
What This Means
You convert percentages back into raw numbers.
Then combine them.
Then divide again.
This reconstructs the true total.
Real Example: Marketing Campaigns
Campaign Alpha
Spend: $8,000
Visitors: 4,000
Conversions: 280
Rate: 7%
Campaign Beta
Spend: $2,000
Visitors: 500
Conversions: 60
Rate: 12%
Step 1: Convert to raw values
Alpha: 280 conversions
Beta: 60 conversions
Total conversions = 340
Step 2: Add bases
Total visitors = 4,500
Step 3: Calculate
340 ÷ 4,500 = 7.56%
Compare Results
Simple average = 9.5% (wrong)
Weighted average = 7.56% (correct)
The difference can significantly distort business decisions.
Excel Shortcut
You can use:
=SUMPRODUCT(B2:B3, C2:C3) / SUM(C2:C3)
This automatically applies weighting.
When Simple Average Works
Only when all base values are equal.
For example:
Same number of test questions
Same survey size
Same batch size
If not equal, always use weighted average.
Part 3: Common Mistakes
Pitfall 1: Missing Base Values
Without denominators, weighted averages cannot work.
Pitfall 2: Averaging Averages
Never average pre-aggregated percentages.
Always return to raw data first.
Pitfall 3: Mixing Different Metrics
Do not combine unrelated percentages.
Example: conversion rate + satisfaction score.
They measure different things.
Pitfall 4: Treating Percentages as Additive
Percentage changes are not simple sums.
They are multiplicative.
Pitfall 5: Not Labeling Methods
Always clarify whether results are:
Simple average
Weighted average
This prevents misinterpretation.
FAQ
Why is my simple average different?
Because it ignores sample size differences.
Is weighted average always correct?
Yes, when denominators differ.
Can percentages be averaged directly?
Only if all bases are equal.
What is best Excel method?
SUMPRODUCT with SUM.
Does weighted average always stay within range?
Yes, always between minimum and maximum values.
Final Thoughts
Averages of percentages are often misleading.
The key issue is hidden denominators.
Simple averages ignore them.
Weighted averages respect them.
If you want accurate analysis, always ask one question:
Are the base values equal?
If not, weight the data.
That is the difference between clean-looking numbers and correct decisions.