What is a Weighted Mean Calculator?
A weighted mean, also called a weighted average or weighted arithmetic mean, is an average in which each value counts according to its weight: x̄w = Σ(w · x) / Σw. Multiply each value by its weight, add the products, then divide by the sum of the weights. Values with bigger weights pull the result toward themselves; with equal weights it is the ordinary mean.
What the Weighted Mean Calculator does
This weighted average calculator takes each value with its weight, multiplies them, adds the products (Σxw) and the weights (Σw), and divides. You get the weighted mean, the simple average for comparison, a table of every product and each weight’s share of the total, and the step-by-step working, so you can check a course grade, GPA, portfolio return or survey score by hand.
Weights can be anything non-negative that measures importance or size: percentages of a grade, credit hours, number of shares, amounts invested, or how many people gave each answer. They do not have to add up to 1 or 100, because dividing by Σw rescales them. The page works the same whether you call it a weighted mean calculator, a weighted arithmetic mean calculator or a weighted average calculator.
To do the same thing in software: in Excel or Google Sheets use =SUMPRODUCT(values, weights) / SUM(weights); in R use weighted.mean(x, w); in Python use numpy.average(x, weights=w).
How to use the Weighted Mean Calculator
- In Values and weights, enter one value per row in Value (x) and its importance in Weight (w). Use Add value for more rows, or paste two spreadsheet columns into the first cell.
- Use any consistent weight scale: 40 and 0.4 give the same result as long as every weight uses the same scale.
- Read the weighted mean, Σw and Σxw, and compare the weighted mean with the simple mean below it.
- Check the table of x · w products and weight shares, or open the step-by-step solution. The GPA (credits), Portfolio return and Likert survey example buttons load ready-made data.
How to calculate the weighted mean
Finding the weighted mean in statistics takes four steps, whatever the weights stand for. The calculator follows the same route and shows each one.
- Pair each value with its weight. For a grade, the value is the score and the weight is its percentage; for a GPA, the value is the grade points and the weight is the credit hours.
- Multiply each value by its weight to get the products x · w.
- Add the products to get Σxw, and add the weights to get Σw.
- Divide Σxw by Σw. The result is the weighted mean. If the weights already add up to 1 (or 100%), Σw is 1 (or 100) and the division is trivial.
Weighted mean formula
| Symbol | Meaning |
|---|---|
| xᵢ | each value |
| wᵢ | the weight of value i (wᵢ ≥ 0, with Σwᵢ > 0) |
| Σw | total weight |
| Σxw | sum of the value × weight products |
This weighted average formula is the same equation statistics textbooks write for the weighted mean. When the weights are frequencies (how many times each value occurs), the weighted mean equals the ordinary mean of the full list. When every weight is equal, it equals the simple average. For class intervals, use the midpoints as values, or let the Grouped Data Mean Calculator do it.
Weighted mean example: GPA from credit hours
A semester GPA
Problem. A student earns an A (4.0) in a 3-credit course, A− (3.7) in a 4-credit course, B (3.0) in a 3-credit course, C+ (2.3) in a 2-credit course and A (4.0) in a 1-credit lab. What is the semester GPA?
- 01Products (grade points × credits): 4 × 3 = 12, 3.7 × 4 = 14.8, 3 × 3 = 9, 2.3 × 2 = 4.6, 4 × 1 = 4.
- 02Σxw = 12 + 14.8 + 9 + 4.6 + 4 = 44.4 quality points.
- 03Σw = 3 + 4 + 3 + 2 + 1 = 13 credit hours.
- 04Weighted mean = 44.4 / 13 = 3.415.
Answer. The GPA is 3.42. A simple average of the five grades would give 3.40, because the 1-credit lab would count as much as the 4-credit course. Load the GPA (credits) example above to see the same working.
More weighted mean examples
The same formula covers grades, money, group averages and surveys. Only the meaning of the weight changes. Each row can be entered in the calculator to see the full working.
- Portfolio: half the money earned 8.5%, so the portfolio return (4.91%) sits well above the simple average of the three returns (3.4%).
- Two classes: the overall mean of all 50 students is 77.2, not 78.5, because the larger class had the lower average. Averaging group means without weights is a common mistake.
- Likert survey: the weighted mean of 3.56 lies between “neutral” (3) and “agree” (4), leaning toward agree.
| Problem | Values (x) | Weights (w) | Σxw / Σw | Weighted mean | Simple average |
|---|---|---|---|---|---|
| Course grade | 95, 82, 74, 88 | 10%, 20%, 30%, 40% | 8,330 / 100 | 83.3 | 84.75 |
| Portfolio return | 8.5%, 3.2%, −1.5% | $50k, $30k, $20k | 491,000 / 100,000 | 4.91% | 3.4% |
| Two class averages | 72, 85 | 30 and 20 students | 3,860 / 50 | 77.2 | 78.5 |
| Likert survey (1–5) | 1, 2, 3, 4, 5 | 4, 6, 10, 18, 12 people | 178 / 50 | 3.56 | 3 |
Weighted average vs regular average
A regular (simple) average adds the values and divides by how many there are, so each value counts the same. A weighted average divides by the total weight instead, so values with larger weights count more. Use the Average Calculator when every value matters equally and this page when they do not.
| Regular average | Weighted average | |
|---|---|---|
| Formula | Σx / n | Σ(w · x) / Σw |
| Each value counts | equally (1/n) | in proportion to its weight (w / Σw) |
| Typical use | test scores of equal value, a list of measurements | course grades, GPA, portfolios, group means, surveys |
| When they agree | all weights equal | all weights equal |
| Excel / Google Sheets | AVERAGE(values) | SUMPRODUCT(values, weights) / SUM(weights) |
What to use as the weight
The weighted mean appears under different names. What changes is what you use as the weight.
| Problem | Value (x) | Weight (w) |
|---|---|---|
| Course grade | score on each component | percentage of the grade |
| GPA | grade points (A = 4, B = 3, …) | credit hours |
| Portfolio return | return on each holding | amount invested |
| Mean from a frequency table | each distinct value | its frequency |
| Combined average of groups | each group’s mean | each group’s size |
| Likert or rating scale | answer code (1 to 5) | number of respondents |
Common use cases
- Grades and GPA: combine component scores by their percentage weights, or grade points by credit hours.
- Finance: portfolio return weighted by the amount in each asset, or average purchase price weighted by shares bought.
- Combining group averages: average several group means weighted by group size to get the true overall mean.
- Surveys and Likert scales: average answer codes weighted by how many people chose each one, or reweight responses so that over- or under-sampled groups count in proportion to the population.
Assumptions and limitations
- The result is only as sensible as the weights. Weights should reflect real importance or size, chosen before looking at the result.
- Weights must be non-negative and at least one must be positive. Negative weights have no meaning in an average.
- A weighted mean still hides spread. Two portfolios with the same weighted return can carry very different risk.
- A Likert weighted mean treats the gaps between answer codes as equal. Report the share of each answer too, or the median, when that assumption is doubtful.
- For an expected value of a probability distribution, where the weights are probabilities summing to 1, the Expected Value Calculator also computes the variance.
Frequently asked questions
How do you calculate a weighted mean?
What is a weighted mean used for?
Do the weights have to add up to 100%?
How do I calculate a weighted mean mark or course grade?
How do I calculate my GPA with a weighted average?
How do you find the weighted mean of a Likert scale?
What is the difference between a weighted mean and an arithmetic mean?
How do I calculate a weighted average in Excel?
Can a weight be zero?
Cite this page
Statculator. (2026, November 14). Weighted Mean Calculator. Retrieved November 14, 2026, from https://statculator.com/descriptive-statistics/weighted-mean-calculator/