cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • Shelf life prediction

    Hey everyone, There is any way to estimate the shelf life of a pharmaceutical product based on historical data of other batches by giving only one result? The goal is to predict, based on the primary result, if a product will survive until its expiry date. Thanks in advance. 

    LimVitamed LimVitamed
    Discussions |
    Jun 7, 2019 12:16 PM
    6469 views | 5 replies
  • How to write multiple 'Contains' in SQL query

    Hello everybody.  Let's say I have an array with strings that are values of rows that I need to pull from DB. Let's say the array is:searchStringArray = {'qwe', 'rty', 'asd',' fgh', 'zxc'}I can construct my WHERE statement in my query in a pretty simple way:"WHERE t1.column1 IN (' " || Concat Items(searchStringsArray, " ', ' ")|| " ' )"which when parsed would give me the following string:"WHERE t...

    miguello miguello
    Discussions |
    Jun 7, 2019 10:29 AM
    21725 views | 4 replies
  • Change Values in a Column to UpperCase

     Question: I have a data table with data values in upper and lower case text strings in one column.I expect that the code will need to loop through each row, select the column of interest and set the value in the column to uppercase. I am having an issue figuring out the correct syntax to do this. This is what I have so far, but don't think I am close enough. Thanks to any help that can be provide...

    JensRiege JensRiege
    Discussions |
    Jun 7, 2019 10:11 AM
    10887 views | 6 replies
  • Questions on Survey Analysis

    Hi All, I am working on the survey data in JMP (Analyze --> Consumer Research --> Categorical) and i wanted to get your advise on the below 1. How to hide rows/columns in the survey output table ?
    2. Is it possible combine two variables ? If yes, how can i do it  ? 
    3. In the survey output table, if i have a supercategory in the 'Top' variable , it doesnt show up in the 'survey output table'. How ca...

    Ravi814 Ravi814
    Discussions |
    Jun 6, 2019 8:23 PM
    3523 views | 3 replies
  • Multiplying multiple columns one by one

    I have 20 columns of data.  I need to multiply each column with all of the other columns - one by one.  For example, column 2 * column 3; column 2 * column 4; column 2 * column 5...column 3* column 4, column 3 * column 5...Is there an easy way to do this with JMP? Thanks for your help, Jess

    Jess Jess
    Discussions |
    Jun 6, 2019 10:56 AM
    3710 views | 2 replies

Latest Discussions

  • Shelf life prediction

    Hey everyone, There is any way to estimate the shelf life of a pharmaceutical product based on historical data of other batches by giving only one result? The goal is to predict, based on the primary result, if a product will survive until its expiry date. Thanks in advance. 

    LimVitamed LimVitamed
    Discussions |
    Jun 7, 2019 12:16 PM
    6469 views | 5 replies
  • Questions on Survey Analysis

    Hi All, I am working on the survey data in JMP (Analyze --> Consumer Research --> Categorical) and i wanted to get your advise on the below 1. How to hide rows/columns in the survey output table ?
    2. Is it possible combine two variables ? If yes, how can i do it  ? 
    3. In the survey output table, if i have a supercategory in the 'Top' variable , it doesnt show up in the 'survey output table'. How ca...

    Ravi814 Ravi814
    Discussions |
    Jun 6, 2019 8:23 PM
    3523 views | 3 replies
  • Multiplying multiple columns one by one

    I have 20 columns of data.  I need to multiply each column with all of the other columns - one by one.  For example, column 2 * column 3; column 2 * column 4; column 2 * column 5...column 3* column 4, column 3 * column 5...Is there an easy way to do this with JMP? Thanks for your help, Jess

    Jess Jess
    Discussions |
    Jun 6, 2019 10:56 AM
    3710 views | 2 replies
  • Windows10: Have to press ALT key twice to access file menu with keyboard, and keyboard commands generally slow to respond

    I am using JMP 14.0.0 64-bit on Windows10.Keyboard commands are all slower to respond than I expect (for instance CTRL+W to close the Column Info window takes ~1 second), and to get the file commands activated I have to type the ALT key twice when I switch to a window for the first time.  For instance, if I ALT+TAB to Excel, then ALT+TAB back to JMP, and press ALT, nothing happens.  If I press ALT...

    JT383 JT383
    Discussions |
    Jun 5, 2019 9:56 AM
    2869 views | 3 replies
  • Updating data from one jmp table to another jmp table

    Hi All,i have written a script where , i will be creating several columns in  JMP table (Say table-1) based on some  calculation. Now i want to populate few selected Row and columns of Table-1 to another JMP table (say table-2). I need help in populating the second table with selected Rows and coloumns. Kindly suggest. Regards,Dilip

    dilipkumar dilipkumar
    Discussions |
    Jun 4, 2019 4:28 AM
    2427 views | 1 replies

Latest Discussions

  • Help understanding how Lift curves are calculated

    Dear JMPers,   (computer details: I have JMP Pro 14 on a W7 Enterprise, 64-bit computer.)   I am trying to better understand how JMP actually calculates a Lift curve. I understand conceptually the ROC and Lift curves, but I'm having a hard time calculating a Lift curve myself. The JMP help/support page (https://www.jmp.com/support/help/14-2/lift-curve.shtml#1276958) isn't all that helpful in under...

    SDF1 SDF1
    Discussions |
    May 29, 2019 11:10 AM
    1945 views | 0 replies
  • How to analyze PSM data(Propensity Score Matching) in JMP?

    How to analyze PSM data(Propensity Score Matching) in JMP?If it is yes, please tell me what detail steps in JMP manu,If there is any available examples in JMP sample data?

    mujahida mujahida
    Discussions |
    May 7, 2019 9:30 PM
    2209 views | 0 replies
  • Chi square or Cochran's Q test

    Okay, so i have to decide whether i should use chi-square or Cochran's Q test for one of my study.If i assume meat as experimental unit (EU) and impose 6 different wood smoke (like apple smoke, cedar smoke, hickory smoke etc.) on EU and consumers (people) act as observational unit (OU). I have 10 consumers and each one will taste each treatment (6 treatments) and respond liking (9 point scale), an...

    sharmachetan sharmachetan
    Discussions |
    Apr 16, 2019 3:54 PM
    2837 views | 0 replies
  • Selecting Number of Clusters in Hierarchical Clustering

    One way to select possible number of clusters in hierarchical methods is to identify the relatively large changes in distance as number of clusters change (see table below). When I look at the actual distance measure from the table (clustering history below dendogram), there is a bigger jump from 3 clusters to 4 than from 4 to 5 (smaller), suggesting 4 may be the right decision. However, when you ...

    pratyushdash pratyushdash
    Discussions |
    Feb 23, 2019 5:51 PM
    2883 views | 0 replies
  • Beta Generalized Regression and adjusted chi-square values

    I have a data set from a two-choice rodent feeding trial. We were testing the effectiveness of 10 deterrents by coating them on seeds and offering them to rodents alongside control seeds that were uncoated. The explanatory variable is which of the 10 deterrents the treatment seed was coated with, and the response variable is the proportion of control seed and treatment seed consumed.  The question...

    Mananahi Mananahi
    Discussions |
    Feb 13, 2019 9:58 AM
    2227 views | 0 replies
view all discussions