LISTSTDEV Function

Computes the standard deviation of all numeric values found in input array. Input can be an array literal, a column of arrays, or a function returning an array. Input values must be of Integer or Decimal type.

When this function is invoked, all of the values in the input array are passed to the corresponding columnar function. Some restrictions may apply. See STDEV Function.

Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.

Basic Usage

Literal example:

liststdev([0,0,2,4,6,8,10,12,14,16,18,20])

Output: Returns the standard deviation of all values in the literal array: 6.952217872.

Column example:

liststdev(myArray)

Output: Generates an output column containing the standard deviation of all values in the arrays of the myArray column.