Welcome to the JMP User Community!

Latest Discussions

• How to append data to a file without opening it?

  I need to append new data to a file on a weekly basis.  Is there a way for me to do so without opening/loading the file in JMP script? dt = open("my.csv"); dt<< Concatenate(Data Table ("New data") , append to first table); dt << Save("my.csv", Replace(1));  Thanks!

  Dawn_Lun

  Discussions |

  Mar 1, 2021 4:08 AM

  3255 views | 2 replies

• k-NN visualization in JMP

  Hi folks, Longtime JMP Pro user here but fairly new to working with the k-Nearest Neighbors classification module.  I'm working with a visible reflectance spectroscopy data set for a geological material classification (two-class) problem.  I have a fairly well-optimized k-NN model at this point with a low misclassification rate on my test set.  So far, so good.  However, I am looking for a way to ...

  redrock

  Discussions |

  Mar 1, 2021 4:00 AM

  3005 views | 3 replies

• JSL - Find % of missing data

  I have a data table with 3 columnsI need to create a table showing % of missing data in the HEIGHT column grouped by ID and SUB_ID. In the case above the result should be: But it is possible in some cases that there are no rows with missing data. In that case Percent Missing should be 0. I need help in writing a JSL script for this. I will appreciate any guidance. I have three issues in my script ...

  rverma

  Discussions |

  Feb 28, 2021 7:40 AM

  5722 views | 8 replies

• Looking for a sample size calculator for defect proportions that can help me optimize the sample size with a minimum proportion to detect and the CIs for computed proportions.

  Use case: 35,000 defects detected by a machine on one wafer. An operator samples 1500 images and sorts them into 10 categories. The percentages of the defect categories are meant to reflect the defects in the population of 35,000. In this case 1500 images were used but what happens when the 5000 images are used? What does that do to the confidence intervals on the proportions. As the sampling gets...

  students_t

  Discussions |

  Feb 27, 2021 12:38 PM

  5163 views | 4 replies

• How is JMP STD error for means and STD error for Mean difference calculated? I wish validate the numbers I get in Excel with JMP

  How does JMP calculate the Std Error of means and Std Error of Diff in the LS means Table and LS Means Differences Student's t. I tried to replicate the results by STD error calculated from both Standard deviation of sample and population,but the values do not match. Please refer the document attached, I calculated the  STD errors from the values in 4 groups as well as theSTD error of the 4 means ...

  samjoshva

  Discussions |

  Feb 27, 2021 12:36 PM

  7249 views | 5 replies