Weighted Average Calculator
Calculate the weighted mean of any set of numbers. Perfect for school grades, stock portfolios, and statistical data where some values have different importance.
Weighted Average Calculator
Enter your values and their corresponding weights
Weights can be percentages, decimals, or raw numbers. They will be automatically normalized.
Your Weighted Average
Detailed breakdown and statistics
Enter your values and weights, then click Calculate to see the weighted average, simple average, and a full breakdown of the math.
Common Weighting Scales
Quick reference guide for typical weighting scales used in academic grading and performance reviews.
| Category | Typical Weight | Description |
|---|---|---|
| Homework / Assignments | 10% – 20% | Regular practice and foundational learning |
| Quizzes / Tests | 20% – 30% | Frequent assessments of specific modules |
| Midterm Exam | 20% – 30% | Major assessment covering half the course |
| Final Exam / Project | 30% – 40% | Comprehensive assessment of all material |
| Participation | 5% – 10% | Class engagement, attendance, and effort |
Weighted Average FAQ
Everything you need to know about calculating weighted means, grades, and statistical data.
To calculate a weighted average, multiply each value by its corresponding weight, sum all those products together, and then divide by the sum of the weights. The formula is: Weighted Average = Σ(Value × Weight) / Σ(Weight).
A simple average (or mean) adds all values together and divides by the number of values, treating every value as equally important. A weighted average assigns a ‘weight’ to each value, reflecting its relative importance. Values with higher weights have a greater impact on the final average.
No, the weights do not need to add up to 100% or 1. The formula automatically normalizes the weights by dividing by the sum of the weights. Whether you use percentages (20, 30, 50), decimals (0.2, 0.3, 0.5), or raw numbers (2, 3, 5), the final weighted average will be exactly the same.
To calculate your school grades, enter the score you received for each assignment or exam as the ‘Value’, and enter the percentage that the assignment is worth as the ‘Weight’. For example, if you scored 85 on a test worth 20% of your grade, enter 85 and 20. The calculator will compute your final weighted grade.
Weights should generally be positive numbers, as they represent the relative importance or frequency of a value. A weight of zero means that value is completely ignored in the calculation. Negative weights are mathematically possible but rarely make sense in practical applications like grades or finance.
In Excel, you can calculate a weighted average using the SUMPRODUCT and SUM functions. If your values are in cells A1:A5 and weights are in B1:B5, the formula is: =SUMPRODUCT(A1:A5, B1:B5) / SUM(B1:B5).