Business Finance

How to Average Percentages: Simple vs. Weighted Methods

By Bill & Tip Team

Percentages are ratios. They represent a relative value compared to a base of 100. Because percentages do not exist in a vacuum, averaging them together is a common area of mathematical confusion.

Simply adding a column of percentages and dividing by the total count can lead to significant calculation errors in academic grades, business data analysis, and investment portfolios. This guide explains the differences between Simple and Weighted averages of percentages and how to calculate them accurately.


The Trap: When Simple Averaging Fails

A simple average is calculated by summing a list of values and dividing by the number of items.

Let’s look at an extreme example to see why this fails for percentages:

If we calculate a Simple Average:

However, let’s look at the actual questions:

The simple average of 75% represents a massive distortion because Project B had 50 times as many questions (weight) as Project A. To get the true proportion, we must calculate a Weighted Average.

To input your data points and weights and see the math step-by-step, utilize our Average Percentage Calculator.


Simple vs. Weighted Average Formulas

To determine which calculation method to use, evaluate the bases (or sample sizes):

Method 1: Simple Average Percentage

Use this when all categories carry identical weight or base sizes:

Simple Average = (Pct 1 + Pct 2 + … + Pct N) ÷ N

Method 2: Weighted Average Percentage

Use this when the base sizes, point totals, or dollar values differ:

Weighted Average = [ (Pct 1 × W 1) + (Pct 2 × W 2) + … ] ÷ (W 1 + W 2 + … )

Where W represents the weight, sample size, or point value of each category.


Common Use Cases

Averaging percentages has major real-world implications:

Use our Average Percentage Calculator to quickly find averages, test grades, and portfolio returns.

If you are budgeting sales tax deductions or calculating tax additions, check out our standard Sales Tax Calculator to verify pre-tax bills and overall percentages.

Free Tools

Try the tools

Put this guide into action instantly with these free tools.

Frequently asked questions

Common questions about this topic.

Is the average of 50% and 100% always 75%? +

Only if the base numbers are equal. If you got 50% on a test with 2 questions (1/2) and 100% on a test with 100 questions (100/100), your true total is 101 out of 102 questions correct, which is a weighted average of 99.02%.

How do you calculate a weighted average in Excel? +

You can use the SUMPRODUCT and SUM functions in Excel: `=SUMPRODUCT(Percentages_Range, Weights_Range) / SUM(Weights_Range)`.

What is a simple average of percentages? +

A simple average of percentages adds all percentage values together and divides by the total count of percentages. It is only mathematically accurate when the size of each category or group is identical.

Back to blog