REGR_AVGY Function | Mean Function | Teradata Vantage - 17.10 - REGR_AVGY - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Returns the mean of the dependent_variable_expression for all non-null data pairs of the dependent and independent variable arguments.

For the REGR_AVGY window function that performs a group, cumulative, or moving computation, see Window Aggregate Functions.


When there are fewer than two non-null data point pairs in the data used for the computation, then REGR_AVGY returns NULL.

Division by zero results in NULL rather than an error.