ARRAY_VAR_POP()

All functions > ARRAY > ARRAY_VAR_POP()

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

Signatures

Returns: Population variance

ARRAY_VAR_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
    f1 := ARRAY_VAR_POP(ARRAY[2, 4, 4, 4, 5, 5, 7, 9]) -- Population variance
;