The WAVG function calculates the weighted average of the values in array_x, with corresponding weights taken from array_y. The arguments are either ranges or arrays.
WAVG is calculated using the formula:
For example:
WAVG({1, 2, 3, 4, 5}, {0.3, 0.3, 0.1, 0.7, 0.8})
returns 3.64.
See also: