Results for REGR_COUNT


1 to 8 of 8 results.


Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

REGR_COUNT FunctionREGR_COUNT returns the number of non- number pairs used to fit the regression line. If applied

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

Type of Statistic ExpressionAdjusted R2 1-((1 - REGR_R2)*((REGR_COUNT-1)/(REGR_COUNT-2))) Standard error SQRT((REGR_SYY-(POWER(REGR_SXY … ,2)/REGR_SXX))/(REGR_COUNT-2)) Total sum of squares REGR_SYY Regression sum of squares POWER … / ((Standard error) * SQRT((1/REGR_COUNT)+(POWER(REGR_AVGX,2)/REGR_SXX))

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

REGR_SXX, REGR_SYY, and REGR_SXY Functionsfunctions make the following computations: REGR_SXX: REGR_COUNT(e1,e2) * VAR_POP(e2) REGR_SYY: REGR_COUNT … (e1,e2) * VAR_POP(e1) REGR_SXY: REGR_COUNT(e1,e2) * COVAR_POP(e1, e2)

SQL Reference, 10g Release 1 (10.1)

REGR_ (Linear Regression) Funct ion s

REGR_ (Linear Regression) FunctionsREGR_COUNT REGR_R2 REGR_AVGX REGR_AVGY REGR_SXX REGR_SYY REGR_SXY Syntax linear_regr::= Description … (expr1, expr2) * AVG(expr2) REGR_COUNT returns an integer that is the number of non- number pairs … elimination of ( expr1, expr2 ) pairs: REGR_COUNT(expr1, expr2) * VAR_POP(expr2) REGR_SYY makes the … following computation after

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

Sample Linear Regression Calculation) INTCPT, REGR_R2(s.quantity_sold, p.prod_list_price) RSQR, REGR_COUNT(s.quantity_sold, p.prod_list_price

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

Linear Regression Functions… The functions are as follows: REGR_COUNT Function REGR_AVGY and REGR_AVGX Functions REGR_SLOPE and

SQL Quick Reference, 10g Release 1 (10.1)

2 SQL Functions

Syntax for SQL Functions] ] ] ) REGR_AVGX REGR_AVGY REGR_COUNT REGR_INTERCEPT REGR_R2 REGR_SLOPE REGR_SXX REGR_SXY REGR_SYY … { REGR_SLOPE | REGR_INTERCEPT | REGR_COUNT | REGR_R2 | REGR_AVGX | REGR_AVGY | REGR_SXX | REGR_SYY

Guide, 10g Release 1 (10.1)

Contents

ContentsRegression Functions REGR_COUNT Function REGR_AVGY and REGR_AVGX Functions REGR_SLOPE and REGR_INTERCEPT


Was this page helpful?