Difference between revisions of "Stdev"
(jrfconvert import) |
|||
(2 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
− | [[Category: | + | [[Category:Functions_Used_in_where_Expressions]] |
− | | + | {{HelpFiles}} |
====stdev==== | ====stdev==== | ||
Line 22: | Line 22: | ||
'''Example''' | '''Example''' | ||
− | stdev(C1) where C2 >2; | + | ''number n = stdev(C1) where C2 >2; '' |
+ | |||
+ | ''print(n); // return standard deviation value '' | ||
'''Availability''' | '''Availability''' |
Latest revision as of 11:47, 20 December 2011
stdev
Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). All empty values are ignored.
Calculates
where x is the sample mean average(DCSColumn)… and n is the sample size
Syntax
stdev(dcsColumn)
Arguments
dcsColumn: is a numeric dcs column (column whose data type is Number)
Example
number n = stdev(C1) where C2 >2;
print(n); // return standard deviation value
Availability
All