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  

ArgumentDescription
listThe 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: