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

This article describes how you can create new variables that show the proportion of respondents who selected the bottom 2 options in Nominal, Nominal - Multi, Ordinal, or Ordinal - Multi variable sets. In other words, Displayr computes what is commonly referred to as 'Bottom 2 Box' percentages. 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.

Requirements

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

Method

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 (+) > Ready-Made New Variable(s) > Bottom Two Category Variable(s) (Bottom 2 Boxes).
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:

Notes

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 lowest values. To determine the numeric values, select the variable set in the Data Sources tree, then in the object inspector go to Data > Properties > Values.