Top

Name

REGR_AVGY — Evaluates the average of the independent variable (expr1) of the regression line.

Synopsis

numeric REGR_AVGY ( in expr1 any ,
  in expr2 any );
 

Description

REGR_AVGY evaluates the average of the independent variable (expr1) of the regression line. It makes the following computation after the elimination of null (expr1, expr2) pairs:

AVG(expr1)

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.