Now You Can Measure Controversy?!

One of the unique features of Feedback Frames is that the results can consistently be tabulated and compared quantitatively.

Simply count the number of tokens in each column, and enter the numbers into a spreadsheet table.  Then, calculate the average score of each frame result, and voilà!

You can sort the results from a meeting by priority of agreement.

  
 

How to Get the Template:

Download a free Excel template for the Results Data-Entry Score Spreadsheet by cruising on over to our Templates page.

Feedback Frames spreadsheet example

Now with a “Controversy” Column!

This newly added column automatically calculates the standard deviation in the number of tokens across the 5 rating columns (the 6th column being the less controversial “not sure”).

Standard deviation is a number used to tell how measurements for a group are spread out from the average. This number is a good indicator of how controversial an idea was among participants.

For example, if most responses were around the same column, such as all strong agreement, or all neutral, or all disagreement, then the standard deviation “controversy” will be low, such as 4 out of 10.

If ratings were instead polarized with almost all tokens split between strong agreement and strong disagreement, then the standard deviation “controversy” will be high, such as 9 out of 10.

Using the spreadsheet from our templates page is an easy way to make your meeting results clearly prioritized for participant review and reporting.

Thanks for the Excel math help from my super genius friend John Richardson, creator of Ethelo group decision-making software.

Leave a Comment

Sign-up for tips, templates
and discounts on
Feedback Frames