STDEV

STDEV(*values)[source]

Computes the standard deviation of one or more numeric values or arrays.

This function calculates the standard deviation (sample) for all provided inputs. Inputs can be scalar numbers or arrays of numbers. If arrays are provided, they must be of numeric type and the function will compute the standard deviation over all values.

Parameters:

*values (Operand | int | float) –

One or more numeric values or arrays to compute the standard deviation.

Supported types:

  • INTEGER

  • INTEGER_ARRAY

  • DECIMAL

  • DECIMAL_ARRAY

Return type:

Formula

Returns:

A formula representing the standard deviation of the input values.

Supported types:

  • DECIMAL

  • DECIMAL_ARRAY

Raises:

ValueError – If any input value is not numeric.

Examples

Scalar numbers:

STDEV(2, 4, 4, 4, 5, 5, 7, 9)
# Returns 2.0

Numeric arrays:

STDEV([2, 4, 4], [4, 5, 5], [7, 9])
# Returns 2.0