Difference between revisions of "Median"
(jrfconvert import) |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{HelpFiles}} | |
| − | | ||
| − | ====median==== | + | ==== 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. | + | 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. | + | Note that the median is NOT calculated based on the categories, but using all data in the dcs. All empty values are ignored. |
| − | '''Syntax''' | + | '''Syntax''' |
| − | median(''dcsColumn'') | + | median(''dcsColumn'') |
| − | '''Arguments''' | + | '''Arguments''' |
| − | ''dcsColumn'': | + | ''dcsColumn'': is a numeric dcs column (column whose data type is Number). |
| − | '''Example''' | + | '''Example''' |
| − | median(C1) where true; | + | ''number n = median(C1) where true; '' |
| − | '' | + | ''print(n); //return median value'' |
| − | Version 5.2 | + | '''Availability''' |
| − | __NOTOC__ | + | |
| − | <!-- imported from file: 759.htm--> | + | Version 5.2 __NOTOC__ <!-- imported from file: 759.htm--> |
| + | |||
| + | [[Category:Functions_Used_in_where_Expressions]] | ||
Latest revision as of 11: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
