STDEVP()

Arithmetic standard deviation of list items

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.

See Also

AVERAGE()

COUNT()

MAX()

MIN()

SUM()