JMP User Community

Latest Discussions

AND/OR statements in Formula Editor

Hi All, I was hoping someone could help me with a formula containing AND/OR statements. I have written a formula in "Column 5" based on the results of 3 other columns: Run F, Run M, and Run S. The portions of the formula that only contain IF/THEN statements produce the desired results. However, the portions of the formula that also contain AND/OR statements do not work (non-working portions of ...
EH1

Discussions |
Jul 12, 2021 7:43 AM

7751 views | 2 replies
Adjusting Time Stamp For Ten Experimental Replicates

Our data has ten replicates (repeats, to be more accurate). The desired data lies between vehicle speeds of 35 and 70 mph. For each of the ten replicates, a column labeled "time" exists, and that time indication varies a little, due to experimental procedure variation. I would like to create a calculated column, using JMP commands, not scripts, for "adjusted time." In this column, the value woul...
Victor60

Discussions |
Jul 12, 2021 7:04 AM

863 views | 1 replies
Upload Spec Limits to columns by matching DeviceID

Hello, I am looking to add USL and LSL lines to many of the graphs I have created in JMP. I think the easiest way to do this would be adding spec limits to my table. I have a SpecLimit table for the parameters I am interested in - but the specs change for each DeviceID and the table contains all of the specs for multiple DeviceIDs. Is there anyway to upload Spec Limits to my columns by matching De...
saneal

Discussions |
Jul 12, 2021 6:58 AM

1587 views | 2 replies
Use column name as a value for X axis

Hi,can I use a value in column name as an X value to fit Y by X?I have 10 columns with multiple rows, and for all rows the X is the same (i.e. the value in the column name).Thanks.
ruskicar

Discussions |
Jul 12, 2021 6:30 AM

2838 views | 4 replies
One sided confidence interval in stability plots

Working on stability of pharmaceuticals, I was wondering whether the stability script (Analyze -> Reliability and Survival -> Degradation -> Stability Test) allows estimation of shelf life based on a one sided confidence interval. The default script, as it is set up now, is exclusively based on the intersection between a user defined acceptance limit and the two-sided 95% confidence interval. Howe...
Ressel

Discussions |
Jul 11, 2021 11:34 AM

11728 views | 12 replies

Previous
Next

Latest Discussions

Adjusting Time Stamp For Ten Experimental Replicates

Our data has ten replicates (repeats, to be more accurate). The desired data lies between vehicle speeds of 35 and 70 mph. For each of the ten replicates, a column labeled "time" exists, and that time indication varies a little, due to experimental procedure variation. I would like to create a calculated column, using JMP commands, not scripts, for "adjusted time." In this column, the value woul...
Victor60

Discussions |
Jul 12, 2021 7:04 AM

863 views | 1 replies
Use column name as a value for X axis

Hi,can I use a value in column name as an X value to fit Y by X?I have 10 columns with multiple rows, and for all rows the X is the same (i.e. the value in the column name).Thanks.
ruskicar

Discussions |
Jul 12, 2021 6:30 AM

2838 views | 4 replies
Column concatenation only takes some column entries

I have a sample file taken from a Covid report on reopening file dining that was originally presented as a two column journal article. The PDF tool brought in the file as illustrated in columns 3 and 5 of "To-dineornot_test.jmp." The script was copied from an exchange in the Community. I changed the names of the columns. In the file "Column D" is the result of the script. I find that the conca...
LNitz

Discussions |
Jul 10, 2021 4:45 PM

862 views | 1 replies
Variables not being passed between scripts

Hi, I am using a script from the following post to try and expand on the heatmap that is created from the script. The script in its current form does a heatmap for all of the columns together but I would like a separate heatmap PER column. In other words I would like to find the min, mid and max for a certain column then apply a heat map only on that column then do the same thing for the next colu...
tarkan_bih

Discussions |
Jul 9, 2021 4:33 PM

2491 views | 5 replies
How do I write a script to recode to remove partial text?

I am trying to write a script that converts any occurrence where a number is within the text "saturated ()", to remove the saturated (), leaving only the number. I thought I could edit a recode script, but had no success. Thank you in advance. Names Default To Here( 1 ); dt = Data Table( "Book1_Sheet1" ); dt << Begin Data Update; dt << Recode Column( dt:Area, {Map Value( _rcOri...
KRT

Discussions |
Jul 9, 2021 1:58 PM

1117 views | 2 replies

Previous
Next

Latest Discussions

Obtaining a p-value for an odds ratio of a continuous variable

Hi all,When performing an odds ration analysis on a nominal variable I get a p-value which is identical to the p-value of the parameter estimate (see pic below). When performing the same on a continues variable there is no p-value (see pic below). Could I use the p-value of the parameter estimate as the p-value of the odds ratio?If not how could I obtain the p-value in JMP?TIA
eliyahu100

Discussions |
Jul 7, 2021 10:27 AM

1491 views | 0 replies
How do I get Odds Ratios after fitting a GLM with binomial distribution and logit function?

Hi everyone,I need to get OR after fitting a GLM with binomial distribution and logit function - that is a logistic model. I cannot fit a "nominal logistic" where there's the option for OR because I need to use the Firth adjustment for small-sample bias (I can only do that for that GLM). Is there an option to get the Odds Ratios? Thank you in advance. Antony
Antony

Discussions |
Jul 7, 2021 10:04 AM

880 views | 0 replies
Solving for new FPCs using a training set

Had a question on the Functional Data Explorer system. Feels like a dumb question but can't figure it out. So I set up a training set and developed FPCs I like. The next step is then to use that spline structure to solve the FPCs for new items as they come in. What steps would I take to do that?
Evan_Morris

Discussions |
Jul 6, 2021 11:08 AM

707 views | 0 replies
Section 508 compliance

Is there any guidance on how to make JMP graphs section 508 compliant (ADA issue for government documents)? I found a post on how to remove the gray background, but is there any 508 specific guidance or other preference settings that would be helpful? Maybe this is a wish list item?
GGfGA

Discussions |
Jun 30, 2021 10:03 AM

875 views | 0 replies
Multi File Import of network folder slower in latest JMP version

Hello, In JMP 14, Multi File Import of a network folder was relatively fast. For example, it takes ~11 seconds to load the below folder. With JMP 16 on the same computer/folder/network, it will first spend almost 3 minutes while "discovering files", before proceeding with the above "loading file names" step. Are there any settings or options that I could change to skip the "discovering files" step...
jach

Discussions |
Jun 22, 2021 11:06 AM

729 views | 0 replies