Investment Studio > Expressions > Functions > Statistical > VAR

float var(float data [, ...])

Returns the unbiased variance of the arguments, i.e. an estimate of the variance of a larger population from which the arguments are sampled (if the argument list contains the entire population, use varp instead).

All elements in the argument list are converted to floats, with exclusion if conversion fails. The list may contain array arguments, in which case each array element is treated as a separate list element.

The unbiased variance of N values is

        N     æ N   ö 2
      N å x2 - ç å x ÷  
        k = 1     è k = 1   ø  
var  =   ¾ ¾¾¾ ¾ ¾ ¾ ¾¾¾ ¾ ¾  
          N (N - 1)      

Example

The expression

=var(1, 7, 2, 5, 0, 3, 6, 6, 8, 3)

returns 7.21111...

See also average, avedev, confidence, kurt, stdev, stdevp, varp.