The AVERAGE.WEIGHTED function finds the weighted average of a set of values, given the values and the corresponding weights.
Parts of an AVERAGE.WEIGHTED function
AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])
Part | Description | Notes |
values |
The values to be averaged. |
|
weights |
The corresponding list of weights to apply. |
|
[additional_values] |
Additional values to average. |
|
[additional_weights] |
Additional weights to apply. |
|
Sample formulas
AVERAGE.WEIGHTED(10, 1, 20, 3)
AVERAGE.WEIGHTED(A1:A2, B1:B2)
AVERAGE.WEIGHTED(A1:A2, B1:B2, C1, C2)
Examples
This example shows the weighted averages of different numbers and weights:
A | B | C | D | |
1 | 2 | 1 | Formula | Result |
2 | 4 | 3 | =AVERAGE.WEIGHTED(A1:A2, B1:B2) | 3.5 |
3 | 8 | 6 | =AVERAGE.WEIGHTED(2, 10, 4, 15) | 3.2 |
4 | =AVERAGE.WEIGHTED(A1:A2, B1:B2, C1, C2) | 6.2 |
This example of weighted average calculates someone's grade in a school course:
A | B | C | |
1 | Item | Grade | Percentage of final grade |
2 | Homework | 95 | 25% |
3 | Participation | 90 | 10% |
4 | Midterm exam | 85 | 15% |
5 | Projects | 88 | 20% |
6 | Final exam | 82 | 30% |
7 | Formula | Result | |
8 | Final grade | =AVERAGE.WEIGHTED(B2:B6, C2:C6) | 87.7 |
Related functions
- SUMPRODUCT: The SUMPRODUCT function calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges.
- AVERAGE: The AVERAGE function returns the numerical average value in a dataset, ignoring text.