What is a median?
Median refers to the middle term in a sorted set of data. It separates a group of numbers into two equal parts and acts as the center of data when arranged symmetrically.
If your data consists of an odd number of values, the middle term will be the median of your data set.
But if your data set contains an even number of values, the average of the two middle values will make the median.
Luckily, Excel offers a built-in MEDIAN Function that you can use to calculate the median of a data range. Its syntax is:
=MEDIAN (number1, [number2], ..)
Number1, Number2 are the numeric values whose median is to be calculated.
The first argument, Number 1, is mandatory. It can be a cell reference, named range, date, or even logical values. Number 2 uses the same types of values, but its use is optional.
You can use up to 255 arguments for the Excel MEDIAN formula in Excel. But the first two arguments suffice for most cases.