List.StandardDeviation is a Power Query M function that returns a sample-based estimate of the standard deviation of the values in a list. The function returns a number representing the standard deviation or throws an exception for an empty list or a list of non-numeric items.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
List.StandardDeviation( numbersList as list ) as nullable numberDescription
Returns a sample based estimate of the standard deviation of the values in the list, numbersList.
If numbersList 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.
Examples
Find the standard deviation of the numbers 1 through 5.
// Output: 1.5811388300841898
List.StandardDeviation( {1..5} )Related articles
Learn more about List.StandardDeviation in the following articles:
- Lists in Power Query M / List Functions (200+ Examples)
The complete guide to Lists in Power Query M. Learn from practical examples and master Power Query’s most powerful List functions. » Read more
Related functions
Other functions related to List.StandardDeviation are:
- List.Average
- List.Count
- List.Covariance
- List.Median
- List.Mode
- List.Modes
- List.NonNullCount
- List.Percentile
- List.Product
- List.Sum
