atoti.agg.var()#
- atoti.agg.var(operand: VariableColumnConvertibleOrLevel, /, *, mode: Literal['sample', 'population'] = 'sample') MeasureDescription #
- atoti.agg.var(operand: VariableMeasureConvertible, /, *, mode: Literal['sample', 'population'] = 'sample', scope: CumulativeScope | SiblingsScope | OriginScope) MeasureDescription
Return a measure equal to the variance of the passed operand across the specified scope.
- Parameters:
operand – The operand to get the variance of.
mode –
One of the supported modes:
The
sample
variance, similar to Excel’sVAR.S
, is \(\frac{\sum_{i=1}^{n} (X_i - m)^{2}}{n - 1}\) wherem
is the sample mean andn
the size of the sample. Use this mode if the data represents a sample of the population.The
population
variance, similar to Excel’sVAR.P
is \(\frac{\sum_{i=1}^{n}(X_i - m)^{2}}{n}\) wherem
is the mean of theXi
elements andn
the size of the population. Use this mode if the data represents the entire population.
scope – The
aggregation scope
.