variance() (aggregation function)

  • Article
  • 2 minutes to read

Calculates the variance of Expr across the group, considering the group as a sample.

  • Used formula:

Variance sample.

  • Can be used only in context of aggregation inside summarize

Syntax

variance (Expr)

Arguments

  • Expr: Expression that will be used for aggregation calculation.

Returns

The variance value of Expr across the group.

Examples

range x from 1 to 5 step 1
| summarize make_list(x), variance(x)
list_x variance_x
[ 1, 2, 3, 4, 5] 2.5