JMP User Community

Latest Discussions

Custom DOE do 3 replicates of each combination

I'm trying out the custom DOE tool and I'm not sure what the replicate runs option does.I would like to specify that I want 20 combinations for example but I was to run each of those combinations 3 times, so we have 3 replicates of each combination and 60 runs in total.What would be the best way to do this? Thanks
Agustin

Discussions |
Jun 5, 2020 6:31 AM

3320 views | 2 replies
Make Combined Data Table from Journal in jsl

Hi community! I have the attached Journal, and I want to make a combined data table from the Summary Statistics and Capability Analysis. I checked the tree structure, but I'm unsure on how to make the correct reference. I was trying with the below but it didn't work. Any clues? Current Journal()["Summary Statistics"][Tablebox(2)] << Make Combined Data Table;
oscarmforero

Discussions |
Jun 5, 2020 1:58 AM

3122 views | 2 replies
Column Formula for summary value of group based on values in 2 other columns

Hi everyone - I'm looking for a column formula that would return the following desired column below. For simplicity in this post each group has 3 rows, but the dataset I currently have has groups with varying numbers of rows. Any help appreciated! GroupTimeScoreFirst Time Failed (Desired Column)A1Pass8A3Pass8A8Fail8B1PassPassB2PassPassB6PassPassC1Pass3C3Fail3C7Fail3
user8421

Discussions |
Jun 4, 2020 5:08 PM

3910 views | 2 replies
How do use JSL to quickly compare two sets of range columns in order to get the minimum of each column?

The title is a bit hard to understand. Take this big class as an example:
1. First, summarize the average values of "height" and "weight" by age.
2. Then summarize the median of "height" and "weight" by age.
3. Then compare the mean and median of "height" and take their minimum.
Finally, compare the mean and median of "body weight" and take their minimum. I'll use the following code and finally loop t...
lwx228

Discussions |
Jun 4, 2020 3:49 PM

3102 views | 4 replies
HTML import as data table issue

I have been using the open() function for a HTML file. I'm now dealing with a column that has values such as "<2.4!". when I use the open() function, it imports those values as "" in the data table. However, when I do it using prompts in JMP, after opening the html file, I'm able to open the html file using 'Import table as Data Table' and the correct value of "<2.4!" is imported. Is there a way ...
danielharding0

Discussions |
Jun 4, 2020 2:01 PM

2962 views | 4 replies

Previous
Next

Latest Discussions

HTML import as data table issue

I have been using the open() function for a HTML file. I'm now dealing with a column that has values such as "<2.4!". when I use the open() function, it imports those values as "" in the data table. However, when I do it using prompts in JMP, after opening the html file, I'm able to open the html file using 'Import table as Data Table' and the correct value of "<2.4!" is imported. Is there a way ...
danielharding0

Discussions |
Jun 4, 2020 2:01 PM

2962 views | 4 replies
How to get partitioned sum of squares in ANOVA results of fit model

Not just CTSS, SSmodel and SSE, I mean SS for individual predictors. How do I get it from fit model results? Thank you.
ricardor

Discussions |
Jun 4, 2020 5:30 AM

1742 views | 1 replies
DATA WIDE TO LONG FORMAT

Hi allI have data in wide format i.e col with three variables: predicted, upper and lower and respective rounding options like round up of predicted, upper and lower, round down of predicted, upper and lower etc. which I want to reorganize it in long format i.e some constant rows like date and all of the value has to be reformatted into longer.I have attached the " have" and "want" data.Any h...
sweetycha

Discussions |
Jun 2, 2020 12:12 PM

4390 views | 1 replies
Add rows every x rows

Dear community, i've got a huge table and would like to add one row every 4 rows (4 rows data, adding 1 row, moving the rest of the data downwards, then adding 1 row after 4 rows of data aso).I have no clue how to achieve that with a script. Can anyone kindly help me with this topic?
Sandra

Discussions |
Jun 2, 2020 11:52 AM

4224 views | 7 replies
Autorunning the JMP script periodically

Hi, I'm trying to automate my everyday task. I want the following script to run periodically and save the output. Can JMP auto select from the drop down list and save the output?For ex. Selecting a Age then selecting a Name and then saving the output for all the age from 12 - 17 Thanks
Jackie_

Discussions |
Jun 2, 2020 8:54 AM

2450 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

4672 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

2218 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

2028 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

1607 views | 0 replies