next up previous contents index
Next: VARS, XLVAR Up: A. Function Reference Previous: VALUE   Contents   Index


VAR, VARP

Syntax: VAR(argumentlist)
  VARP(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

VAR returns the population variance (N weighting) of its arguments. Blank cells and cells containing strings are not counted. The formula is given by:

\begin{displaymath}
\frac{1}{N} \sum_{i=1}^N (x_i - \overline{x})^2
\end{displaymath}

VARP is a synonym for VAR.

Examples:

VAR(1, 2, 7) = 6.8888889

VAR(Y1..Y5) = 67.76, where Y1..Y5 = 22, 24, 29, 34, and 45

VARP(K6..K10) = 0.500824, where K6..K10 = 1, .33, 0, -0.66, and -0.99

Excel function: VARP


next up previous contents index
Next: VARS, XLVAR Up: A. Function Reference Previous: VALUE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003