Computes the average of the dependent variable of the regression line.
Parameter |
Description |
---|---|
dependent-expression |
The variable that is affected by the independent variable. |
independent-expression |
The variable that influences the outcome. |
DOUBLE
This function converts its arguments to DOUBLE, performs the computation in double-precision floating-point, and returns a DOUBLE as the result. If applied to an empty set, then REGR_AVGY returns NULL.
The function is applied to the set of (dependent-expression and independent-expression) pairs after eliminating all pairs for which either dependent-expression or independent-expression is NULL. The function is computed simultaneously during a single pass through the data. After eliminating NULL values, the following computation is then made, where y represents the dependent-expression:
AVG(y)
Syntax 2 represents usage as a window function in a SELECT statement. As such, you can specify elements of window-spec either in the function syntax (inline), or with a WINDOW clause in the SELECT statement.