VARPA

Calculates the population variance[1] of the values in a data set.

Syntax:

VARPA( list )

Returns the population variance of the values in the list

list may be a range of cells, an array, or a comma-separated list of values (which may contain cell references and also ranges of cells as one or more of its elements).

Note that numeric values and text cells are included in the calculation - with text being treated as zero - but that blank elements still do not upset the average.

Formula:

VARPA, σ² = ( ni 1n (xi2) − (i 1n xi)2 )  ∕  n2

where n is the number of values and xi is the i‑th value.

Example:

VARPA(A1:A15)

returns the population variance of the cells in the range A1:A15.

Revisions:

This function was added in Fireworkz 2.00.

  1. Weisstein, Eric W. "Variance." From MathWorld--A Wolfram Web Resource. https://mathworld.wolfram.com/Variance.html