Name
REGR_INTERCEPT — Returns the y-intercept of the regression line.
Synopsis
numeric REGR_INTERCEPT ( |
in expr1 any , |
in expr2 any ); |
Description
REGR_INTERCEPT returns the y-intercept of the regression line. After the elimination of null (expr1, expr2) pairs, it makes the following computation:
AVG(expr1) - REGR_SLOPE(expr1, expr2) * AVG(expr2)
Parameters
expr1
Number expression.
expr2
Number expression.
Return Types
The function returns a value of type NUMERIC. If the function is applied to an empty set, then it returns null.