MEDIAN function returns median of the given set of values. When you sort a list of values from smallest to largest, median is in the middle of this list. If you have even number of values, e.g. 1, 4, 5, 6, the median is 4.5 (4+5/2).
= MEDIAN (number1, [number2], ...)number1 - First number or range of numbers.
number2 - [Optional] Second number or range of numbers.
=MEDIAN(B2:F3)returns 1.95, because MEDIAN of the list of numbers:
0.1, 0.3, 0.5, 0.7, 0.9, 3, 5, 10, 34, 78. is (0.9 + 3) / 2.
UseThe median is widely used in statistics where might be seen as a better indication of central tendency than arithmetic mean.