Note: This function is only available on SharpCloud v9.7.0217 and later
The standard deviation of an array of numbers can be produced using this function to show the spread of data around the mean value.
arrayOfValues – An ARRAY of NUMBERS that the Standard Deviation will be calculated from.
Data Type Returned
Standard Deviation function will return a NUMBER.
STDEV([1,2,3,4,5]) – This will return a Standard Deviation value of 1.58.
STDDEV(GETITEMVALUES(RELATEDITEMS(), ‘cost’)) – This will return the std dev of costs of all items related to this one.
STDDEV(GETRELATIONSHIPVALUES(RELATEDITEMS(), ‘relCost’)) - This will return the std dev of the relCost of all relationships connected to this item.