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. | * May refer to a range of cells, or may contain the values themselves. |
weights | The corresponding list of weights to apply. | * May refer to a range of cells, or may contain the weights themselves. * Weights cannot be negative, though they can be zero. * At least one of the weights must be positive. * If using a range of cells, that range must have the same number of rows and columns as the range of values. |
[additional_values] | Additional values to average. | * Additional values are optional. |
[additional_weights] | Additional weights to apply. | * Additional weights are optional, but each additional_value must be followed by exactly one additional_weight. |
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 |
| 2 | 4 | 3 | =AVERAGE.WEIGHTED(A1:A2, B1:B2) |
| 3 | 8 | 6 | =AVERAGE.WEIGHTED(2, 10, 4, 15) |
| 4 | =AVERAGE.WEIGHTED(A1:A2, B1:B2, C1, C2) |
This example of weighted average calculates someone’s grade in a school course:
| A | B | C |
|---|---|---|
| 1 | Item | Grade |
| 2 | Homework | 95 |
| 3 | Participation | 90 |
| 4 | Midterm exam | 85 |
| 5 | Projects | 88 |
| 6 | Final exam | 82 |
| 7 | Formula | |
| 8 | Final grade | =AVERAGE.WEIGHTED(B2:B6, C2:C6) |
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.