stats.md

stats: Mathematical statistics

Common statistical functions for SQLite. Adapted from extension-functions.c by Liam Healy.

Provides following functions:

• mode - mode,
• median - median (50th percentile),
• percentile_25 - 25th percentile,
• percentile_75 - 75th percentile,
• percentile_90 - 90th percentile,
• percentile_95 - 95th percentile,
• percentile_99 - 99th percentile,
• stddev or stddev_samp - sample standard deviation,
• stddev_pop - population standard deviation,
• variance or var_samp - sample variance,
• var_pop - population variance.

Download

Usage

sqlite> .load ./stats
sqlite> select median(value) from generate_series(1, 100);