Re: [office-formula] MEDIAN

["David A. Wheeler" <dwheeler@dwheeler.com>]

Andreas J Guelzow wrote:
> > MEDIAN logically _ranks_ the numbers (lowest to highest).  If given an 
> > odd number of values, MEDIAN returns the middle value. If given an even
> > number of values, MEDIAN returns the arithmetic average of the two
> > middle values.
> > 
> > (The change is to replace "sorts" with "ranks" as indicated.)
> > 
> > And of course to make a similar replacement in teh formula description
> > that follows.
> 

Eike:
> I agree. And will change it if no one disagrees.

Sounds fine to me.  I'm not sure what the difference is between "sort" and "rank", they seem the same to me. Obviously the actual values in the spreadsheet aren't changed... is that what you mean?

--- David A. Wheeler