<< Click to Display Table of Contents >> VAR.S (variance of a sample)

Syntax:

VAR.S(Number1, Number2 [, Number3 ...])

Description:

This provides an estimate of the variance of a population based on a sample.

Number1, Number2, etc., are single values, cell ranges or arrays that contain the values to be evaluated (sample).

If this function refers to empty cells or cells with error values, they are ignored. Likewise, cells that contain text strings or logical values, but these can be entered directly into the list of arguments and thus taken into account.

Additional info:

The variance is calculated using the "unbiased" or "n-1" method.

Example:

VAR.S(2, 2, 3, 4, 1) returns 1.3

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. The function is unknown in older versions.

See also:

VAR, VARA, VAR.P/VARP, VARPA, STDEV.S/STDEV, STDEV.P/STDEVP