Returns the computed standard deviation (Decimal value) of the values in the list.
Sample usage
STDEVP(Products[Price]) : The standard deviation for values in the Price column of the Products table. Equivalent to STDEVP(SELECT(Products[Price], TRUE)). See also: SELECT()
STDEVP([Discounts]) : The standard deviation for the items in the Discounts column value, where Discounts is of type List or EnumList.
STDEVP(LIST(1, 2, 3)) : 0.82
Common problems
STDEVP(1, 2, 3) : the arguments are not in list form. To fix, wrap them in LIST() to construct a list: STDEVP(LIST(1, 2, 3)).
Syntax
STDEVP(list)
list- List of any numeric type.
Notes
AppSheet must be given enough context to determine what type of values list contains, that its contents are or will be numeric. To that end, list must be one of the following: a column value of type List that contains numeric values; a column list (such as, Products[Price]) for a column of a numeric type; or a constructed list (such as, with LIST()) of a numeric type.