pub enum RegrType {
Slope,
Intercept,
Count,
R2,
AvgX,
AvgY,
SXX,
SYY,
SXY,
}
Variants§
Slope
Variant for regr_slope
aggregate expression
Returns the slope of the linear regression line for non-null pairs in aggregate columns.
Given input column Y and X: regr_slope(Y, X)
returns the slope (k in Y = k*X + b) using minimal
RSS (Residual Sum of Squares) fitting.
Intercept
Variant for regr_intercept
aggregate expression
Returns the intercept of the linear regression line for non-null pairs in aggregate columns.
Given input column Y and X: regr_intercept(Y, X)
returns the intercept (b in Y = k*X + b) using minimal
RSS fitting.
Count
Variant for regr_count
aggregate expression
Returns the number of input rows for which both expressions are not null.
Given input column Y and X: regr_count(Y, X)
returns the count of non-null pairs.
R2
Variant for regr_r2
aggregate expression
Returns the coefficient of determination (R-squared value) of the linear regression line for non-null pairs in aggregate columns.
The R-squared value represents the proportion of variance in Y that is predictable from X.
AvgX
Variant for regr_avgx
aggregate expression
Returns the average of the independent variable for non-null pairs in aggregate columns.
Given input column X: regr_avgx(Y, X)
returns the average of X values.
AvgY
Variant for regr_avgy
aggregate expression
Returns the average of the dependent variable for non-null pairs in aggregate columns.
Given input column Y: regr_avgy(Y, X)
returns the average of Y values.
SXX
Variant for regr_sxx
aggregate expression
Returns the sum of squares of the independent variable for non-null pairs in aggregate columns.
Given input column X: regr_sxx(Y, X)
returns the sum of squares of deviations of X from its mean.
SYY
Variant for regr_syy
aggregate expression
Returns the sum of squares of the dependent variable for non-null pairs in aggregate columns.
Given input column Y: regr_syy(Y, X)
returns the sum of squares of deviations of Y from its mean.
SXY
Variant for regr_sxy
aggregate expression
Returns the sum of products of pairs of numbers for non-null pairs in aggregate columns.
Given input column Y and X: regr_sxy(Y, X)
returns the sum of products of the deviations of Y and X from their respective means.