VAR.S function

The VAR.S function is one of the statistical functions. It is used to estimate variance based on a sample (ignores logical values and text in the sample).

Syntax

VAR.S(number1, [number2], ...)

The VAR.S function has the following arguments:

Argument	Description
number1/2/n	Up to 255 numeric values for which you want to calculate the variance.

Notes

Empty cells, logical values, text, or error values supplied as part of an array are ignored. If they are supplied directly to the function, text representations of numbers and logical values are interpreted as numbers.

How to apply the VAR.S function.

Examples

The figure below displays the result returned by the VAR.S function.