JMP User Community

Latest Discussions

Need help getting a MATLAB structure as a JMP data table

I have the following JSL code where I call a MATLAB script, LTDmacroNew, and output a MATLAB structure, sensitivityResults. The MATLAB script saves a .mat file and generates some .png figures. JMP is connecting with MATLAB and doing all of that successfully, however it's only showing the first row of my structure. Here is the MATLAB structure with 12 fields/columns and 19 rows However, the JMP da...
thamilton

Discussions |
Oct 25, 2018 6:47 PM

2686 views | 1 replies
paneling multiple bar charts vertically with same categorical x-axis

so i want something like this:i'd prefer all the y-axis values to be on the same side and each y-axis is a seperate column of data and labeled seperately using the header of that column. the x-axis is categorical and the same for all panels. any ideas?
jac865

Discussions |
Oct 25, 2018 1:32 PM

5307 views | 1 replies
Import data from Excel from SAP, how to fill in blanks with the value above?

Often there are data tables in Excel or from SAP that do not repeat values down a column. This is not missing data. The data is implied from the last cell in the column that has a value. Is there a way to get JMP to fill in my imported data with those values?
BSwid

Discussions |
Oct 25, 2018 11:35 AM

10857 views | 5 replies
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

17854 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

3979 views | 3 replies

Previous
Next

Latest Discussions

Need help getting a MATLAB structure as a JMP data table

I have the following JSL code where I call a MATLAB script, LTDmacroNew, and output a MATLAB structure, sensitivityResults. The MATLAB script saves a .mat file and generates some .png figures. JMP is connecting with MATLAB and doing all of that successfully, however it's only showing the first row of my structure. Here is the MATLAB structure with 12 fields/columns and 19 rows However, the JMP da...
thamilton

Discussions |
Oct 25, 2018 6:47 PM

2686 views | 1 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

3979 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

14609 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

4879 views | 2 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

3681 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

2514 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

3511 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

2509 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

3094 views | 0 replies