Tie breaking in a rank order

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: HondaMike (HondaMike_at_discussions.microsoft.com)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 15:21:03 -0800

I'm composing my first worksheet in Excel that lists and ranks several
columns of salesman's data. The last column ranks the salesmen based upon a
cumulative point total generated by their rankings in several categories.
I'm stumped by ties that may occur in this rank order if two or more salesmen
accumulate the same number of points. I want to break any ties that occur by
referencing the data in a specific column; having the salesman with the
larger dollar amount in this column ranked immediately above the person that
tied him. How can I do this?

Relevant Pages

  • Re: Tie breaking in a rank order
    ... > I'm composing my first worksheet in Excel that lists and ranks several ... The last column ranks the salesmen based upon ... I want to break any ties that occur ... > referencing the data in a specific column; having the salesman with the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Computing Wilcoxon signed rank test p-value
    ... Hollander & Wolfe has a good description. ... finding the pattern of ties in the data. ... % a function to return a row vector of tied groups, T, ... % Ranks R and indices of tied elements ...
    (sci.stat.consult)
  • Re: Gamma Correlation pros & cons
    ... ordered-category, rather than ordinal (ranks), then: both the gamma statistic and Spearman's rho are affected by the large number of tied cases that result; and the polychoric correlation coefficient avoids this. ... Until now the data has been analysed with Spearman Rank Correlation, but because of all the ties we are looking for a test which fits better. ...
    (sci.stat.edu)
  • Re: Wilcoxon Ranksum
    ... TIEDRANK Compute the ranks of a sample, adjusting for ties. ... The return value TIEADJ is an adjustment for ties required by ...
    (comp.soft-sys.matlab)