How to Ignore Missing Data in the Column Sample Sizes of a Table

This article describes how to go from a crosstab where missing data results in an inconsistent Column Sample Size per row...

...to a table that adjusts the bottom Column Sample Size to ignore the missing data:

Requirements

• A crosstab with a Nominal, Binary - Multi or Binary - Multi (Compact) in the rows and Column Sample Size is available in Object Inspector > Data> Statistics > Below.
• Missing data in your table, whereby the number of respondents that have complete data for all the rows results in a lower Column Sample Size in Statistics > Below.

Method

1. Select your table.

2. Go to Data > Rules in the object inspector .

3. TSelect Plus (+) > Calculation > Ignore Missing Values in Column Sample Size in 'Statistics - Below' > OK.

Note, this rule affects only the Column Sample Size and Weighted Column Sample Size statistics in Statistics > Below and has no effect on any other statistics in the table.

Next

How to Use Rules in Displayr