JMP User Community

Latest Discussions

Find rows that contains specific text

All, I got stuck on a seemingly easy step. My table is compiled from multiple CSV files. Where those files were previously concatenated, there is one service row that is empty except first three columns where it says something like "### Switching Logging: datetime" in the first column and then from which file in second coumn and to what file in third column. So, a trash row that I want to delete. ...
miguello

Discussions |
Feb 15, 2019 2:01 PM

11159 views | 6 replies
ROC curve, probability , cut off

Hi, How do I find the cut off value from the probaility on the ROC. I had to adjust to get a better AUC. Thanks
Cartica

Discussions |
Feb 15, 2019 6:54 AM

6421 views | 2 replies
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

26603 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

5661 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

7179 views | 4 replies

Previous
Next

Latest Discussions

ROC curve, probability , cut off

Hi, How do I find the cut off value from the probaility on the ROC. I had to adjust to get a better AUC. Thanks
Cartica

Discussions |
Feb 15, 2019 6:54 AM

6421 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

7179 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

6217 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

3410 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

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

2425 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

4183 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

3467 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

2596 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

3253 views | 0 replies