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:

- Σ(t^3 - t /12)
- Σ(t * (t-1)/2)
- Σ(t * (t-1) * (2t+5))
- Σ(t * (t-1) * (t-2))
- Σ(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 |

Copyright © 2000-2017 StatsDirect Limited, all rights reserved. Download a free trial here.