SOLVED

Microsoft Forms: Ranking question type calculation methodology

Occasional Contributor

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!
~Kimberly

2 Replies
best response confirmed by Kimberly_Huffman (Occasional Contributor)
Solution

Re: 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!

Re: Microsoft Forms: Ranking question type calculation methodology

@Jon_Kay Yes that seems to be the case.

I was able to find a RCV tabulator.  So for my purposes, I'm using the MS Forms Ranking question type to collect votes. When the voting is over, I will open the results in Excel, convert the ranked candidate cells to columns, save, and then use the RCV tabulator.  It's going to be interesting to see if the results will be the same.

Thanks!