Why do our survey percentages add to more than 100 when people could tick several answers?
EducationWe 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.