This article describes how to create new variables that show the proportion of respondents who selected the top 2 options in
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
Method
- 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.
- OPTIONAL: To determine the numeric values, select the variable set in the Data Sources.
- OPTIONAL: Then, in the object inspector go to Properties > Data Values > Values.
- To create a 'Top 2 Box' variable select the variable set in the Data Sources.
- 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).
- Displayr will ask you if you want to consider whose categories suggest they may be scale (for example, 5-point agreement scales).
- Then, it will ask you to select which to generate new variables for, if you haven't already selected a variable in the Data Sources.
- 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.
- Displayr will then create new variables for the top 2 categories of each selected
. 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)