How To Show Missing Values on a Table

From Market Research
Jump to: navigation, search

The way that missing values can be shown on a table differs from program to program. However, the following are broadly representative of the different mechanisms:

  • Many programs, such as SPSS and R, will automatically show missing values as a separate category on summary tables.
  • Where the programs automatically exclude the missing values then you need to either:
    1. Recode the missing values as actual values (e.g., in SPSS, change the SYSMIS to a 99).
    2. Change the Missing Values settings.