Documentation/How Tos/Calc: VAR function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 04:31, 8 April 2008 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


VAR

Returns the sample variance of the arguments.

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:
Calc sample var formula.png

Example:

VAR(2; 6; 4)

returns 4.

See also:

VARA, VARP, VARPA, STDEV

Statistical functions

Issues:

  • Calc assumes that logical values are 1 (TRUE) and 0 (FALSE). Excel ignores logical values.
Personal tools