JMP User Community

Latest Discussions

Transpose header data and concatenate files

I have a set of raw data csv files with metadata in the header that I want to concatenate and copy the header data into columns. I have been able to modify the "combine txt tables.jsl" script I found on this site to pull in the header data, transpose it and join it to the raw data table. The header data is contained within each raw data file on rows 2 through 29, and I transpose it to make the fir...
mlipsitz

Discussions |
Feb 15, 2019 5:13 AM

26442 views | 6 replies
Which table does For Each Row() apply to?

When using the FOR EACH ROW() command to step through each row in a table, does JMP just assume the Current Data Table? I've made a habit of issuing a Current Data Table("target_table") command prior to using the For Each Row(), just in case. I'm now wondering if this is necessary?
nikles

Discussions |
Feb 14, 2019 4:55 PM

5607 views | 2 replies
how to remove moving range, limits and center line in control chart by JSL?

For example, I have a table: T A B1 7 2
3 3 1
5 5 3and would like to plot 2 control chart on A and B vs T with some specs: :A<<Set Property( "Spec Limits", {LSL( 2 ), USL( 9 ), Target( 5.5 )} );
:B<<Set Property( "Spec Limits", {LSL( 0 ), USL( 2 ), Target( 4 )} );
dt=Current Data Table();
dt<< Control Chart Builder(
Variables(
Y(:A,:B),
Subgroup(T)
)
); Here what I get: How I can delect the moving range par...
jasongao

Discussions |
Feb 14, 2019 11:22 AM

7070 views | 4 replies
Cannot move or remove annotations on graph (JMP 14)

Graph was created using a saved script on the data table. Graph was modiliable, however, the text annotations are locked into place.Is there a simple way to unlock them if the graph size or axis ranges are changed? Alternately I can create new text annotations, but would need to delete the old ones. Thanks,Dave
dsoltz

Discussions |
Feb 14, 2019 10:19 AM

10296 views | 4 replies
Ways to draw a heart in JMP?

Here's one way to do it, using parametric equations found at Math World: Heart Curve. New Table( "heart", New Column( "t", Set Values( Index( 0, 2 * Pi(), 0.1 ) ) ), New Column( "x", Formula( 16 * Power( Sin(t), 3 ) ) ), New Column( "y", Formula( 13 * Cos(t) - 5 * Cos(2 * t) - 2 * Cos(3 * t) - Cos(4 * t) ) ) ); Graph Builder( Show Control Panel( 0 ), Variables( X( :x ), Y( :y ), Legend( 1...
XanGregg

Discussions |
Feb 14, 2019 9:18 AM

33447 views | 27 replies

Previous
Next

Latest Discussions

how to remove moving range, limits and center line in control chart by JSL?

For example, I have a table: T A B1 7 2
3 3 1
5 5 3and would like to plot 2 control chart on A and B vs T with some specs: :A<<Set Property( "Spec Limits", {LSL( 2 ), USL( 9 ), Target( 5.5 )} );
:B<<Set Property( "Spec Limits", {LSL( 0 ), USL( 2 ), Target( 4 )} );
dt=Current Data Table();
dt<< Control Chart Builder(
Variables(
Y(:A,:B),
Subgroup(T)
)
); Here what I get: How I can delect the moving range par...
jasongao

Discussions |
Feb 14, 2019 11:22 AM

7070 views | 4 replies
Add replicates of the same level for a DOE that include the quadratic

Hi, I want to create a DOE that will include replicates of the same level and that the model has interactions as well as quadratic for 4 factors out of 5. The reason why is that each run, you can obtain 3 independent results. I just want to know if with this approach the number of run will be n/3 becuase I will obtain 3 results in 1 run. Thank you, Vanessa
var3

Discussions |
Feb 14, 2019 8:45 AM

6098 views | 7 replies
Variability plot legend not linking to data table

I've been having an intermitant problem with adding legends to variability plots. Typically, before I plot I will assign row colors and markers within the data table. Then I make my varibility plot and add a row legend. I want it to use the marker and color assignments I've already added in my table, so I select "None" under Colors and Markers. Some of the times it does exactly what I want it to d...
Splicegirl43

Discussions |
Feb 14, 2019 3:13 AM

3357 views | 1 replies
Matched pair analysis comparing 4 groups

Hi there,we are facing some problems with matched pairs analysis right now.
Our situation:
4 groups with 16 patients each, the 1st patient of group 1 is matched to the 1st patient of group 2,3 and 4 and accordingly patients 2 -16 are matched.For each patient we have 58 metabolic regions that need to be compared within the 1st patients of all groups, the 2nd patients of all groups, and so on... Our q...
Hailey

Discussions |
Feb 14, 2019 1:33 AM

2702 views | 1 replies
Count how many time Y is greater than N

Is there a formula that can be used to determine the number of rows that contain a value greater than a predetermined number, like > 65%? I guess it would be similar to a countif formula in excel. I want to count if the value is greater than 65%. Thank you
ark1019

Discussions |
Feb 13, 2019 4:36 PM

14715 views | 7 replies

Previous
Next

Latest Discussions

Beta Generalized Regression and adjusted chi-square values

I have a data set from a two-choice rodent feeding trial. We were testing the effectiveness of 10 deterrents by coating them on seeds and offering them to rodents alongside control seeds that were uncoated. The explanatory variable is which of the 10 deterrents the treatment seed was coated with, and the response variable is the proportion of control seed and treatment seed consumed. The question...
Mananahi

Discussions |
Feb 13, 2019 9:58 AM

2382 views | 0 replies
DF Dens for repeated measures ANOVAs

Dear JMP Community, When I run repeated measures ANOVAs with JMP (RMS, with Subject as a random factor), I have noticed that when a certain factor is crossed with Subject, the corresponding DF Den stays independent while the DF Dens for the other factors are put together as “Residual”. Please see Images 1-3 of the attached file on how “DF Den” under “Test Denominator Synthesis” change across imag...
mu

Discussions |
Feb 6, 2019 8:10 AM

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

3419 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

2558 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

3235 views | 0 replies