variance function
The variance function returns the variance of the column, evaluated within groups defined by the group parameter if required.
The variance is a measure of dispersion, which displays how a set of values is far from their average value.
Function and parameters
variance(column, group)
Parameter | Description |
---|---|
column | It identifies the column to which you want to apply the formula. The column parameter is mandatory. |
group | It allows you to group the results by a certain column. |
Example
The following example uses the Bike sales dataset.
Description | Screenshot |
---|---|
| |
|