Summary: Determine the middle number of a series in an Excel 2003 spreadsheet.
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.
For example, assuming the following grades spreadsheet:
A B
1 John Smith 95
2 Sue Walker 97
3 Jim Paulson 88
4 Carol Thompson 81
5 Laura Jones 92
6
7 Average: =AVERAGE(B1:B5)
8 Mean: =MEDIAN(B1:B5)
Add: Del.icio.us |
Digg |
Furl |
My Yahoo!
Last Modified on: August 12, 2008, at 8:54 A.M. EDT
Return to the Microsoft Excel 2003 Functions and Formulas page.
Search the Site: