n+1/2
Chat with our AI personalities
you just simply cut it in half and you'll have the median
The formula is: median of lognormal = exp(u)
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
If you will let me assume that the probability density function (pdf) is absolutely continuous over its support then the median is given as the integral from -inf to the median of the pdf over that support = 1/2.