JMP User Community

Latest Discussions

Subtraction in Column Formula Slow

Hello!If I use analyze>tabulate>mean, then jmp 14 can take my 3 million rows and get a summary in about 15 seconds. If I try to subtract column A from column B using a column formula, it takes 3+ hours. How can I do a workaround to increase calculation speed? some sort of JSL? I could just pull it into python but jmp should be able to handle subtraction! Thanks for your help!
Ifrit109

Discussions |
Oct 4, 2023 2:11 PM

2301 views | 5 replies
Column formula: How to correctly combine character columns that have missing entries?

Hi All, Not sure why I'm having a hard time getting the correct solution to this, but I'm having a hard time combining columns of text when each column has missing entries that are not on the same row -- but all rows are aligned. See the screenshot below. For example, if a row has an entry A or B or C, then if it's within a column, say :C1 or :C2, then the row is the same for both columns. For ...
SDF1

Discussions |
Oct 4, 2023 1:14 PM

2222 views | 4 replies
Significance of factors in Definitive Screening Design

Dear JMP ommunity,

I have conduced a 37-run Definitive Screening Design for 15 factors to find the dominating ones. I have set the p-value as 0.05 and in the documentation it says that a factor will be shown as "active" if the p-value is lower than the defined threshold (i.e., 0.05). However, in some cases, when I fit the definitive screening design, there are factors with p-value of higher than 0....
Ahmedhadi

Discussions |
Oct 4, 2023 11:09 AM

2460 views | 4 replies
Understanding/organizing user-defined functions

Hi folks,

I'm looking for examples and references to look at in the manuals as appropriate.

I'm a longtime JMP user but have marginal experience with JSL. I'm writing a script to automate the extraction and compilation of a bunch of legacy data. I am having reasonable luck with the mechanics of each step, but my code is becoming a long series of *stuff* and I need to modularize it by writing functio...
ScottMullin

Discussions |
Oct 4, 2023 10:56 AM

2627 views | 3 replies
distribution of response variable

Hello: I ran a DOE study of 5 factors.It was a manufacturing process study and I measured the output which is the response variable.for the identification of the significant factors and later forming a regression equation do we have to have the response variable following a normal distribution? For my response variable for Normal distribution, AD is 0.886 and p-value is 0.18. Should I go ahead wit...
VarunK

Discussions |
Oct 4, 2023 7:40 AM

4346 views | 7 replies

Previous
Next

Latest Discussions

Search specific name by IF

HelloI have set up a New Column "Pin Name"and would like to add a number of PINIt means if you contain gp_0 in the column "Test Name" it should be GP_0or if you have contains gp_1 in test name it should be GP_1 in Column "Pin Name"or if you have contains gp_11 in test name it should be GP_11 in Column "Pin Name"I wrote the scriptColumn(dt,"PIN_NAME") << Formula ( If ( Contains( :TEST_NAME, "gp_0" ...
Dennisbur

Discussions |
Oct 4, 2023 6:58 AM

937 views | 2 replies
Testing Parallelism: F-test vs. Chi-square vs. SRA in Potency Assays

Hello All, I'm assessing different approaches for testing parallelism of 4PL fits in a potency assay. I know some of the limitations/tradeoffs of the F-test/chi-square approaches. One of our vendors is also using the Slope Ratio method for their testing. Does anyone have thoughts about pros/cons of this approach and where it's appropriate to use? Finally - has anyone implemented this in JMP? T...
ClusterFerret68

Discussions |
Oct 4, 2023 2:00 AM

2409 views | 4 replies
How to draw heatmap to visualize main effect and quadratic effect found in definitive screening design

Hi JMP community, I am using DSD to find the main effect as well as quadratic effect among my factors. Specifically, my responses are multiple numerical parameters, and my factor inputs include both numerical and categorial values. Now, I have run the experiments and feed into the model. Because I am interested in the effects of all these factors to my multiple responses simultaneously, I am using...
Elsie24

Discussions |
Oct 3, 2023 10:35 AM

7367 views | 5 replies
Using Permanova in JMP

Hi,I'm trying to run a PERMANOVA in JMP instead of Qiime to look at the differences in community composition among different microbial samples based on different factors. I'd also love to learn to build PCoa plots in JMP if possible, but this is secondary.Thank you!
gabrielamaiz

Discussions |
Oct 2, 2023 6:57 PM

15387 views | 8 replies
Box and whisker plot in JMP17 outlier question

With this box and whisker pot, the number of red dots represent what? qty of outliers?
The left is a box and whisker plot of the right graph distribution.
ChesterKnurek

Discussions |
Oct 2, 2023 5:55 PM

952 views | 1 replies

Previous
Next

Latest Discussions

Strange behavior using GenReg and Forward Selection

Hi All, I'm hoping someone might be able to help me to understand what is causing some strange behavior when I use GenReg and the Forward Selection Estimation Method. So, I have some data that I'm running through GenReg with Forward Selection, where I have several model effects and a validation column as well. After performing the fit, I want to run some simulations on the Estimate column of t...
SDF1

Discussions |
Oct 2, 2023 9:06 AM

618 views | 0 replies
SIMCA classification method: what alternative options do I have in JMP and what are the pros/cons?

Hello, I am after a combination of guidance and education. I have recently come across SIMCA as a classification approach. I believe this is not something JMP can address at the moment so my question is, which alternative options can I explore to achieve a similar goal and what would be the advantages/disadvantages when compared to the SIMCA method? I am currently using JMP 17 Thank you very much...
CamillaLiscio

Discussions |
Oct 2, 2023 5:55 AM

1124 views | 0 replies
What determines which data table is seen as "Associated Data" for New Window?

What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)? This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...
jthi

Discussions |
Sep 21, 2023 9:44 AM

733 views | 0 replies
Using R - File path problem

I have difficult to get the filepath correct.
Error message says "Cannot open table in access or evaluation of ....(Filepath)"
Prometheus

Discussions |
Sep 17, 2023 10:46 PM

848 views | 0 replies
Data Access Handler

How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties. But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...
hogi

Discussions |
Sep 16, 2023 12:21 AM

560 views | 0 replies