OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[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]