ARRAY_STDDEV_POP

Computes the population standard deviation of numeric array values. NULL entries are ignored; non-numeric entries raise an error.

Syntax

ARRAY_STDDEV_POP(<array>)

Return Type

Floating-point.

Examples

SELECT ARRAY_STDDEV_POP([2, 4, 4, 4, 5, 5, 7, 9]) AS stddev_pop;

┌────────────┐
│ stddev_pop │
├────────────┤
│          2 │
└────────────┘

SELECT ARRAY_STDDEV_POP([1.5, 2.5, NULL, 3.5]) AS stddev_pop_null;

┌─────────────────┐
│ stddev_pop_null │
├─────────────────┤
│ 0.816496580927726 │
└─────────────────┘