regr_sxx
aggregate function (Databricks SQL)
Returns the sum of squares of the xExpr
values of a group where xExpr
and yExpr
are NOT NULL.
Requires: SQL warehouse version 2022.25 or higher. This version is available in the Preview channel.
Arguments
yExpr
: A numeric expression, the dependent variable.xExpr
: A numeric expression, the independent variable.cond
: An optional boolean expression filtering the rows used for the function.