JMP User Community

Latest Discussions

Changing Column Data Types

Hi, I wanted to change my column data types to continuous and numeric but the following is giving me a scriptable[] error, I'm not sure what that means.Column(dt, 1) << Data Type( Numeric ); Column(dt, 1) << Set Modeling Type (Conitnuous);So, I used this next line of code: dt:Column(1) << Data Type( Numeric ); dt:Column(1) << Set Modeling Type( Continuous );But it still doesn't like it. Any sugge...
Jaz

Discussions |
Jun 29, 2018 4:51 AM

6920 views | 2 replies
Determine the correct sampling rate for SPC data

Hello, I have an SPC data with UCL = 12.015 and LCL = 12 (target is 120.007) - see attached.My OOC (Out Of Control) values are too high and I want to check that my sampling rate is correct.Current sample rate is 0.1 (1 out of 10 parts are measured) and we are missing OOC measurements (there are 2 groups of SPC values with same limits: "Measure Depth 7" and "Measure Depth 1"). I tried using the sam...
yoni-b

Discussions |
Jun 29, 2018 3:59 AM

10882 views | 4 replies
Exact match and Nearest Match for updating a table with another table

I have a big data table (1M rows). One column is serialNumber, one column is dateTime, one column is elapsedTime. Another much smaller table also has these columns, but the dateTime is earlier by an small amount (5-20 minutes) and the elapsedTime is a much more accurate value. The small table also has lots of extra rows associated with other events at other dateTimes (I do not have an 'event' c...
mann

Discussions |
Jun 28, 2018 11:01 AM

3812 views | 3 replies
normalcy test for residuals

I am plotting Y vs X (see attachment). The regression line apperas to be quite good. R seq > 0.99. However when I make a residul plot, I get an inverted U. Some people say that such a residual plot point to that the Regression line is not good enough. My question is: 1. Is there some way to improve the residual plot and the Leniar regression (may be by changing intercept ?). 2. I performed a te...
peerr12

Discussions |
Jun 28, 2018 2:30 AM

7137 views | 8 replies
Filling empty cells in a specific “character” column

Hello,I need help with filling empty cells in a specific “character” column.I was able to find a script that does it to all numeric cells of the entire table, but I need it to edit a specific text column. I have something like the table below and I want to fill the empty cells in the "United" column with an expression like "PASS".so from this table:RevOBUnitedABC1231CB1ABC321 CB5CBA2134 ABC546 CB1...
ileshem

Discussions |
Jun 27, 2018 11:18 AM

19827 views | 8 replies

Previous
Next

Latest Discussions

Determine the correct sampling rate for SPC data

Hello, I have an SPC data with UCL = 12.015 and LCL = 12 (target is 120.007) - see attached.My OOC (Out Of Control) values are too high and I want to check that my sampling rate is correct.Current sample rate is 0.1 (1 out of 10 parts are measured) and we are missing OOC measurements (there are 2 groups of SPC values with same limits: "Measure Depth 7" and "Measure Depth 1"). I tried using the sam...
yoni-b

Discussions |
Jun 29, 2018 3:59 AM

10882 views | 4 replies
Exact match and Nearest Match for updating a table with another table

I have a big data table (1M rows). One column is serialNumber, one column is dateTime, one column is elapsedTime. Another much smaller table also has these columns, but the dateTime is earlier by an small amount (5-20 minutes) and the elapsedTime is a much more accurate value. The small table also has lots of extra rows associated with other events at other dateTimes (I do not have an 'event' c...
mann

Discussions |
Jun 28, 2018 11:01 AM

3812 views | 3 replies
normalcy test for residuals

I am plotting Y vs X (see attachment). The regression line apperas to be quite good. R seq > 0.99. However when I make a residul plot, I get an inverted U. Some people say that such a residual plot point to that the Regression line is not good enough. My question is: 1. Is there some way to improve the residual plot and the Leniar regression (may be by changing intercept ?). 2. I performed a te...
peerr12

Discussions |
Jun 28, 2018 2:30 AM

7137 views | 8 replies
Is there any way that I can remove the label numbers in the graph?

Hello all, I am using label in my script to help me filter data. The script is showing bellow: dt_daily << New Column( "Outliers Exclusion (Energy % from Controls)", Numeric, Continuous, Formula( If( !labeled( Row State() ) , "Clean Bad Data", "Show Bad Data" ) ), eval formula ); Close( dt_subdaily ); Close( dt_dailysplit ); Wait( 0 ); New Window( "Energy % from Controls", dt_daily << Grap...
Anonymous

Discussions |
Jun 26, 2018 6:12 AM

6049 views | 2 replies
Passing Date value to Oracle SQL

I have a frustrating problem. I want to write a script to use a JMP date code, to query an Oracle database.For instance:StDt = today() - in weeks(4);.If I manually do it using Query Builder, I get something like the code below. What syntax do I need to replace the integer date code with to do this? The documentation is pretty sparse on this topic. Query1 = New SQL Query(
Version( 130 ),
Connection...
mwechtal

Discussions |
Jun 25, 2018 2:27 PM

5860 views | 3 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

3511 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

2507 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

3094 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

1889 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

4058 views | 0 replies