How to Create Top Two Category Variable(s) (Top 2 Boxes)

This article describes how to create new variables that show the proportion of respondents who selected the top 2 options in Nominal, Nominal - Multi, Ordinal or Ordinal - Multi variable sets, in other words, Displayr computes what is commonly referred to as 'Top 2 Box' percentages. 

The table on the left shows a Summary table of a Nominal - Multi question. The table on the right shows a Summary of the Binary - Multi. 

Requirements

Please note these steps require a Displayr license.

• A data set loaded into Displayr that contains Nominal, Nominal - Multi, Ordinal or Ordinal - Multi variable sets.

Method

1. Displayr identifies the bottom options by looking at the numeric Value for each category not selected as Missing Data in the Value Attributes of the variable set and choosing the lowest value.
2. OPTIONAL: To determine the numeric values, select the variable set in the Data Sources.
3. OPTIONAL: Then, in the object inspector go to Properties > Data Values > Values.
   
4. To create a 'Top 2 Box' variable select the variable set in the Data Sources.
5. Either hover over any variable in your Data Sources > Plus (+) > Insert Variable(s) > Ready-Made New Variable(s) > Top Two Category Variable(s) (Top 2 Boxes) or from the object inspector select General > Transformations  > Top Two Category Variable(s) (Top 2 Boxes).
6. Displayr will ask you if you want to consider variable sets whose categories suggest they may be scale variable sets (for example, 5-point agreement scales).
7. Then, it will ask you to select which variable sets to generate new variables for, if you haven't already selected a variable in the Data Sources.
8. When appropriate, you will be asked if you want to remove categories that look like Don't know options. This is equivalent to setting the category as Missing Data.
9. Displayr will then create new variables for the top 2 categories of each selected variable set. The Value Attributes may look something similar to below:
   
   
   

Notes

• Displayr identifies the bottom options by looking at the numeric Value for each category that is not selected as Missing Data in the Value Attributes of the variable set and choosing the lowest. 
• To determine the numeric values select the variable set in the Data Sources, and go to Properties > Data Values > Values.
  

Next

How to Create Top Three Category Variable(s) (Top 3 Boxes)

How to Create Top K Category Variable(s) (Top K Boxes)

Manipulating Data