Chapter 3. DB2 UDB’s statistics, analytic, and OLAP functions 101
3.2.1 AVG
The AVG function returns the average of a set of numbers.
ALL indicates duplicate rows are to be included, and this is the default.
The average function is applied to a set of values after eliminating all null values.
If DISTINCT is specified, duplicate values are eliminated as well.
3.2.2 CORRELATION
The CORRELATION function returns the coefficient of correlation of a set of
number pairs. The coefficient indicates the strength of the linear relationship
between the set of variables.
The input values must be numeric, and the data type of the result is
double-precision floating point.
REGR_COUNT Returns the number of non-null number pairs used to fit the
regression line.
REGR_INTERCEPT or
REGR_ICPT
Returns the y-intercept of the regression line.
REGR_R2 Returns the coefficient of determination for the regression.
REGR_SLOPE Returns the slope of the regression line.
REGR_SXX Returns quantities used to compute regression diagnostic statistics.
REGR_SXY Returns quantities used to compute regression diagnostic statistics.
REGR_SYY Returns quantities used to compute regression diagnostic statistics.
Statistics and analytic functions Description
Note: ALL and DISTINCT have the same meaning in other functions where
they are supported.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.