ARRAY_STDDEV_POP()

All functions > ARRAY > ARRAY_STDDEV_POP()

Returns the population standard deviation (divide by N) of numeric array elements as a DOUBLE.

Signatures

Returns: Population standard deviation

ARRAY_STDDEV_POP(array: ARRAY<T>) → DOUBLE

Notes

• Ignores NULL elements
• Returns NULL for an empty array or an array of only NULLs

See also

• Array functions

Examples

SELECT
    -- Population stddev
    f1 := ARRAY_STDDEV_POP(ARRAY(2, 4, 4, 4, 5, 5, 7, 9))
;