stdevp() (aggregation function)

Applies to: ✅ Azure Data ExplorerAzure MonitorMicrosoft Sentinel

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.

Image showing a Stdev sample 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