## Microsoft Excel 2003 Functions and Formulas - Calculate the Median of a Group of Numbers

Although the =average function determines the average number of a series in a Microsoft Excel 2003, sometimes determining the median is helpful.

The median of a group of numbers is the middle number of a series - half of all numbers are above the median, half are below.

Calculating this number requires the =median function:

=median(SERIES)

SERIES is a series of numbers, range, or cells for which you want to find the median.

`    A               B1   John Smith      952   Sue Walker      973   Jim Paulson     884   Carol Thompson  815   Laura Jones     9267   Average:        =AVERAGE(B1:B5)8   Mean:           =MEDIAN(B1:B5)`

The results would be:

B7: 90.6
B8: 92

Note that according to the Excel 2003 documentation, cells containing text, TRUE/FALSE, or empty cells are ignored.

Also note that if an even number of elements are in SERIES, Excel will average the sum of the two middle numbers to determine the result.

Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Calculate the Median of a Group of Numbers.