VAR


Returns the sample variance.

Syntax:

VAR(number1, number2, ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers.
VAR returns the variance where number1 to number30 are a sample of the entire population. With N values in the sample, the calculation formula is:



Example:

VAR(2, 6, 4)
returns 4.






 
Created with Zapof