Name
REGR_AVGX — Evaluates the average of the independent variable (expr2) of the regression line.
Synopsis
numeric
REGR_AVGX
(
|
in expr1 any , |
in
expr2
any
); |
Description
REGR_AVGX evaluates the average of the independent variable (expr2) of the regression line. It makes the following computation after the elimination of null (expr1, expr2) pairs:
AVG(expr2)
Parameters
expr1
Number expression.
expr2
Number expression.
Return Types
The function returns a value of type NUMERIC. If the function is applied to an empty set, then it returns null.