Snippet Name: REGR_SXY Description: REGR_SXY makes the following computation after eliminating NULL (expr1, expr2) pairs: REGR_COUNT(expr1, expr2) * COVAR_POP(expr1, expr2) Also see:» RANK » REGR_SLOPE » VARIANCE » VAR_SAMP » VAR_POP » SUM » STDDEV_SAMP » STDDEV_POP » STDDEV » ROW_NUMBER » REGR_SYY » REGR_SXX » REGR_R2 » 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: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
Description: REGR_SXY makes the following computation after eliminating NULL (expr1, expr2) pairs: REGR_COUNT(expr1, expr2) * COVAR_POP(expr1, expr2)
Also see:» RANK » REGR_SLOPE » VARIANCE » VAR_SAMP » VAR_POP » SUM » STDDEV_SAMP » STDDEV_POP » STDDEV » ROW_NUMBER » REGR_SYY » REGR_SXX » REGR_R2 » 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
REGR_COUNT(expr1, expr2) * COVAR_POP(expr1, expr2)