JMP User Community

Latest Discussions

Merging Rows with Sum

Help! I have a datatset with 200ish rows. There are 170ish unique IDs, meaning multiple people have multiple rows. Is there a way to merge the data from the applicable rows (e.g., some rows are dates so that would not be applicable) with a sum? Such that each unique subject ID only has ONE row in the dataset. If its only possible to this with a dataset with applicable rows (i.e., all numeric/...
plfazeli

Discussions |
Jan 30, 2024 11:22 AM

4114 views | 7 replies
Suggestion on experimental design strategy for chemical synthesis

Happy Sunday, a wonderful community of JMP! I will likely have to design and run a set or sequential experiments to maximize the yield of chemical synthesis. Someone in our group ran this chemical reaction in the past. However, my manager wants me to repeat this reaction to better understand the relationship between reaction conditions and yield. Based on the historical data, there are three takea...
BJK_JerseyBoy

Discussions |
Jan 30, 2024 9:31 AM

3689 views | 6 replies
Getting a Cumulative Sum Count based on multiple column conditions

Hi,I am trying to incrementally count rows in a dataset based on matching conditions in three other columns. Essentially if the rows in Column A, B, and C match, then Column D = 1; when Column C changes (Depth) but Column A and B stay the same, Column D = 2. I need this count to restart from one when Column A (Site ID) or B (Year) change. I have gotten this far with the following formula: Col Cumu...
PivotalWeasel30

Discussions |
Jan 30, 2024 9:08 AM

1589 views | 2 replies
How to modify an existing DisplayBox with JSL

I'm trying to create a button that will modify the output of the Fit Model() dialog to include a Predicted R2 in the Summary of Fit table. I grab the current window and then I need to activate the PRESS statistic. After this it's straightforward enough and it mostly works if I've already activated the PRESS statistic through the contest menu. It also works if I code the Fit Model dialog myself ...
Anonymous

Discussions |
Jan 30, 2024 7:36 AM

10634 views | 6 replies
Consumer research categorical data analysis report

This will undoubtedly be a silly one, but in the categorical report from Consumer Research, there are two warnings in place: Base count warning 100 and base count minimum 30. I am trying to figure out what these actually represent, and how they differ from the usual chi-square 20% of cells with less than expected counts. These warning can be changed in the set preferences platform so am wondering...
GregMcMahon

Discussions |
Jan 29, 2024 5:08 PM

1553 views | 2 replies

Previous
Next

Latest Discussions

Getting a Cumulative Sum Count based on multiple column conditions

Hi,I am trying to incrementally count rows in a dataset based on matching conditions in three other columns. Essentially if the rows in Column A, B, and C match, then Column D = 1; when Column C changes (Depth) but Column A and B stay the same, Column D = 2. I need this count to restart from one when Column A (Site ID) or B (Year) change. I have gotten this far with the following formula: Col Cumu...
PivotalWeasel30

Discussions |
Jan 30, 2024 9:08 AM

1589 views | 2 replies
Books for learning JMP

Could anyone please recommend some advanced books for studying JMP Pro?
thiennguyen

Discussions |
Jan 29, 2024 2:47 PM

1309 views | 2 replies
How do i group values and run on the groups descriptive statistic?

I have a table of MODIS. There is a column Confidence with the range from 1 to 100. I want to group it by low confidence 0-30, moderate confidence 31-60, high confidence 61-100 and run descriptive statistic on the groups. I have wrote the statement but all values disappeared and became a black dots.How do i group columns right?How do i bring back the data back instead of black dots?Thank you.Natal...
Nataliia_bud

Discussions |
Jan 28, 2024 10:49 PM

2833 views | 4 replies
Anyone have the data files of this book?

https://www.wiley.com/en-us/Machine+Learning+for+Business+Analytics%3A+Concepts%2C+Techniques+and+Applications+with+JMP+Pro%2C+2nd+Edition-p-9781119903857 I hope someone has the data files for it. Can you share it with me? I really need it Thank you for your attention to my problem
thiennguyen

Discussions |
Jan 28, 2024 10:03 PM

830 views | 1 replies
JMP scripting on Bivariate plot

Dear JMP script experts, Below is an example to illustrate I am trying to do. wondering if any expert can help or shed the light on writing the script. By using Bivariate Fit of Y by X to generate a plot. And the row legend is Z column. Each data point of Z is plotted as square (not circle as default. And Z=1 is plotted as green color, Z=2 is plotted as blue color and Z=3 is plotted as red col...
cdwang9507

Discussions |
Jan 27, 2024 11:43 PM

1174 views | 2 replies

Previous
Next

Latest Discussions

Optimal decision tree and Adam's consensus?

Hello - First of all, I'm speaking very much as a non-statistician here. I have a paper I'm trying to replicate that is doing hierarchical clustering with multiple similarity functions and grouping methodologies, and then using an Adam's consensus to find a sort of "optimal" dendrogram, if you will. I looked at their software they were using, and its been out of comission for a good 15 years. JMP ...
ehchandlerjr

Discussions |
Jan 26, 2024 11:06 AM

744 views | 0 replies
Use Limits Table In Distributions Platform

Hi, is it possible to use a limits table to load specifications grouped by some factor in platforms other than Process Screening? Ideally I'd like to use the limits table in the distributions platform. Thanks in advance, Alicia
Alicia

Discussions |
Jan 25, 2024 8:24 AM

697 views | 0 replies
Which predictive analysis method/column organisation for RSM output with duplicate samples

Hi all. So I'm working on a project where I have 2 x component classes, each of which has 4 items within the class, which are mixed together at varying concentrations over 48 combinations. Figured the best Factor way to do this was to use 2 x Continuous for the max/min concentrations for each class, then 2 x 4-level Categoricals for each of the items. Each of the combinations was made twice, so af...
ProbitLeopard63

Discussions |
Jan 25, 2024 3:06 AM

729 views | 0 replies
how to show "nonparametric overlay" in the output of "Fit life by x"?

I tried to do “Fit life by X” (fit TTF by voltage), but in the output, somehow “nonparametric overlay” did not show up. I was hoping to see the probability of failure vs time at 80V, 50V, and 15V (use condition), but that plot was not included in the output. I attached the report here. If anyone can take a look and point out went wrong, that would be great. Thank you!
RenZ

Discussions |
Jan 22, 2024 10:02 AM

581 views | 0 replies
Custom Binning - how to edit the bins?

Wow, custom binning even works with dates, cool! There is even a possibility to edit the binning. But: quite uncomfortable to type in the dates in seconds and to correct the labels manually.What do I have to change in my workflow to be able to enter the "dates" in a usual format - and to get the labels adjusted automatically?

(view in My Videos) dt = Open( "$SAMPLE_DATA/Aircraft Incidents.jmp" ); d...
hogi

Discussions |
Jan 21, 2024 2:33 AM

849 views | 0 replies