Var (MDX)

Returns the sample variance of a numeric expression evaluated over a set, using the unbiased population formula (dividing by n).

Syntax

Var(Set_Expression [ ,Numeric_Expression ] )

Arguments

• Set_Expression
  A valid Multidimensional Expressions (MDX) expression that returns a set.

• Numeric_Expression
  A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number.

Remarks

The Var function returns the unbiased variance of a specified numeric expression evaluated over a specified set.

The Var function uses the unbiased population formula, and the VarP function uses the biased population formula.

See Also

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
17 July 2006	Changed content: Updated syntax and arguments to improve clarity.