Now you can measure controversy?!

One of the unique features of Feedback Frames is that the results can always 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 voila, you can sort all the results from a meeting by priority of agreement.


Get the Template

You can download a free Excel template for a Results Data-Entry Score Spreadsheet on our templates page.

Feedback Frames spreadsheet example

Now with a “Controversy” Column

Recently we added a new column to the template that automatically calculates the standard deviation in the number of tokens across the five rating columns (the sixth column being “not sure”).   Standard deviation is a number used to tell how measurements for a group are spread out from the average. This number is then a good indicator of how controversial an idea was among participants.  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.  But if ratings were very 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 for professional client reports.

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 templates
and discounts on
Feedback Frames