Calculates the sample variance of the specified arguments.

Syntax  Copy Code
VAR( Number n1, Number n2, ... ) → Number

Parameters

n1
n2
…

Two or more numbers representing the sample.

Remarks

The arguments can be either numbers or cells, ranges, or arrays that contain numbers. Logical values, text, and empty cells are ignored. If the specified arguments do not contain at least two numbers, the function returns #N/A.

Example

Formula  Copy Code
=VAR({1245;1201;1268;1222;1211})

See Also

Function Reference
VARP Function
STDEV Function
AVERAGE Function