On Sun, Nov 25, 2001 at 12:08:56AM -0700, Andreas J. Guelzow wrote:
Hi, could somebody with access to Excel please find out which ranks its ranking tool assigns to: 1,1,5,3,2,0 I am especially interested in the rank of the 1s. (It seems that gnumeric currently claims they have rank 4 each, while I think they should have rank 4.5. But we may want to be Excel compatible on this...)
Attached is the XL version. I do not think we need to be XL compatible here. The analysis tools are filters. Workbooks that depend on their results matching XL are much harder to envision than those with standard sheet functions. If accepted statistical conventions indicate using fractional ranks then we should conform to the convention, not XL.
Attachment:
ranktest.xls
Description: MS-Excel spreadsheet