Statistical aggregate function reference

Aggregate functions typically used for statistics.

corr

Return the (Pearson) population correlation coefficient.

covar_pop

Compute population covariance.

covar_samp

Compute sample covariance.

regr_avgx

Compute the average of the independent variable ('x').

regr_avgy

Compute the average of the dependent variable ('y').

regr_count

Compute the count where both inputs are not NULL.

regr_r2

Compute the square of the correlation coefficient.

regr_slope

Compute the slope of the least-squares-fit linear equation.

stddev

Alias of stddev_samp

Compute the sample standard deviation.

stddev_pop

Compute the population standard deviation.

stddev_samp

Compute the sample standard deviation.

var_pop

Compute the population variance.

var_samp

Compute the sample variance.