JMP User Community

Latest Discussions

Col (Sum) function by selecting specific rows

Hello,I would like to create a column which calculates another columns mean or sum but I would like to specify the function by :Let’s say if we select the year the calculation to be occured by "Year" or, Let’s say col (sum) of NetRevenueWithoutVat by Year or "NetRevenueWithoutVat" by "Month (Stay Date)" orCol (Sum) functions of specific row numbers...Would anyone please share his/her knowledge how...
saitcopuroglu

Discussions |
Sep 7, 2018 3:10 PM

34203 views | 16 replies
Test if data table is locked

I know that I can lock and unlock a data table through the Lock Data Table() command, but how do I test if a data table is locked? A table locked through Lock Data Table() returns Empty() when using the Get Edit Lock() function. //:*/dt<<Lock Data Table(1);
/*:Scriptable[]
//:*/
dt << Get Edit Lock();
/*:Empty()
MarkDayton

Discussions |
Sep 7, 2018 12:38 PM

4330 views | 3 replies
Reduced Major Axis regression in JMP

Can you do a reduced major axis (RMA) regression in JMP Pro 14? I've been trying to figure it out. Is it one of the orthogonal regression models? Thanks!
DAS_Owen

Discussions |
Sep 7, 2018 11:17 AM

8703 views | 3 replies
Formulation DOE

I have to define DOE for 2 continuous factors and 1 qualitative factor with 2 levels (A and B) tested at different concentrations. My constraints are the following:- if the A concentration is >0 then B=0- if the B concentration is >0 then A=0The objective is to optimize the formulation.I try to do a custom design but I didn't find the way to define my constraint.The optimum should select the bes...
hytou31

Discussions |
Sep 7, 2018 8:43 AM

7943 views | 7 replies
Subsetting a subset of Columns

Hi All, 1. I have here a raw prober robot logs with continous by-time data per seconds of its movement executions a record of SiteX data (site0~7 this is basically a fixed hardware that touches a wafer), it records an X & Y and a BIN it touched down.2. One row is one touch-down (of site0-7 ) on a wafer. However this raw format is hard to manipulate unless I do a subsetting and concatenating. See ...
jerryspilTC

Discussions |
Sep 7, 2018 2:47 AM

8139 views | 8 replies

Previous
Next

Latest Discussions

Test if data table is locked

I know that I can lock and unlock a data table through the Lock Data Table() command, but how do I test if a data table is locked? A table locked through Lock Data Table() returns Empty() when using the Get Edit Lock() function. //:*/dt<<Lock Data Table(1);
/*:Scriptable[]
//:*/
dt << Get Edit Lock();
/*:Empty()
MarkDayton

Discussions |
Sep 7, 2018 12:38 PM

4330 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

10672 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

4217 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

7347 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

4545 views | 7 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

3276 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

2314 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

2840 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

1710 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

3807 views | 0 replies