Welcome to the JMP User Community!

Latest Discussions

• Actual by predicted plot confidence region

  Here is a simple linear regression with just one independent variable x. The predicted y (Save Columns -> Pred Formula) as well as upper and lower 95% confidence values (Save Columns -> Mean Confidence Limit Formula) are shown too. Have a look at the second data point:
  
   The upper and lower confidence values match with the plot (16.99 and 12.30 on the y axis are very close to the calculated values i...

  OmegaHard

  Discussions |

  Oct 21, 2024 3:37 AM

  4968 views | 7 replies

• Multiple file import Excel hidden row

  Hello, I am using JMP 18 and I need to import multiple excel files.
  As different users applied different filters I add this command to import even filtered rows from all excel files. 
  <<Set Excel Suppress Hidden Rows( 1 ), However the filtered data are not imported. Is there a difference on how JMP or excel handle hidden vs filtered rows? Is there another command I should use? Many thanks for your h...

  mgerusdurand

  Discussions |

  Oct 21, 2024 12:15 AM

  2596 views | 6 replies

• List of Strings

  To create a matrix of N identical numbers, I can use J(N, 1, number).What is the shortest (syntax) and fastest way to create a list of N identical strings?

  hogi

  Discussions |

  Oct 20, 2024 11:44 PM

  1549 views | 7 replies

• JSL - Check box to select variable to then plot in graph builder

  Hi everyone, I am trying to make a script which would work this way:1. Opens a new window showing "Select the parameters you want to plot" with a list of parameters with check box for each, and the operator would chose which ones he wants to plot by ticking them.2. Then for the ones that are ticked, open a graph builder with the corresponding variables. I am currently able to make the first step (...

  Elofar

  Discussions |

  Oct 20, 2024 5:15 PM

  9462 views | 15 replies

• Update a table with another table based on "Nearest Match" columns

  Hello, I have 2 tables (Table1 and Table2), both queried from databases.I need to update Table1 with Table2 by matching columns (:match). The problem is: - I get :match content for Table1 with a Regex from the database with (sometimes) this format: “XXXX-YY-ZZZ”.- I get :match content for Table2 from another database with a different but consistent format: “XXXXYYZZZ”. I can manually use If() and ...

  Voizingu

  Discussions |

  Oct 20, 2024 12:30 PM

  1672 views | 6 replies