atoti.agg.std()#
- atoti.agg.std(operand: VariableColumnConvertibleOrLevel, /, *, mode: Literal['sample', 'population'] = 'sample') MeasureDescription #
- atoti.agg.std(operand: VariableMeasureConvertible, /, *, mode: Literal['sample', 'population'] = 'sample', scope: CumulativeScope | SiblingsScope | OriginScope) MeasureDescription
Return a measure equal to the standard deviation of the passed operand across the specified scope.
- Parameters:
operand – The operand to get the standard deviation of.
mode –
One of the supported modes:
The
sample
standard deviation, similar to Excel’sSTDEV.S
, is \(\sqrt{\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
standard deviation, similar to Excel’sSTDEV.P
is \(\sqrt{\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
.