stddev_samp#
- stddev_samp(input)[source]#
Calculates the standard deviation of non-null elements in the input expression.
Example:
SQL#SELECT stddev(x) FROM tbl
Input#╭───────╮ │ x │ │ --- │ │ Int64 │ ╞═══════╡ │ 100 │ ├╌╌╌╌╌╌╌┤ │ 200 │ ├╌╌╌╌╌╌╌┤ │ null │ ╰───────╯ (Showing first 3 of 3 rows)
Output#╭──────────────╮ │ x │ │ --- │ │ Float64 │ ╞══════════════╡ │ 70.710678118 │ ╰──────────────╯ (Showing first 1 of 1 rows)