MS Excel: Median Function
In Excel, the Median function returns the median of the numbers provided.
The syntax for the Median function is:
Median( number1, number2, ... number_n )
number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Median(B2, B3) would return 8.85 =Median(B3, B5, 45) would return 7.2 =Median(B2:B6) would return 8.1 =Median(1, 3, 13, 14, 15) would return 13