The STDEV() function calculates the standard deviation of a set of numbers. It is used to measure the dispersion of values around the mean.
Function compatible with fields from a relation.
If the input is a relational field, the calculation is applied to all linked values.
Numeric function name:
STDEV()
Syntax
STDEV(value1, value2, …)ℹ Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to be added between quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
value1 |
Set of numerical values |
value2… |
(Optional) other set of numerical values |
Example
STDEV(4, 5, 8, 10)Rounded result: 2.75
Notes
- STDEV() measures the deviation between values, not their mean.
- If the input is a field from a relation, the standard deviation is calculated on all linked items.
- Non-numeric values are ignored.
Return type
The function returns a number.
The output type format of the result can be set in the output field options of the formula editor. For more details, see Output format options in the Formula column article.