How to Create Bottom Category Variable(s) (Bottom 2 Box, Bottom 3 Box, Bottom K Box)

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 Nominal, Nominal - Multi, Ordinal, or Ordinal - Multi variable sets. 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 Nominal, Nominal - Multi, Ordinal, or Ordinal - Multi variable sets.

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.

Your variable set's values will need to be in ascending order in order to count the "bottom" attributes:

If your value scale is reversed and the highest value is assigned to the "lowest" attribute (i.e., Hate is assigned a value of 5 instead of 1), then consider using How to Create Top Category Variable(s) (Top 2 Box, Top 3 Box, Top K Box) instead.

If, instead, you want to recode your variable to reverse the scale, see How to Reverse Scales in Variable Sets.

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 variable set(s). 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.

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