[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-formula] MEDIAN
Hi Andreas, On Saturday, 2007-02-10 18:43:22 -0700, 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. I agree. And will change it if no one disagrees. Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]