JMP User Community

Latest Discussions

Select rows based of multiple conditions

Hello,I'm trying to select rows where either the second or third column have a value below 10^-9, or if there is a missing value in the 4th column. The problem appears to be with the less than operator and I cannot figure out why. Example table:Col1Col2Col3Col410.000000590.000000308A24.08e-9-8.1e-11B3-1.11e-101.02e-10 Here's the code:dtColNames = dt << get ColumnNames("String"); val = 10^-9; dt <...
aserino

Discussions |
Apr 15, 2020 11:41 AM

2283 views | 2 replies
Data type vs Design Role for general factorial design

I'm transitioning from Minitab to JMP for a course this semester and I'm struggling with the workflow. Example: I have a 2 factor general factorial experiment with 3 levels each (3^2 design). The variables themselves are continuous (e.g., temperature and pressure). I want to do two things: 1. Evaluate a general factorial effects model with main effects (Temperature, Pressure) and 2-way interactio...
CO_rower

Discussions |
Apr 15, 2020 7:54 AM

10235 views | 7 replies
How to Constrain Factors in DOE to Sum to A Value

Hello all,My apologies if this has been asked and answered before. I did not see any topic that specifically addressed this. Does anyone know what steps you must take in creating a DOE that has a constraint of three factors adding to one particular value? Thank youo.
A_Ghezelbash

Discussions |
Apr 15, 2020 7:53 AM

2373 views | 3 replies
non parametric tolerance interval

I am trying to calculate tolerance interval. However, my data is not normal so I selected nonparametric method bu it gives me an error "Unable to calculate this tolerance interval". Do I need to select some other option to use non-parametric method?
billi

Discussions |
Apr 15, 2020 6:17 AM

3487 views | 2 replies
clone a column

Hi All, I want to clone a column in the data table (make a new identical column in all but it’s name). Is there a more sleek (and robust) way of doing this or do I need to extract the values and all properties and assign them to the new column as such:dt3 = Open( "$SAMPLE_DATA/Cars.jmp" );// add a column property dt3:Make << Set Property( "Value Colors", {"Acura" = -13977687, "Au...
ron_horne

Discussions |
Apr 15, 2020 4:20 AM

19323 views | 12 replies

Previous
Next

Latest Discussions

How to Constrain Factors in DOE to Sum to A Value

Hello all,My apologies if this has been asked and answered before. I did not see any topic that specifically addressed this. Does anyone know what steps you must take in creating a DOE that has a constraint of three factors adding to one particular value? Thank youo.
A_Ghezelbash

Discussions |
Apr 15, 2020 7:53 AM

2373 views | 3 replies
non parametric tolerance interval

I am trying to calculate tolerance interval. However, my data is not normal so I selected nonparametric method bu it gives me an error "Unable to calculate this tolerance interval". Do I need to select some other option to use non-parametric method?
billi

Discussions |
Apr 15, 2020 6:17 AM

3487 views | 2 replies
Question with natural log

I'm trying to set a variable to a natural log, but I do not know how to go about it.
juggernauttt

Discussions |
Apr 14, 2020 1:24 PM

4086 views | 2 replies
How to choose multiple color coding in a heatmap?

Hi, I am trying to plot a heatmap with some data as shown in the image below.x and y are the grouping variables and d, a are the coloring variables.I only see the effect of one coloring variable at a time.Is it possible to have each cell of the above plot (vertically/horizontally)divided into two where one cell refers to colors based on d and other based on a? Is there any other solution that I ca...
AD1

Discussions |
Apr 13, 2020 12:44 PM

2355 views | 2 replies
Batch Processing

I have multiple folders (4), each folder with multiple files (4), each file with multiple sheets (12), each sheet with a matrix of about 80x20. Speaker sound pressure level vs frequency. I am looking to extract the data in JMP, put it back on the same folder for each file, for each sheet, and run a simple x by y correlation matrix, where x=the first 10 files and y=the second 10 files, files BUT PI...
Guillermo

Discussions |
Apr 13, 2020 12:39 PM

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

2206 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

2016 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

1660 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

1600 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

1681 views | 0 replies