Welcome to the JMP User Community!

Latest Discussions

• Fill empty cells with last valid value

  Hello, I have the following problem. My dataset is composed by a list of rows, each representing one item produced by a machine. Normal items are not measured, but from time to time some "measurement items" are produced and the propetries measured. The assumption is that all the parts not measured will have properties similar to the latest measurment. How can I fill the empty cells using this logi...

  lburtone

  Discussions |

  Jan 10, 2020 7:53 AM

  15113 views | 4 replies

• XBar Chart not Calculating or Displaying UCL and LCL Correctly

  Hi, I'm a JMP 10 user. I can't figure out why my XBar charts are not calculating or displaying the UCL's and LCL's correctly. Here's my script and a snip-it of what the charts look like. I'm not sure if something strange is going on with my data set or my script. Thanks.  Control Chart( SendToByGroup( {:Category == "A"} ), Sample Label( :Name( "Date" ) ), KSigma( 3 ), Chart Col( :Process, XBar...

  Raquel

  Discussions |

  Jan 9, 2020 7:13 AM

  4380 views | 4 replies

• What's wrong with below code

  I've got errors on below code: dt << New Column( "Stage", If( Formula( Substr( :Column 9, 1, 2 ) ) == "CP", Formula( Left( :Column 9, 3 ) ), " " ) );   I want to add a new Col named "Stage" besides a raw Column 9, if starts with CP get the 1st 3 letters else blank, but I've got errors    Unexpected end of input. Perhaps there is a missing "," or ")".
  Trying to parse arguments of function "New...

  jerryspilTC

  Discussions |

  Jan 8, 2020 4:42 PM

  2438 views | 2 replies

• How to show the exact P-value when running Partial Correlation

  I just ran a Partial Correlation with 3 Variables : Paternal Care, Maternal Care and Self-Competence while controlling for Paternal Control and Maternal Control. I did this by going to Analyze-> Fit Model-> Add Paternal Care, Maternal Care and Self-Competence to Y while adding Paternal Control and Maternal Control to Model Effects.I want to know the P-value of the Partial Correlation but can't fin...

  nguyentandat234

  Discussions |

  Jan 8, 2020 2:59 AM

  2198 views | 4 replies

• Convert Character Date Time to Date Time

  Having difficulty converting to a numeric date time.  JMP log error: Column "Date-Time" changed to type Character to match formula.   Date::Time original format: 01:28:2018::02:14:08:099   What I am trying to do (after many attempts from various posts): dt<< new column ("Date-Time", numeric, formula( rawdate = substitute(trim(substr(:TimeStamp,1,10)),":","/"); rawtime = (trim(substr(:TimeStamp,13,...

  KST-CPT

  Discussions |

  Jan 7, 2020 1:36 PM

  10993 views | 8 replies