Menu location: Data_Rank.
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:
S(t^3 - t /12)
S(t * (t-1)/2)
S(t * (t-1) * (2t+5))
S(t * (t-1) * (t-2))
S(t * (t-1) * (t+1))
Here t is the number of data tied at each tie and upper case sigma (S) 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 |