List.StandardDeviation
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Returns the standard deviation from a list of values. List.StandardDeviation performs a sample based estimate. The result is a number for numbers, and a duration for DateTimes and Durations.
List.StandardDeviation(list as list) as any
| Argument | Description |
|---|---|
| list | The List to check. If List is a list of numbers, a number is returned. An exception is thrown on an empty list or a list of items that is not type number. |
- If the list is empty, an Expression.Error is thrown.
List.StandardDeviation({1..5}) equals 1.5811388300841898
Show: