Re: Tie breaking in a rank order

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

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 12/29/04 

Date: Thu, 30 Dec 2004 00:30:14 +0100

Hi
start with:
http://www.cpearson.com/excel/rank.htm 

-- 
Regards
Frank Kabel
Frankfurt, Germany
"HondaMike" <HondaMike@discussions.microsoft.com> schrieb im Newsbeitrag 
news:E7B1921E-DD51-4034-81D7-5FEAA042B25B@microsoft.com...
> 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

  • Tie breaking in a rank order
    ... I'm composing my first worksheet in Excel that lists and ranks several ... I'm stumped by ties that may occur in this rank order if two or more salesmen ... 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)
  • very poignant and an interesting thing....
    ... Whose I find really poignant, esp. ... in the choice of not putting ranks in the lists, whose I dare to give a BZ to them. ...
    (sci.military.naval)
  • 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: how can I rank within a filtered list in Excel?
    ... row contains your headers/labels... ... > qualifies the lists content, and have excel generate "ranks" based on the ... > includeing the records that are filtered out. ...
    (microsoft.public.excel.misc)