stats

Overview ¶

Package stats provides aggregate functions for statistics.

Provided functions:

• var_pop: population variance
• var_samp: sample variance
• stddev_pop: population standard deviation
• stddev_samp: sample standard deviation
• skewness_pop: Pearson population skewness
• skewness_samp: Pearson sample skewness
• kurtosis_pop: Fisher population excess kurtosis
• kurtosis_samp: Fisher sample excess kurtosis
• covar_pop: population covariance
• covar_samp: sample covariance
• corr: Pearson 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 as a JSON object
• percentile_disc: discrete quantile
• percentile_cont: continuous quantile
• percentile: continuous percentile
• median: middle value
• mode: most frequent value
• every: boolean and
• some: boolean or
• bit_and: bitwise and
• bit_or: bitwise or
• bit_xor: bitwise xor

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