List.StandardDeviation
How far a list's numbers spread around their mean: the sample standard deviation.
Group: List. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
List.StandardDeviation(numbersList as list) as nullable number| Parameter | Type | Description |
|---|---|---|
numbersList | list | Numbers; nulls are skipped. |
Returns
nullable number. The sample standard deviation (divided by the count less one).
Remarks
- It is the sample estimate, as in Excel's STDEV.S, not the population one.
Examples
Daily sales spread
List.StandardDeviation({10, 12, 14})2The mean is 12; the squared distances add up to 8, divided by 2 is 4, and its root is 2.