오라클 선형회귀함수

https://atotw.tistory.com/21

Oracle REGR_*(선형회귀함수) 설명 : 오라클 함수

 

http://statwith.com/regr_-linear-regression-oracle-function-list/

[오라클 SQL 함수] REGR_ (Linear Regression) 함수 » 기서무나구물 & 통계분석연구회

 

-- 채용기간(sysdate-hiredate)과 sal 사이 회귀직선 기울기, 절편 구하기
select job, regr_slope(sysdate-hiredate, sal) slope,
                regr_intercept(sysdate-hiredate, sal) intercept
                from emp
                where deptno in (20,30)
                group by job
                order by job;
-- president는 1명 뿐이고, analyst는 2명의 sal가 같다.   


-- deptno가 20,30인 부서 직원 중 , 회귀분석에 사용된 직원의 숫자를 카운팅, job으로 묶어준다.
select job, regr_count(sysdate - hiredate, sal) count
            from emp
            where deptno in (20,30)
            group by job
            order by job, count;