I often use MS Excel to perform statistical analyses but I have been unable
to use it for simple non-parametric procedures (e.g., Friedman's test,
Mann-Whitney test) because the RANK() function does not deal with ties
properly. For example, Excel would rank scores as follows;
Score Rank
12 3
12 3
11 2
24 5
55 6
2 1
However, the ranks for the scores of 12 should be 3.5. Does anyone know of
an Add-In that provides appropriate ranks for tied scores?
Dr Graham D. Smith
Psychology Division
School of Behavioural Studies
University College Northampton
Boughton Green Road
Northampton
NN2 7AL
Tel (01604) 735500 Ext 2393
Email [EMAIL PROTECTED]
