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...
...and keep in mind that MEDIAN is like QUARTILE
and PERCENTILE. In fact MEDIAN is the 2nd
QUARTILE and the 50th PERCENTILE.
