variancep() (aggregation function)
Learn how to use the variancep() aggregation function to calculate the population variance of an expression across the group.
Calculates the variance of expr across the group, considering the group as a population.
The following formula is used:
Syntax
variancep(expr)
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| expr | string | ✔️ | The expression to use for the variance calculation. |
Returns
Returns the variance value of expr across the group.
Example
range x from 1 to 5 step 1
| summarize make_list(x), variancep(x)
Output
| list_x | variance_x |
|---|---|
| [ 1, 2, 3, 4, 5] | 2 |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.