JMP User Community

Latest Discussions

Adding up all the columns with names stored in a list

I have create a list of column containing roughly the same name below: Xlist = {};
Ylist = {};for(i = 1, i < ncols(dt2), i++,
if(
contains(dt2:i<< get name, "XXX") > 0, insert into(Xlist, dt2:i<< get name),
contains(dt2:i<< get name, "YYY") > 0, insert into(Ylist, dt2:i<< get name),
)
); I would like to create a new column which will give me a sum of the Xcolumn and Ycolumn. It is not working well for m...
nguyendv06

Discussions |
Jul 17, 2018 12:46 PM

9390 views | 2 replies
how to get a sum of all columns with names stored in a list

I have create a list of column containing roughly the same name below: Xlist = {}; Ylist = {}; for(i = 1, i < ncols(dt2), i++, if( contains(dt2:i<< get name, "XXX") > 0, insert into(Xlist, dt2:i<< get name), contains(dt2:i<< get name, "YYY") > 0, insert into(Ylist, dt2:i<< get name), ) ); I would like to create a new column as below which will give me a sum of the Xcolumn and Ycolumn. It is not ...
nguyendv06

Discussions |
Jul 17, 2018 12:45 PM

8032 views | 1 replies
Delete Duplicate Data from Table using Time Stamp

I apologize, i know this question has been asked quite a few times on this forum but I haven't been able to find a solution to my problem.I have a large data set ~24,000 rows of test data. Our process is to run a 5 step validation on 5 die and once we get the results we begin testing which ultimately means i am going to have repeat data on those 5 sites. This 5 step validation verifies the conta...
Yngeinstn

Discussions |
Jul 16, 2018 12:03 PM

9798 views | 10 replies
JSL Check Box Set Size

Hello JMP folk, Is it possible to change the size of a Check Box by script? Looking through the documentation I set the max size before changing the Height & Width but I have still not been able to increase the checkbox size. Have not found any other topics on this in the forum. windowMain = New Window( "test", //Header Outline Box( "", H List Box( Check Box( "", << Set Max Size(30,30),...
RBILLC

Discussions |
Jul 16, 2018 11:45 AM

11614 views | 6 replies
Saving a graph as an image file without the "graph builder" header in the image. Can someone please advise?

Saving a graph as an image file without the "graph builder" header in the image. Can someone please advise?
nlc4

Discussions |
Jul 16, 2018 10:09 AM

17760 views | 7 replies

Previous
Next

Latest Discussions

JSL Check Box Set Size

Hello JMP folk, Is it possible to change the size of a Check Box by script? Looking through the documentation I set the max size before changing the Height & Width but I have still not been able to increase the checkbox size. Have not found any other topics on this in the forum. windowMain = New Window( "test", //Header Outline Box( "", H List Box( Check Box( "", << Set Max Size(30,30),...
RBILLC

Discussions |
Jul 16, 2018 11:45 AM

11614 views | 6 replies
Running Multivariate analysis

Hi, I'm trying to run a few analysis but can't seem to figure my way around JMP to set-up and produce any kind of results. I'm a graduate student in California. What I know I need to run is:1) MANOVA - where I am trying to find differences in 4 variables between 4 groups.2) Multivariate t-test: I have 2 variables, that are related, and find differences between two groups over time. A little backgr...
E_Dandekar

Discussions |
Jul 16, 2018 5:07 AM

5732 views | 3 replies
Graph Builder - Change the Drawing Order when using a Group Y variable

Hello everybody, I would like to know how we can uniformize the customization of graphical elements when we use a Grouping column. Let's take an exemple using the Big Class.jmp table.I choose "height" as Y variable and "age" as Group Y variable. I display the histogram in addition to the points.After that, I change the order of elements using the Customize menu so that points are now over histogra...
anne_sa

Discussions |
Jul 15, 2018 11:26 PM

4153 views | 4 replies
RE: Selecting Matching Character Values in the Same Column

Hi, I'm aware I could make use of loops to solve this problem but I was wondering if there was a function / another way to find matching character values in one row in my data table in JSL? Any help would be appreciated.
Jaz

Discussions |
Jul 15, 2018 1:54 PM

5891 views | 2 replies
Bar Graph - Stacking Multiple Columns with Discrete Categories

I'm trying to determine RFT of parts based on the value against spec limits. I've been able to create custom transform columns in the graph builder using the following JSL script: vars = expr(Variables()); dataSheet = "....CENSORED.jmp"; dt = Open(dataSheet); colnames = dt << get column group( "Data" ); For( i = 1, i <= nitems(colnames), i++, colName = Char(colnames[i]); insert into(vars,...
David_

Discussions |
Jul 13, 2018 10:10 AM

7349 views | 4 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

3430 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

2462 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

3023 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

1842 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

3984 views | 0 replies