Quick Search:
 
 Oracle PL/SQL: REGR_INTERCEPT Jump to:  
Category: >> Oracle PL/SQL >> REGR_INTERCEPT  

<< lastnext >>

Snippet Name: REGR_INTERCEPT

Description: REGR_INTERCEPT returns the y-intercept of the regression line. After the elimination of null (expr1, expr2) pairs, it makes the following computation:

AVG(expr1) - REGR_SLOPE(expr1, expr2) * AVG(expr2)

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_R2
» 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

Generic Syntax: FUNCTION_NAME (<expression1>,<expression2>) OVER (<analytic_clause>)
 
conn oe/oe
 
SELECT job_id,
REGR_SLOPE(SYSDATE - hire_date, salary) slope,
REGR_INTERCEPT(SYSDATE - hire_date, salary) intercept
FROM employees
WHERE department_id IN (50,80)
GROUP BY job_id
ORDER BY job_id;


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org