Variance()

Working with Formulas > Functions Used in Formulas > List Functions > Variance()

VARIANCE( ) calculates the variance of the numbers in the specified list.

Function Format

VARIANCE(number1 [, number2, number3, ...]) 

Return Value

VARIANCE() returns a numeric value 

Examples

VARIANCE(1, 2, 3) = 1 

VARIANCE(50, 100, 1) = 44 

VARIANCE(-50, -100, -1) = 44