STDEV
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. | ||||||||||||||||||
| ||||||||||||||||||
|