JMP User Community

Latest Discussions

Formula to return value from a row, where row is the Maximum value from a different column

Hi, I am looking for a formula that does the following: 1) Evaluates the maximum value of a column, by a Grouping Column2) Once the largest value is found for each "group", I need to return the value in another column corresponding to that row for each "group". Is this possible? This would be so easy in Excel. =( Example below. Thanks a million GroupingColumn for ReturnColumn to Eval MaxO...
M0gAl0g

Discussions |
Jun 6, 2018 5:59 PM

6568 views | 2 replies
Trouble formatting date from DMY to MDY

Hi, I'm using JMP 12 and trying to change my date column from d/m/y to m/d/y, but the format does not seem to be working. It just keeps the date as 04/06/2018 instead of changing it to 06/04/2018. Ultimately, I want to be able to use the date in m/d/y to convert it into the day of year. Is there any way to fix this issue or another way to change the date from d/m/y to m/d/y? Thank you!
JMP_Student

Discussions |
Jun 6, 2018 12:04 PM

5344 views | 2 replies
Removing Duplicate Rows from Current Table

Hi, I have 256k rows in a parent table right now. While doing some analysis, I found out I have few duplicate rows. This table constantly gets new data ammended through script. And there is chance source data may have duplicate again. So I am trying to create a clean up script, that i can run before executing some of my analysis. I searched other discussions here and found a solution (https:/...
NilD

Discussions |
Jun 6, 2018 9:30 AM

8858 views | 4 replies
IR chart 4 sigma control limits

Hi, When we make a IR control chart the UCL and LCL are based on 'mean + 3 sigma' limits. Is there anyway to increase the limits to 'mean + 4 sigma'? thanks
tahirawan11

Discussions |
Jun 6, 2018 5:33 AM

4906 views | 1 replies
Cox mixture estimates and Profiler

Martin here: Recently I did one cementitous adhesives with 4 factors (CSA cement, OPC cement, retarder, accelerator), one reponse (adhesion).See the attached JMP design. I am prettty happy with the results. Lou advsed me before to focus on Cox mixture and profiler. Estimate in Cox mixture model represnt the slope of the curves in profiler, it appears to me CSA and OPC all show maximum valueat cer...
MartinY

Discussions |
Jun 5, 2018 10:06 PM

5614 views | 2 replies

Previous
Next

Latest Discussions

Trouble formatting date from DMY to MDY

Hi, I'm using JMP 12 and trying to change my date column from d/m/y to m/d/y, but the format does not seem to be working. It just keeps the date as 04/06/2018 instead of changing it to 06/04/2018. Ultimately, I want to be able to use the date in m/d/y to convert it into the day of year. Is there any way to fix this issue or another way to change the date from d/m/y to m/d/y? Thank you!
JMP_Student

Discussions |
Jun 6, 2018 12:04 PM

5344 views | 2 replies
Fit Spline By Group: Save Spline Coefficients to Column?

Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
M0gAl0g

Discussions |
Jun 5, 2018 3:19 PM

2840 views | 0 replies
Help needed! How to automatize control chart building

Dear users,I need your help in using JMP to build up control charts. Right now we have all data on excel spreadsheets updated daily (every day is 1 line more on Excel representing the datapoints of the day) and I want to make out of this data a I-MR chart.Here below my requirements:data out of an Excel spreadsheet possibly imported automatically to JMPfixed control limits to be updated only when n...
js1985

Discussions |
Jun 5, 2018 1:51 PM

5687 views | 7 replies
Creating a Variable

I have an issue while creating an overall measure of time. I have attached a screenshot that shows what the data looks like thus far. I need to now create a variable that is called "time in trial" where I basically take the "Nback start" minus the "Nback stop." More specifically I would need several things to happen. 1. When "Nback # of letters presented" equals 1 the "time in trial" should equal ...
tlsimons

Discussions |
Jun 5, 2018 7:59 AM

2382 views | 1 replies
Conditional formatting in a data table

Hello, I'm trying to apply conditional formula for columns in order to apply cell color but I can't achieve successful result. Any suggestions how to do it? I believe I am using wrong formula here. Example: ColumnsUV UV to reject0.15 0.15 Formula: If( :UV == :UV to reject,
Color Of( "Red" ),
"White"
) Idea is that JMP highlights the cell in color red if the value is equal to...
robertasme

Discussions |
Jun 3, 2018 2:38 PM

5500 views | 5 replies

Previous
Next

Latest Discussions

Fit Spline By Group: Save Spline Coefficients to Column?

Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
M0gAl0g

Discussions |
Jun 5, 2018 3:19 PM

2840 views | 0 replies
Why does Profiler not stop

All,
I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this. I am using JMP 13.
uday_guntupalli

Discussions |
Apr 27, 2018 7:12 AM

1710 views | 0 replies
P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

3808 views | 0 replies
Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column

Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...
Picard

Discussions |
Mar 15, 2018 1:57 PM

2630 views | 0 replies
pseudo r square in JMP choice model platform

Hi,I am using JMP's choice model platform to analyse some Discrete Choice Experiment (DCE) data. I am trying to find the pseudo r square but the platform does not provide it. Is there a way to calculate pseudo r square based on the results JMP presents under the choice model platform? I know pseudo R square comes up as entropy RSquare under JMP's fit model platform, nominal logistic fir for respon...
DG

Discussions |
Mar 11, 2018 6:27 AM

2256 views | 0 replies