Skip to contents

Returns the intercept of the univariate linear regression line for non-NULL pairs in a group.

Usage

regr_intercept(y, x)

Arguments

y, x

DOUBLE

Value

DOUBLE

SQL examples

AVG(y)-REGR_SLOPE(y, x)*AVG(x)