Forum Discussion
Microsoft Forms: Ranking question type calculation methodology
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 can you share the RCV tabulator you used? How did it turn out?
mrdlo Sure 🙂 I found a lot of great information and the tabulator at https://www.rcvresources.org/. We used the https://www.rcvresources.org/types-of-rcv-lib/single-winner-rcv. I downloaded and installed the https://www.rcvresources.org/rcv-universal-tabulator. It worked great. The tabulator is actually stored in https://github.com/BrightSpots/rcv/releases/ along with documentation. Good Luck!
~Kimberly
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.
