DVARP

Syntax:

DVARP(range, condition)

Returns the population variance in the range for which the condition is satisfied.

The formula used is:

(n·Σi=n (xi2) − (Σi=n xi)2) ÷ n2

where xi is each value and n is the number of values.

Example:

DVARP(A1:A15, B1:B15>0)

returns the population variance of those cells in the range A1 to A15 whose equivalents in the range B1 to B15 are greater than zero.

See DAVG for more examples of how to use the condition to control which cells are included.