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.