Power Query
Search…
List.StandardDeviation

List.StandardDeviation

Returns a sample based estimate of the standard deviation.
function (numbersList as list) as nullable any

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.

Category

List.Averages

Examples

Find the standard deviation of the numbers 1 through 5.
1
List.StandardDeviation({1..5})
Copied!
1.5811388300841898
Last modified 3yr ago