Welcome to the JMP User Community!

Latest Discussions

• 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

  598 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

  16617 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

  1183 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

  10412 views | 15 replies

• Add Counter for Unique Cases in Groups

  Hi all,  How can I write an integer value counter to increment unique values in column B within group A, to do this? Here is what I have tried so far:   dt_Table1 = Data Table("Table1"); dt_Table1 << New Column("Dataset", Numeric, "Nominal", Set Selected); Sum1 = dt_Table1 << Summary(Group(:Group, :Date)); Sum2 = Sum1 << Summary(Group(:Group)); :N Rows << Set Name("N Datasets in Group"); dt_Tab...

  StumptownSlash

  Discussions |

  Oct 29, 2023 3:30 PM

  2752 views | 10 replies