Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

Correlation (MDX)

Updated: 17 July 2006

Returns the correlation coefficient of x-y pairs of values evaluated over a set.


Correlation( Set_Expression, Numeric_Expression_y [ ,Numeric_Expression_x ] )

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.

The Correlation function calculates the correlation coefficient of two pairs of values by first evaluating the specified set against the first numeric expression to obtain the values for the y-axis. The function then evaluates the specified set against the second numeric expression, if present, to obtain 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 the values for the x-axis.

ms145489.note(en-US,SQL.90).gifNote:
The Correlation function ignores empty cells or cells that contain text or logical values. However, the function includes cells with values of zero.

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft