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
Chat with our AI personalities
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