Name

REGR_SLOPE — Returns the slope of the line.

Synopsis

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

Description

REGR_SLOPE returns the slope of the line. After the elimination of null (expr1, expr2) pairs, it makes the following computation:

COVAR_POP(expr1, expr2) / VAR_POP(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.