How to Compute the Number of Observations to Select One And Only One Option

Sometimes it is interesting to compute the proportion or number of observations (e.g., people) that have selected one and only one option from a Pick Any question (i.e., multiple response question). If your data is not already in this format, then you should first change the Question Type (please review Help > Online Training > Manipulating Data > Questions > Multiple Response Questions if you are not familiar with how to do this).

Method 1: Finding the number or percentage of people that selected one and only one category

1. Go to the Variables and Questions tab.
2. Right-click on an row number and select Insert Variables > Binary - Complicated Filter.
3. Select the question and choose the options, as shown in the example below. (Please see Help > Online Training > Filters > Complicated Filters and Filters for more information about how to do this.)
4. Fill in the Label field appropriately (e.g., Only loyal to Coke Zero) and press OK.
5. Double-click on the row number of the newly created variable. This will cause it to replace whatever is currently selected in the Blue Drop-down menu.
6. Right-click on the table and select Statistics - Cells > n to see the number of observations.

Method 2: Finding the number or percentage of people that selected each combination of categories

1. Automate > Browse Online Library
2. Type Combinations in the Find box and press the magnifying button.
3. Select Multivariate - All Combinations of Pick Any Categories and press OK.
4. Select the variables of interest and press OK.
5. Select the table at the bottom of the Report Tree.
6. Right-click on the table and select Statistics - Cells > n to see the number of observations.