你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

stdevp() (aggregation function)

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft 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.

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

Run the query

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