Regr_Intercept





This function calculates the Y-intercept of the regression line. It uses the following formula: AVG(Y) - Regr_Slope(Y, X) * AVG(X). Pairs with NULL values are discarded.

Syntax:

Regr_Intercept(Y, X)

Parameters:

  • Y. Type: Number.
  • X. Type: Number.

Example:

X

Y

1

7

2

1

3

2

4

5

5

7

6

34

7

32

8

43

9

87

SELECT Regr_Intercept(Y, X) FROM Table

Result:

-20.361111


Comments
0
Add comment