stats package - github.com/ncruces/go-sqlite3/ext/stats - Go Packages (original) (raw)
v0.30.3 Published: Nov 30, 2025 License: MIT
Documentation¶
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
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
This section is empty.
This section is empty.
Register registers statistics functions.
This section is empty.