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.