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

Introduction

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

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

Requirements

• A crosstab with a Pick One, Pick Any or Pick Any - Compact in the rows and Column n available in 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 n in Statistics Below.

Method

1. Select your table.

2. In the toolbar go to Automate > Browse Online Library > Modify Whole Table or Plot > Ignore Missing Values in Column Sample Size in Statistics Below.

3. Press OK.

Note, this rule affects only the Column n and Column Population statistics in Statistics - Below and has no effect on any other statistics in the table.

Next

How to Use Rules in Q