Function STDEV()

 

Description
Calculates the standard deviation of a numeric array, showing data spread around the mean.

Syntax

STDEV(arrayOfValues)

Parameters

• arrayOfValues – An array of numbers

Return Value
NUMBER

 

Examples

Formula

STDEV([1,2,3,4,5])

Result
1.58

Formula

STDEV(GETITEMVALUES(RELATEDITEMS(), "cost"))

Result
Standard deviation of related item costs

Formula

STDEV(GETRELATIONSHIPVALUES(RELATEDITEMS(), "relCost"))

Result
Standard deviation of relationship costs

Notes

• Available in SharpCloud v9.7.0217+
• Works with numeric arrays only