stats

Overview ¶

Package stats provides aggregate functions for statistics.

Provided functions:

• stddev_pop: population standard deviation
• stddev_samp: sample standard deviation
• var_pop: population variance
• var_samp: sample variance
• covar_pop: population covariance
• covar_samp: sample covariance
• corr: correlation coefficient
• regr_r2: correlation coefficient squared
• regr_avgx: average of the independent variable
• regr_avgy: average of the dependent variable
• regr_sxx: sum of the squares of the independent variable
• regr_syy: sum of the squares of the dependent variable
• regr_sxy: sum of the products of each pair of variables
• regr_count: count non-null pairs of variables
• regr_slope: slope of the least-squares-fit linear equation
• regr_intercept: y-intercept of the least-squares-fit linear equation
• regr_json: all regr stats in a JSON object
• percentile_disc: discrete percentile
• percentile_cont: continuous percentile
• median: median value
• every: boolean and
• some: boolean or

These join the Built-in Aggregate Functions:

• count: count rows/values
• sum: sum values
• avg: average value
• min: minimum value
• max: maximum value

And the Built-in Window Functions:

• rank: rank of the current row with gaps
• dense_rank: rank of the current row without gaps
• percent_rank: relative rank of the row
• cume_dist: cumulative distribution

See: ANSI SQL Aggregate Functions