Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Education · Advice & Questions ·

Why do our survey percentages add to more than 100 when people could tick several answers?

Education category photographEducation

We are working through a made-up survey example in class. Twenty people answered “Which resources did you use this week? Tick all that apply.” Twelve chose videos, ten chose worked examples and eight chose revision notes.

I calculated 60%, 50% and 40%, then panicked because they add to 150%. My partner wants to divide by the thirty selections instead so the total becomes 100%.

The ABS guidance on multiple-response data describes questions where a respondent can select more than one category. How should we explain this exercise? I want to show what proportion of people used each resource without quietly changing the question just to make the percentages add up neatly.

Discussion

5 community replies

Each calculation uses the twenty people as its base: 12/20, 10/20 and 8/20. One person may be counted under several resources, so adding the three percentages does not give a percentage of distinct people.

Dividing by thirty would describe the share of all selections belonging to each option. That is a different calculation from the share of people who used it. It is not a repair you can make without changing the label and meaning.

Still check the tally. Permission to tick several answers does not excuse entering the same person's choice twice within one category or using different denominators by accident. A total above 100% can be expected here without proving that every entry is correct.

Show the counts with the base of twenty and state that multiple answers were allowed. Keep the resource names attached to the question about use, so readers know what those numbers describe.

And do not relabel the most-used resource as the favourite or the most effective. The question did not ask people to rank the resources or say what helped them learn. Explaining the overlapping answers also means keeping those limits on the conclusion.

Join the discussion

More in Education