Discovering Patterns in Missing ValuesI 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 ValuesYou 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 ValuesTo 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 ValuesThank you! I will try this.
Re: Discovering Patterns in Missing ValuesOkay, thanks for the advice!
Re: Discovering Patterns in Missing ValuesHi, what do you mean by "Cell Plot Script"?
Re: Discovering Patterns in Missing ValuesNevermind. Just figured it out!
