Weighted Average vs Simple Average: The Difference, With a Worked Example

Ask someone to average three numbers, and most people reach for the same instinct: add them up, divide by three. That instinct is exactly right when every number deserves equal say. It quietly breaks the moment some numbers matter more than others, and that is precisely the situation a weighted average exists to fix. This guide covers weighted average vs simple average with worked examples, formulas and the questions people ask around them.

Weighted average vs simple average: the formulas side by side

A simple average is the calculation almost everyone already knows.

A weighted average changes exactly one thing: every value is multiplied by its own weight before anything gets added up, and the division at the end is by the total of the weights, not by how many items there are.

Here x_i is a value, w_i is its weight, n is the number of values, and Σ means "sum across every item." When every weight happens to be equal, the two formulas collapse into the same answer, which is why the difference between them is easy to overlook until the weights genuinely differ.

A worked example: three grades, three different credit loads

Suppose a student earns 90 in a 4-credit course, 70 in a 3-credit course, and 60 in a 1-credit course. Treat all three grades as equally important, and the simple average is straightforward:

But a 4-credit course carries four times the weight of a 1-credit course in a real semester GPA, and a simple average has no way to reflect that. Weighting each grade by its own credit hours instead:

The weighted figure lands more than five points above the simple average, 78.75 versus 73.33, because it correctly lets the strongest result, the 90 in the largest course, pull harder than the weakest one, the 60 in a course worth only a single credit. The simple average, by contrast, let a 1-credit course cancel out a third of a 4-credit course's influence, which is not how a real semester GPA actually works.

Why the gap only shows up once the weights differ

If every course above carried the same number of credit hours, the weighted and simple averages would be identical, since a weight applied equally to everything does not change anything relative to anything else. The gap opens up specifically because the weights are unequal: one course is worth four times as much as another. The more lopsided the weights, and the wider apart the values themselves are, the larger that gap can grow. A weighted average is not a different kind of number from a simple average, it is the same idea corrected for the fact that not every input actually deserves an equal vote.

A second worked example: a portfolio return

The same arithmetic applies well outside of grades. Suppose 70% of an investment portfolio sits in a fund earning an 8% return this year, and the remaining 30% sits in a fund earning 2%. Averaging 8% and 2% as if they mattered equally gives 5%, but that number ignores that more than twice as much money is riding on the 8% fund. Weighting each return by its actual share of the portfolio:

The portfolio's true overall return, 6.2%, sits much closer to the larger holding's 8% than the naive 5% simple average would suggest, exactly because most of the money was earning the higher rate. Using the portfolio's dollar allocation as the weight, rather than treating both funds as equally important, is what makes the 6.2% figure the honest answer.

Weighted average when weights don't add up to 1 (or 100)

A detail that trips people up the first time they build a weighted average by hand: the weights never need to sum to 100, or to 1, or to any specific total at all. The formula divides by whatever the weights actually add up to, so credit hours of 4, 3 and 1 produce exactly the same result as scaled-up weights of 40, 30 and 10, or scaled-down weights of 0.4, 0.3 and 0.1. Only the size of each weight relative to the others changes the answer; the total they happen to sum to is irrelevant, because that total is exactly what the division at the end cancels out.

What a zero weight does, and does not, do

An item can carry a weight of zero without breaking the calculation. It still shows up in the count used for a simple average shown alongside the weighted one for comparison, but it contributes nothing to the weighted average itself, since multiplying any value by zero always produces zero. That makes a zero-weight row a useful way to keep something visible in a list, an audited course taken without credit, for instance, without letting it move the weighted result at all. A negative weight, on the other hand, is not meaningful the same way: it would subtract an item's influence rather than simply excluding it, which is why a weighted average calculation should reject a negative weight outright rather than silently accepting it.

Weighted mean definition and the weighted arithmetic mean

The weighted mean definition in statistics is a mean in which each observation is multiplied by a weight before the products are added and divided by the sum of the weights. Under that weighted mean statistics definition it is also called the weighted arithmetic mean, to separate it from weighted geometric and harmonic means. The simple average is the special case in which every weight is equal. Weighted mean vs arithmetic mean is therefore a question of generality rather than of kind, and weighted average vs mean, in everyday speech, is the same pairing: "mean" is the careful word, "average" the casual one.

Weighted average vs average, unweighted, normal and regular

Weighted average vs average, weighted average vs unweighted average, weighted average vs normal average and weighted average vs regular average all describe one contrast. Unweighted means every item counts equally, and in ordinary conversation "average" nearly always means exactly that. Adding the word "weighted" is a signal that the items are not equal, so a weight has to be supplied for each. If you are unsure which one a source used, check whether the number of items matters to the result: a simple average changes when you add an item, while a weighted average changes only as much as the new item's weight allows.

Weighted average vs median, moving average and FIFO

Weighted average vs median is a difference of purpose. The median is the middle value of a sorted list and ignores how far the other values sit from it, while a weighted average uses every value and its weight. Weighted average vs moving average is different again: a moving average smooths a time series by averaging a sliding window, and it can itself be weighted so that recent points count for more.

Weighted average vs FIFO appears in inventory accounting. FIFO assumes the oldest units are sold first, while the weighted average cost method prices every unit at the average cost of everything held. With 100 units bought at 10 and 50 units bought at 13, the weighted average cost is (1,000 + 650) ÷ 150 = 11.00 a unit. Selling 60 units then costs 660 under weighted average cost and 600 under FIFO. Expected value vs weighted mean is a simpler link: an expected value is a weighted mean whose weights are probabilities that add up to 1.

When to use a weighted average, and why

When to use weighted average methods comes down to one test: do the items differ in size, importance or reliability? If so, why use weighted average at all? Because a simple average would let a small or unreliable item count as much as a large or reliable one. When to use weighted average vs average is settled the same way: use the simple one only when the items are interchangeable. And why would you use a weighted average instead of a mean that ignores weights? Because the result then describes the whole quantity, not the list of items. The same reasoning explains why use weighted mean methods in surveys, where groups are weighted to match their share of a population.

Real life examples of weighted average are everywhere: a grade made from assignments and exams, a portfolio return, a consumer price index that weights each item in a basket by how much households spend on it, and a combined class average built from sections of different sizes.

Weighted average of percentages, and of averages

Weighted average of percentages questions usually start with a mistaken plain average. How to find the average of percentages depends on what they are percentages of. Suppose Class A has 30 students averaging 80% and Class B has 10 students averaging 60%. Averaging the two class figures gives 70%, but that treats a 10-student class as equal to a 30-student one. Weighting each by its size gives (30 × 80 + 10 × 60) ÷ 40 = 3,000 ÷ 40 = 75%. The same logic applies to a weighted average of averages in general: each group's average must be weighted by the number of items behind it.

The weighted average of two values is the simplest case, with one weight w on the first value and 1 minus w on the second. Weighted average with two weights such as 0.7 and 0.3 on the values 8 and 2 gives 0.7 × 8 + 0.3 × 2 = 6.2, the portfolio figure above.

Weighted average with negative numbers and negative weights

A weighted average with negative numbers works normally: profits and losses, or temperature changes, can be weighted exactly like positive values. A weighted average with negative weights is a different matter. A negative weight subtracts an item's influence, the sum of the weights can reach zero, and the result can fall outside the range of the values. For that reason a weighted average tool should reject negative weights, as the calculator on this site does.

Is GPA a weighted average?

Is GPA a weighted average? Yes. A GPA weights each course's grade points by its credit hours, which is exactly the credit-hour example earlier in this guide. Do not confuse that with a weighted GPA, where some schools add extra grade points to honors or advanced courses. The first is a weighted average of grade points; the second changes the grade points themselves before the averaging happens.

Calculating a weighted average in a spreadsheet

How to calculate weighted average in Excel takes one formula. Put the values in B2:B4 and the weights in C2:C4 and enter =SUMPRODUCT(B2:B4,C2:C4)/SUM(C2:C4). With 90, 70 and 60 against weights of 4, 3 and 1, that returns 630 ÷ 8 = 78.75. This SUMPRODUCT weighted average is also the weighted average formula in Excel for any list, and it is a weighted mean in Excel whatever you call it. The weighted average in Google Sheets uses the identical formula, and a plain =AVERAGE(B2:B4) gives the unweighted 73.33 for comparison.

Weighted average cost and weighted average interest rate

The weighted average cost inventory method, described above, applies when identical units are bought at different prices. A weighted average interest rate works the same way with loan balances as weights. Take 20,000 at 4% and 30,000 at 7%: the yearly interest is 800 and 2,100, so the weighted average interest rate formula gives 2,900 ÷ 50,000 = 5.8%. A simple average of the two rates would say 5.5%, which understates the cost because more of the money sits at the higher rate.

Where else this shows up

Weighted averages turn up anywhere some inputs should count for more than others:

• Course grades weighted by credit hours, the calculation universities actually run to produce a semester GPA, rather than a plain average of letter grades.
• Investment returns weighted by portfolio allocation, the example worked through above.
• Survey results weighted by sample size, so a 50-person survey wave does not carry the same influence as a 5,000-person wave when the two are combined.
• Product or supplier ratings weighted by review count, since a 5.0 average built from two reviews and a 4.6 average built from two thousand reviews are not equally trustworthy figures.

In every one of these cases, the underlying arithmetic is identical: a list of values, a list of weights, and one number at the end that reflects how much each value actually mattered rather than how many values there happened to be.

A short checklist for choosing between the two

Before you average anything, ask three questions. Are the items different in size, such as class sizes, loan balances or credit hours? Are some of them more reliable or more important than others? Would adding one more item of any size change what the result is supposed to mean? If the answer to any of these is yes, use weights. If all three answers are no, the simple average is the honest choice, and adding weights only adds work. When in doubt, compute both, as the calculator does, and look at the gap between them.

Running your own numbers

The weighted average calculator on this site takes any list of value-and-weight rows, adds or removes rows as needed, and returns both the weighted average and the plain simple average side by side, so the size of the gap between them is visible at a glance. A large gap means the weights are doing real work on your specific numbers; a small one means the weighting barely mattered this time. Either way, seeing both numbers together is the fastest way to check that the weights entered are actually the ones intended.