Forum Discussion
Help!!! how can I rank or score this???
Looking at the 3 groups below. I asked each group to give me their list of top 5. Each group was asked to rank 1-5 with 1 being the best and 5 being the least. how can I score these so the 1's ar...
Roman0919 Well, if the lowest number represents the best score, you need to sort the list in ascending order. And I guess you need the average the scores as well. HORN has received 5 points from 3 groups. That's an average of 1.66667. Do the same for all others and HORN will turn out to be best (i.e. lowest average). APPLE and GREEN come out worst with 11/3 = 3.66667 . BANANA, HOUSE, FLOWER and FLAG will share 2nd place, each with 3 points.
If this is not what you had in mind, you should perhaps just turn around your scoring table. 1 is worst, 5 is best and the product with the highest overall score comes out as best.