Aggregate. Computes the average of the independent variable of the regression line.
regr_avgx ( dependent-expression , independent-expression )
dependent-expression | The variable that is affected by the independent variable. The expression accepts integer, long, float, timestamp, interval, and money datatypes. |
independent-expression | The variable that influences the outcome. The expression accepts integer, long, float, timestamp, interval, and money datatypes. |
avg( y )