Oracle PL/SQL: REGR R2 - REGR R2 returns the coefficient of determination (also called "R-squared" or "goodness of fit") for

Quick Search:

Oracle PL/SQL: REGR_R2

Jump to:

Category: >> Oracle PL/SQL >> REGR_R2

<< last

next >>

Snippet Name: REGR_R2

Description: REGR_R2 returns the coefficient of determination (also called "R-squared" or "goodness of fit") for the regression. VAR_POP(expr1) and VAR_POP(expr2) are evaluated after the elimination of null pairs. The return values are:

* NULL if VAR_POP(expr2) = 0
* 1 if VAR_POP(expr1) = 0 and VAR_POP(expr2) != 0
* (CORR(expr1,expr2) * CORR(expt1, expr2)) if VAR_POP(expr1) > 0 and VAR_POP(expr2) != 0

Also see:
» RANK
» REGR_SLOPE
» VARIANCE
» VAR_SAMP
» VAR_POP
» SUM
» STDDEV_SAMP
» STDDEV_POP
» STDDEV
» ROW_NUMBER
» REGR_SYY
» REGR_SXY
» REGR_SXX
» REGR_INTERCEPT
» REGR_COUNT
» REGR_AVGY
» REGR_AVGX
» Number Functions: RATIO_TO_REPORT
» Number Functions: RANK
» PERCENTILE_DISC
» PERCENTILE_CONT
» PERCENT_RANK
» OVER PARTITION BY
» NTILE
» MIN
» MAX
» LEAD
» LAST_VALUE
» LAST
» LAG

Comment: See REGR_AVGX Demo

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 02nd, 2009

conn oe/oe
 
SELECT job_id, REGR_R2(SYSDATE-hire_date, salary) REGR_R2
FROM employees
WHERE department_id IN (50, 80)
GROUP BY job_id;