Forum Discussion
Solved
Microsoft Forms: Ranking question type calculation methodology
What methodology is used in determining the results of a Ranking question type? I believe I have ruled out Ranked Choice Voting (RCV) but would like to know for sure the methodology. Thanks! ~Kimbe...
Kimberly_Huffman i dont know the official name, but i like to think of it as points. Eg you have 5 items to rank. And 3 people do the ranking:
A, B, C, D, E
A, C, D, E, B
C, A, B, D, E
Position 1 gets 5 points, position 5 gets 1 point. So add it up
A=14 points
B = 8
C = 12
D = 7
E = 4
So the ordering in the results page should show A as the winner, C as 2nd place, etc etc
While we order by total points, the bars are colored appropriately so you can see the breakdown within that score
Hope this makes sense!
Kimberly_Huffman how did the results compare to the Forms ranking methodology?
Kendra_Perry In the screenshot, you can see how the Forms ranked compared to using the RCV Universal Tabulator. I collected the votes using Forms, opened the results in Excel, and uploaded those results to the RCV tabulator. Hope this helps.
- Thanks for sharing! Very interesting.