topic Re: Non-numeric Pass/Fail Rate Analysis in Discussions

Non-numeric Pass/Fail Rate Analysis

nldavis — Sat, 31 Jan 2015 01:05:01 GMT

I'm a long time JMP user, but a first time poster. I’ve searched and searched and cannot find a means to analyze data the way I’d really like.

Attached is an Example data table that I’m using.

For my specific example, each “ID” has ~700 unique X/Y coordinate locations. And each one of those X/Y coordinate locations is tested for Pass/Fail. (Pass = “.”; Fail = “F”).

Ideally, I’d like:

A Contour Plot, with a color gradient associated to the Pass and/or Fail rate for all ID’s. (e.g. if -9/+13 passes 1% of the time it would be blue, and if -9/+14 passes 99% of the time it would be red).
Or a 3-dimensional chart indicating pass/fail rates similar to above.
Or, if I can convert my X/Y coordinates into a distance-like measurement (radius, for example), a plot of Pass/Fail rate vs. distance.

The Example data table I have here (~30k rows) is a relative small subset of my larger data table (>>1 million rows).

Although I'm not opposed to working with scripts, can JMP do the above without scripts? That is, does JMP have built-in functions to accomplish this task?

Help or advice is much appreciated. Thanks.

Re: Non-numeric Pass/Fail Rate Analysis

KarenC — Sat, 31 Jan 2015 20:41:08 GMT

I think the key to your analysis is "data prep work". Meaning that you if you had a table that had a %pass for each x-y coordinate then you could use any number of graphics to explore your data. I would recode your pass/fail column to a numeric column with 0 = fail and 1 = pass. Then you can summarize your table (your x and y go into the "Group" and then you want the mean for the P/F column. Once you have that table try graph builder with x = x, y = y and the mean column (%pass) as the color and try the contour or heat map from there.

Karen

Re: Non-numeric Pass/Fail Rate Analysis

ms — Tue, 18 Oct 2016 22:26:15 GMT

JMP appears to automatically interpret the Pass/Fail as a binary variable and show the proportion of "F" for each coordinate without summarizing. Recoding 0/1 gives the same result.

Set X and Y to Ordinal data type to get a heat map as below.

Re: Non-numeric Pass/Fail Rate Analysis

nldavis — Mon, 02 Feb 2015 17:31:52 GMT

Thank you very much. This works beautifully.