Welcome to the JMP User Community!
Ask questions, get answers, meet other JMP usersLearning Resources
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesLatest Discussions
-
open xls data
I have a tab in xls sheet wich combines data from different xls tabs into one which I try to open via jsl for further data processing in jmp. When I use the open function the data downloaded into jmp is wrong. Either no values are copied into jmp are fake dates (1900s). However, when I use xls add in from jmp to convert table into jmp table I get the correct data. Is there a method to change the ...
SC1
6670 views | 7 replies -
Sample Size and Power Calculation
Hi All, I'm seeking help on how to determine the statistically correct sample to be used for my experiment.Below is the scenario and given data: Hypothesis: The new chemical Z used in process A has no significant difference in Process Sigma A.Matrix: I have 3 cells to be evaluatedCell 1: POR , Chemical XCell 2: Chemical Z1 (certain concentration)Cell 3: Chemical Z2 (certain concentration) Process ...
switzal87
4275 views | 1 replies -
Open file using batch script
I have a linux application that generates text data tables that we study with JMP. I'd like to be able to open these files in JMP with a hotkey. I was thinking of writing the filename to a standard location, then using a batch script to open the file in the currently-running JMP. I've tried a batch file with this: FOR /F "tokens=*" %%I IN (\\server\path\to\file\with\path\to\text\file\to\open) DO ...
BHarris
4186 views | 1 replies -
Post processing of data in a csv file using script
I have a folder with mutiple csv files having similar data structure whose data I need to process and store the results in a new file.
Each csv file has 2 columns, I need to process the data in the second column as follows:Name the second column as itemsPerform the following operation on all rows creating a new column x with the following formula :36 + -19.5 * :items+ 49.99 *:items* :items* :items...jojmp
10659 views | 5 replies -
Renaming Data Table using a previous table name
I know I can rename a table using dt << SetName("FirstTablename"); But say I'd like to rename a 2nd data table that concatenates the name of the 1st data table so that it is something likedt2 << SetName( Nameof1stTable || " 2"); Does anyone know how I could just name a 2nd table with an appended character? The reason I want to do this is that usually I modify multiple tables in JSL with splits and...
bioptical
4434 views | 1 replies
Latest Discussions
-
Sample Size and Power Calculation
Hi All, I'm seeking help on how to determine the statistically correct sample to be used for my experiment.Below is the scenario and given data: Hypothesis: The new chemical Z used in process A has no significant difference in Process Sigma A.Matrix: I have 3 cells to be evaluatedCell 1: POR , Chemical XCell 2: Chemical Z1 (certain concentration)Cell 3: Chemical Z2 (certain concentration) Process ...
4275 views | 1 replies -
Ternary plot and background grid issue with JMP 14
Hello,Since I moved to JMP 14 I have this issue when plotting ternary plots with Contour fill: a grid is systematically drawn with thin white horizontal and vertical lines (see captures), whatever the Color theme chosen for the Contour fill. This issue was not present in my previous JMP versions until JMP 13. Any idea to remove these thin white horizontal and vertical lines? I can't manage to remo...
dp30
5512 views | 4 replies -
Select Where(Contains()) Usage
I often find that the Contains() function inside the Select Where() function can be convenient. What if I would like to select all rows where a designated column contains the string "a" when it is followed by a number? For example, in a column with the values "a", "a12", and "absent", only the row with "a12" would be selected. Thanks for any tips!
twillkickers
10188 views | 3 replies -
How to set color scale for a contour plot
and if I have several plots by page, how to set the different scale for each of them? Thanks a lot!
3186 views | 1 replies -
Get Selected Rows results in error, when using the rows
Hey,i can´t figure out, why the following results in an error:
For( i = 1, i <= N Items(list), i++, item = list[i]; rows = dt << Get Rows Where( dt:foo == item ); Column(dt, "bar" )[rows] = "foobar"; );The error is: "Cannot set value for the column 'bar' because the row number (-1) is not valid.{941}" Can anyone enlighten me? Thank you!
vkessler
5564 views | 5 replies
Latest Discussions
-
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
2257 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
2962 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
3261 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
2103 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
2994 views | 0 replies
JMP Events
-
ChinaShanghai May 29
-
1:00PM - 2:30PM EDTApr 16Jump into DOE: Hands-on Workshop
Jump into DOE Wednesday, April 16 | Live Web Workshop1:00 p.m. – 2:30 p.m. ET Hosted via Zoom...
-
12:00PM - 1:00PM EDTApr 17JMP for Teaching Statistics in Semiconductor Engineering Education
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp-for-teaching-stat-semicon...
-
1:00PM - 2:00PM EDTApr 25Getting Started with JMP
New JMP users will learn how to: Easily navigate JMP using the JMP Starter. Import all types o...
-
3:00PM - 4:00PM CESTApr 30Scripters Club: Is Your SPC Doing Well?
Is Your SPC Doing Well? Presenter: Georg Raming (Siltronic) Would you like to keep an eye on many SP...
