![]() REGR_COUNT(expr1, expr2) * VAR_POP(expr2) ![]() REGR_SXX makes the following computation after the elimination of null ( expr1, expr2) pairs: REGR_SXY, REGR_SXX, REGR_SYY are auxiliary functions that are used to compute various diagnostic statistics. It makes the following computation after the elimination of null ( expr1, expr2) pairs: REGR_AVGY evaluates the average of the dependent variable ( expr1) of the regression line. REGR_AVGX evaluates the average of the independent variable ( expr2) of the regression line. POWER(CORR(expr1,expr),2) if VAR_POP(expr1) > 0 andĪll of the remaining regression functions return a numeric data type and can be null: VAR_POP( expr1) and VAR_POP( expr2) are evaluated after the elimination of null pairs. The return value is a numeric data type and can be null. REGR_R2 returns the coefficient of determination (also called R-squared or goodness of fit) for the regression. REGR_COUNT returns an integer that is the number of non-null number pairs used to fit the regression line. After the elimination of null ( expr1, expr2) pairs, it makes the following computation:ĪVG(expr1) - REGR_SLOPE(expr1, expr2) * AVG(expr2) REGR_INTERCEPT returns the y-intercept of the regression line. After the elimination of null ( expr1, expr2) pairs, it makes the following computation: REGR_SLOPE returns the slope of the line. Oracle computes all the regression functions simultaneously during a single pass through the data.Įxpr1 is interpreted as a value of the dependent variable (a y value), and expr2 is interpreted as a value of the independent variable (an x value). Oracle applies the function to the set of ( expr1, expr2) pairs after eliminating all pairs for which either expr1 or expr2 is null. Table 2-8 for more information on implicit conversion and " Numeric Precedence" for information on numeric precedence
0 Comments
Leave a Reply. |