View Patterns of Missing Data

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • Enter and Edit Data • Organize Data • View Patterns of Missing Data

•

View Patterns of Missing Data

If your data table contains missing data, you might want to determine whether there is a pattern to the missing data. The pattern might help you make discoveries about your data.

To view patterns of missing data, follow these steps:

1.

With your data table open, select Tables > Missing Data Pattern.

2.

Select the columns for which you would like to find patterns of missing data.

3.

Click Add Columns.

4.

Select Count Missing Value Codes to count missing value codes as missing values.

5.

Select Add Value Colors Property to consistently color columns that contain 0 or 1 (missing value indicators).

For example, non-missing is always colored blue, missing is always colored red. This is especially helpful for data tables that might have similar values across columns.

6.

Example of Viewing Patterns of Missing Data

1.

Select Help > Sample Data Library and open Missing Data Pattern.jmp.

2.

Select Tables > Missing Data Pattern.

Figure 3.18 The Missing Data Pattern Window

3.

Highlight all of the columns.

Note: For details about the options in the red triangle menu, see Column Filter Menu in Get Started.

4.

Click Add Columns.

5.

Figure 3.19 A Missing Data Pattern Table

Tip: To quickly create a Treemap or Cell Plot of the data, click the green triangle next to the Treemap or Cell Plot script in the table panel.

Figure 3.19 shows the following patterns:

•

Row 1 shows that there are two instances where all rows in Trial 1, Trial 2, Trial 3, and Trial 4 have no missing values.

•

Row 2 shows that there are two rows in the source table whose one missing value is in the Trial 4 column.

•

Row 3 shows that there are two rows in the source table whose missing values are in the Trial 3 and Trial 4 columns.

•

Row 4 shows that there is one row in the source table whose three missing values are in the Trial 2, Trial 3, and Trial 4 columns.

The Count column is assigned the frequency role. If you now use the Missing Data Pattern data table to run an analysis, JMP automatically uses Count as a frequency. For details, see Assign a Preselected Analysis Role in The Column Info Window.

•

Help created on 7/12/2018