MEDIAN (number1, [number2], …) Where number1, number2, … are numeric values for which you want to calculate the median. These can be numbers, named ranges, or references to cells containing ...

If there are two middle values the median is halfway between them. This might not be a whole number.

While mean and median are not applicable to nominal data due to its non-numeric and unordered nature, the mode is a ...