Welcome to the JMP User Community!

Latest Discussions

• Duplicate Row Selection Including the Original Row

  Hello. I have a data table that contains 960K rows and 49 columns. There are duplicate rows (from 2-4 rows) based on one of the 49 columns. I've used the Row Selection - Select Duplicate Rows function after selecting this one column that contains the duplicate values. When the results came back, the duplicate rows became highlighted but the original row above the duplicate row/s is not. Is there a...

  SKHDS

  Discussions |

  May 16, 2025 10:46 AM

  2430 views | 4 replies

• Column Names With A Numeric Initial

  I have a code that stumbles with column names having a numeric initial, whereby the code thinks the name represents a date.  I did a column rename to overcome the problem but it's ugly.  I also found that wrapping the object that represents the names in a Char(obj) statement didn't work either.  Any suggestions on how to better deal with this? dt = Current Data Table(); cnmes = dt << get column na...

  SpannerHead

  Discussions |

  May 16, 2025 9:37 AM

  749 views | 2 replies

• Confirmation results: Redo mixture design or make a new one?

  Hi JMP community,   I have conducted the following mixture design with constraints: MeOH + ACN + UPW = 0.6, and MeOH + ACN ≤ 0.3. Would it be better to repeat this mixture design to confirm the results, or create a new one for validation?   Thanks a lot!  Kimberly   Details mixture design:  Version: Jmp Pro 18

  K_JMP

  Discussions |

  May 16, 2025 6:39 AM

  1069 views | 4 replies

• How to plot only for the selected range of data without extracting subsets?

  For example, like this, I deliberately increased the data within the selected range:
  Age ==14 dt=Open("$SAMPLE_DATA/Big Class.jmp"); dt<<Sort(By( age),Order(Ascending),replace table); ca="NO";New Column(ca);Column(ca)<<Formula( if(row()==1|age!=lag(age,1),r=row();1,1+row()-r) );dt<<run formulas;Column(ca)<<deleteFormula; ca="height1";New Column(ca);Column(ca)<<Formula( if(age==14,height*100,height)...

  lala

  Discussions |

  May 16, 2025 6:22 AM

  2338 views | 9 replies

• Confidence Intervals For Cpk

  I was trying to replicate the confidence intervals for Cpk in JMP.  I found this page which details the formula: https://www.jmp.com/support/help/en/17.0/#page/jmp/statistical-details-for-capability-analysis.shtml This page says the equation is: So this is the example I am trying to match,    since it is 95%, the lower confidence interval should be (32 is the sample sample size):    This equals, 6...

  lisamaley

  Discussions |

  May 15, 2025 9:50 PM

  3776 views | 5 replies