Weighted Average Calculator

What Is a Weighted Average?

A weighted average gives different items different levels of importance when calculating a mean. Unlike a regular average, it does not treat every value equally — a final exam worth 40% of your grade matters far more than a quiz worth 5%. The weighted mean formula multiplies each value by its weight, sums the products, then divides by the total weight.

The formula looks like this: Weighted Mean = Σ(value × weight) / Σ(weight). When all weights are equal, the weighted mean reduces to the ordinary arithmetic mean. The concept appears everywhere from university grade books to bond pricing in finance and sample-size adjustments in survey research.

For a deeper look at the math behind this formula, the full weighted mean guide on this site covers the derivation, common pitfalls, and a comparison with the arithmetic mean.

How to Calculate a Weighted Average — Step by Step

The worked example below uses a typical four-component course grade: Final Exam (88, weight 40%), Midterm (75, weight 30%), Homework (92, weight 20%), Quizzes (85, weight 10%).

Notice that the regular arithmetic average of the four scores — (88 + 75 + 92 + 85) / 4 — is 85.00, slightly higher than 84.60. The difference arises because the largest weight (40%) belongs to the second-lowest score (88). Whenever the highest weights do not align with the highest values, the weighted average falls below the regular average.

Weighted Average Formula

The weighted mean formula is Σ(v × w) / Σ(w), where v is each value and w is its corresponding weight. The denominator normalises the result, which means the formula works correctly whether you enter weights as percentages, decimal proportions, or raw numbers like credit hours.

Weighted Average vs. Regular Average

The simplest way to see the difference is through the same four scores. Using the regular average: (88 + 75 + 92 + 85) / 4 = 85.00. Using the weights above (40%, 30%, 20%, 10%): the weighted mean is 84.60. The gap is small here, but grows sharply when weights are very unequal or when the high-weight items have much lower (or higher) scores than the low-weight items.

Situation	Use Regular Average	Use Weighted Average
All items matter equally	Yes	Not needed
Course grades with different exam weights	No	Yes
GPA across courses with different credit hours	No	Yes
Portfolio return with different allocation sizes	No	Yes
Survey means with unequal group sizes	No	Yes
Average price of identical items	Yes	Not needed

One practical rule: if the thing you are averaging has an explicit importance factor attached to it (a credit value, an allocation percentage, a sample size), that factor is your weight. When no such factor exists, a regular mean is usually the right tool. For a broader discussion of how the mean relates to weighted calculations, the mean guide and the mean examples page both cover the connection clearly.

Real-World Examples

Course Grade

The Course Grade preset in the calculator above already shows this calculation in full. With a final exam at 88 (40%), a midterm at 75 (30%), homework at 92 (20%), and quizzes at 85 (10%), the weighted mean is 84.60. Compare that to the raw average of 85.00 — the 0.40-point drop comes entirely from the highest weight going to a below-average score.

Investment Portfolio

Survey Research

Three demographic groups reported customer satisfaction scores: Group A (n = 500, score = 7.2), Group B (n = 300, score = 6.8), Group C (n = 200, score = 8.1). Weighting by sample size gives a mean of (7.2×500 + 6.8×300 + 8.1×200) / 1000 = 7.24. The unweighted average of 7.37 overstates satisfaction because it treats the small group (n = 200) as equally influential as the large group (n = 500). This is the scenario the weighted mean guide explores for research applications. See also how population vs. sample considerations can affect which weights to choose.

Frequently Asked Questions

What is the difference between a weighted average and a regular average?

A regular average treats every value equally — it sums all values and divides by the count. A weighted average scales each value by its importance before averaging. If your final exam is worth 40% of your grade and a quiz worth 5%, the exam score pulls the overall average far more than the quiz. The two calculations give the same result only when all weights are equal.

How do I calculate a weighted average in Excel?

Use =SUMPRODUCT(B2:B5, C2:C5) / SUM(C2:C5), where B2:B5 holds your values and C2:C5 holds your weights. SUMPRODUCT multiplies each value by its corresponding weight and sums all the products. Dividing by SUM(C2:C5) normalises the result. This is the same calculation this calculator performs for every preset.

What does a weighted average GPA mean?

A weighted GPA weights each course grade by the number of credit hours that course carries. A 3-credit course contributes three times as much to your GPA as a 1-credit course. This is more accurate than a simple average of letter grades because it reflects the academic workload of each class. Use the Raw Numbers weight mode in the calculator above and enter credit hours as your weights to compute a GPA directly.

Can weights be percentages, credit hours, or raw numbers?

Yes — any positive numbers work. The formula Σ(v×w) / Σ(w) normalises automatically, so 40, 30, 20, 10 and 4, 3, 2, 1 give identical results for the same set of values. What matters is the relative size of each weight, not the unit. This calculator accepts both formats and warns you when percentage weights do not sum to 100, but it still calculates correctly even then.

Why is my weighted average different from my regular average?

They differ whenever weights are not equal. For four scores of 88, 75, 92, 85 with equal weights, the regular average is 85.00. With weights of 40%, 30%, 20%, 10%, the weighted average is 84.60 — lower because the largest weight goes to the second-lowest score (88). If your highest-weighted items have higher scores than your low-weighted items, your weighted average will exceed the regular average.

What happens if my weights do not add up to 100%?

The formula still works. The denominator Σ(w) normalises the result to give the proportional weighted mean. If weights sum to 90 instead of 100, the calculator divides by 90 and the result is still mathematically correct. The yellow warning banner appears so you can check for data entry mistakes, but it does not block the calculation.

Is a weighted mean the same as a weighted average?

Yes — both terms describe the same calculation: Σ(v×w) / Σ(w). Weighted mean is the standard term in statistics and academic research. Weighted average is the everyday term you see in grade books, financial models, and inventory accounting. This calculator and the weighted mean guide use both interchangeably.

Related Calculators & Guides

The weighted average is one tool within descriptive statistics. These pages cover the concepts and calculations that connect directly to weighted means.