This function calculates the linear regression of the values defined by a scope expression, and returns the coefficient of determination, R2.
LinRegR2( 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.
After obtaining the set of points, the LinRegR2 function returns the statistical R2 that describes the fit of the linear equation to the points.
Linear regression uses the least-squares method to calculate the equation of a regression line (which means the best-fit line for a series of points). The regression line has the following equation, where a is the slope and b is the intercept:
y = ax + b
The LinRegR2 function evaluates the specified scope against Numeric_Expression_y to obtain the values for the y-axis. The function then evaluates the specified scope against Numeric_Expression_x, if it is specified, to obtain the 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 scope as the values for the x-axis. This technique is useful with the Time dimension.
The PEL compiler cannot generate SQL code for this function.