Difference between revisions of "Stdev"

From Catglobe Wiki
Jump to: navigation, search
(jrfconvert import)
 
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
[[Category:HelpBooks]]
+
[[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

776.gif

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