JMP User Community

Latest Discussions

Column Formula to display difference between two rows of another column

My data set is-

Vg Ig Igs
0 1 1
1 5 4
2 7 2
3 3 -4

I would like to create column Igs which is difference between current row and previous row in the column Ig. Is it possible script something like this in jmp.

Thank you

Chivukula
chivukula

Discussions |
Feb 1, 2019 6:14 PM

22752 views | 7 replies
Adding Images to A Data Table From a Directory

Friends, I am running JMP12 and I would like to add a series of PNG images to my data table. I would like to do this so that I can use them as labels on a scatterplot of statistical mean-matching flags and invoke the PNG (an image of a control limit chart) by hovering the mouse over the value of each flag. I found an SAS video by Gail Massari importing state bird pictures from a wikipedia web UR...
RSantana

Discussions |
Feb 1, 2019 1:50 PM

17881 views | 8 replies
Skip lines of script if the table is empty.

I am quering a database that currently does not yet have the information that I am quering but will in the near future. So right now I get an empty table. I would like to add the functionality to skip certain lines in my code that pertain to the empty table and move on with the remaining part of my code that deals with other data sources. Can someone give me a way to check if the table is empty...
wjalford

Discussions |
Feb 1, 2019 12:24 PM

7000 views | 3 replies
Adding unit to Y-axis of a variability chart

I have a set of test items test across 80 devices. I am plotting the variability chart, i want to add the unit in to Y axis. I have the units in a diferent column. Column name is the default label set. Is there a way to add the units in to the label? any scripts available? attached is the sample sheet and sample format of outout i want.
Vmuthu

Discussions |
Feb 1, 2019 10:21 AM

19184 views | 7 replies
Huge DF denominators for repeated measures ANOVAs with JMP 14

I used to run repeated measures ANOVAs with JMP 13 with no proglems. But now I got JMP 14 and ran an ANOVA with the same data and somehow got "4326" as a DF Den under "Test Denominator Synthesis". This used to be "42" with JMP 13, and ovbiously the new F ratio got so much larger. I do not think there is anything different I did (data, how to set up), other than I am now using JMP 14 instead of ...
mu

Discussions |
Feb 1, 2019 8:45 AM

15070 views | 15 replies

Previous
Next

Latest Discussions

Huge DF denominators for repeated measures ANOVAs with JMP 14

I used to run repeated measures ANOVAs with JMP 13 with no proglems. But now I got JMP 14 and ran an ANOVA with the same data and somehow got "4326" as a DF Den under "Test Denominator Synthesis". This used to be "42" with JMP 13, and ovbiously the new F ratio got so much larger. I do not think there is anything different I did (data, how to set up), other than I am now using JMP 14 instead of ...
mu

Discussions |
Feb 1, 2019 8:45 AM

15070 views | 15 replies
How to change mosaic plot graph order?

Hey Folks, I was just wondering how to change the order of the data displayed in the mosaic charts. In the picture below, say I would like to change the order of the data to be displayed as blue at the top, or orange goes to the bottom. Thanks in Advance, Thomas
ThomasLovesRedV

Discussions |
Jan 31, 2019 9:28 PM

5774 views | 1 replies
Partition and Pruning

I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
NG

Discussions |
Jan 30, 2019 8:25 AM

3245 views | 0 replies
Editing Color Gradient Scale Using JSL

Hi All, I have this data table for example test = Graph Builder( Variables( X( :X ), Y( :Y ), Color( :Value ) ), Elements( Points( X, Y, Legend( 23 ) ) ), SendToReport( Dispatch( {}, "400", ScaleBox, {Legend Model( 23, Properties( 0, {gradient( {Scale Values( [-2 2] ), Label Format( "Fixed Dec", 15, 3 )} )}, Item ID( "Value", 1 ) ) )} )...
bittnere

Discussions |
Jan 30, 2019 8:02 AM

7213 views | 4 replies
verifying 95% exact binomial confidence in JMP - Lower CI OK but Upper not?

Hi,I would like to ask if somebody has encounter the issue I got. I would like to verify the 95% CI for a case as below in the table. 95% Confidence Intervals for the True Rate at all Possible Observed Rates within a Subgroup (n=15)Observed Rate Lower Bound 95% CIUpper Bound 95% CI5/150.1520.723 I used JMP Analyze/Distribution and got the correct Lower CI (0.151763 which verifies 0.152 in the tabl...
konradkk

Discussions |
Jan 29, 2019 7:18 AM

5209 views | 4 replies

Previous
Next

Latest Discussions

Partition and Pruning

I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
NG

Discussions |
Jan 30, 2019 8:25 AM

3245 views | 0 replies
I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2412 views | 0 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3111 views | 0 replies
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

3437 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

2327 views | 0 replies