stdevp() (aggregation function)
Calculates the standard deviation of Expr across the group, considering the group as a population for a large data set that is representative of the population.
For a small data set that is a sample, use stdev() (aggregation function).
- Used formula:
- Can be used only in context of aggregation inside summarize
Syntax
stdevp (Expr)
Arguments
- Expr: Expression that will be used for aggregation calculation.
Returns
The standard deviation value of Expr across the group.
Examples
range x from 1 to 5 step 1
| summarize make_list(x), stdevp(x)
| list_x | stdevp_x |
|---|---|
| [ 1, 2, 3, 4, 5] | 1.4142135623731 |