Median: Difference between revisions

Latest revision as of 10:39, 20 December 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

number n = median(C1) where true;

print(n); //return median value

Availability

Version 5.2

@@ Line 1: / Line 1: @@
-[[Category:Functions_Used_in_where_Expressions]]
+{{HelpFiles}}
-{{HelpFiles}}
+==== 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.
-====median====
+Note that the median is NOT calculated based on the categories, but using all data in the dcs. All empty values are ignored.
-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.
+'''Syntax'''
-Note that the median is NOT calculated based on the categories, but using all data in the dcs. All empty values are ignored.
+median(''dcsColumn'')
-'''Syntax'''
+'''Arguments'''
-median(''dcsColumn'')
+''dcsColumn'':&nbsp; is a numeric dcs column (column whose data type is Number).
-'''Arguments'''
+'''Example'''
-''dcsColumn'':  is a numeric dcs column (column whose data type is Number).
+''number n = median(C1) where true; ''
-'''Example'''
+''print(n); //return median value''
-number n = median(C1) where true;
+'''Availability'''
-'''Availability'''
+Version 5.2 __NOTOC__ <!-- imported from file: 759.htm-->
-Version 5.2
+[[Category:Functions_Used_in_where_Expressions]]
-__NOTOC__
-<!-- imported from file: 759.htm-->