List.StandardDeviation

Updated on

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 number

Description

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} )

Learn more about List.StandardDeviation in the following articles:

Other functions related to List.StandardDeviation are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/list-standarddeviation