← Back to List functions

List.StandardDeviation

Calculates an approximate standard deviation for the values in the list numbersList. If numbersList contains numerical values, a number will be generated. An error will be raised for an empty list or ...

Syntax

List.StandardDeviation(numbersList as list) as nullable number

About

Calculates an approximate standard deviation for the values in the list numbersList. If numbersList contains numerical values, a number will be generated. An error will be raised for an empty list or a list containing non-numerical items.

Explanation

Calculate the standard deviation of the numbers 1 to 5 using Power Query MList function. StandardDeviation({1..5}) will give an output of 1.5811388300841898.