CovarianceN (MDX)

Returns the sample covariance of x-y pairs of values evaluated over a set, by using the unbiased population formula (dividing by the number of x-y pairs).

Syntax

CovarianceN(Set_Expression, Numeric_Expression_y [ ,Numeric_Expression_x ] )

Arguments

  • Set_Expression
    A valid Multidimensional Expressions (MDX) expression that returns a set.
  • Numeric_Expression_y
    A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number that represents values for the y-axis.
  • Numeric_Expression_x
    A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number that represents values for the x-axis.

Remarks

The CovarianceN function evaluates the specified set against the first numeric expression, to get the values for the y-axis. The function then evaluates the specified set against the second numeric expression, if specified, to get the set of values for the x-axis. If the second numeric expression is not specified, the function uses the current context of the cells in the specified set as values for the x-axis.

The CovarianceN function uses the unbiased population formula. This is in contrast to the Covariance function that uses the biased population formula (dividing by the number of x-y pairs).

Note

The CovarianceN function ignores empty cells or cells that contain text or logical values. However, the function includes cells with values of zero.

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.