regr_intercept()

Aggregate. Computes the y-intercept of the linear regression line that best fits the dependent and independent variables.

Syntax

regr_intercept ( dependent-expression, independent-expression )

Parameters

dependent-expression	The variable that is affected by the independent variable. The expression accepts numeric datatypes, except timestamp, bigdatetime, and interval.
independent-expression	The variable that influences the outcome. The expression accepts numeric datatypes, except timestamp, bigdatetime, and interval.

This function converts its arguments to float, performs the computation in double-precision floating point, and returns a float. If the function is applied to an empty set, the result is NULL. The function is applied to sets of dependent-expression and independent-expression pairs after eliminating all pairs where either variable is NULL. The function is computed simultaneously during a single pass through the data. After eliminating NULL values, this computation is made, where x represents the independent variable and y represents the dependent variable:

avg( x ) - regr_slope( x, y ) * avg( y )