How do I calculate the average pass percentage across multiple schools?

Use weighted average: multiply each school's pass percentage by its number of students, sum all those products, then divide by the total students across all schools. Example: School A 80% (500 students), School B 60% (1500 students): weighted avg = (0.80×500 + 0.60×1500) / 2000 = (400+900)/2000 = 65%. Simple average of 70% would over-represent the smaller school.

Average Percentage Calculator

Q: How do you find the average of percentages?

Simple average: add all percentages and divide by the count. Example: average of 20%, 50%, 80% = (20+50+80)/3 = 50%. But if the groups behind each percentage have different sizes, use weighted average: Σ(pct × group size) / Σ(group sizes). Use simple average only when all groups are equal in size.

Q: When should I use simple vs weighted average for percentages?

Simple average: when all groups are the same size, or when each percentage represents one observation (e.g., average score across equal-sized test batches). Weighted average: when groups have different sizes, such as averaging pass rates across schools with different enrolments, or averaging defect rates across factories with different output volumes.

Q: Why is averaging percentages tricky?

Percentages hide the absolute counts behind them. A 90% success rate from 10 trials carries far less statistical weight than a 60% success rate from 1,000 trials. Simply averaging 90% and 60% gives 75%, but pooling the raw data: (9 + 600) / (10 + 1000) × 100 ≈ 60.3% — far closer to the larger group's rate. Weighted average correctly accounts for this by using group sizes.

Q: What is Simpson's Paradox and how does it relate to percentage averages?

Simpson's Paradox occurs when a trend appears in several groups of data but disappears (or reverses) when those groups are combined. For example: Treatment A has 80% success (800/1000) in mild cases and 40% success (200/500) in severe cases. Treatment B has 90% (90/100) in mild and 50% (50/100) in severe. A is better in each group, but simple percentages might suggest B is better overall. Weighted average with group sizes reveals the truth.

Q: How do you average percentages in Excel?

Simple average: =AVERAGE(A1:A10) where cells contain percentages. Weighted average: =SUMPRODUCT(A1:A10/100, B1:B10)/SUM(B1:B10)*100, where column A contains percentages and column B contains group sizes. Alternatively: =SUMPRODUCT(A1:A10, B1:B10)/SUM(B1:B10) if percentages are already as fractions (0.30, not 30%).

Q: What is the difference between average percentage and percentage change?

Average percentage: the mean value of several percentage figures (e.g., three departments have 60%, 70%, 80% completion — average is 70%). Percentage change: how much a value has changed relative to its original: (New − Old)/Old × 100. These are different calculations. Use average percentage when summarising multiple rate measurements; use percentage change when measuring growth or decline.

Q: Can I average percentages that exceed 100%?

Yes — for growth rates or ratios expressed as percentages, values can exceed 100% (e.g., revenue grew by 150%). Simple averaging still works: mean of 120%, 80%, 200% = (120+80+200)/3 ≈ 133%. For weighted average of such rates, the weighted formula Σ(pct × weight) / Σweight still applies. Just ensure the weights represent the appropriate quantity (revenue, population, etc.).

Q: What is the overall percentage if I know department-wise percentages and headcounts?

Overall percentage = Σ(department percentage × department headcount) / total headcount × 100. This gives the correct pooled rate. Example: HR dept 90% (50 staff), Engineering 70% (200 staff), Sales 80% (150 staff). Overall = (0.90×50 + 0.70×200 + 0.80×150) / 400 × 100 = (45+140+120)/400 × 100 = 76.25%.

Find the true average of percentages — simple arithmetic average or properly weighted by group size.

% What is Average Percentage?

The average percentage is a single representative percentage summarising a set of individual percentages. There are two ways to compute it, and choosing the wrong method is one of the most common statistical mistakes in everyday analysis.

The simple average (arithmetic mean of percentages) is correct only when every percentage is based on the same number of observations or the same group size. You add all the percentages and divide by how many there are. For example, if three equally-sized departments have 60%, 70%, and 80% task completion, the average is (60+70+80)/3 = 70%. This is valid because the three groups contribute equally.

The weighted average is necessary when percentages represent rates from groups of different sizes. The formula is: Weighted Average = Σ(percentage_i × total_i) / Σtotal_i. This is equivalent to pooling all the raw counts: (total successes across all groups) / (total population across all groups) × 100. For example, if a small school of 100 students has a 90% pass rate and a large school of 1,000 students has a 50% pass rate, the simple average of 70% is misleading. The weighted average = (0.90×100 + 0.50×1000) / 1100 × 100 = 590/1100 × 100 ≈ 53.6% — much closer to the large school’s rate, which dominates the combined student pool.

The discrepancy between simple and weighted averages can be dramatic. This is related to Simpson’s Paradox, where a trend in grouped data can completely reverse when groups are combined without proper weighting. This calculator shows both methods and highlights how much they differ — a useful sanity check whenever you report combined percentages.

📐 Formula

Simple Average = (p₁ + p₂ + … + p_n) ÷ n

p₁, …, p_n = the individual percentages

n = the number of percentages

Valid only when all groups have equal sizes.

Example: Average of 20%, 60%, 40% = (20+60+40)/3 = 40%

Weighted Average = Σ(p_i / 100 × n_i) / Σn_i × 100

p_i = percentage for group i

n_i = size (total) of group i — acts as the weight

Equivalent to: total successes across all groups ÷ total population × 100

Example: 30% from 200 people, 70% from 800 people: (0.30×200 + 0.70×800) / 1000 × 100 = (60+560)/1000 × 100 = 62%

📖 How to Use This Calculator

Steps to Calculate Average Percentage

Select a mode: "Simple Average" if all groups have equal sizes, or "Weighted Average" if percentages come from groups with different numbers of people or items.

Enter your data. In simple mode, enter percentages (e.g., 30, 50, 70). In weighted mode, enter percentages in the first box and corresponding group sizes in the second box — one value per line or comma-separated, in the same order.

Click Calculate to see the average percentage. In weighted mode, the simple average is shown alongside for comparison, and the note tells you how different the two methods are.

💡 Example Calculations

Example 1 — Simple Average of Test Scores

Four equal batches score 55%, 65%, 72%, 88%

All batches have the same size, so simple average is correct.

Average = (55 + 65 + 72 + 88) / 4 = 280 / 4 = 70%

Average percentage = 70% · Min: 55% · Max: 88% · Range: 33%

Try this example →

Example 2 — Weighted Average Pass Rate Across Schools

Small school: 90% pass (100 students) — Large school: 50% pass (1,000 students)

Simple average: (90 + 50) / 2 = 70% — misleading

Weighted: (0.90×100 + 0.50×1000) / (100+1000) = (90+500) / 1100 = 590/1100

Weighted average = 590/1100 × 100 ≈ 53.6%

Weighted average = 53.6% vs simple average of 70% — the large school dominates the combined rate.

Try this example →

Example 3 — Average Defect Rate Across Production Lines

Line A: 2% defect (5,000 units) — Line B: 5% defect (2,000 units) — Line C: 1% defect (8,000 units)

Simple average: (2 + 5 + 1) / 3 = 2.67% defect rate

Weighted: (0.02×5000 + 0.05×2000 + 0.01×8000) / 15000 = (100+100+80) / 15000

Weighted average = 280 / 15000 × 100 ≈ 1.87%

Weighted defect rate = 1.87% (Line C’s low rate dominates due to its high volume).

Example 4 — Department-Wide Approval Rating

HR: 85% approval (40 staff) — Engineering: 70% (150 staff) — Sales: 75% (60 staff)

Total staff = 40 + 150 + 60 = 250

Weighted sum = 0.85×40 + 0.70×150 + 0.75×60 = 34 + 105 + 45 = 184

Weighted average = 184 / 250 × 100 = 73.6% · Simple average = (85+70+75)/3 ≈ 76.7%

Overall approval = 73.6%. Engineering’s 70% (largest department) pulls the weighted result below the simple average.

Try this example →

❓ Frequently Asked Questions

How do you find the average of percentages?+

Simple average: add all percentages, divide by count. Valid only for equal-sized groups. Example: average of 20%, 50%, 80% = 50%. Weighted average (for unequal groups): Σ(pct × group size) / Σ(group sizes). Example: 30% from 200, 70% from 800 → (0.30×200 + 0.70×800)/1000 × 100 = 62%, not 50%.

What is the weighted average of percentages?+

Weighted average = Σ(pct_i / 100 × n_i) / Σn_i × 100, where n_i is the group size. This is equivalent to pooling the raw data: sum all individual successes, divide by total population. Use it whenever percentages come from groups with different sizes — schools, factories, departments, regions.

When should I use simple vs weighted average for percentages?+

Simple average: when all groups are the same size (e.g., five equally-sized test batches, or one observation per percentage). Weighted average: when groups have different sizes — averaging pass rates across schools, defect rates across production lines, approval ratings across departments with different headcounts. If in doubt and group sizes vary, use weighted average.

Why is averaging percentages tricky?+

Percentages hide absolute counts. A 90% pass rate from 10 students and a 60% pass rate from 1,000 students: simple average = 75%, but weighted average = (9+600)/1010 × 100 ≈ 60.3%. The 1,000-student group dominates. Simple averaging over-represents the smaller group, producing a misleading result that overstates the combined pass rate by 15 percentage points.

What is Simpson's Paradox and how does it relate to percentage averages?+

Simpson's Paradox: a trend visible in each subgroup can reverse or disappear when groups are combined incorrectly. Classic example: Treatment A beats B in mild cases AND severe cases, but simple percentage averaging makes B look better overall. Weighted averaging with proper group sizes always resolves the paradox by correctly pooling the data.

How do you average percentages in Excel?+

Simple average: =AVERAGE(A1:A5). Weighted average: =SUMPRODUCT(A1:A5/100, B1:B5)/SUM(B1:B5)*100, where column A holds percentages (as numbers like 30, 70) and column B holds group sizes. Alternatively: =SUMPRODUCT(A1:A5, B1:B5)/SUM(B1:B5) if column A already contains decimal fractions (0.30, 0.70).

What is the difference between average percentage and percentage change?+

Average percentage summarises multiple rate measurements into one representative value (e.g., 70% average pass rate across schools). Percentage change measures how one value has changed: (New−Old)/Old × 100. These are separate calculations for different purposes. Use average percentage for summarising rates; use percentage change for measuring growth or decline over time.

Can I average percentages that exceed 100%?+

Yes — for growth rates or ratios, values can exceed 100%. Simple average: mean of 120%, 80%, 200% = 133.3%. Weighted average still uses Σ(pct × weight) / Σweight with the appropriate weights (e.g., revenue for growth rates). The formula works the same way regardless of whether values are above or below 100%.

How do I calculate the overall pass percentage across multiple schools?+

Weighted average: multiply each school's pass % by its student count, sum all products, divide by total students. Example: School A 80% (500 students), School B 60% (1,500 students): overall = (0.80×500 + 0.60×1500) / 2000 × 100 = (400+900)/2000 × 100 = 65%. Simple average of 70% over-represents the smaller school.

What is the overall percentage if I know department-wise percentages and headcounts?+

Overall % = Σ(dept % × dept headcount) / total headcount × 100. Example: HR 90% (50), Engineering 70% (200), Sales 80% (150): overall = (0.90×50 + 0.70×200 + 0.80×150) / 400 × 100 = (45+140+120)/400 × 100 = 305/400 × 100 = 76.25%. Simple average of the three percentages (80%) would overstate the combined rate.

🔗 Related Calculators

📌 Quick Tips

💡Simple averaging of percentages is only correct when all groups have equal sizes. If group sizes differ, use weighted average to get the true overall percentage.

💡Weighted average percentage = Σ(percentage × group size) / Σ(group sizes). The group sizes act as weights that give larger groups more influence on the result.

💡A classic mistake: averaging 10% from a group of 1,000 people with 90% from a group of 10 people gives a simple average of 50% — but the weighted average is (100 + 900) / 1010 ≈ 9.9%.

💡When percentages represent pass rates, approval ratings, or defect rates for groups of different sizes, always use the weighted average.

💡The weighted average of percentages is equivalent to pooling all raw counts: total successes ÷ total population × 100.