UPCOMING WEBINAR: Finding the story in your survey data Sometimes you may want to set low values in a Numeric variable to a certain number. This can be useful if you have a Numeric variable that has negative values, but actually shouldn't. You can recode these negative values as 0, or round up other low values based on a threshold. This article describes how to take a numeric question with low values:
And recode the values so that the low values are capped at a selected value:
Requirements
- A data set containing one or more Numeric variables with low values that you want to cap.
Method
1. In the Data Sources pane, select the Numeric variables with low values you want to cap.
2. Click Anything > Data > Variables > Modify > Recode > Recode Low Values (Capping) in Numeric Variable(s).
4. Enter the value to use as the lower limit cap (I used 0 in the example above). All values lower than the value entered will be recoded to that value and click OK.
Next
How to Create Top K Category Variable(s) (Top K Boxes)
How to Create Bottom K Category Variable(s) (Bottom K Boxes)
How to Recode High Values (Capping) in Numeric Variables
How to Set High or Low Values to Missing 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