How to Count Number of Selections in a Pick Any Question

Introduction

Sometimes with a Pick Any question (i.e., a multiple response question) it is useful to count up the number of choices or selections (i.e., selections, or mentions) made for each case or respondent (e.g., the proportion to select only one option, two options, three options, etc.)

For example, 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

Method

1. On the Variables and Questions tab, select all of the applicable variables.
2. Right-click and select Insert Ready Made Formula(s) > Mathematical Functions (by Case) > Sum and Yes.
3. Change the Question Type to Pick One.
4. Create a SUMMARY table of the variable.
5. To show the average number of selections, right-click and choose Statistics - Cells > Average.

NEXT

How to Count Responses Instead of Respondents in a Pick Any Question

How to set Value Attributes for a Pick Any and Pick Any-Grid