This article describes how you can create new variables that show the proportion of respondents who selected the bottom category (bottom 2 box, bottom 3 box, bottom k box) options in
You have the option to exclude categories that look like Don't know.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 after running the bottom 2 box feature.
Requirements
- A data set loaded into Displayr that contains
Displayr identifies the bottom categories 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 highest values. To determine the numeric values, select the variable set in the Data Sources tree, then in the object inspector, click Data > Properties > Values.
Method
Bottom 2 Category Variable (Bottom 2 Box)
- Select the variable set(s) in the Data Sources tree. If multiple variable sets are selected, a new bottom 2 box variable will be created for each.
- Hover and click Plus (+) > Convert To > Binary - Multi > Bottom 2 Categories.
- 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 a new variable for the bottom 2 categories for the selected
. The Value Attributes may look something similar to below:Bottom 3 Category Variable (Bottom 3 Box)
- Select the variable set(s) in the Data Sources tree. If multiple variable sets are selected, a new bottom 3 box variable will be created for each.
- Hover and click Plus (+) > Convert To > Binary - Multi > Bottom 3 Categories.
- 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.
Bottom K Category Variable (Bottom K Box)
- Select the variable set(s) in the Data Sources tree. If multiple variable sets are selected, a new bottom 3 box variable will be created for each.
-
Hover and click Plus (+) > Convert To > Binary - Multi > Bottom K Categories.
- Displayr will ask you how many categories you wish to combine. For example, to combine the bottom two categories, type '4' and press OK.
- 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.
Notes
If you want to create a bottom box NET category on a table, in addition to retaining the original scale, as seen in the table below, see the "Adding a new category" section of How to Recode into Existing or New Variables.
Some users might prefer to restructure a nominal - multi or ordinal - multi variable set into a binary - multi and manually indicate which values to count. Use this method if you are only interested in aggregating one aspect of the question, such as one specific code, one combination of codes, etc. See How to Merge or NET Categories on a Nominal - Multi for more information.
Next
How to Create Top Category Variable(s) (Top 2 Box, Top 3 Box, Top K Box)
How to Reverse Scales in Variable Sets
How to Recode into Existing or New Variables
How to Merge or NET Categories on a Nominal - Multi
Manipulating Data video