cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace

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

  • How can I select rows based on multiple conditions for the same ID?

    Hello, I need assistance in cleaning up some data. The data in the table contain multiple IDs, dates, and categories. I am interested in IDs with category 1 and 2, or 1 and 2 and 3, or 1 and 3, while retaining only the entries with the maximum date for each category. Could you please provide the best script for this solution? Thank you!IDcategorydatecostAcostBcostCcostD111/21/16500003000500111/21/...

    doraemengs doraemengs
    Discussions |
    Mar 26, 2024 10:04 PM
    1435 views | 4 replies
  • calculate the total percentage of outliers for a process of several properties combined

    I am trying to calculate total yield of a process. The process will decide several properties of a product. For any one of the product that comes out from this process, if any one of these properties falls outside the limits we target for,  then this product should be counted as a outlier. I found it convenient to calculate the outliers for each of the single property alone, but I did not find a w...

    gfke gfke
    Discussions |
    Mar 26, 2024 5:06 PM
    1473 views | 6 replies
  • Clarification on Categorizing the Same ID in Rows with Other Columns

     Hi,
    I have a dataset where the same ID appears in multiple rows, each with 1 to 3 categories. The columns range from costA to costZ, and I need to consolidate them into a single "Cost" column. My goal is to group by Category 1 according to specific criteria (1 if Category 1 < 2000, 2 if Category 1 = 2000 - 4000, 3 if Category 1 = 4000 - 6000, 4 if Category 1 = 6000 - 10000, 5 if Category 1 > 10000...

    doraemengs doraemengs
    Discussions |
    Mar 26, 2024 9:43 AM
    1065 views | 2 replies
  • How can use the regex substitution <*>?

    How to use regex to replace the text of dt[1,"A"] with tabs for each <*>.It get the multi-column result in row 2.Thanks!abc<ahref="/cindex/list->897</a>"id="s897"</dd> 

    lala lala
    Discussions |
    Mar 26, 2024 8:50 AM
    5067 views | 11 replies
  • Merge data of two cells in one by Serial Number

    I have a product manufacturing data. Some products are made using the material using two different lot. I need to merge all the lot information in one cell by SN. 

    ConfidenceOwl94 ConfidenceOwl94
    Discussions |
    Mar 26, 2024 7:13 AM
    1807 views | 4 replies

Latest Discussions

  • Clarification on Categorizing the Same ID in Rows with Other Columns

     Hi,
    I have a dataset where the same ID appears in multiple rows, each with 1 to 3 categories. The columns range from costA to costZ, and I need to consolidate them into a single "Cost" column. My goal is to group by Category 1 according to specific criteria (1 if Category 1 < 2000, 2 if Category 1 = 2000 - 4000, 3 if Category 1 = 4000 - 6000, 4 if Category 1 = 6000 - 10000, 5 if Category 1 > 10000...

    doraemengs doraemengs
    Discussions |
    Mar 26, 2024 9:43 AM
    1065 views | 2 replies
  • how to create Pareto plot like the following image ?

    hello I'm bigginner in using Jmp , I need to create Pareto Plot with the t-value of effect  and the Bonferroni and t-value limits like the following image .Thanks .

    Gacem_Seyf Gacem_Seyf
    Discussions |
    Mar 25, 2024 11:47 PM
    576 views | 1 replies
  • Use list of targets per name

    I have a list of targets per name (example):aa 7bb 10cc 9 I want to use them per name as a target in my graph.is there a way to do it? 

    Hamal22 Hamal22
    Discussions |
    Mar 25, 2024 10:15 PM
    862 views | 3 replies
  • How to categorize the same ID in row with other columns?

    Hi, I have the data set that the same ID in multiple rows. Each rows had 1 to 3 categories. The columns represent costA to costZ that I need to stack in the same Cost column. However, I need to generate group by category 1 ( 1 if category 1 < 2000, 2 if category 1 = 2000 - 4000, 3 if category 1 = 4000 - 6000, 4 if category 1 = 6000 - 10000, 5 if category 1 > 10000). However, I need to delete categ...

    doraemengs doraemengs
    Discussions |
    Mar 25, 2024 9:12 PM
    650 views | 0 replies
  • Can we have Monte Carlo simulation in regression parameters

    Hello: I was just wondering if there is a way to incorporate Monte-Carlo simulation in regression parameters.I guess once I have the regression equation I can run a Monte-Carlo simulation by specifying a distribution for each parameter and get the distribution of the output parameter. Q1) But while creating that regression equation will three data points (one at each LSL and USL of tolerance zone ...

    VarunK VarunK
    Discussions |
    Mar 25, 2024 2:38 PM
    1811 views | 6 replies

Latest Discussions

  • How to categorize the same ID in row with other columns?

    Hi, I have the data set that the same ID in multiple rows. Each rows had 1 to 3 categories. The columns represent costA to costZ that I need to stack in the same Cost column. However, I need to generate group by category 1 ( 1 if category 1 < 2000, 2 if category 1 = 2000 - 4000, 3 if category 1 = 4000 - 6000, 4 if category 1 = 6000 - 10000, 5 if category 1 > 10000). However, I need to delete categ...

    doraemengs doraemengs
    Discussions |
    Mar 25, 2024 9:12 PM
    650 views | 0 replies
  • LCA appears to treat ordinal variables as nominal

    When I run cluster analysis --> LCA with ordinal variables (numeric, ordinal), the probability formula appears to be treating the variables as nominal, rather than ordinal. For each variable, there are 5 levels (i.e., 1-5). If being treated as ordinal, wouldn't the probability formulas reflect an order for each level where 1 may have the smallest probability and 5 the largest? As you can see below...

    AutoMethodsBee1 AutoMethodsBee1
    Discussions |
    Mar 25, 2024 12:41 PM
    406 views | 0 replies
  • RSS, TSS, precent of residual sum of squares

    Is it possible to calculate RSS and TSS and precent of residual sum of squares for a linear calibration curve in JMP?

    gholamhasantey gholamhasantey
    Discussions |
    Mar 25, 2024 3:29 AM
    656 views | 0 replies
  • Error during stemming in text explorer: Inconsistent Recodes in access or evaluation of 'List'

    Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer( Text Columns( :col1) ); obj << Stemming("Stem for Combining"); obj << Add Recodes( {{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl...

    sm3001 sm3001
    Discussions |
    Mar 21, 2024 12:49 AM
    570 views | 0 replies
  • Error column property

    Hello - I have a data set that comes from an external measurement and the software that comes with the instrument automatically calculates the property and error bars that I'm looking for. Is there a way to include the error as a column property without doing a custom column property? I know there's a saved model error property, but fitting a custom model would introduce it's own issues as the mod...

    ehchandlerjr ehchandlerjr
    Discussions |
    Mar 20, 2024 3:32 PM
    471 views | 0 replies
view all discussions