Skip to main content
Version: 8.1

stdDev

This function is used by Ignition's Expression language.

Description​

Calculates the simple standard deviation of the values in the given column of the given dataset, or the standard deviation for a series of numbers specified as arguments. When looking up the standard deviation in a dataset, the column may be specified as an index or as a column name. Any null values in the column are ignored.

Syntax (index)​

stdDev(dataset, columnIndex)

  • Parameters

    • Dataset dataset - The dataset to search through.

    • Integer columnIndex - The index of the column to search through. Must be a column index of the provided dataset.

  • Returns

    • Integer/Float - The standard deviation of the values in that column.

Syntax (name)​

stdDev(dataset, columnName)

  • Parameters

    • Dataset dataset - The dataset to search through.

    • String columnName - The name of the column to search through. Must match a column name in the provided dataset.

  • Returns

    • Integer/Float - The standard deviation of the values in that column.

Syntax (value)​

stdDev(value, [value, ...])

  • Parameters

    • Integer/Float value - A number. Can be as many values as needed. Can be either a float or an integer.
  • Returns

    • Integer/Float - The standard deviation of the values in the list of values.

Syntax (sequence)​

New in 8.1.8
The following overload was added in 8.1.8:

stdDev(sequence)

  • Parameters

    • Sequence sequence - A list, tuple, array, or set of numerical values.
  • Returns

    • Integer/Float - The standard deviation of the values in the list of values.

Examples​

For example, suppose you had a table with this dataset in it:

ProductCodeQuantityWeight
BAN_0023803.243
BAN_0101209.928
APL_0001251.287
FWL_2203227.889
Code Snippet
stdDev({Root Container.Table.data}, "Weight") //... would return 4.00532