Welcome to the JMP User Community!

Latest Discussions

• Calculate Rate of Change Grouped by Column

  I, like many others I suppose, are looking at the COVID-19 data (I got mine from https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-states.csv). I would like to plot the daily change in confirmed cases by State. I've been able to work it out by first sorting the data by State, and then calculating the deltas: If(:state == Lag(:state, 1), :cases - Lag(:cases, 1) )But is there any wa...

  MarkDayton

  Discussions |

  Mar 31, 2020 2:37 PM

  5431 views | 3 replies

• Assigning Minimum value to a column

  Hi folks,I have 2 files. 1st file: 2nd file : I am trying to write a script which will search for the Minimum age from the 1st file and assign the lowest age in the 2nd file For e.g. The 1st row which has three name Sam, John, Smith so the Value in the Minimum Age Column should be Min{Sam, John, Smith}  Min{21, 27, 32} = 21 my final output will look something like this:  Any suggestions please?Tha...

  Jackie_

  Discussions |

  Mar 31, 2020 2:31 PM

  7950 views | 13 replies

• How can I write a script to automatically group columns in new table?

  Hello, I am currently writing a script to essentially join three "reference" tables together using the Join, Transpose, and Update functions. My script allows the final output table to be updated each time I add rows to the first "reference" table. I was wondering if it would be possible to edit my script to automatically group columns (i.e. the "Group Columns" function) in the final output table ...

  bhdarst

  Discussions |

  Mar 31, 2020 10:53 AM

  2590 views | 3 replies

• Copying data from Matrix to JMP file

  Hi, I imported the data from the column properties into a matrix. My question is how can I copy data from matrix into JMP file?Spec2 = Function( {co}, a = Column( co ) << get property( "Spec limits" ); b = a["UL"]; C = Matrix( {b} ); );Copying data from Variable C into JMP file Any suggestion? 

  Jackie_

  Discussions |

  Mar 31, 2020 9:42 AM

  4288 views | 5 replies

• How to make 28 Run Five-Factor Central Composite Design

  Hi all-I'm studying Split Plot Design.
  There is a table 12. '28 Run Five-Factor Central Composite Design'
  in 'Split-Plot Designs:What, Why, and How' by BRADLEY JONES, CHRISTOPHER J. NACHTSHEIM,as Follows:I would like to make this DOE table with JMP,
  please advice me how to make this table by JMP. Thanks a lot.Aki

  yuzawaomine

  Discussions |

  Mar 30, 2020 9:49 PM

  6271 views | 4 replies