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()

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
17290882396096926789
true
Search Help Center
true
true
true
false
false