REGR_SXY
Returns the sum of products of the difference between the dependent expression (expression1) and its average and the difference between the independent expression (expression2) and its average.
That is, REGR_SXY returns: ∑[(expression1 - average(expression1)(expression2 - average(expression2))]
The return value is of type DOUBLE PRECISION
. REGR_SXY
eliminates expression pairs where either expression in the pair is NULL
. If no rows remain, REGR_SXY
returns NULL
.
Syntax
SELECT REGR_SXY ( expression1, expression2 )
Parameters
expression1 |
The dependent DOUBLE PRECISION expression
|
expression2 |
The independent DOUBLE PRECISION expression
|
Example
=> SELECT REGR_SXY (Annual_salary, Employee_age) FROM employee_dimension; REGR_SXY ------------------- -90323481.0730019 (1 row)