Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize
0 out of 4 rated this helpful - Rate this topic

Correlation (MDX)

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.

Note Note

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.