This function calculates the correlation coefficient of x-y pairs of values evaluated over a scope.
Correlation( Scope_Expression, Numeric_Expression_y [ , Numeric_Expression_x ] )
A valid PerformancePoint Expression Language (PEL) expression that returns a scope.
A valid numeric expression that is typically a PEL expression of cell coordinates that return a number that represents values for the y-axis.
A valid numeric expression that is typically a PEL expression of cell coordinates that return a number that represents values for the x-axis.
If successful, this function returns the real number between 0 and 1 that specifies the correlation coefficient.
The Correlation function calculates the correlation coefficient of two pairs of values by first evaluating the scope specified in Scope_Expression against Numeric_Expression_y to obtain the values for the y-axis. The function then evaluates the specified scope against the Numeric_Expression_x, if present, to obtain the scope of values for the x-axis. If Numeric_Expression_x is not specified, the function uses the current context of the cells in the specified scope as the values for the x-axis.
The Correlation function ignores empty cells or cells that contain text or logical values. However, the function includes cells with values of zero.
The PEL compiler cannot generate SQL code for this function.