JMP User Community

Latest Discussions

Times from Excel

Hey, when I pull in a time from excel I get a number like `-126167045`. So when I try to add it to date, it gives a very weird number.

I can get around this by turning it to a string and back into a number, but that seems weird. Anyone know what's going on and if there's a better way than

:Date + Num( Format( :Time, "h:m:s" ) )
vince_faller

Discussions |
Feb 19, 2024 11:11 AM

1820 views | 4 replies
JMP 16 Discreet Fit to Gamma Poisson to Kulmogrov

Hello All, Need assistance trying to get the goodness-of-fit test for the following parameters in JMP 16: 1. Discrete Fit2. Fit Negative Binomial (equivalent to Gamma Poisson as no option to choose gamma poisson)3. Goodness-of-fit4. output -> Pearson Chi-square -> no values From past version of JMP 14, there was a gamma poisson option with a goodness-of-fit option that outputted kolmogorov's D va...
RichC

Discussions |
Feb 19, 2024 10:19 AM

429 views | 0 replies
How do I get a list of all combinations that can give greater than a threshold of the response in JMP DoE RSM model

This may sound like a basic question. I am a fairly new user. I had designed a RSM model with four factors A,B, C, and D. After conducting the experiments and loading the results, the model suggests, all three factors are significant and that the interaction factor between A and D is also significant- with positive correlation. The interaction between factors B and C is a significant factor but h...
Do_AuLu

Discussions |
Feb 19, 2024 7:41 AM

935 views | 2 replies
Delete formula status without deleting values

Hello,I have a for loop for calling formulas from a file.The loop works fine but when I try removing the formula and maintaining the created values using<<delete formulaor<<delete property(formula); the formula is removed but the values are all gone as well.This happens for both JMP 11 and 14.can you please help? loop: formula_table = Open( formula table adress, Worksheets( "Formulas" ), Invisible...
vsr

Discussions |
Feb 19, 2024 6:41 AM

3271 views | 8 replies
Multiple Graph-builders and cross-selection

Hey,
i have a fairly large data table similar to this format: from which we create a set of graph builders to be to visualize different assay types and assays next to each other, sort of like this (one assay type to the right with assays as pages and batches as overlay, and then the other assay type on the right but the same setup): We'd like to select the batches in one graph and have then highlig...
DSA

Discussions |
Feb 19, 2024 5:49 AM

980 views | 2 replies

Previous
Next

Latest Discussions

Times from Excel

Hey, when I pull in a time from excel I get a number like `-126167045`. So when I try to add it to date, it gives a very weird number.

I can get around this by turning it to a string and back into a number, but that seems weird. Anyone know what's going on and if there's a better way than

:Date + Num( Format( :Time, "h:m:s" ) )
vince_faller

Discussions |
Feb 19, 2024 11:11 AM

1820 views | 4 replies
JMP 16 Discreet Fit to Gamma Poisson to Kulmogrov

Hello All, Need assistance trying to get the goodness-of-fit test for the following parameters in JMP 16: 1. Discrete Fit2. Fit Negative Binomial (equivalent to Gamma Poisson as no option to choose gamma poisson)3. Goodness-of-fit4. output -> Pearson Chi-square -> no values From past version of JMP 14, there was a gamma poisson option with a goodness-of-fit option that outputted kolmogorov's D va...
RichC

Discussions |
Feb 19, 2024 10:19 AM

429 views | 0 replies
How do I get a list of all combinations that can give greater than a threshold of the response in JMP DoE RSM model

This may sound like a basic question. I am a fairly new user. I had designed a RSM model with four factors A,B, C, and D. After conducting the experiments and loading the results, the model suggests, all three factors are significant and that the interaction factor between A and D is also significant- with positive correlation. The interaction between factors B and C is a significant factor but h...
Do_AuLu

Discussions |
Feb 19, 2024 7:41 AM

935 views | 2 replies
Delete formula status without deleting values

Hello,I have a for loop for calling formulas from a file.The loop works fine but when I try removing the formula and maintaining the created values using<<delete formulaor<<delete property(formula); the formula is removed but the values are all gone as well.This happens for both JMP 11 and 14.can you please help? loop: formula_table = Open( formula table adress, Worksheets( "Formulas" ), Invisible...
vsr

Discussions |
Feb 19, 2024 6:41 AM

3271 views | 8 replies
How to select points in a graph which are associated with two or three factors?

Hi pals, I want to choose the points which are associated with two factors.How can I select them as below graph marked in rectangle region?Furthermore, if they are associated with three factors, how can I select them?In below graph, how to "slice" as black rectangle, so I can select the points in blue circle?
Media-Taker-101

Discussions |
Feb 19, 2024 1:03 AM

835 views | 2 replies

Previous
Next

Latest Discussions

JMP 16 Discreet Fit to Gamma Poisson to Kulmogrov

Hello All, Need assistance trying to get the goodness-of-fit test for the following parameters in JMP 16: 1. Discrete Fit2. Fit Negative Binomial (equivalent to Gamma Poisson as no option to choose gamma poisson)3. Goodness-of-fit4. output -> Pearson Chi-square -> no values From past version of JMP 14, there was a gamma poisson option with a goodness-of-fit option that outputted kolmogorov's D va...
RichC

Discussions |
Feb 19, 2024 10:19 AM

429 views | 0 replies
Visualizing 2-way clustering

Hello - I have a table of 180 factors. I have used the 2-way clustering to visualize the grouping in the dendrogram, which works really well for a few factors. Close to 200? Not so much, especially in a paper. In my mind, I have basically the K-means type plot of all of the factors clumped and colored. But this doesn't make sense for factors. Is there a way that to plot the clustering on a 2-D plo...
ehchandlerjr

Discussions |
Feb 15, 2024 2:53 PM

435 views | 0 replies
Help with JMP formula (IFERROR)

My excel formula is: =+IF(AND(E98=1, E108=1), IFERROR(E121-E$128, "NA"), "NA"). E98 = 1. E108 = 1. E121 is a calculation that came out to .267993337. E128 is a calculation that came out to -0.2792984. How can I re-create that formula in JMP? I'm trying with no success.
UpliftElk866

Discussions |
Feb 13, 2024 12:19 PM

464 views | 0 replies
Scheduled job failed

Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?
shaiv90

Discussions |
Feb 11, 2024 11:09 PM

512 views | 0 replies
PickFile(), Projects and Network Drives

Did you notice that PickFile looks different when it's opened from within a project? More than that - when Pick File is opened from a project, with mydir pointing to a network drive with thousands of files, Jmp will freeze for dozens of seconds:mydir= "\\computername\directory"; Pickfile("select a file" , mydir) So, if you work in a project, to prevent Jmp from freezing, please be sure that your i...
hogi

Discussions |
Feb 9, 2024 3:07 PM

523 views | 0 replies