Regr_SXX

This function calculates the sum of squares of independent expressions used in a linear regression model. You can use this function to evaluate the statistical validity of a regression model.

It uses the following formula: Regr_Count(Y, X) * Var_Pop(X). The value is calculated after discarding all pairs with NULL.

Syntax:

Regr_SXX(Y, X)

Parameters: 

• Y. Type: Number.
• X. Type: Number.

Example:

X	Y
1	7
2	1
3	2
4	5
5	7
6	34
7	32
8	43
9	87

SELECT Regr_SXX(Y, X) FROM Table

Result:

60

Next page: Regr_SYY