cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest 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 SC1
    Discussions |
    Jan 23, 2019 6:01 AM
    6570 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 switzal87
    Discussions |
    Jan 23, 2019 1:04 AM
    4235 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 BHarris
    Discussions |
    Jan 22, 2019 11:05 AM
    4147 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 jojmp
    Discussions |
    Jan 21, 2019 7:58 PM
    10518 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 bioptical
    Discussions |
    Jan 21, 2019 9:38 AM
    4404 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 ...

    switzal87 switzal87
    Discussions |
    Jan 23, 2019 1:04 AM
    4235 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 dp30
    Discussions |
    Jan 18, 2019 1:16 PM
    5430 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 twillkickers
    Discussions |
    Jan 18, 2019 10:33 AM
    10098 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! 

    jasongao jasongao
    Discussions |
    Jan 17, 2019 5:14 PM
    3146 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 vkessler
    Discussions |
    Jan 17, 2019 9:55 AM
    5492 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 gene
    Discussions |
    Nov 2, 2018 7:43 AM
    2234 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 Vball247
    Discussions |
    Oct 29, 2018 2:18 PM
    2931 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 Yu
    Discussions |
    Sep 25, 2018 2:34 AM
    3242 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 jfranc19
    Discussions |
    Sep 14, 2018 2:35 PM
    2080 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 Reinaldo
    Discussions |
    Jun 18, 2018 6:31 AM
    2956 views | 0 replies
view all discussions