transforming rank data
I have an interesting problem, I think. I've got ranking data in the
form of:
1 2 3 4 5
a c d b e
c a d b e
e a c d b
where a, b, c, d, and e are the various choices being ranked (3
responses in this sample). How can I programmatically create a matrix
as follows so that it scales easily to any number of responses?
a 1 2 2
b 4 4 5
c 2 1 3
d 3 3 4
e 5 5 1
TIA,
David
|