Difference between revisions of "Median"
| Line 1: | Line 1: | ||
[[Category:Functions_Used_in_where_Expressions]] | [[Category:Functions_Used_in_where_Expressions]] | ||
| − | | + | {{HelpFiles}} |
====median==== | ====median==== | ||
Revision as of 09:11, 12 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
median(C1) where true;
Availability
Version 5.2
