How to Add Bottom K Category Variables

This article describes how to create a new variable based from an original variable containing ordinal or categorical data: 

To a new variable that contains only the selected bottom K categories. In this example, I've selected the bottom 3 categories from the variable above: 

Requirements

• A Displayr document with a data set, preferable containing at least one ordinal (scale) variable or variable set. Categorical variables with scales will also work.

Method

1. Select the variable or variable set from the Data Sets tree. 

2. Hover over the selected variable until a + sign appears. Click the + , and then select Ready-Made New Variables > Add Bottom K Category Variable(s) (Bottom K Boxes).

3. Enter the number of categories that you want to combine and click OK.

4. A new variable will appear in the Data Sets tree containing a summary of only the selected bottom K categories selected at Step 3.

Next

How to Add Top K Category Variables

How to Recode High Values (Capping) in Numeric Variables

How to Recode Low Values (Capping) in Numeric Variables

How to Combine Categories with Small Percentages

How to Remove Don't Know Categories

How to Exclude Don't Knows from Averages but Include in Percentages

Manipulating Data