Table of contents
TOC
Collapse the table of content
Expand the table of content

List.StandardDeviation

Owen Duncan|Last Updated: 4/19/2018

About

Returns the standard deviation from a list of values. List.StandardDeviation performs a sample based estimate. The result is a number for numbers, and a duration for DateTimes and Durations.

List.StandardDeviation(list as list) as any  

Arguments

ArgumentDescription
listThe List to check. If List 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.

Remarks

  • If the list is empty, an Expression.Error is thrown.

Example

List.StandardDeviation({1..5}) equals 1.5811388300841898  
© 2018 Microsoft