After you order the n individual ages from youngest to oldest you can find the location of the median with the formula M=(n+1)/2.
For example, if you have an odd number of ages such as 7, 23, 35, 53, 99 then the median will be the (n+1)/2=(5+1)/2=3rd observation of the ordered set. Hence the median age is 35 years. Exactly half the ages are less than 35 and exactly half the ages are more than 35.
If, on the other hand, you have an even number of ages such as 7, 23, 35, 53, 75, 99 then the location of the median will be at position (n+1)/2=(6+1)/2=3.5 of the ordered set. Since there is no "three and halfth" observation you need to take the average of the 3rd and 4th observation. Hence the median age is (35+53)/2=44 years.
easy way out middle age is the median age
The formula is: median of lognormal = exp(u)
you just simply cut it in half and you'll have the median
n+1/2
If you want to get the median of numbers within the first quartile, you have to use the QUARTILE, MEDIAN and IF functions together and then enter it as an array formula. Say your values are in the cells from E2 to E27. =MEDIAN( IF( E2:E27<=QUARTILE( E2:E27,1 ), E2:E27 ) ) To enter it as an array formula, you must press Ctrl- Shift - Enter together. The formula will then appear with curly braces around it, indicating that it is an array function.
the average lengh of the top and bottem together
According to census.gov, the median age of Wisconsin is 37.9 years of age.
According to census.gov, the median age in Oregon is 37.8 years of age.
According to census.gov, the median age in Texas is 33.1 years of age.
According to census.gov, the median age of people in Maine is 41.6 years of age (2007).
According to census.gov, the median age of people in Illinois is 35.9 years of age (2007).
According to census.gov, the median age of people in Alaska is 33.4 years of age (2007).
According to census.gov, the median age in New York is 37.7 years of age.
According to census.gov, the median age in Washington is 37.1 years of age.
According to census.gov, the median age of people in Hawaii is 37.9 years of age (2007).
According to census.gov, the median age of people in Arizona is 34.9 years of age (2007).
According to census.gov, the median age of people in Georgia is 34.7 years of age (2007).
According to census.gov, the median age of people in Missouri is 37.3 years of age (2007).