Solved – How would one graph the results of subjective rank order

data visualizationexcelnonparametricranking

I'm looking for way to visualize subjective rankings, separate from my non-parametric tests.

I've asked 12 participants to rank 8 different items according to different subjective criterion (separate rankings for each one). For any individual set of rankings, I'm looking for a good way to visualized the high-level trends of the rankings.

I've tried both bar and radar plots on the average rankings, and I've seen one other person use a scatter/balloon plot over the number of responses per ranking, but I'm not quite sure what conveys the best overview. Either I can use the 8 mean rankings, or the the 8 counts of each ranking per item.

Edit:

For example:
Each column is an item, each row is a person's ranking of each of the eight items. Not a particularly strong agreement in this example, but in general would like to understand the best way to convey the overall trends.

                        Item:
            A   B   C   D   E   F   G   H
Rater:  
  1         6   8   1   7   3   4   2   5
  2         1   3   8   7   6   5   2   4
  3         5   8   7   6   1   4   2   3
  4         5   8   7   6   4   2   1   3
  5         1   2   8   7   4   3   5   6
  6         1   7   8   5   6   2   4   3
  7         5   1   8   4   7   3   6   2
  8         4   2   8   7   6   1   5   2
  9         6   3   8   4   7   1   5   2
  10        3   2   8   7   4   1   5   6
  11        2   3   7   8   1   5   4   5
  12        8   5   6   7   2   3   1   4

Best Answer

I've done something similar for visualizing similar rankings. The method I used gave me a quick snapshot of how the rankings related-nothing more. My solution used Excel 2010 sparklines to create a small-multiples view of the rankings (this can be done in other Excel versions, but it takes a bit more work). Also, I generally use Excel's Table functionality just to speed things along.

  1. Transpose your matrix so the rows hold all the values per rated item.
  2. If rank 1 is best, invert your ranks so 1=8,2=7... this just helps you visualize the chart's columns (rather than blank space) as better.
  3. Sum the results of each question's raters. Then sort by this total. This will put the item with the best overall scores first and worst overall scores last. This ranking will help you visually rank the charts when the overall pattern may not be obvious (as was the case in your sample data.
  4. Insert Sparklines using your ranking data (without the totals column) next to your data table. Visually, the more/bigger bars there are, the better the overall ranking.

There's nothing particularly analytical about this approach, but it's a pretty quick way to visualize the data.

Subjective Rankings

Note, if you don't have Excel 2010, you can create stripped down, cell sized column charts for each row that look about the same. Or, you can use a third-party add-on to create them.

EDIT: Table and Chart utilizing Gung's suggestion for average measure. As pointed out, since the scale is similar, it was added to the chart as an additional point of comparison (I used gray to help differeniate it from the raw data plots).

enter image description here

Related Question