Skip to content
Statculator
Descriptive Statistics

Weighted Mean Calculator (Weighted Average)

Free weighted average calculator. Enter values and weights to get the weighted mean with steps, Σxw and Σw. Works for grades, GPA, portfolios and surveys.

Free, no sign-up Runs in your browserBy Hira Noor, BS MathematicsUpdated

Try
Values and weights
#Value (x)Weight (w)Remove row
1
2
3
4
Tip: paste rows straight from a spreadsheet.

Weights can be percentages, credit hours, counts or any non-negative numbers. They do not need to add up to 100.

Results

Weighted mean, x̄w
83.3
Sum of weights, Σw
100
Sum of products, Σxw
8330
Number of values
4
Simple (unweighted) mean
84.75
Weighted − simple mean
-1.45
Largest weight share
40%
Smallest and largest value
74, 95

Interpretation: The weighted mean is 83.3. That is 1.45 below the simple average of 84.75: overall, the weights favor the lower values. The largest single effect comes from x = 95, which carries 10% of the total weight instead of an equal share of 25%, so it is under-represented compared with a simple average.

Weighted mean table

#xwShare of Σwx · w
1951010%950
2822020%1640
3743030%2220
4884040%3520
Σ100100%8330

Share of Σw is each weight divided by the total weight: the fraction of the result that value controls.

Step-by-step solution

  1. 1

    Multiply each value by its weight

    95 × 10 = 950
    82 × 20 = 1640
    74 × 30 = 2220
    88 × 40 = 3520
  2. 2

    Add the products

    Σxw = 950 + 1640 + 2220 + 3520 = 8330
  3. 3

    Add the weights

    Σw = 10 + 20 + 30 + 40 = 100
  4. 4

    Divide the sum of products by the sum of weights

    x̄w = Σxw / Σw = 8330 / 100 = 83.3

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

  1. 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.
  2. Use any consistent weight scale: 40 and 0.4 give the same result as long as every weight uses the same scale.
  3. Read the weighted mean, Σw and Σxw, and compare the weighted mean with the simple mean below it.
  4. 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.

  1. 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.
  2. Multiply each value by its weight to get the products x · w.
  3. Add the products to get Σxw, and add the weights to get Σw.
  4. 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

Weighted mean (weighted arithmetic mean)
x̄w = Σ(wᵢ · xᵢ) / Σwᵢ = (w₁x₁ + w₂x₂ + … + wₙxₙ) / (w₁ + w₂ + … + wₙ)
With weights that already sum to 1
x̄w = Σ(wᵢ · xᵢ)
Formula symbols
SymbolMeaning
xᵢeach value
wᵢthe weight of value i (wᵢ ≥ 0, with Σwᵢ > 0)
Σwtotal weight
Σxwsum 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?

  1. 01Products (grade points × credits): 4 × 3 = 12, 3.7 × 4 = 14.8, 3 × 3 = 9, 2.3 × 2 = 4.6, 4 × 1 = 4.
  2. 02Σxw = 12 + 14.8 + 9 + 4.6 + 4 = 44.4 quality points.
  3. 03Σw = 3 + 4 + 3 + 2 + 1 = 13 credit hours.
  4. 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.
ProblemValues (x)Weights (w)Σxw / ΣwWeighted meanSimple average
Course grade95, 82, 74, 8810%, 20%, 30%, 40%8,330 / 10083.384.75
Portfolio return8.5%, 3.2%, −1.5%$50k, $30k, $20k491,000 / 100,0004.91%3.4%
Two class averages72, 8530 and 20 students3,860 / 5077.278.5
Likert survey (1–5)1, 2, 3, 4, 54, 6, 10, 18, 12 people178 / 503.563

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 averageWeighted average
FormulaΣx / nΣ(w · x) / Σw
Each value countsequally (1/n)in proportion to its weight (w / Σw)
Typical usetest scores of equal value, a list of measurementscourse grades, GPA, portfolios, group means, surveys
When they agreeall weights equalall weights equal
Excel / Google SheetsAVERAGE(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.

ProblemValue (x)Weight (w)
Course gradescore on each componentpercentage of the grade
GPAgrade points (A = 4, B = 3, …)credit hours
Portfolio returnreturn on each holdingamount invested
Mean from a frequency tableeach distinct valueits frequency
Combined average of groupseach group’s meaneach group’s size
Likert or rating scaleanswer 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?

Multiply each value by its weight, add up those products, then divide by the sum of the weights. For scores 80 and 90 with weights 1 and 3, the weighted mean is (80 × 1 + 90 × 3) / (1 + 3) = 350 / 4 = 87.5.

What is a weighted mean used for?

It is used whenever values should not count equally: course grades and GPAs, portfolio returns, combining the averages of groups of different sizes, price indexes, and survey or Likert-scale scores. In each case the weight says how much each value should count.

Do the weights have to add up to 100%?

No. The formula divides by the total weight, so weights of 10, 20, 30 and 40 give the same answer as 0.1, 0.2, 0.3 and 0.4. If your weights already add up to 1, the weighted mean is simply the sum of the value × weight products.

How do I calculate a weighted mean mark or course grade?

Use each assessment’s mark as the value and its percentage of the course as the weight. Homework 95 at 10%, quizzes 82 at 20%, midterm 74 at 30% and final 88 at 40% give (950 + 1,640 + 2,220 + 3,520) / 100 = 83.3.

How do I calculate my GPA with a weighted average?

Use each course’s grade points as the value and its credit hours as the weight. For an A (4.0) in a 3-credit course and a B (3.0) in a 4-credit course, GPA = (4 × 3 + 3 × 4) / (3 + 4) = 24 / 7 ≈ 3.43.

How do you find the weighted mean of a Likert scale?

Use each answer code (1 = strongly disagree up to 5 = strongly agree) as the value and the number of respondents who chose it as the weight. Counts of 4, 6, 10, 18 and 12 give (4 + 12 + 30 + 72 + 60) / 50 = 178 / 50 = 3.56.

What is the difference between a weighted mean and an arithmetic mean?

The arithmetic mean treats every value as equally important, while the weighted mean lets some values count more than others. The arithmetic mean is the special case of the weighted mean in which every weight is the same.

How do I calculate a weighted average in Excel?

Put the values in one column and the weights in the next, then use =SUMPRODUCT(A2:A6, B2:B6) / SUM(B2:B6). The same formula works in Google Sheets. In R the function is weighted.mean(x, w).

Can a weight be zero?

Yes. A value with weight 0 is effectively left out of the average. At least one weight must be positive, otherwise the total weight is 0 and the weighted mean is undefined.

Cite this page

Statculator. (2026, November 14). Weighted Mean Calculator. Retrieved November 14, 2026, from https://statculator.com/descriptive-statistics/weighted-mean-calculator/