JMP User Community

Latest Discussions

Open Excel File in Excel (Windows standard application) by JSL

Dear all,my JMP should host a toolbox with also Excel and other files,so I need to open a file by another application from my Windows system (JMP Pro 15.1, Win10).Most preferably I would use that standard application that is used by windows explorer, when opening a file. The example below opens the xls in JMP, I would like to open it in Excel, does anyone know how to accomplish that?Thanks in adva...
Georg

Discussions |
Feb 19, 2024 11:19 AM

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

2535 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

567 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

1313 views | 2 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

1345 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

2535 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

567 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

1313 views | 2 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

1215 views | 2 replies
Are there ways to have different, overlapping groups of columns?

Hello - Are there ways to have multiple overlapping groups of columns? Right now, the best I can come up with is a script at the top right to select predefined columns, which is servicable until you have a bunch of scripts in addition to your grouping scripts, so if there's another way to do this, it would be nice.

Thanks!
ehchandlerjr

Discussions |
Feb 17, 2024 10:00 AM

1139 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

567 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

583 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

681 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

707 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

761 views | 0 replies