Calculate a mean with different weights
Enter one value and its weight on each line. A weighted average gives greater influence to entries with larger weights. It is useful for combining scores, proportions and other quantities when each observation has a different importance.
Formula and calculation method
Weighted average = sum(value × weight) ÷ sum(weights). Enter one value and weight per line, separated by a comma, semicolon or space. Weights can be decimals or percentages and do not have to add to 100. Zero weights are allowed but at least one weight must be positive.
Worked example
For a value of 80 with weight 2 and a value of 90 with weight 3, the weighted sum is 430 and total weight is 5. The weighted average is 86.
Do weights have to add to 100?
No. The calculator divides by the actual sum of weights. Weights must be non-negative and their total must be greater than zero.