regr_intercept

Returns the intercept of the regression line.

regr_intercept

Introduced in: v26.9.0

Returns the intercept of the least-squares fit of y on x:

$$\bar{y} - slope \cdot \bar{x}$$

Returns nan when x is constant, because the fitted line is vertical.

Syntax

regr_intercept(y, x)

Aliases: regrIntercept

Arguments

• y — Dependent variable. (U)Int* or Float*
• x — Independent variable. (U)Int* or Float*

Returned value

Returns the intercept of the regression line. Float64

Examples

Basic usage

Query

SELECT regr_intercept(y, x)
FROM VALUES('x Float64, y Float64', (1, 2), (2, 4), (3, 6), (4, 8))

Response

┌─regr_intercept(y, x)─┐
│                    0 │
└──────────────────────┘