The MEDIAN function returns the content of the argument whose value is the middle value in the list formed by arranging the
arguments in sorted order. The type of this function is numeric.
Usage
FUNCTION MEDIAN ({argument-1} ... )
Parameter
|
argument-1
|
Must be class numeric.
|
Returned Values
- The returned value is the content of the
argument-1 having the middle value in the list formed by arranging all the
argument-1 values in sorted order.
- If the number of occurrences referenced by
argument-1 is odd, the returned value is such that at least half of the occurrences referenced by
argument-1 are greater than or equal to the returned value, and at least half are less than or equal. If the number of occurrences referenced
by
argument-1 is even, the returned value is the arithmetic mean of the values referenced by the two middle occurrences.
- The comparisons used to arrange the
argument-1 values in sorted order are made according to the rules for simple conditions.