REGR_AVGY
REGR_AVGY evaluates the average of the dependent variable of the regression line.
Syntax
REGR_AVGY (expression1, expression2) OVER (window_clause)
Remarks
• The dependent variable is expression1. The independent variable is expression2.
• REGR_AVGY makes the following computation after the elimination of NULL expression1-expression2 pairs:
AVG (expression2)
• Without a window clause, REGR_AVGY is a simple aggregate function. Refer
Window Clause