# Column Comparisons with Missing Data and Grid Questions

There are a variety of different assumptions that can be made regarding missing values when conducting tests on SUMMARY tables of the following type of grid tables

- Number - Grid
- Pick Any - Grid
- Pick One - Multi where the variables are in the columns of the tables. (NB: prior to Q 4.3.1, casewise exclusion was automatically applied.)

## Pairwise inclusion of missing values

This is the default option. What it means is that when columns are compared, they are compared using only respondents with complete data on all the variables that correspond to the columns. Casewise deletion is employed if an ANOVA-Based Column Comparison has been specified.

## Casewise exclusion of missing values

This involves only performing comparisons using respondents with complete data on all the columns being compared. This occurs automatically when using ANOVA-Based Column Comparison. It can be made to occur with any table by application of a filter.

## Dependent tests

These tests use all the data that is available for performing the test. To apply dependent tests, make the following changes in Statistical Assumptions:

- Change the
**Proportions**setting to**Survey Reporter Proportions**. - Change the
**Means**setting to**Survey Reporter Means**. - Where a Pick Any question is in the Brown Drop-down Menu or analyzing a Number - Grid, Pick Any - Grid or Pick One - Multi SUMMARY set
**Overlaps**to**Dependent**.