I tried to calculate the median of a set of numbers in Excel using the MEDIAN() function and got 13. However, while 7 values are below 13, above it are 8 values. 7 is not equal to 8, so why is it "the median"?
When the number of numbers in the set is an odd number, the median is the point in the middle. For a set of 17 numbers, the median is the 9th number (here 13). This way the median fits exactly its definition "the median is the value separating the higher half from the lower half".