JMP User Community

Latest Discussions

How to save a summary table (and scripts within) back to the original table?

I make a summary table from an original table and within the summary table I create a bunch of graphs which I save their scripts to the table. Now how can I save this entire summary table (and scrips within) back to the original data table? I know it can be done with JSL but I'm not very familiar with scripting.
shasheminassab

Discussions |
Apr 30, 2020 3:21 PM

7962 views | 8 replies
Use of local variable in a formula

I have a table that has a column (Samp Pt) which lists the equipment name as Equip_n where n is 1 through 9.The Column "Date / Time" is the date and time.The data is sorted by Equip_n and then Date / Time.I want to create a value called Run which is the Run number for each piece of Equipment. The Run is the Equipment number-Run, e.g. 1-1. A new Run is defined when the difference between successi...
lance

Discussions |
Apr 30, 2020 12:33 PM

3034 views | 4 replies
GRR Report

Hi, I have script to generate GRR plot and then make a summary table. The problem is when I have a mix of one side and two side spec and use command "make combined data table", it will show only either one side spec or two side spec based on the first parameter. How can I get the summary table of both in the script ? new window ("GRR", for (i = 1, i <= N items (ColList), i++, variability ch...
yanee

Discussions |
Apr 30, 2020 9:57 AM

4072 views | 7 replies
set variable to random number.

I want to set variables to random numbers. I tried this. but it is not working MEnum = 5; For( i = 1, i = MEnum, i++, betai = Random uniform.( 30, 50 ) ); When I print this to the log it just keeps giving me random numbers, how do I get 5 different random numbers for beta1 to beta5?
lisamaley

Discussions |
Apr 30, 2020 4:48 AM

3168 views | 6 replies
Mantel test to compare the similarity of two matrices

How do I perform the non-parametric Mantel tests in JMP or JMP pro 14 in order to compare two structurally similar matrices. Typically this test evaluates the correlation between two matrices using permutation methods. An interactive explanation seems like a good way to start.
berenrob

Discussions |
Apr 30, 2020 4:42 AM

2385 views | 2 replies

Previous
Next

Latest Discussions

How to save a summary table (and scripts within) back to the original table?

I make a summary table from an original table and within the summary table I create a bunch of graphs which I save their scripts to the table. Now how can I save this entire summary table (and scrips within) back to the original data table? I know it can be done with JSL but I'm not very familiar with scripting.
shasheminassab

Discussions |
Apr 30, 2020 3:21 PM

7962 views | 8 replies
GRR Report

Hi, I have script to generate GRR plot and then make a summary table. The problem is when I have a mix of one side and two side spec and use command "make combined data table", it will show only either one side spec or two side spec based on the first parameter. How can I get the summary table of both in the script ? new window ("GRR", for (i = 1, i <= N items (ColList), i++, variability ch...
yanee

Discussions |
Apr 30, 2020 9:57 AM

4072 views | 7 replies
Mantel test to compare the similarity of two matrices

How do I perform the non-parametric Mantel tests in JMP or JMP pro 14 in order to compare two structurally similar matrices. Typically this test evaluates the correlation between two matrices using permutation methods. An interactive explanation seems like a good way to start.
berenrob

Discussions |
Apr 30, 2020 4:42 AM

2385 views | 2 replies
Implementing disallowed factor combinations and/ or linear constraints using DSD-approach?

Hi everyone,I'm currently struggling to combine the advantages of the DSD-platform with the Custom-Design platform and didn't find a somewhat workable solution.The task is to investigate about 30 continuous variables and 8 categorial variables with as few runs (currently around 90) as possible AND to discard combinations which make no sens based on process knowledge. On top of that we are mainly i...
egon_gross

Discussions |
Apr 29, 2020 10:52 PM

5374 views | 8 replies
PCA analysis of time-course data to yield a PCA by Batch ID

Hello, I have several bioreactor data. Each bioreactor has an ID (1 to 5) and several time-course profile variables (Dissolved oxygen, pH...). I have 20 variables for the time-course data, and 10 timepoints. When I do a PCA analysis, using the 20 variables as Y columns, I obtain a score plot of the bioreactor data, which is good. Meaning for each bioreactor I get one time-course profile considerin...
DAMP

Discussions |
Apr 29, 2020 4:13 PM

3080 views | 4 replies

Previous
Next

Latest Discussions

How do I have two different chart types in a single graph using two axis?

While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot? Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot. To do this, first clear the row s...
Bass_Masri

Discussions |
Apr 28, 2020 4:28 PM

4565 views | 0 replies
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

2128 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

1962 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

1618 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

1570 views | 0 replies