WAVG(array_x, array_y)

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:

image\ebx_792254907.gif

For example:

WAVG({1, 2, 3, 4, 5}, {0.3, 0.3, 0.1, 0.7, 0.8})

returns 3.64.

See also:

Other statistical functions