JMP User Community

Latest Discussions

Converting numeric seconds to 0:00.0 time format

I cannot seem to find a simple way to accomplish this in jmp. I have tried to include a snapshot of what I am doing but does not want to load. Say that I have a numeric value of 0.000021713. In time format this should be 0:01.9 When I apply the m/s format with 1 decimal to the numeric value, jmp returns 0:00.0 This is not difficult to replicate, my colleagues see the same issue. Not sure if I a...
Sciguy_1

Discussions |
Jun 2, 2019 4:31 PM

8614 views | 7 replies
Linking JSL scripts to Buttons in JMP Application

Hi, I am Building a JMP application to read in an Excel workbook, for each sheet data in workbook, I have JSL to generate a graph, I also have a JSL to load XLSX to datatables in JMP. I want to link the JSL scripts to the application builder elements like buttons, could you please help me in understanding where to like the JSL script to button on click functionality? Eg:In the above picture, click...
dileepkr

Discussions |
May 31, 2019 2:06 PM

6480 views | 4 replies
To fill areas based on the value of the Y variable

Hi ,Could JMP do the graph like this?I need to fill the areas above certain values on Y axis
EricTsai

Discussions |
May 31, 2019 1:24 PM

7958 views | 4 replies
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

Discussions |
May 31, 2019 10:02 AM

4515 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

Discussions |
May 31, 2019 7:40 AM

8251 views | 8 replies

Previous
Next

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

Discussions |
May 31, 2019 7:40 AM

8251 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

Discussions |
May 31, 2019 7:02 AM

4482 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

Discussions |
May 29, 2019 9:53 PM

2222 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

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

Discussions |
May 29, 2019 3:48 AM

3594 views | 5 replies

Previous
Next

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

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

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

Discussions |
Apr 16, 2019 3:54 PM

2841 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

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

Discussions |
Feb 13, 2019 9:58 AM

2228 views | 0 replies