PROCESIO
OverviewPlatform ActionsIntegrations & DemosMarketplaceCustom ActionsDeveloperโ€™s Guide

List Standard Deviation

Computes the population standard deviation of a list of numbers.

List Standard Deviation measures how spread out a list of numbers is around its average. A small value means the numbers are close to the average; a large one means they vary a lot. Use it to spot unusual values, for example orders far above the usual amount.

Add the action

In the Process Designer toolbox, open Community-Made and pick List Standard Deviation (or type List Standard Deviation in the search box).

The List Standard Deviation action properties: List of numbers and Standard deviation

Inputs and outputs

FieldDirectionTypeRequiredWhat to put / what you get
List of numbersInputList of Number (decimal)YesThe numbers. Map a list variable.
Standard deviationOutputNumber (decimal)YesThe standard deviation.

Example

List of numbersStandard deviation
[2, 4, 4, 4, 5, 5, 7, 9]2
[1.5, 2.5, -3]2.392116682401221
[5]0
[]step fails: Input Error: The list of numbers can't be empty !

Good to know

  • This is the population standard deviation: the sum of squared differences from the average is divided by the number of values (n), not by n โˆ’ 1. If you need the sample standard deviation (as in Excel STDEV.S), multiply the result by the square root of n / (n โˆ’ 1).
  • The standard deviation is the square root of the variance.

Creator

Franck, The Productivity Lab

On this page