Welcome to the JMP User Community!

Latest Discussions

• Partial Least Squares

  Hello all, I am trying to perform a multivariate partial least squares on my dataset in JMP. This dataset consists of 10 rows and 59740 columns (FT-IR data, which has many thousands of "discrete" measurements to create a continuous curve). I get the following error when I try to run the PLS, setting 59738 columns to the X factors and two columns to the Y response. This dataset is structured in the...

  bi0

  Discussions |

  Mar 20, 2020 9:14 AM

  5846 views | 7 replies

• Generating ordinal data

  Hello!Does anyone know how I can generate ordinal data in JMP to simulate a sample?I mean I need to simulate a sample including ordinal measurements by generating synthetic ordinal  data. Thank you in advance for your help. 

  Fatemeh_2020

  Discussions |

  Mar 19, 2020 6:47 AM

  4619 views | 5 replies

• Import hidden Excel worksheet

  How can I import data from a hidden Excel worksheet? If I use Open() with the option Worksheets("TechnicalData"), then it fails as long as the worksheet "TechnicalData" is hidden in my Excel file. As soon as I unhide the worksheet in Excel, the import works again. (Note: Why do I want to import a hidden worksheet? Because I need to import data from a "user friendly" excel sheet, which is not actua...

  JWi

  Discussions |

  Mar 17, 2020 12:15 PM

  2246 views | 1 replies

• JMP script - Color or Mark by Column

  I have a JMP table with a column called Order that contains letter values like A, B, C, D, E, etc., and another column called Number that contains number values like 1, 2, 3, 4, etc.  Manually operating on this table, I could do the following:-- Right click at the upper left of the table and select Color or Mark by Column-- Select Order from the list of columns, then leave Colors = JMP Default and...

  fbm73

  Discussions |

  Mar 15, 2020 4:16 PM

  2692 views | 1 replies

• how to find and replace all instances of specified characters within a given column

  This is a very simple question.  I have a given column in a JMP table, and I want a JMP scripting command that will find and replace all instances of specified characters within that column.  For example, I have a column called GROUP, and certain rows in GROUP contain values like "A05 or "B17 and I would like to replace all " characters in GROUP so that the entries become A05 and B17 instead of "A...

  fbm73

  Discussions |

  Mar 15, 2020 5:37 AM

  8738 views | 4 replies