JMP User Community

Latest Discussions

Renaming cells

Hello, I'm trying to renaming specific cells after a filter was applied in in a different column. Here is the script that I came up with: dt = Current Data Table(); df = dt << Data Filter( Add Filter( Columns( :"Sample/Control" ), Where( :"Sample/Control" == "Sample" ) ), ); dt << Go To ( :"Control ID"); I'm only missing the last step, which is to rename the specific cells that are selected. I c...
moti617

Discussions |
Sep 4, 2018 11:42 AM

6687 views | 4 replies
How can I write a good condition if else if in JMP

Hello I have several columns with data and I want to add another col which will get a formula like this:A B C2 53 45 54 7C column will get an if else formula for example: If(A&B==4 then C ==Good) else if(A&B==3 then C ==bad) else if(A&B==1 then C ==Good)How can I write this in a formula ?
axcelenator1

Discussions |
Sep 4, 2018 6:07 AM

30020 views | 2 replies
Matching comparison of two samples doesn't make sense

I ran a matching comparison between two sets of measurements (Platform: Fit Y by X) using Sample ID as matching variable and Treatment as grouping variable. Obviously, the objective is to see if Treatment has an effect on the dependent variable. Results show that Treatment is significant (p = 0.03) whereas the mean diamonds and common sense indicate it is not. Omiting the non-matching observati...
kanenas

Discussions |
Sep 3, 2018 3:12 AM

7600 views | 3 replies
QQ-Plot double x-axis

Dear Community, Please help, how do I change the ugly default QQ-Plot in jmp so that it does not have two x-axis and a histgoram but only a normal x- and y-axis?
juliaaline

Discussions |
Sep 1, 2018 3:43 AM

11706 views | 13 replies
Query Builder for Oracle database slow unless use Custom SQL() argument in New SQL Query() function

Hi JMP users. When using the JMP Query Builder, we have fast response for SQL servers using "ODBC Driver 11 for SQL Server", but slow response on some Oracle servers using "Oracle in OraClient11g", on the order of 2 to 3 minutes. We discovered by accident that it works just fine using the Custom SQL() argument in the New SQL Query() function in the script, instead of using the generated script fro...
Vball247

Discussions |
Aug 31, 2018 1:22 PM

4530 views | 3 replies

Previous
Next

Latest Discussions

QQ-Plot double x-axis

Dear Community, Please help, how do I change the ugly default QQ-Plot in jmp so that it does not have two x-axis and a histgoram but only a normal x- and y-axis?
juliaaline

Discussions |
Sep 1, 2018 3:43 AM

11706 views | 13 replies
Query Builder for Oracle database slow unless use Custom SQL() argument in New SQL Query() function

Hi JMP users. When using the JMP Query Builder, we have fast response for SQL servers using "ODBC Driver 11 for SQL Server", but slow response on some Oracle servers using "Oracle in OraClient11g", on the order of 2 to 3 minutes. We discovered by accident that it works just fine using the Custom SQL() argument in the New SQL Query() function in the script, instead of using the generated script fro...
Vball247

Discussions |
Aug 31, 2018 1:22 PM

4530 views | 3 replies
Duplicate a column

Hello, I'm relatively new to scirpting..I'm interested in simply duplicate a column within the existing table. I would the duplicated column to be last and have a different name. After that, I would like to annonymize the original column. Thanks
moti617

Discussions |
Aug 31, 2018 12:02 PM

7781 views | 4 replies
Does JMP automatically calculate ranks in Steel-Dwass

Hi The study: I am to analyze a non-parametric dataset where two types of twine were cultered in the same tank to test preference in settlement of algal spores. Three levels of agitation was tested. Using 3 replicates of the twine (2) and agitation (3) results in 6 combinations or datasets. They were cultered in 9 experimental units and 2*9 pieces of twine was used. Can I use the Steel-Dwass to ...
PeterSchmedes

Discussions |
Aug 31, 2018 8:11 AM

4989 views | 7 replies
Determine if time is between certain hours

Casual jmp 12 userHow do I have jmp determine if a time is between certain hours on any day?I want to create a column to show (Y/N) if the time when data was taken is between 12:00 AM and 7:00 AM. So the below data points would be Yes then No.Data taken at random times and transferred into jmp as shown in the examples below. Data (Example) Between 12 and 7? (Desired result)11/11/2017 ...
Elby

Discussions |
Aug 29, 2018 12:11 PM

4650 views | 1 replies

Previous
Next

Latest Discussions

repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3435 views | 0 replies
Time Series - Prewhiten

Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
nopon649

Discussions |
Jun 7, 2018 11:10 PM

2470 views | 0 replies
Fit Spline By Group: Save Spline Coefficients to Column?

Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
M0gAl0g

Discussions |
Jun 5, 2018 3:19 PM

3028 views | 0 replies
Why does Profiler not stop

All,
I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this. I am using JMP 13.
uday_guntupalli

Discussions |
Apr 27, 2018 7:12 AM

1850 views | 0 replies
P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

3995 views | 0 replies