Welcome to the JMP User Community!

Latest Discussions

• Create columns with 'Steps' and 'Runs' based on column with sequential numbers but varying rows, 'Steps' repeat every 4th number.

  Having a tough time trying to word this question! But I have a data set, 'Sample', that start at 1 and is continuous but number of rows per value is not consistent (ie. 1,1,1,2,2,3,3,3,3,4,4,5...). Format for sample and desired columns below. Thanks!  SampleStep # (desired)Run # (desired)111111221331331441512512622732732732732842913913913102310231023113312431243124313141424153416441644

  Ctron87

  Discussions |

  Oct 30, 2023 7:23 AM

  2052 views | 4 replies

• Add-in Manager with Google Drive

  Hello, I have an add-in that I deploy and maintain at a customer site with dozens of users. The problem is that when I deliver a new version, the users have to update. This customer has the google suite, so I drop the new version each time on a private google Drive directory , and the users have to retrieve this new version each time to update. We all agree that this is very time-consuming, not op...

  SophieCuvillier

  Discussions |

  Oct 30, 2023 7:03 AM

  1568 views | 2 replies

• MFI import data start on row X

  Hello, I am trying to do a multi file import, but I have data with a header on row 7 and data starting on row 8. I know how to change this in the script for individual worksheet imports. How do I do it for MFI? Using JMP 17. 

  patriciafm811

  Discussions |

  Oct 30, 2023 6:42 AM

  908 views | 1 replies

• How good is K-fold cross validation for small datasets?

  I have a small data set with 154 molecules (attached). I'm trying to predict KV40 using 6 factors. From looking at similar studies in the literature, many use the leave-one-out validation method to build models for such smaller data sets, so to replicate this in JMP, I did the following:Fit-model: Stepwise regression
  - used response surface for factors
  - used k (k-fold cross-validation) = number of ...

  tnad

  Discussions |

  Oct 30, 2023 6:04 AM

  20175 views | 9 replies

• How do I sum multiple columns using the formula window?

  I have a table with many columns and would like to easily sum a block of them (columns 50-100) in another column.  What is the best way to do so without making a formula: column50 + column51 + column52.... ? I did find a similar question from 2015 showing you can shift+click to select many columns using the "Sum" function (https://community.jmp.com/t5/Discussions/How-do-I-sum-multiple-columns-usin...

  EH1

  Discussions |

  Oct 30, 2023 5:17 AM

  1834 views | 2 replies