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.

Return type:

Formula

Returns:

A formula representing the standard deviation of the input values.

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

``value`` (variadic) — accepted types

  • DECIMAL

  • DECIMAL_ARRAY

  • INTEGER

  • INTEGER_ARRAY

Return types

  • DECIMAL