MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using the Median Function within a Pivot Table


Posted by Wendy Hubbard on February 14, 2002 2:08 PM

Hello All,
HHHHEEEELLLPPP
I have approximately 27,000 records which I'm trying to find the median value. The records contain the following fields: Hour, Category & Wait Time. I need to group the records by Hour (00:00 to 24:00) then by Category (1,2,3,4 or 5) and find the median value of the Wait Time (stored in minutes).

I've used a pivot table to look at frequency by the hour which works fine and also Averge Wait Time by Hour/by Category. I just need to find a way to work out Median.

Any Clues????


Posted by Mark W. on February 14, 2002 2:25 PM

See...

22348.html

...and keep in mind that MEDIAN is like QUARTILE
and PERCENTILE. In fact MEDIAN is the 2nd
QUARTILE and the 50th PERCENTILE.