JMP User Community

Latest Discussions

JMP Excel File Import - Can I ignore columns in the Excel file?

Either in the import wizard or in the import script (data source script) can I write script that ignores certain columns so that it is not imported from the source file to the JMP file?
BSwid

Discussions |
Oct 19, 2018 8:23 PM

7314 views | 3 replies
JSL Script Continue Sequence to End of Table

Hi, I am new to JSL script. Can anyone teach me how to write the script for below option, "Continue sequence to end of table". I would like to automate this process. I only able to find script to key in the first three rows as below: dt << New Column("Time","Continuous", Set Values([1,2,3])); Then not sure how to automate it if I want to Continue sequence to end of table.
ReginaHong

Discussions |
Oct 19, 2018 8:55 AM

6979 views | 2 replies
How to look at variability in this data

We did measurements in duplicate 96-well plates (so 96 different samples equally split into two plate). We want to estimate variability between the plates. It seems to me that there are two important sources of variability, one related to time since one plate was measured at a different time and so all samples probably degraded equally in that plate and another related to other differences betwee...
tnad

Discussions |
Oct 18, 2018 12:33 PM

11705 views | 6 replies
How to save predicted values into matrix or list without saving into existing data table

Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); obj = Bivariate( Y( :Weight ), X( :Height ) )<<Group by(:sex);; obj<<Fit spline(0.1, Standardized,{Save Predicteds});tried lis below , it won't work.val_predict_ls=obj<<Save Predicteds.
wu

Discussions |
Oct 18, 2018 10:34 AM

4827 views | 2 replies
Trouble with time separators

We're having some difficulties with time formats when importing data. In our lab, we have a pool of computers with either Win7 or Win10 with varying settings regarding time formats. This seems to cause issues when attempting to import data with timestamp to JMP12 and 14. Our timestamps have the format yyyy-mm-dd hh:mm:ss (e.g. 2018-08-24 13:39:27) and depending on which computer we test, the impor...
timovalta0

Discussions |
Oct 18, 2018 3:33 AM

11607 views | 9 replies

Previous
Next

Latest Discussions

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

5147 views | 5 replies
How to use scrollBox

Hello,I put a few strings in a scroll box in view of selecting one and using it later in the script...But I see no way to get the string that is selected by the user.Example: in the following script we get a list of strings "first Item", "Second Item", ...Once the user selects the "Second Item", how can I extract this information ?Thanks a lot.Names Default To Here( 1 ); win = New Window( "Example...
samir

Discussions |
Oct 16, 2018 8:50 AM

4386 views | 2 replies
How to select columns with same values

Hello,How to select columns with same values (continues and nominal)?Thanks,Assaf
Assaf1

Discussions |
Oct 15, 2018 10:27 AM

8391 views | 7 replies
How do I change the size of the x-axis labels in the Fit Y to X (Oneway) Platform?

I have a script that generates the graph below:While I was able to right-click onn the Y-axis to change the font size, doing the same on the X-axis only provides the following options:Rotated Tick LabelsTick Marks ▸Lower FrameEdit ▸So there is no Axis Settings… or Font… option that will allow me to change the X-axis labels to the size I want. As I am generating these graphs from scripts, I figure ...
mdawson69

Discussions |
Oct 15, 2018 10:03 AM

18982 views | 9 replies
Variability Chart

Hi, I have a variabilty chart with 100 lots. I was wondering how can I order the lots by starttime? If variabilty chart is not the best to show this, what would you recommend? This lots are also broken down by different blends. The x grouping is lots then blend. Thank you,Rami
rshehadah

Discussions |
Oct 12, 2018 2:47 PM

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