MEDIAN
The MEDIAN function returns the median value between the passed arguments.
Syntax 1
function median (arg-1[, arg2 ...,arg-n]) |
Syntax 2
$median (arg-1[, arg2 ...,arg-n]) |
Arguments
• arg-1 can be either a numeric or a alphanumeric data item or literal. Other arguments, if any, must be of the same type.
• A table can be referenced by specifying the data-name and any qualifiers that identify the table, followed immediately by subscripting where one or more of the subscripts is the word ALL. When ALL is specified as a subscript, the effect is as if each table element associated with that subscript position were specified. The order of the implicit specification of each occurrence is from left to right, with the first (or leftmost) specification being the identifier with each subscript specified by the word ALL replaced by one, the next specification being the same identifier with the rightmost subscript specified by the word ALL incremented by one. For example, "function median (tbl-item(all))" is equivalent to "function median (tbl-item(1), tbl-item(2),...,tbl-item(n))".
Result
The function returns returns the median value between the passed arguments.
Examples
Example - Display the median value between 1, 2 and 3.
display function median(1, 2, 3) |