Re: ranking tool in Excel

["Andreas J. Guelzow" <aguelzow math concordia ab ca>]

Phillip Shelton wrote:

>The function (is that the thing you wanted tested?) RANK returns 4 for the
>descending case and 2 for the ascending case.
>Numbers
>1,1,5,3,2,0
>rank
>4,4,1,1,3,6
>
Thanks. I hope you meant that the ranks are: 4, 4, 1, 2, 3, 6. (typo?)

I guess that means that the ranking tool as implemented is XL compatible
rather than accurate since for all practical purposes (IMHO) the ranks
ought to be:
4.5, 4.5, 1, 2, 3, 6

>OT: Ranks can have fractional parts?  Jody, what was the go with being
>accurate against compatible?
>
Jody??

Thanks again

Andreas


--
Prof. Dr. Andreas J. Guelzow
Assoc. Prof of Mathematics
Concordia University College of Alberta
http://www.math.concordia.ab.ca/aguelzow