Welcome to the JMP User Community!

Latest Discussions

• 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

  1440 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

  828 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

  19425 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

  1674 views | 2 replies

• count unique

  Hi, I have a table with transaction data like the below. transactionID, individualID, product1, a, apple2, a, orange3, b, apple4, b, banana5, c, orange I want to do in tabulate, not using script, to count how many unique individualID by product. Does anyone know how to do this?I can do summary table using individualID and product first, and then do a tabulate on it to get the uniqueID count by pro...

  joann

  Discussions |

  Oct 29, 2023 3:32 PM

  13687 views | 15 replies