stdev()(聚合函数)stdev() (aggregation function)
将该组作为示例,计算组内 Expr 的标准偏差。Calculates the standard deviation of Expr across the group, considering the group as a sample.
- 使用的公式:Used formula:
语法Syntax
summarize stdev(
Expr)
summarize stdev(
Expr)
参数Arguments
- Expr:用于聚合计算的表达式。Expr : Expression that will be used for aggregation calculation.
返回Returns
组内 Expr 的标准偏差值。The standard deviation value of Expr across the group.
示例Examples
range x from 1 to 5 step 1
| summarize make_list(x), stdev(x)
list_xlist_x | stdev_xstdev_x |
---|---|
[ 1, 2, 3, 4, 5][ 1, 2, 3, 4, 5] | 1.581138830084191.58113883008419 |