STDEV
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
This function calculates the standard deviation for samples per group. The standard deviation is using the "n-1" method. Standard deviation can be applied to INT or FLOAT columns.
Syntax
STDEV ( table.column )
NULL handling
NULL values are ignored, meaning that they do not influence the result. If all values of a group are NULL, the result for this group is also NULL.
Examples
[1] Standard deviation of column. |
[2] Get the standard deviation by country. |
[3] Get the standard deviation with nulls, grouped by country. |