JMP User Community

Latest Discussions

FIT Spline in Loop Function

I am using below loop function to create Bivariate charts by Column " MEASUREMENT_FLAG_NOCHAMBER". However , I want to add more FIT Spline grouping by " WLT_COMPONENT" but fail again and again. anybody can help check what I can do for below script ? dt = Current Data Table();Summarize( dt, byVals = by( :MEASUREMENT_FLAG_NOCHAMBER ) );Bi = Bivariate( X( :LOT_DATA_COLLECT_DATE ), Y( :CHART_VALUE ),...
yu629xiao

Discussions |
Mar 9, 2020 10:57 AM

1624 views | 1 replies
Displaying data values from Graph Builder

I am looking for some help in extracting data values at a specific point on a -x-y plot and putting them into a table to add to a presentation. I have attached a picture of a plot and if you notice there are 4 Ref Lines ( 8, 11, 14.5, and 17.5). I would like to get get the exact value for each device at that specific point and put them into a table. I have tried Summary & Tabulate but I can't seem...
Yngeinstn

Discussions |
Mar 9, 2020 10:43 AM

7071 views | 8 replies
JMP Script: Capability Ananysis in JMP 15

Hi Everyone, We recently upgraded from JMP 14 to 15.One of our scripts is currently showing a different result when a capability analysis is done. In JMP 14 we had the following result: In JMP 15, the exact same expression suddenly shows the PPx values (note - this is from a different analysis, so different limits): The code we use to generate the chart:Distribution( Uniform Scaling( 1 ), Stack...
jan_solo_ff

Discussions |
Mar 9, 2020 9:52 AM

2387 views | 1 replies
Exclude outlier in box plot

Hello,I'm comparing two parameter sets in a box plot. Each set includes has 10 reps for statistics. And obviously there is one outlier in it (see attached file). Is there a way to include the outlier in the graphic, but exclude it from the statistics? I tried the "exclude" status for the row, the statistics are corrected then, but the outlier disapears (it works for the points plot, but I would li...
JL_LZH

Discussions |
Mar 9, 2020 3:15 AM

6618 views | 2 replies
Nearest Neighbor to detect outliers

I have a data set with three columns X,Y and Z. There are several rows in the table. X and Y coordinates in each row is one location in XY space and Z is the height at that XY location. I want to create a 3x3 cluster at each XY location and calculate the average of 8 nearest neighbor points (excluding the center point). Then subtract Z height of the XY location in the center from the calculated av...
rverma

Discussions |
Mar 8, 2020 7:38 PM

3712 views | 3 replies

Previous
Next

Latest Discussions

FIT Spline in Loop Function

I am using below loop function to create Bivariate charts by Column " MEASUREMENT_FLAG_NOCHAMBER". However , I want to add more FIT Spline grouping by " WLT_COMPONENT" but fail again and again. anybody can help check what I can do for below script ? dt = Current Data Table();Summarize( dt, byVals = by( :MEASUREMENT_FLAG_NOCHAMBER ) );Bi = Bivariate( X( :LOT_DATA_COLLECT_DATE ), Y( :CHART_VALUE ),...
yu629xiao

Discussions |
Mar 9, 2020 10:57 AM

1624 views | 1 replies
Exclude outlier in box plot

Hello,I'm comparing two parameter sets in a box plot. Each set includes has 10 reps for statistics. And obviously there is one outlier in it (see attached file). Is there a way to include the outlier in the graphic, but exclude it from the statistics? I tried the "exclude" status for the row, the statistics are corrected then, but the outlier disapears (it works for the points plot, but I would li...
JL_LZH

Discussions |
Mar 9, 2020 3:15 AM

6618 views | 2 replies
HELP WITH FRACTIONAL FACTORIAL DESIGN OF EXPERIMENT

How do I carry out a fractional factorial design of experiment. I have watched some videos but they did not explain the basics to me very well. I have a data I need to analyse but I am new to design of experiment, yet, I don't have time to spare. I will prefer an interactive explanation.I greatly appreciate any help provided
JesusJewel

Discussions |
Mar 8, 2020 6:55 AM

4853 views | 5 replies
Paste Table Script into Script

I am trying to save a script to my data table that will recreate a table I made previously. This is an add-in that is pretty extensive and involves opening/closing several different tables, creating summary tables, joining, updating and in the end the only data I will need for the reports is a simple 2 column table. I would like the users to be able to run this add-in one time, and if they acciden...
aallman

Discussions |
Mar 6, 2020 4:00 PM

4877 views | 5 replies
Accessing JMP plots from Python

I have some team members that use JMP for analysis and plotting of some data. We have a set python tools that plan to take in the plots from JMP. We have been able to get the data tables from JMP in Python, but I don't see a way to bring in the plots directly. I'm referencing the Automation Reference pdf that comes with JMP. Anyone have any ideas?
cookiedough

Discussions |
Mar 6, 2020 1:40 PM

2714 views | 1 replies

Previous
Next

Latest Discussions

How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

2220 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

2033 views | 0 replies
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1673 views | 0 replies
how to add confounding variable

I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
billi

Discussions |
Jan 6, 2020 9:39 AM

1608 views | 0 replies
Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!
Ranae

Discussions |
Nov 26, 2019 11:44 AM

1689 views | 0 replies