Welcome to the JMP User Community!

Latest Discussions

• How to show failure rate in summary statistics (e.g. percentage of cells in a column with value larger than a given number)?

  For example, snapshot below is the statistics of a column of values. There are mean/Std Dev etc in the Summery Statistics. I want to add another variable called failure rate, which is defined as the number of cells out of the total N (=1079) which has value larger than a give number, e.g. 99.5. How can I do that? Thanks.  

  fireonthesea

  Discussions |

  Mar 8, 2021 5:52 AM

  3042 views | 3 replies

• Sequentially exclude rows?

  Hi.  Is there a command to exclude rows that doesn't also unexclude previously excluded rows?  In my script, I'd like to exclude rows in a table that already may have some of these rows excluded.  The problem is that if I use Exclude, it may actually Unexclude previously excluded rows.  For example:Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp"); dt << Clear Row States; r = dt <<...

  nikles

  Discussions |

  Mar 8, 2021 12:35 AM

  1270 views | 2 replies

• Tweak a model before running fit model, list box not respecting special column names

  I’m looking to build a copy of this model effects dialog from fit model: Goal is to build a script that will read in this effects expression from the model script that DOE saves in the table, allow people to tweak the effect expression and then run some analysis using fit model with the new effects expression.If you run the dialog in below script, you will see that it reads in the effects expressi...

  pauldeen

  Discussions |

  Mar 7, 2021 10:59 PM

  3030 views | 6 replies

• Using loop variable as column input

  Hello,   I am wondering if it possible to use my for loop variable, i, as an input for a new column, depending on the value of another column.  Here is what I am thinking, but cannot get to work. dt << New Column("Site", Numeric, Formula(    For(i = 1, i <= 8, i++,       If(Contains(:Column1, i), i);    ) ));  

  wyatt_dunn

  Discussions |

  Mar 5, 2021 1:10 AM

  1419 views | 2 replies

• How to color code by sample type in a PCA?

  I am novice at JMP, and I am making my first PCA that I would like to color code by sample type (treatment) ... but I cannot figure out how. Any advice?My study compares a variety (15+) of carbon composition metrics of the leaves, litter, and soil of two different plant species in rivers versus creeks -- overall that is 12 sample types, or treatments.Any help would be greatly appreciated!I have JM...

  harvestnoon

  Discussions |

  Mar 4, 2021 10:14 PM

  3199 views | 1 replies