cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
mmadelman26
Level II

Discovering Patterns in Missing Values

I am working on analyzing patterns of missing values in various well log data in a particular basin. What are some ideas on the best way to analyze these patterns using JMP. Eventually, I would like to classify these missing values as missing at random (MAR), not missing at random (NMAR), and missing completely at random (MCAR) and define which geological conditions and drilling operations contribute to missing values in logging data (EX: washed out zone, change in formation, cased hole, etc). 

1 ACCEPTED SOLUTION

Accepted Solutions
ian_jmp
Staff

Re: Discovering Patterns in Missing Values

You probably know already that 'Tables > Missing Data Pattern' will generate another table containing two other graphics scripts. It might be worth using the 'Cell Plot' script, possibly in conjunction with a local data filter, to see what you find. Of course the effectiveness of such a visualisation may be influenced by the number of rows and columns in your data.

View solution in original post

6 REPLIES 6
ian_jmp
Staff

Re: Discovering Patterns in Missing Values

You probably know already that 'Tables > Missing Data Pattern' will generate another table containing two other graphics scripts. It might be worth using the 'Cell Plot' script, possibly in conjunction with a local data filter, to see what you find. Of course the effectiveness of such a visualisation may be influenced by the number of rows and columns in your data.

mmadelman26
Level II

Re: Discovering Patterns in Missing Values

Thank you! I will try this. 

mmadelman26
Level II

Re: Discovering Patterns in Missing Values

Hi, what do you mean by "Cell Plot Script"? 

mmadelman26
Level II

Re: Discovering Patterns in Missing Values

Nevermind. Just figured it out!

P_Bartell
Level VIII

Re: Discovering Patterns in Missing Values

To add on to @ian_jmp 's advice and counsel is if you intend to model the data there are several platforms which support JMP's 'Informative Missing' capability. You may want to first decide which modeling technique you'd like to use, then read up in the JMP documentation about how that particular platform implements the general category of informative missing.

mmadelman26
Level II

Re: Discovering Patterns in Missing Values

Okay, thanks for the advice!