UPCOMING WEBINAR: From Thousands of Tables To One Clear Story: using AI in survey analysis You can show averages on tables for categorical variables without having to make another table, see How to Calculate an Average Value from Categorical Data in Displayr. This article describes how to show the Average in a table, including a Don't know or a similarly labeled Value (Unsure below,) which includes the category:
to one where the category is still shown but is removed from the Averages and any other Statistics created using the underlying values.
Requirements
- A data set containing one or more categorical or numeric variables that contains a 'Don't know' or a similarly labeled category that you want to exclude from Statistics that use the underlying categorical Value.
Technical details
Phrases that are identified as Don't Know type responses contain one or more of:
- dk
- dont know
- don't know
- don t know
- unsure
- not sure
- do not know
- no idea
- not applicable
The matching of these is not case-sensitive.
Additionally, where a label is, in its entirety, NA or na, it is treated as a Don't Know.
Method
- Select one or more tables/variables or an entire data set in your document. Any Don't Know categories within the selected object(s) will be removed.
- From the toolbar, select Anything
> Data > Variables > Modify > Recode > Set the Value of Don't Knows to NaN.
Next
How to Rebase Multiple Response Data in Variable(s) to NET
How to Create Top Category Variable(s) (Top 2 Box, Top 3 Box, Top K Box)
How to Create Bottom Category Variable(s) (Bottom 2 Box, Bottom 3 Box, Bottom K Box)
How to Recode High Values (Capping) in Numeric Variables