Multiple response analysis

1. What is multiple response analysis?
2. What is multiple response questions in research?
3. How do I analyze multiple responses in Excel?

What is multiple response analysis?

Multiple response analysis is a frequency analysis for data which include more than one response per participant, such as to a multiple response survey question. Examples of survey items which create multiple responses: "Tick all responses that apply." (multiple dichotomies)

What is multiple response questions in research?

A multiple response question presents a list of possible answer options, and the respondent selects all options that are true for them.

How do I analyze multiple responses in Excel?

Use the FILTER Function to get an array of responses per multiple choice and section, then count this array and divide by total responses to get the percent.