Enter any value with its weight. Works for grades, GPA, salaries, ratings, or any weighted mean.
| Item | Value | Weight | Remove |
|---|---|---|---|
| Total Weight | |||
What is a Weighted Average?
A weighted average is the sum of each value multiplied by its weight, divided by the total weight. The weight tells the formula how much each value should count. When all weights are equal, the weighted average reduces to a simple arithmetic mean. When weights differ, values with higher weights pull the result toward themselves.
The weighted mean is the standard tool for combining numbers that are not equally important. A 5,000-share holding and a 100-share holding should not contribute equally to a portfolio's average return; a final exam worth 40% should not count the same as a 5%-weighted homework category; a survey response from 10,000 people carries more weight than one from 12. Every domain that mixes apples of different sizes uses some form of weighted average.
How to Calculate a Weighted Average
To calculate a weighted average, list every value with its weight, multiply each value by its weight, sum the products, and divide by the total weight. The same four steps work for grades, GPAs, finance, ratings, and surveys. Once you have the inputs, the calculator above runs the math live so you can swap weights and see the result move in real time.
- Pair every value with a weight. A value can be a percentage, a points score, a salary, a price, anything numeric. The weight is the relative importance: percentage weight in a syllabus, share count in a portfolio, number of respondents in a survey, dollars in a payroll category.
- Compute Value x Weight per row. Each product is the contribution of that row to the total weighted sum.
- Add every contribution to get the weighted total. This is the numerator of the formula.
- Divide by the sum of weights. The denominator doesn't have to equal 100; the formula works with any positive total. The result is the weighted mean in the same units as the values.
Weighted Average Formula
The weighted average formula is the same for every application. The notation below uses the standard plain-text form; the formula box renders it as a stacked fraction.
- Value = the number being averaged (a grade, a return, a rating, a salary)
- Weight = how much that value counts (a percentage, a share count, a number of respondents)
The formula is identical to a Sumproduct divided by a Sum if you are working in a spreadsheet. In Excel or Google Sheets the equivalent is =SUMPRODUCT(values, weights) / SUM(weights). The calculator above is a faster way to run the same math without setting up a sheet for a one-off calculation.
Calculate a Weighted Average Step by Step
Suppose a course has four assessments: a homework category at 15% weight (current score 95), two midterm exams at 20% weight each (scores 82 and 88), and a final at 45% weight (score 79). Each row contributes Value x Weight, and the total weight is 100, so:
Weighted Average = (95 x 15 + 82 x 20 + 88 x 20 + 79 x 45) / 100
= (1,425 + 1,640 + 1,760 + 3,555) / 100
= 8,380 / 100
= 83.80%
The final exam, at 45% weight, contributes the most to the result. A 1-point swing in the final moves the weighted average more than a 1-point swing anywhere else, which is why high-weight items deserve disproportionate study time.
Calculating a Weighted Average from Scratch in a Spreadsheet
Calculating a weighted average from scratch in a spreadsheet uses two columns and one formula. Put values in column A, weights in column B, then in any cell type =SUMPRODUCT(A2:A5, B2:B5) / SUM(B2:B5). The result updates whenever you change a value or weight. The calculator above is the no-spreadsheet equivalent for one-off calculations and what-if planning.
Setting an Average Calculator Weight per Item
Choosing the right average calculator weight for each item is the part most people get wrong. The weight should reflect relative importance, not frequency: a single 30%-weighted final exam carries more pull than ten 1%-weighted homework assignments. For finance, the weight is typically the dollar amount or share count. For surveys, the weight is the count of respondents in each group. Pick the weight unit that matches what the data is measuring, and the formula does the rest.
Using a Weighted Mean Calculator for Different Data Types
A weighted mean calculator works for any numeric data set: course grades, portfolio returns, survey ratings, salary bands, and product reviews. The math is identical across domains; what changes is the unit of the values and weights. For grades, values are percentages and weights are syllabus-defined percentages. For finance, values are returns and weights are dollars or shares. For surveys, values are response averages and weights are sample sizes.
Weighted Average vs Unweighted (Arithmetic) Average
A simple arithmetic mean adds the values and divides by the count. It treats every number equally, which is correct only when every number is equally important. A weighted average lets you assign different importance to each value. The two are mathematically the same when every weight is identical.
The difference matters whenever the underlying populations or contexts differ in size. Average a class grade where the final is worth 40% and homework is worth 5% as if they were equal, and the result misrepresents performance by 10 to 15 points. A weighted calculator is the way to keep the relative importance correct.
When a Weighted Average Equals an Arithmetic Mean
A weighted average equals the arithmetic mean only when every weight is identical. If five values all have weight 20 (for example, five exams each worth 20% of a course grade), the weighted average is the same as their arithmetic mean. Any deviation in the weights, even one category bumped from 15% to 25%, makes the two averages diverge.
Why an Average Calculator with Weighting Beats a Simple Mean
An average calculator with weighting captures importance differences that a simple mean cannot. Take two job offers: a $90K base with $10K equity, vs. an $80K base with $30K equity. A simple mean of base + equity treats them as identical at $50K average. Weighting by base salary (the realized cash component) shows the first offer is meaningfully higher in guaranteed pay. The same logic explains why a 4.5-star average from 1,200 reviews is more reliable than a 4.8-star average from 15.
Real-World Uses of Weighted Averages
The weighted average shows up across academic and professional fields any time numbers carry different importance. Below are the most common uses on this site and beyond.
Weighted Average Grading in Courses
Weighted average grading is the dominant approach in US high school and college syllabi. Categories like homework, quizzes, midterms, and final exams each get a percentage weight that sums to 100. The weighted course grade is what shows up in your gradebook. If you are calculating a course grade specifically, our weighted grade calculator takes letter grades and percentages directly with three input modes (Points, Letter, Percentage), and our grade calculator handles unweighted scoring. The calculator on this page is the more general math tool that the same formula powers under the hood.
GPA and Academic Averages
GPA is a weighted average of grade points, with credit hours as weights. A 4.0 grade in a 3-credit course contributes 12 quality points; a 3.0 in a 4-credit course contributes 12. The weighted average formula divides the sum of quality points by the sum of credits to produce the GPA. To compute GPA across multiple courses, our GPA calculator applies the formula automatically with the standard 4.0 scale and credit hour weighting.
Finance: WACC and Portfolio Returns
The weighted average cost of capital (WACC) is one of the most cited weighted averages in finance, blending the after-tax cost of debt and the cost of equity by their respective weights in the firm's capital structure. Portfolio returns work the same way: a position of $10,000 at an 8% return weighted by dollars contributes more than a $2,000 position at 12%. Combined return = ($10,000 x 8 + $2,000 x 12) / $12,000 = 8.67%, not the simple 10% midpoint of the two return percentages.
Survey Aggregation and Ratings
Aggregating ratings across groups requires a weighted average if the groups differ in size. A 4.5-star average from 1,200 customer reviews carries more statistical weight than a 4.8-star average from 15 reviews. The combined rating is (4.5 x 1,200 + 4.8 x 15) / 1,215 = 4.504, very close to the larger group because its weight dwarfs the smaller one. Survey research uses weighted averages to combine responses across demographic strata in proportion to each stratum's share of the population.
Salary, Payroll, and Project Cost Averages
Average payroll cost across departments uses headcount as the weight: a 50-person department at $80,000 average contributes more than a 5-person team at $120,000 to the company-wide figure. Combined average = (50 x 80,000 + 5 x 120,000) / 55 = $83,636. The same pattern holds for project cost averaging across line items, where each line's dollar amount is the natural weight.
Weighted Average of Percentages
The weighted average of percentages is the most common stumbling block users hit. The formula is the same as any weighted average: multiply each percentage by its weight, sum the products, divide by the total weight. The trap is treating the weights as decimals (0.30 instead of 30) or trying to pre-convert percentages, neither is needed because the division by total weight at the end normalizes everything.
For two grades of 92% (weight 30) and 78% (weight 70), the weighted average percentage is (92 x 30 + 78 x 70) / 100 = 82.20%. The result stays in percent because both values were already in percent. If your weights themselves are percentages (a 30% category), enter them as plain numbers (30) in the weight column; the formula doesn't need a decimal conversion.
How to Calculate Weighted Average Percentage When Weights Don't Sum to 100
When the weights in your data don't sum to 100 (a partial gradebook mid-semester, for example), the weighted average formula still works. The denominator becomes the actual total, not 100. If you have entered three grades with weights of 20, 30, and 25 (totaling 75), the formula divides by 75. The result accurately reflects only the entered data; once the remaining 25% of weight is graded, recalculate to update the result.
Common Mistakes and Edge Cases
Most weighted average errors come from one of three places: confusing weight with frequency, mismatched units, or forgetting that the divisor is the sum of weights and not always 100.
- Weight versus frequency. If you have five test scores and want the average, the count of tests (5) is not a weight. Weights are the relative importance of each score: a single midterm worth 25% has a higher weight than a single quiz worth 5%, even though both occur once.
- Mismatched units. Mixing percentage values with raw point values in the same column produces nonsense. Convert to a consistent unit first (everything to percent, or everything to points out of the same maximum) before averaging.
- Zero weight or negative weight. A zero weight removes that row from the calculation entirely (the contribution becomes zero, but so does the divisor share). Negative weights are not meaningful in any standard application; the calculator silently skips them.
- Forgetting the denominator. Adding the products without dividing by the total weight is a Sumproduct, not a weighted average. The calculator handles this for you, but if you are checking the math by hand, the divide step is required.
- Backward solver expectations. The Backward Solver assumes the only remaining work is one item with a known weight. If you have multiple remaining items, treat them as a single combined row by entering their total combined weight. To plan around a final exam specifically, the final grade calculator handles the inverse case directly.
Backward Solver: What Value Do I Need Next?
The Backward Solver inverts the weighted average formula to answer the planning question: given my current weighted average and the weight of the next item, what value do I need on that item to hit a target weighted average? The math is:
Required Value = (Target x (Current Weight + Remaining Weight) - Current Avg x Current Weight) / Remaining Weight
Switch to Backward Solver mode at the top of the calculator, type your current weighted average, the weight already counted, your target, and the weight of the remaining item. The required value displays instantly. If the required value is above 100, the target is mathematically out of reach unless extra credit or bonus points are available; the calculator flags this in the result interpretation.
For grade-domain planning specifically, where the remaining item is typically a final exam, the final grade calculator has additional features (letter-grade input, target letter grade, course-grade weighting) that this generic solver doesn't include. Use the solver here when the math problem is generic (any value, any weight) and the final-grade calculator when the context is academic.
Getting the weighted average wrong has real consequences depending on the context. A miscounted course grade can drop a student from a 3.5 scholarship threshold to a 3.4; a portfolio return computed without weighting can mislead allocation decisions by 1 to 2 percentage points; a survey result that ignores group size can flip a strategic recommendation. Always sanity-check the Total Weight readout below the calculator, and for graded coursework, verify the official weighted grade against your school's registrar or your gradebook before relying on the figure for academic standing.
Weighted average methodology aligns with academic record practices documented by AACRAO (the national association for collegiate registrars and admissions officers) for grade weighting in syllabi. For finance applications, the weighted average reference at Investopedia documents the same formula across portfolio returns, inventory accounting, and WACC. The math is consistent whether the values are grades, dollars, ratings, or any other numeric measure.