The text currently says, "If there is an even number of numbers in the set, MEDIAN calculates the average of the two numbers in the middle". This is ambiguous. Middle of what Middle of the range is the most direct interpretation. Probably want something more like, "The values in the range are logically ranked from lowest to highest and the middle number is returned. If there is an even number of numbers in the set…"
Clarify the definition.
3.17.7.207 te
MEDIAN 2709(2716)
Proposed Disposition of DIS 29500 Comment CO-0196 (Modified: 2007-11-06) Agreed; the following change will be made to Part 4, §3.17.7.207, page 2,709, lines 1718: Description: Computes the median of the numeric values of its arguments. The median of a set of values is the value that half the numbers in the set are greater than, and half the values are less than. For sets with an odd number of values, the median is calculated by finding the value whose rank in the ordered set of all values is equal to half the number of items (n) in the set plus one half (n/2 + 1/2). If the number of values in the set is even, then the median is defined to be the average of the values of rank n/2 and n/2 + 1. Arguments: Name Type Description argument-list logical, number, name, arrays, reference to number. The arguments in argument-list designate the values whose median is to be computed. If there is an even number of numbers in the set, MEDIAN calculates the average of the two numbers in the middle. Logical values and text representations of numbers entered directly into the list of arguments are included. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included. Similar Comments: CL-0152 , FR-0474 , GB-0416 , US-0213
