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 variables that contains a 'Don't know' or a similarly labeled category (see here) that you want to excluded from Statistics that use the underlying categorical Value.

## Method

1. You can 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.

2. From the toolbar menu, 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 Add Top K Category Variables

How to Add Bottom K Category Variables

How to Recode High Values (Capping) in Numeric Variables

How to Recode Low Values (Capping) in Numeric Variables

How to Remove Don't Know Categories