JMP User Community

Latest Discussions

Creating a new colunm with max values of another column for each month

Hello community, I would like to create an extra colunm as in the example below. The result is the max of the volume of data per month. I have tried to do it with "group by" of the :month column and then use the "max()" function from the formula option but no sucess. Anyone has an idea to create this extra colunm without going to summary and merge. thanks!!
jmit

Discussions |
Jun 1, 2025 8:24 AM

1519 views | 4 replies
Make IMF function more efficient.

I have thousands of file like the attached example (.CSV). Time information is in raw 102 and my measurement data start at raw 242. Currently I am doing Importing file 2 times, one for Time information and one for test data. After that I use update function to import time information to test data table. This logic was working with small set of files but it is not efficient on large number of ...
ConfidenceOwl94

Discussions |
May 31, 2025 7:12 AM

1328 views | 5 replies
How can I arrange the unique values obtained from a column in the order they appear in the original column?

When looking for unique values in a column, `summarize()` is often used. However, the values outputted by `summarize()` are sorted, and the output in following JSL would look like this: {"64", "67", "74",..., "172"}. I would like the output to be arranged in the order they appear in the column, for example: {"95", "123", "74",...}. What modification should I make to achieve this result? Names D...
BabyDoragon

Discussions |
May 31, 2025 7:11 AM

793 views | 3 replies
How to Evaluate DOE Design

Hi all, I’m working on a DOE with the following factors: 1 categorical variable with 4 levels 2 continuous variables Before running the experiments, I want to know how to evaluate my design to ensure that I can: Confidently identify which variables have the most influence on the response Determine which specific levels of the variables perform better Also, I don’t want to do just the minima...
PredictorCHAID1

Discussions |
May 30, 2025 8:07 AM

1034 views | 4 replies
Second Degree Polynomial Parameter Script

Hi All, I have a data set (x and y) that I need to approximate to the 2nd degree polynomial (ax2+bx+c) and report "a" value in the "a"-column. Is there a potential script for this? Please see JMP table attached. Thank you All!
Alex19

Discussions |
May 30, 2025 7:59 AM

600 views | 2 replies

Previous
Next

Latest Discussions

Make IMF function more efficient.

I have thousands of file like the attached example (.CSV). Time information is in raw 102 and my measurement data start at raw 242. Currently I am doing Importing file 2 times, one for Time information and one for test data. After that I use update function to import time information to test data table. This logic was working with small set of files but it is not efficient on large number of ...
ConfidenceOwl94

Discussions |
May 31, 2025 7:12 AM

1328 views | 5 replies
How can I arrange the unique values obtained from a column in the order they appear in the original column?

When looking for unique values in a column, `summarize()` is often used. However, the values outputted by `summarize()` are sorted, and the output in following JSL would look like this: {"64", "67", "74",..., "172"}. I would like the output to be arranged in the order they appear in the column, for example: {"95", "123", "74",...}. What modification should I make to achieve this result? Names D...
BabyDoragon

Discussions |
May 31, 2025 7:11 AM

793 views | 3 replies
How to Evaluate DOE Design

Hi all, I’m working on a DOE with the following factors: 1 categorical variable with 4 levels 2 continuous variables Before running the experiments, I want to know how to evaluate my design to ensure that I can: Confidently identify which variables have the most influence on the response Determine which specific levels of the variables perform better Also, I don’t want to do just the minima...
PredictorCHAID1

Discussions |
May 30, 2025 8:07 AM

1034 views | 4 replies
Second Degree Polynomial Parameter Script

Hi All, I have a data set (x and y) that I need to approximate to the 2nd degree polynomial (ax2+bx+c) and report "a" value in the "a"-column. Is there a potential script for this? Please see JMP table attached. Thank you All!
Alex19

Discussions |
May 30, 2025 7:59 AM

600 views | 2 replies
Dario Schiraldi : How can I use JMP to analyze and integrate travel data from different sources into my website?

Hello everyone,
I’m Dario Schiraldi, CEO of Travel Works from Dubai. I’m looking to use JMP to analyze and integrate travel data from multiple sources like flights, hotels, and car, rentals into my website to enhance my online business presence. Can anyone suggest the best approach or tools within JMP to integrate these different data sources efficiently? I’m eager to learn how to use JMP for bette...
darioschiraldi1

Discussions |
May 30, 2025 2:44 AM

875 views | 4 replies

Previous
Next

Latest Discussions

Testing slices in JMP Pro Mixed Model?

Hello, I am doing a 4-way, full factorial ANOVA with one repeated measures factor (time, 3 samplings) and three between-subject factors (species, color, and irrigation; 2 levels of each) using the Mixed Model personality in JMP Pro 18.1.0. I'm using the AR(1) repeated covariance structure, as it provides the best fit based on AICc values. The analysis indicates I have no significant 4- or 3-way in...
JHS

Discussions |
May 7, 2025 7:38 AM

666 views | 0 replies
Help with Multiple Linear Regression
LogitParrot179

Discussions |
Apr 23, 2025 7:58 PM

583 views | 0 replies
when does model reduction lead to the problem of multiple comparisons?

My interest is in identifying the strongest predictors of annual per capita growth rate for three groups of bird species: residents, short-distance migrants and long-distance migrants. My model has per capita growth rate as the dependent variable, and as predictors bird density during the breeding season, and 13 environmental predictors (various measures of climate, food abundance and nest predat...
olddabbler

Discussions |
Apr 21, 2025 5:56 AM

570 views | 0 replies
steps to use the minimum p-value approach with log-rank test?

I am interested in applying the minimum p-value approach using the p-values obtained from the log-rank test. However, I am uncertain about the specific steps involved. Could you kindly advise me on how to proceed? I am currently using the following version: JMP® Student Edition 18.2.0, running on Microsoft Windows 11 Home.
Namamugi

Discussions |
Apr 10, 2025 11:22 PM

576 views | 0 replies
Discovery summit book signings - official list of books?

Fellow JMP enthusiasts! During the 2024 Manchester Discovery Summit I was surprised to learn that the handing out and signing of books is a tradition. So, I am wondering whether there is a list of the books handed out & signed so far. If it exists, where to find it?I thoroughly enjoyed reading "Bitch" by Lucy Cooke, and I have a feeling "Hello World" by Hannah Frey will be a good read too.
Ressel

Discussions |
Feb 28, 2025 11:25 AM

493 views | 0 replies