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:

Stdev population.

  • 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