JMP User Community

Latest Discussions

Variable names that change every time a loop is iterated

I am trying to create a new column formula that changes variable names every time a for loop is iterated. See below for the JSL code: For(i = 1, i <= 5, i++, dtMachineStartandStopTimes << New Column(:Machine||char(i)||RunDuration, Formula(:Machine||char(i)||StopTime-:Machine||char(i)||StartTime)); );Each row in dtMachineStartandStopTimeshas columns labeled "Machine1StartTime" thru "Machine5StartTi...
twillkickers

Discussions |
Jul 12, 2018 12:49 PM

5137 views | 2 replies
Copy column subset or cell range from table to table

I have two data tables. Some columns on table2 are identical to columns table1. I wasnt to copy the data of the identical columns from table2 to table1. That means, of course, that (1) table1 will be expanded with the number or rows in table2 and, (2) there will be missing data in table1. That's OK. My issue is how to copy the data from table2 to table1. E.g. - both tables have column "NAME". Tab...
RonB

Discussions |
Jul 12, 2018 11:28 AM

10756 views | 15 replies
set value to selected cells

Hello, I am trying to select certain cells in data table and set value 2 to them, but it doesn't work. Can someone check my script to see what's wrong with it? sdt << selectwhere( :Informat( "06/26/2018 16:49:00", "m/d/y h:m:s" ) <= :Time <= :Informat( "06/26/2018 16:54:00", "m/d/y h:m:s" ) ); selRows = sdt << getselectedRows; As Column( sdt, "Status" )[selRows] = "2";
Kevin

Discussions |
Jul 12, 2018 10:54 AM

11590 views | 6 replies
join two tables different row numbers

Hello, I have a question of how to merge two tables with different row numbers. The first table is TimeTool 182 182 193 193 The 2nd table is TimeTool 185 198 The final Table I want isTimeTool 185 185 198 198
Kevin

Discussions |
Jul 12, 2018 10:51 AM

5171 views | 2 replies
Capability analysis

Hi have continuous data (processing time)The Continuous Fit suggests the "Normal 2 Mixture Distribution"Can I make a capability analysis with this distribution? Thanks
olympiac

Discussions |
Jul 12, 2018 7:42 AM

10525 views | 9 replies

Previous
Next

Latest Discussions

Capability analysis

Hi have continuous data (processing time)The Continuous Fit suggests the "Normal 2 Mixture Distribution"Can I make a capability analysis with this distribution? Thanks
olympiac

Discussions |
Jul 12, 2018 7:42 AM

10525 views | 9 replies
data table extraction from saved .jrn file

Problem Statement: we are using version JMP 12.0.1. for one of our analysis, we have saved file with extension of .jrn and .jrp in PC but somehow, we are able only to find .jrn file which results, we are unable to see "data table" for that analysis. Can someone help us to know how can we extract data table from saved .jrn file??? ThanksPraveen
PraveenG

Discussions |
Jul 11, 2018 9:34 PM

3275 views | 1 replies
JSL: Set title not working

Hi all, i'm trying to script a trend chart and set a title, it's working on bivariate but not working on oneway. anyone can help to advice? thanks. trend_R14toCu = V List Box (For( k = 1, k <= N Items( Conf ), k++, joindt << Oneway( Y( :Name( "FVIM - R14 to Cu" ) ), X( :Point_Wafer ), Means and Std Dev( 0 ), Mean Lines( 1 ), Mean Error Bars( 1 ), Std Dev Lines( 1 ), Connect Means( 1 ), Where( :Co...
jamesloh

Discussions |
Jul 11, 2018 7:02 PM

4770 views | 2 replies
Graph builder jitter and non jitter meshed up?

as you see above in graph builder i see some median overlapped with box plot and some are not. any body knows why?
ram

Discussions |
Jul 11, 2018 10:50 AM

4767 views | 1 replies
Exclude certain rows in data analysis

I recently imported a survey that I created on Qualtrics. The survey was 30 minutes long so some people stopped halfway through or at the beginning etc.. I gave each question a point value to make the survey like a test and assign grades. But when I look at final points, this includes users who chose to terminate the survey early and do not have responses from that point forward. How do I excl...
nhi225

Discussions |
Jul 11, 2018 6:03 AM

8023 views | 2 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

3433 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

2465 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

1845 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

3986 views | 0 replies