ARRAY_VAR_SAMP()

All functions > ARRAY > ARRAY_VAR_SAMP()

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

Signatures

Returns: Sample variance

ARRAY_VAR_SAMP(array: ARRAY<T>) → DOUBLE

Notes

• Ignores NULL elements
• Returns NULL when fewer than two non-NULL values are present

See also

• Array functions

Examples

SELECT
    f1 := ROUND(ARRAY_VAR_SAMP(ARRAY[2, 4, 4, 4, 5, 5, 7, 9]), 3) -- Sample variance
;