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

  • Using For Loop to Create New Column

    Hi   I try to create the new column by using for loop     names default to here (1); dt = current data table (); summarize (PN=by (:Name("~DEVICE TYPE" ))); for (i=1, i <= N items(PN), i++, new column("Cnt "||PN[i], formula(If( :Name( "~DEVICE TYPE" ) == PN[i], If( :SERIAL_NO || :TIME_DATE == Lag( :SERIAL_NO || :TIME_DATE, -1 ),0,1) ))));     I can create the new column but cannot get the formula...

    yanee yanee
    Discussions |
    May 31, 2019 10:02 AM
    4510 views | 2 replies
  • Clustering result change everytime I contuct latent class analysis(LCA) on my text data

    Hi there, I used LCA of text explorer form to cluster my text data, but everytime I run it. it gives me different results. Anyone know why it happens? Also, what is the difference between these two clustering methods on text explorer platform, latent class analysis(LCA) and clustering documents in Latent semantic analysis?

    sigma_field sigma_field
    Discussions |
    May 31, 2019 7:40 AM
    8248 views | 8 replies
  • How do I visualize individual relationships in multiple regression

    Dear all I have put together a multiple regression model in JMP from fit model. I already visualized the relationships with fit y by x before beginning. My question is, how can I visualize the relationships between the response and the variables after the model has been output? I have tried prediction profiler, but I would like to see the relationships with all data points, so that I can fit lines...

    FISH1 FISH1
    Discussions |
    May 31, 2019 7:02 AM
    4475 views | 3 replies
  • Text to Columns result columns

    I'm using the built-in JSL Text to Columns() function. I won't know how many "segments" my input text has, so I won't know in advance how many new columns will result from calling the function. But I need to know this so I can do certain subsequent steps in my script. Back when this was an add-in, Jeff Perkinson's v3 returned a result that gave the names of the columns that had been created; the v...

    john_madden john_madden
    Discussions |
    May 30, 2019 12:14 PM
    8331 views | 3 replies
  • Text time to numeric time

    I am having an issue converting a text time format to a numeric time format. Data should be of the format MM:SS.0  (This is the format it was in excel). After the import into JMP I have a long string (i.e. 2.1713e-5) that I seem to be unable to do anything with. This time value represents a time duration that needs to be in the format of MM:SS.0  I have tried a few solutions but nothing quite seem...

    Sciguy_1 Sciguy_1
    Discussions |
    May 30, 2019 9:08 AM
    5965 views | 5 replies

Latest Discussions

  • Clustering result change everytime I contuct latent class analysis(LCA) on my text data

    Hi there, I used LCA of text explorer form to cluster my text data, but everytime I run it. it gives me different results. Anyone know why it happens? Also, what is the difference between these two clustering methods on text explorer platform, latent class analysis(LCA) and clustering documents in Latent semantic analysis?

    sigma_field sigma_field
    Discussions |
    May 31, 2019 7:40 AM
    8248 views | 8 replies
  • How do I visualize individual relationships in multiple regression

    Dear all I have put together a multiple regression model in JMP from fit model. I already visualized the relationships with fit y by x before beginning. My question is, how can I visualize the relationships between the response and the variables after the model has been output? I have tried prediction profiler, but I would like to see the relationships with all data points, so that I can fit lines...

    FISH1 FISH1
    Discussions |
    May 31, 2019 7:02 AM
    4475 views | 3 replies
  • How to combine two columns (with missing data)?

    got a table with missing data like this:Column1Column21••5•73• Need to combine it it to one column Column31573 I used sum but it didn't work. The only way I can do is using If and is Missing() formual. Any fast way to combine it? Thanks! 

    jasongao jasongao
    Discussions |
    May 29, 2019 9:53 PM
    2219 views | 1 replies
  • 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
    1946 views | 0 replies
  • How to calculate moving average of column with more than 10000 million entries in JMP 11?

    I am trying to run the below formula on a column with 100 million rows to calculate the moving average.Could you please suggest an JMP11 alternative for  Col Moving Average  Col Moving Average( :x, 1, 9999999, 0 ) is not supported by JMP11. Please find below the code I have tried: NamesDefaultToHere(1); // Use a function to open a .CSV file: Given the path to such a file, returns a reference to t...

    jojmp jojmp
    Discussions |
    May 29, 2019 3:48 AM
    3592 views | 5 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
    1946 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
    2210 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
    2884 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