View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
KC Rippstein hotmail com> KC Rippstein hotmail com> is offline
external usenet poster
 
Posts: 168
Default Finding Median Age

This is tricky.

First, you'd have to have an odd number of age categories. If you have an
even number, then MEDIAN take the average of the two Medians to come up with
an artificial median not present in your list.

Second, if you had a Median value which shows up twice (let's say the
population count which creates a median is 30 but you have two age categories
which have a population of 30), then the first age bracket is what would turn
up.

If you can get past both of those issues (have an odd number of age brackets
every time and have a unique population count in each age bracket), then this
will give you the age bracket which falls within your Median:
=INDEX(A2:A8,MATCH(MEDIAN(B2:B8),B2:B8,0))

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"BStacy" wrote:

Is there a function that will allow me to find a median age?

The data I have is in the following format:

Age Range Population
0-14 45
15-17 23
18-24 31
35-54 52
55-64 28
65+ 30