LinRegPoint (PEL)
This function calculates the linear regression of the values specified in a scope and returns the value of the y-intercept in the regression line y = ax + b for a particular value of x.
LinRegPoint(
Slice_Expression_x,
Scope_Expression,
Numeric_Expression_y
[ , Numeric_Expression_x ]
)
Parameters
- Slice_Expression_x
A valid numeric expression that is typically a PerformancePoint Expression Language (PEL) expression of cell coordinates that return a number that represents values for the slicer axis.
- Scope_Expression
A valid PEL expression that returns a scope.
- Numeric_Expression_y
A valid numeric expression that is typically a PEL 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 PEL expression of cell coordinates that return a number that represents values for the x-axis.
Return Value
After the linear regression line is calculated, the value of the equation is calculated for the first numeric expression and then returned.
Remarks
Linear regression uses the least-squares method to calculate the equation of a regression line (that is, 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 LinRegPoint function evaluates the specified scope against Numeric_Expression_y to obtain the values for the y-axis. The function then evaluates the specified Scope_Expression againstNumeric_Expression_x, if specified, to get the 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. This technique is useful with the Time dimension.
The PEL compiler cannot generate SQL code for this function.