List.StandardDeviation

Syntax

List.StandardDeviation(numbersList as list) as nullable number

About

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.

Example 1

Find the standard deviation of the numbers 1 through 5.

Usage

List.StandardDeviation({1..5})

Outut

1.5811388300841898