Weighted Mean Calculator

What Does a Weighted Mean Calculator Do?

A weighted mean calculator finds the average of a list of numbers when some of them count for more than others. You give it each value and the weight that goes with it, and it returns the single number that balances the whole set. A final exam worth 40% of your grade pulls the result harder than a quiz worth 10%, and the calculator builds that into the answer.

This one also shows the ordinary average right next to it, so you can see how much the weights changed the picture. You get the working step by step, a table showing each item’s share of the total weight, and a chart where bigger bubbles mean heavier weights. Enter your data row by row, or paste two lists straight from a spreadsheet.

“Weighted mean” and “weighted average” are the same thing. Statistics books tend to say mean, grade books and finance sites tend to say average. The arithmetic does not change.

What Is the Weighted Mean Formula?

The weighted mean is the sum of each value times its weight, divided by the sum of the weights:

Here xi is the i-th value, wi is its weight, and Σ means “add them all up.” The top of the fraction is the total “weighted score.” The bottom is the total weight, and dividing by it is what keeps the answer on the same scale as your original numbers.

If your weights already add up to 1 (or to 100%), the denominator is 1 and the formula shrinks to Σ(wi × xi). That is the version most course syllabi use. You do not need the weights to add up to anything in particular, though. Weights of 1, 2 and 3 give exactly the same weighted mean as 10, 20 and 30, or 0.1, 0.2 and 0.3, because the total weight in the denominator absorbs the scale. Only the ratios between weights matter.

When every weight is equal, the formula collapses into the plain arithmetic mean. That is a useful sanity check: if you set all the weights to the same number and your result does not match the simple average, something was entered wrong. The mean, median and mode calculator handles that plain case and adds the median and mode.

How Do You Use This Weighted Mean Calculator?

Pick an entry style, type your numbers, and the results update as you go.

1. Rows mode: each row holds one value and its weight. The label field is optional, but it makes the breakdown table and chart easier to read. Use Add row for more items and the × button to remove one. A row you leave completely empty is ignored.
2. Paste mode: drop your values in the first box and the matching weights in the second. Commas, spaces, tabs and new lines all work as separators, so a column copied from Excel or Google Sheets pastes cleanly. Both lists must have the same number of entries, and the n-th weight belongs to the n-th value.
3. Weights can be anything non-negative. Percentages (a trailing % sign is fine), credit hours, quantities, counts or plain ratios all work. A weight of 0 simply leaves that item out.
4. Decimal places: choose how many digits to show, from 2 to 8. The calculation itself always runs at full precision.

The quick buttons load real examples: a course grade, a GPA, an average purchase price, star ratings and grouped age data. They are a fast way to see how the same formula adapts to different problems.

How Do You Calculate a Weighted Mean by Hand?

Multiply each value by its weight, add those products, add the weights, and divide the first total by the second. Four steps, and the middle two are just addition.

Take three test scores, 70, 80 and 90, with weights of 1, 2 and 3 (the later tests count more).

The plain average of those scores is 80. The weighted mean is 83.33 because the highest score carries the heaviest weight. That gap is the whole point of the method: it tells you how much the weighting matters for your particular data.

A quick reasonableness check is to remember that a weighted mean can never fall outside the range of your values, as long as no weight is negative. If your answer is below the smallest score or above the largest one, a step went wrong. Once you have the center, check the spread with the standard deviation calculator or the variance calculator.

Example 1: How Do You Work Out a Weighted Course Grade?

A syllabus says homework is worth 15%, quizzes 15%, the midterm 30% and the final exam 40%. Your scores are 95, 82, 74 and 88. Treat the percentages as weights:

Your course grade is 83.95%. The simple average of the four scores is 84.75, so ignoring the weights would have overstated your grade by 0.8 points. The midterm at 74 is the weak spot, and it counts twice as much as homework, which is why the weighted figure comes out lower.

Example 2: How Is a GPA a Weighted Mean?

A grade point average is a weighted mean of grade points, with credit hours as the weights. A three-credit class moves your GPA more than a one-credit lab, which is exactly what a weight is for.

On a common 4.0 scale, suppose you took Calculus (A, 4.0, 3 credits), Chemistry (B+, 3.3, 4 credits), English (A−, 3.7, 3 credits) and an elective (B−, 2.7, 2 credits).

Rounded to two places, that is a 3.48. Averaging the four grade points without weights would give 3.425, a gap of about 0.05. Schools do not all use the same scale (some score A− as 3.67, some add plus and minus differently), so use your registrar’s point values when you need an official number. The method stays the same.

Example 3: What Is the Average Price You Paid per Share?

Your average cost per share is a weighted mean of the purchase prices, weighted by the number of shares bought each time. Say you bought 10 shares at $42.50, then 25 shares at $38.20, then 15 shares at $51.00.

The simple average of the three prices is $43.90, a dollar higher, because it treats the small 10-share purchase as if it were as large as the 25-share one. The weighted figure matches what your brokerage statement calls the cost basis per share. The same logic works for the average price per unit of anything you buy in batches, such as fuel, inventory or ingredients. (This is a piece of arithmetic, not investment advice.)

How Do You Find a Weighted Mean From Frequencies or Grouped Data?

Use the frequencies as the weights. A frequency table already tells you how many times each value occurred, so it is a weighted mean waiting to happen.

A product has 250 reviews: 120 five-star, 80 four-star, 30 three-star, 10 two-star and 10 one-star.

The average rating is 4.16. Averaging the five star levels directly (1 through 5) would give 3.0, which says nothing about how the 250 people actually voted. This is the same trap that shows up with survey scales, test-score distributions and any table where each row stands for many observations.

For grouped data such as age bands, use the midpoint of each class as the value and the class frequency as the weight. With midpoints 5, 15, 25 and 35 and frequencies 4, 10, 6 and 2, the estimated mean is (20 + 150 + 150 + 70) / 22 = 17.73. It is an estimate, since the midpoint stands in for every observation inside its band.

The idea extends to probability. An expected value is a weighted mean in which the weights are probabilities and add up to 1. A fair die has an expected value of (1+2+3+4+5+6) / 6 = 3.5. The formulas behind the binomial distribution, the Poisson distribution and the hypergeometric distribution all produce their means this way.

When Should You Use a Weighted Mean Instead of a Simple Mean?

Use a weighted mean whenever the items you are averaging do not represent equal amounts of the thing you care about. If every item counts the same, the simple mean is the right tool and the two will agree.

• Grades: exams, projects and homework rarely carry the same percentage.
• GPA: courses have different credit hours.
• Prices and rates: the unit price over several purchases, an average interest rate across loans of different sizes, or a portfolio return where each holding has a different amount invested.
• Surveys: groups that are over- or under-represented in a sample are re-weighted toward their share of the population.
• Combining group averages: a class of 18 averaging 72 and a class of 12 averaging 85 do not average 78.5 together. Weight by headcount: (72×18 + 85×12) / 30 = 77.2.

The last one is easy to get wrong. Whenever someone averages averages without looking at the group sizes, a weighted mean is probably what they should have used.

What Score Do You Need on the Final Exam?

Subtract the points you have already earned from your target, then divide by the weight of the final. It is the weighted mean formula solved for the one unknown.

Using the grade from Example 1 before the final: homework 95 at 15%, quizzes 82 at 15% and the midterm 74 at 30% have earned 14.25 + 12.30 + 22.20 = 48.75 points out of the 60 available so far. The final is worth 40%, and you want an 85 for the course.

You would need about a 90.6 on the final. If the number comes out above 100, the target is out of reach without extra credit. If it comes out below zero, you have already locked in the grade. To test a few scenarios with this calculator, enter your finished components plus a trial final score and adjust the final until the weighted mean lands where you want it.

What Are the Weighted Variance and Standard Deviation?

They measure how far the values spread around the weighted mean, with heavier items counting more. The calculator reports both, using the weight-total denominator:

For the 70, 80, 90 example with weights 1, 2, 3, the weighted mean is 83.33. The squared deviations are 177.78, 11.11 and 44.44, weighted to 177.78 + 22.22 + 133.33 = 333.33. Divide by 6 and the variance is 55.56, so the weighted standard deviation is 7.45.

One caution. This is the “frequency weight” form, where a weight of 3 really means three observations. If your weights are survey or reliability weights, statistical packages offer other denominators, so check what your course or software expects before comparing numbers. Once you have a mean and a standard deviation, the normal CDF calculator can turn them into probabilities, and the normal curve calculator gives z-scores and percentiles.

How Do You Calculate a Weighted Mean in Excel, R and Python?

In every tool it is the same two pieces: a sum of products divided by a sum of weights.

Excel / Google Sheets   (values in A2:A5, weights in B2:B5)
  =SUMPRODUCT(A2:A5, B2:B5) / SUM(B2:B5)

R
  weighted.mean(c(95, 82, 74, 88), c(15, 15, 30, 40))    # 83.95

Python
  import numpy as np
  np.average([95, 82, 74, 88], weights=[15, 15, 30, 40])  # 83.95

Excel’s plain AVERAGE function knows nothing about weights, so it will quietly give you the unweighted result. SUMPRODUCT multiplies the two ranges row by row and adds the products, which is exactly the numerator of the formula. The calculator prints these lines again with your own numbers filled in, so you can check a spreadsheet against it or copy the code into a script.

What Mistakes Do People Make With Weighted Means?

The most common slip is dividing by the number of items instead of the total weight. In the 70, 80, 90 example that gives 500 / 3 = 166.67, which is higher than every score in the list. A weighted mean must sit between your smallest and largest values, so any answer outside that range is a flag.

Second, mismatching values and weights. When data lives in two columns that get sorted separately, the pairs fall out of line and the result is quietly wrong. Keep each weight on the same row as its value, or check the lengths when pasting two lists.

Third, mixing scales. A weight written as 0.15 in one row and 15 in the next means very different things. Pick one scale for the whole set.

Fourth, forgetting that some weights are missing from the total. If your syllabus percentages add up to 85 because you have not entered the final yet, the weighted mean is a grade on the work done so far, not your course grade. Divide only by the weights you actually include, or add the missing item.

Last, using a weighted mean where the weights should not apply. If an average is meant to treat every item equally, adding weights just distorts it.

Key Points to Remember

• Weighted mean = Σ(w × x) / Σw. Multiply, add, then divide by the total weight.
• Only the ratios of the weights matter, so 1:2:3 gives the same result as 10:20:30.
• Equal weights turn the weighted mean into the ordinary average.
• A weighted mean always lies between the smallest and largest value, provided no weight is negative.
• GPA, course grades, cost per share and frequency-table averages are all weighted means.
• To combine group averages, weight them by group size.
• In Excel use SUMPRODUCT divided by SUM, since AVERAGE ignores weights.

Frequently Asked Questions

Further reading: NumPy documentation: numpy.average and NIST/SEMATECH e-Handbook of Statistical Methods.

Related Calculators

Need a different statistics tool? Try these, or browse the full list of free statistics calculators:

Normal CDF CalculatorArea under the normal curve between any two bounds. Hypergeometric Distribution CalculatorProbabilities when you sample without replacement. Binomial Distribution CalculatorExact, cumulative, and interval binomial probabilities with full statistics. All StatsSolve CalculatorsBrowse the full directory of free statistics tools.