stdevp() (aggregation function)
Calculates the standard deviation of expr across the group, considering the group as a population for a large dataset that is representative of the population.
For a small dataset that is a sample, use stdev() (aggregation function).
Note
This function is used in conjunction with the summarize operator.
Formula
This function uses the following formula.
Syntax
stdevp(expr)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| expr | string |
✔️ | The expression used for the standards deviation aggregation calculation. |
Returns
Returns the standard deviation value of expr across the group.
Example
range x from 1 to 5 step 1
| summarize make_list(x), stdevp(x)
Output
| list_x | stdevp_x |
|---|---|
| [ 1, 2, 3, 4, 5] | 1.4142135623731 |