REGR_R2
Returns the square of the correlation coefficient of a set of expression pairs. The return value is of type DOUBLE PRECISION
. REGR_R2
eliminates expression pairs where either expression in the pair is NULL
. If no rows remain, REGR_R2
returns NULL
.
Syntax
SELECT REGR_R2 ( expression1, expression2 )
Parameters
expression1 |
The dependent DOUBLE PRECISION expression
|
expression2 |
The independent DOUBLE PRECISION expression
|
Example
=> SELECT REGR_R2 (Annual_salary, Employee_age) FROM employee_dimension; REGR_R2 ---------------------- 5.17181631706311e-05 (1 row)