In Oracle PL/SQL, REGR_INTERCEPT is a linear regression analytic function which takes two numeric inputs and returns the y-intercept of the regression line according to the calculation shown below:
AVG(x) - REGR_SLOPE( x, y) * AVG( y )
Note that the pairs having any argument's value as NULL are eliminated, but the final result might be NULL as per the above computation.
In the syntax, 'x' is referred to as the dependent variable and 'y' is referred to as the independent variable of the Regression Line.
sql> SELECT deptno, sal, REGR_INTERCEPT(sal, deptno) OVER (partition by deptno) "REGR_INTERCEPT"
Related Code Snippets:
- REGR_INTERCEPT - REGR_INTERCEPT returns the y-intercept of the regression line. After the eliminat...