Contribute in GitHub:
Edit online

# variancep() (aggregation function)

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

The following formula is used:

## Syntax

`variancep`

`(`

*Expr*`)`

## Arguments

Name | Type | Required | Description |
---|---|---|---|

Expr |
string | ✓ | Expression that will be used for aggregation 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)
```

### Results

list_x | variance_x |
---|---|

[ 1, 2, 3, 4, 5] | 2 |