VARP

Investment Studio > Expressions > Functions > Statistical > VARP

float varp(float data [, ...])

Returns the actual ("biased") variance of the arguments, regarded as a complete population. If the argument list contains a sample of a larger population for which the variance is to be estimated, use var instead.

All elements in the argument list are converted to floats, with exclusion if conversion fails. The list may contain array arguments, in which case each array element is treated as a separate list element.

The biased variance of N values is

			N			æ	N		ö	2
		N	å	x²	-	ç	å	x	÷
			k = 1			è	k = 1		ø
varp	=	¾	¾¾¾	¾	¾	¾	¾¾¾	¾	¾
					N²

Example

The expression

=varp(1, 7, 2, 5, 0, 3, 6, 6, 8, 3)

returns 6.49.

See also average, avedev, confidence, kurt, stdev, stdevp, var.