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
you just simply cut it in half and you'll have the median
The formula is: median of lognormal = exp(u)
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).
The median age in New York is approximately 38 years old.
The median age of Washington state is around 37 years old.
According to census.gov, the median age of people in Arizona is 34.9 years of age (2007).
The median age of Georgia is approximately 36 years old.
The median age in Missouri is around 38 years old.
The median age of Michigan is around 39 years old.