topic Re: Discovering Patterns in Missing Values in Discussions

Discovering Patterns in Missing Values

mmadelman26 — Tue, 02 Apr 2019 20:35:03 GMT

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).

Re: Discovering Patterns in Missing Values

ian_jmp — Wed, 03 Apr 2019 09:00:35 GMT

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.

Re: Discovering Patterns in Missing Values

P_Bartell — Wed, 03 Apr 2019 13:55:17 GMT

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.

Re: Discovering Patterns in Missing Values

mmadelman26 — Wed, 03 Apr 2019 14:15:41 GMT

Thank you! I will try this.

Re: Discovering Patterns in Missing Values

mmadelman26 — Wed, 03 Apr 2019 14:16:50 GMT

Okay, thanks for the advice!

Re: Discovering Patterns in Missing Values

mmadelman26 — Wed, 03 Apr 2019 15:01:03 GMT

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

Re: Discovering Patterns in Missing Values

mmadelman26 — Wed, 03 Apr 2019 15:05:08 GMT

Nevermind. Just figured it out!