JMP User Community

Latest Discussions

Formula for combining columns?

I would like to combine 2 numeric column data with a delimiter. First I used cancat function with a third concat character but it seems the columns to be character. I used the char function but the result is obvious if you look at Column "Column". Column Utilities "Combine Colums" make the thing perfectly but it does not implement the formula inside the column properties so no automation. I have t...
saitcopuroglu

Discussions |
Oct 25, 2018 10:50 AM

17867 views | 4 replies
How to use max among several column with "get rows where" condition

It seems an easy question but I'm struggling to solve it...I have this kind of data table : It goes until 64 which is the parameter "dim" in my script.I'm looking for the maximum and minimum of all median_range_mm 1, 2 , 3 ... until 64. But I don't want JMP to look at rows where target_status is different of 5 or 9.As you can see, when target status is 10 it overranges at 39996.It is easier to ...
Rob128

Discussions |
Oct 25, 2018 1:47 AM

3986 views | 3 replies
closing all data tables but leave one open for further analysis

Hi All This is a follow up on the post: https://community.jmp.com/t5/Discussions/JSL-How-to-close-data-tables-after-analysis/m-p/36739 However, I have encountered an error on my script while running JSL Debgger. DontClose = ("dt4"); // Example names of tables you want to leave // Loop backwards through the list, so the table numbers do not change For( i = N Table(), i >= 0, i--, If( Contains(...
ivomdb

Discussions |
Oct 24, 2018 5:13 AM

14613 views | 7 replies
Outliers in data

Hi, Is there a way in JMP to label outliers in a dataset. For example, I have 100 lots and I want to label the units that are observered on the lower side of the distrubution. I dont care if the outliers perform better than the distrubution, I am more intersted in the lower ones. In other words for example, I have a lot with 100 units, 1 or 2 units are outliers. How can I label those units? Than...
rshehadah

Discussions |
Oct 23, 2018 4:04 PM

8595 views | 3 replies
Transforming skewed count data for analysis

Hi Everyone,I have some heavily skewed count data that I'd like to use to build a model. The data looks much better with a log transform shape wise but being count data, there's an abundance of zeros that won't work with a log model. From reading online, I should be using something like a Poisson distribution but I am not sure how to do so with JMP? Any guidance would be appreciated, thank you...
KD

Discussions |
Oct 23, 2018 11:37 AM

6917 views | 3 replies

Previous
Next

Latest Discussions

How to use max among several column with "get rows where" condition

It seems an easy question but I'm struggling to solve it...I have this kind of data table : It goes until 64 which is the parameter "dim" in my script.I'm looking for the maximum and minimum of all median_range_mm 1, 2 , 3 ... until 64. But I don't want JMP to look at rows where target_status is different of 5 or 9.As you can see, when target status is 10 it overranges at 39996.It is easier to ...
Rob128

Discussions |
Oct 25, 2018 1:47 AM

3986 views | 3 replies
closing all data tables but leave one open for further analysis

Hi All This is a follow up on the post: https://community.jmp.com/t5/Discussions/JSL-How-to-close-data-tables-after-analysis/m-p/36739 However, I have encountered an error on my script while running JSL Debgger. DontClose = ("dt4"); // Example names of tables you want to leave // Loop backwards through the list, so the table numbers do not change For( i = N Table(), i >= 0, i--, If( Contains(...
ivomdb

Discussions |
Oct 24, 2018 5:13 AM

14613 views | 7 replies
Outliers in data

Hi, Is there a way in JMP to label outliers in a dataset. For example, I have 100 lots and I want to label the units that are observered on the lower side of the distrubution. I dont care if the outliers perform better than the distrubution, I am more intersted in the lower ones. In other words for example, I have a lot with 100 units, 1 or 2 units are outliers. How can I label those units? Than...
rshehadah

Discussions |
Oct 23, 2018 4:04 PM

8595 views | 3 replies
what's the Marginal Model Plots use for?

what's the Marginal Model Plots use for ?how to explain it ?
zijuanchen

Discussions |
Oct 22, 2018 8:09 AM

4886 views | 2 replies
Confidence Interval for Defect Rate in Simulator

Hello, I am wondering how to obtain a confidence interval on the defect rate (in proportion or ppm units) for a response in the Simulator feature of Fit Model-->Prediction Profiler. Thank you!
SQC

Discussions |
Oct 17, 2018 7:14 AM

5161 views | 5 replies

Previous
Next

Latest Discussions

how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

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

2515 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

3513 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

2510 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

3097 views | 0 replies