JMP User Community

Latest Discussions

Median for all columns

Hi All, Is there an easier way to calculate median of all the columns, rather than getting the summary in different tables and then joining all the data tables together? I have like 200 columns that I need to calculate the median from. I appreciate all the comments and suggestions. for(r=1,r<=N Items(List),r++, Summary( Group( :Mask, :Lot,:Workweek ), Median( Column(dt,List[r]) ), Freq( "Non...
vishwasanj

Discussions |
Sep 17, 2018 1:05 PM

15574 views | 5 replies
API Access to AWS Database

I’m trying to access a database using the new API request feature in JMP ( I’m using 14.1) and I’m having trouble understanding what is required to connect to the database. I’m trying to access amazon cloud ( AWS) at the following location deawdoraisap001.xxxxxxxxxxxx.eu-central-1.rds.amazonaws.comusername is dbarnettpassword is Password_123 ( obviously it isn’t this so it’s just an example) Could...
d_barnett

Discussions |
Sep 17, 2018 11:34 AM

3854 views | 1 replies
How to overlap points with the same/ very close values in a graph?

Hello!A quick question, as the title suggests, how can I overlay points with the same value or close values ( e.g., a difference smaller than 0.1) in a graph?For example, in the following situtation I want to keep only one point for each small range of values, and therefore lose the observed horizontality of points. Thank you very much in advance.
Natalia_Castelo

Discussions |
Sep 17, 2018 10:59 AM

3658 views | 2 replies
how to extract string between specific pattern using regexp?

Hi,
I am new to regex, i need to extract the name of users from their id, for example:
I have the following long string
123450_dan; 154396_kelli; 198756_dev;
Result need to be: dan
What regex do i need to use in order to extract the name dan which have the id 123450?

Thanks in advance.

Shlomizr

Discussions |
Sep 16, 2018 11:34 PM

17135 views | 9 replies
Using a script, how do I set the text of a table script in a button box in a journal file?

Using a script, I need to construct a completely self-contained journal file with button boxes that reproduce data tables. In the production application, there will be many headings (each representing a part), and each heading will have several button boxes beneath it, each showing a different data table associated with the part. Because of the complex calculations that go into constructing the ...
marie_gaudard

Discussions |
Sep 15, 2018 3:38 AM

13547 views | 7 replies

Previous
Next

Latest Discussions

API Access to AWS Database

I’m trying to access a database using the new API request feature in JMP ( I’m using 14.1) and I’m having trouble understanding what is required to connect to the database. I’m trying to access amazon cloud ( AWS) at the following location deawdoraisap001.xxxxxxxxxxxx.eu-central-1.rds.amazonaws.comusername is dbarnettpassword is Password_123 ( obviously it isn’t this so it’s just an example) Could...
d_barnett

Discussions |
Sep 17, 2018 11:34 AM

3854 views | 1 replies
How to overlap points with the same/ very close values in a graph?

Hello!A quick question, as the title suggests, how can I overlay points with the same value or close values ( e.g., a difference smaller than 0.1) in a graph?For example, in the following situtation I want to keep only one point for each small range of values, and therefore lose the observed horizontality of points. Thank you very much in advance.
Natalia_Castelo

Discussions |
Sep 17, 2018 10:59 AM

3658 views | 2 replies
Have means, standard deviation, min, and max data for various groups. How to do statistical tests?

Hello, I have multiple groups which each have a mean, min, standard deivation and max value. I don't know how many samples there were. How would I do statistical tests such as ANOVA with this data set?
TUStudent

Discussions |
Sep 15, 2018 1:04 AM

5371 views | 2 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2456 views | 0 replies
JSL: What to use for new columns, Formula or Set Each Value? Pros and Cons?

Hi All,Can anyone highlight what are the differences between using "Formula" and "Set Each Value"? What are the pros and cons?
ram

Discussions |
Sep 14, 2018 6:34 AM

8118 views | 5 replies

Previous
Next

Latest Discussions

Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2456 views | 0 replies
repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3434 views | 0 replies
Time Series - Prewhiten

Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
nopon649

Discussions |
Jun 7, 2018 11:10 PM

2469 views | 0 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

3023 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

1849 views | 0 replies