Ranking

 

Menu location: Data_Transforming and Deriving_Ranks.

 

This function ranks the workbook data you select and saves the rankings into a new workbook column labelled Rank: Name where Name is the column label of the original data. You can calculate a correction factor for ties in the ranking; five formulae are offered for tie correction:

  1. Σ(t^3 - t /12)
  2. Σ(t * (t-1)/2)
  3. Σ(t * (t-1) * (2t+5))
  4. Σ(t * (t-1) * (t-2))
  5. Σ(t * (t-1) * (t+1))

 

Here t is the number of data tied at each tie and upper case sigma Σ is the summation across these ties.

 

The use of tie corrections is a complex subject upon which learned statisticians sometimes disagree.

 

Example

Test workbook (Nonparametric worksheet: First Born).

 

Ranking the following agressivity scores for a sample of firstborn twins gives.

 

First Born -----> Rank: First Born
86 8
71 3.5
77 6.5
68 1
91 11.5
72 5
77 6.5
91 11.5
70 2
71 3.5
88 10
87 9