UPCOMING WEBINAR: 10 Market Research Predictions Over the Next 4 Years Sometimes with a multiple response question (i.e., a Binary-Multi variable set), you may want to show the average number of options selected (or items mentioned) across respondents. In order to calculate this, you must first create a new variable that is the Count of the number of selections per respondent. Then when you use this Numeric variable in a built-in drag and drop table, Displayr automatically shows the Average (or any other standard statistic).
The example below is a multi-select question, if respondents are asked which of the following list of colas they are aware of, it may be on interest to count the number of colas each respondent selected.
Which of the following colas are you aware of?
_Coca-Cola
_Diet Coke
_Coke Zero
_Pepsi
_Diet Pepsi
_Pepsi Max
Requirements
- The multi-response variable set must be structured as Binary-Multi, see How to Create New Binary Variable(s) for guidance.
Method
- In the Data Sources tree, select a variable set or group of variables.
- Hover over one and click + > Calculate Across Variables > Count. This will create a new variable that is the Count of the 1s (coded for Selected) across the variables. Missing data is ignored by default.
- Drag the new variable to a Page or the Report tree to make a table, and you'll see the Average number of selections.
- OPTIONAL: You can also see how many respondents chose a certain number of options. Select the count variable (or a Duplicate of the variable) and in the object inspector, change the Structure > Nominal: Mutually exclusive categories. You'll see the proportion who chose each number.
Additional Notes
If your data is messy or in a Nominal-Multi structure, you can customize which values to count in the object inspector > Data > Values to count field of the count variable if needed.