Definition:

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.

**Example Syntax:**

REGR_INTERCEPT(x,y)

In the syntax, 'x' is referred to as the *dependent* variable and 'y' is referred to as the *independent* variable of the Regression Line.

**Example Usage:**

sql> SELECT deptno, sal, REGR_INTERCEPT(sal, deptno) OVER (partition by deptno) "REGR_INTERCEPT"

FROM employee

Related Links:

Related Code Snippets:

- REGR_INTERCEPT - REGR_INTERCEPT returns the y-intercept of the regression line. After the eliminat...