REGR_INTERCEPT
Description
REGR_INTERCEPT is used to calculate the y-intercept of the least squares-fit linear equation for a set of number pairs.
Syntax
REGR_INTERCEPT(y, x)
Parameters
y
(Numeric): The dependent variable.x
(Numeric): The independent variable.
Both x
and y
support basic numeric types.
Returned values
Returned data type: FLOAT64
The function returns the y-intercept of the linear regression line.
If there are no rows, or only rows with null values, the function returns NULL.
Examples
-- Example 1: Basic Usage
SELECT regr_intercept(y, x) FROM test;
-- Example 2: Usage in a query with sample data
SELECT * FROM test;
+------+------+------+
| id | x | y |
+------+------+------+
| 1 | 18 | 13 |
| 3 | 12 | 2 |
| 5 | 10 | 20 |
| 2 | 14 | 27 |
| 4 | 5 | 6 |
+------+------+------+
SELECT regr_intercept(y, x) FROM test;
+----------------------+
| regr_intercept(y, x) |
+----------------------+
| 5.512931034482759 |
+----------------------+
Usage notes
- This function ignores any pair where either value is null.
- In cases where the calculation would result in a division by zero, the function will return NULL.
Related functions
REGR_SLOPE, REGR_R2, REGR_COUNT, REGR_AVGX, REGR_AVGY
References
For more details about linear regression functions, please refer to the SQL standard documentation on aggregate functions.