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

This article describes how to you can create new variables that show the proportion of respondents who selected the bottom K options in Nominal, Nominal - Multi, Ordinal or Ordinal - Multi variable sets. In other words, Displayr computes what is commonly referred to as 'Bottom K Box' percentages. Categories that look like Don't know options will not be included in the bottom boxes, and when such categories are identified the script will give you the option to remove them.

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 variable set which will be the result of this function.

Requirements

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

Method

Select the variable set in the Data Sets tree.
Go to Anything > Data > Variables > New > Ready-Made New Variable(s) > Bottom K Category Variable(s) (Bottom K Boxes).
Displayr will ask you how many categories you wish to combine, for example, to combine the bottom two categories type '2' and press OK.
Displayr will then create new variables for the bottom 2 categories of each selected variable set. These will be available in the Data Sets tree. When inspecting the Value Attributes of the new variable sets (Properties > DATA VALUES > Values) you should see something like the 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 find out what the numeric values are, select the variable set in the Data Set tree.
Then in the object inspector on the right of your screen, under Properties > DATA VALUES click on Select categories.