Weighted Average Formula & How to Calculate It

This calculator works out the weighted average of a set of numbers when each value has a different weight (such as a grade worth 40% of a final mark). You enter each value and its weight, and the calculator returns the weighted mean. The formula is: Weighted Average = Σ(value × weight) / Σ(weight).

Formula

In words: multiply each value by its weight, add all those products, then divide by the sum of the weights.

In symbols:

Weighted Average = (x₁·w₁ + x₂·w₂ + … + xₙ·wₙ) / (w₁ + w₂ + … + wₙ)

• x = each value (unit depends on what you are averaging, e.g., points, dollars, kg)
• w = each weight (a number that reflects importance; often a percentage but any positive number works)
• n = the number of values

The weights do not have to add up to 1 or 100. The formula works with any positive weights, as long as the sum of the weights is not zero.

Worked Example

Using the default values from the calculator above:

• Value 1 = 85, weight 1 = 0.4
• Value 2 = 90, weight 2 = 0.4
• Value 3 = 70, weight 3 = 0.2

Step 1: Multiply each value by its weight:

• 85 × 0.4 = 34
• 90 × 0.4 = 36
• 70 × 0.2 = 14

Step 2: Add those products: 34 + 36 + 14 = 84

Step 3: Add the weights: 0.4 + 0.4 + 0.2 = 1.0

Step 4: Divide: 84 ÷ 1.0 = 84.00

The weighted average is 84.00. Notice this is lower than the simple average of (85+90+70)/3 = 81.67? Actually it is higher—because the highest value (90) has a larger weight (0.4) than the lowest (70, weight 0.2). The weighted average reflects that the 90 matters more than the 70.

When to Use a Weighted Average

Use a weighted average when some values in your data set matter more than others. Common situations:

• Grades: homework worth 20%, quizzes 30%, final exam 50%.
• Finance: portfolio return where each investment has a different amount of money.
• Surveys: responses weighted to match population demographics.
• Inventory: average cost per unit when you buy at different prices.

If all weights are equal, the weighted average equals the simple arithmetic mean. That is a good check: if your weights are all 1, the formula reduces to (x₁+x₂+…+xₙ)/n.

How to Choose the Right Weights

Weights represent importance, frequency, or quantity. There is no universal rule—it depends on your context. For grades, the syllabus usually defines the weights. For financial returns, the weight is the proportion of the total investment in each asset. For a customer satisfaction score, you might weight by the number of purchases each customer made.

Key principle: weights should be proportional to the influence you want each value to have. If one value should count twice as much as another, give it a weight that is twice as large. The actual size of the weights (0.5 vs 50) does not matter—only the ratios.

Common Mistakes and Misconceptions

• Forgetting to divide by the sum of weights. Some people just add the products and stop. That only works if the weights sum to 1 (or 100%).
• Using percentages without converting. If you use 40% as 40 instead of 0.4, the result is still correct as long as all weights are in the same scale, because the ratio is unchanged. But mixing 0.4 and 20 will give a wrong answer.
• Confusing weighted average with weighted sum. The weighted sum is just Σ(x·w). The weighted average divides by Σw.
• Rounding too early. Round only at the end. If you round each product to two decimals, you may introduce small errors.

Limitations of the Formula

The weighted average assumes the weights are known and fixed. It does not tell you how to assign weights—that is a judgment call. It also assumes the values are numeric and comparable. For example, averaging a rating scale of 1–5 with a price in dollars is meaningless unless you transform them.

The formula is sensitive to extreme weights. If one weight is 1000 and another is 1, the value with the huge weight dominates the result. That may be intended, but be aware.

Also, the weighted average is a single number—it hides the distribution. Two different data sets can have the same weighted average but very different spreads.

Weighted Average vs. Simple Average vs. Median

A simple average treats every value equally. A weighted average lets you adjust for importance. The median is the middle value when sorted; it is not affected by extreme outliers. Which one to use depends on the question:

• Use simple average when all values are equally important.
• Use weighted average when some values count more (e.g., grades, portfolio).
• Use median when you want a typical value that is not skewed by a few extreme numbers (e.g., income).

For example, if one student scores 100 and nine score 50, the simple average is 55, the median is 50. If the 100 is worth 90% of the grade, the weighted average is 95—very different. The choice changes the story.

Frequently Asked Questions

Q: Do the weights have to add up to 100%?
No. The formula divides by the sum of weights, so any positive numbers work. If they add to 1 or 100, the division is just a scaling step, but it is not required.

Q: Can I use negative weights?
Mathematically you can, but it rarely makes sense. Negative weights would invert the importance, which is usually not what you want. In practice, weights are non-negative.

Q: What is the difference between weighted average and weighted mean?
They are the same thing. “Weighted mean” is the formal statistical term; “weighted average” is the everyday phrase.

Q: How do I calculate weighted average in Excel?
Use the SUMPRODUCT function: =SUMPRODUCT(values_range, weights_range)/SUM(weights_range). For example, =SUMPRODUCT(A1:A3, B1:B3)/SUM(B1:B3).

Q: What if one weight is zero?
That value is simply ignored, because multiplying by zero removes it. The formula still works as long as the sum of weights is not zero.

Q: Is weighted average the same as weighted arithmetic mean?
Yes, exactly. There are also weighted geometric and weighted harmonic means, but the default “weighted average” usually refers to the arithmetic version.

Related

• Average km per year car? A global look
• Calculate Time Between Two Times: Formula & Guide
• Hectares to Acres Ireland: Land Area Converter

in v1 | Value 1 | - | 85 | 0
in w1 | Weight 1 | - | 0.4 | 0
in v2 | Value 2 | - | 90 | 0
in w2 | Weight 2 | - | 0.4 | 0
in v3 | Value 3 | - | 70 | 0
in w3 | Weight 3 | - | 0.2 | 0
out wa | Weighted average | - | (v1*w1 + v2*w2 + v3*w3) / (w1 + w2 + w3) | 2