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:
- 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.
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.
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
Article is closed for comments.