Aggregate. Returns the sum of products of the dependent and independent variables. Evaluates the statistical validity of a regression model.
regr_sxy ( dependent-expression , independent-expression )
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. |
regr_count( x, y ) * covar_pop( x, y )