Difference between revisions of "Median"

From Catglobe Wiki
Jump to: navigation, search
(jrfconvert import)
 
Line 1: Line 1:
[[Category:HelpBooks]]
+
[[Category:Functions_Used_in_where_Expressions]]
 

 

  

Revision as of 05:13, 28 March 2011



median

Calculate the value of the middle observation. In case of an even number of observations the median is the average of the two values on each side of the middle point.

Note that the median is NOT calculated based on the categories, but using all data in the dcs. All empty values are ignored.

Syntax

median(dcsColumn)

Arguments

dcsColumn:  is a numeric dcs column (column whose data type is Number).

Example

median(C1) where true;

Availability

Version 5.2