Functions
AVERAGE.WEIGHTED
Weighted average
Try it
When to use it
When should I use AVERAGE.WEIGHTED instead of AVERAGE?
Use AVERAGE.WEIGHTED when different values should contribute unequally to the mean, such as combining scores from assessments with different credit hours or combining prices for different quantities.
Used in
education · finance · operations
Syntax
AVERAGE.WEIGHTED(values,weights)Examples
=AVERAGE.WEIGHTED({2,4},{1,3}) // => 3.5
=AVERAGE.WEIGHTED(2,10,4,15) // => 3.2
=AVERAGE.WEIGHTED({95,90,85,88,82},{0.25,0.10,0.15,0.20,0.30}) // => 87.7