It depends on whether you mean median in terms of statistical data or the line joining a vertex of a triangle to the midpoint of the opposite side.
The Statistical Median:
If there are n observations where n is odd, then the median is the (n+1)/2 smallest observation. If n is even, then the median is the arithmetical mean of the n/2 and n/2+1 smallest observations.
The Coordinate Geometry Median:
Given triangle ABC, with A = (xa, ya), B = (xb, yb) and C = (xc, yc), the midpoint, D of BC is [(xb+xc)/2, (yb+yc)/2] and so, the equation of the median AD is
(y-ya)/(x-xa) = (2ya-yb-yc)/(2xa-xb-xc)
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)
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