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

  • Utilizing contour map to set up the constraints for Augment Design

    Hi community, I am working on a formulation work. I got initial 3 by 3 Design as below with replicates.  Then I got decet predictive model. Below is the controur plot with raw data vs plot predicted by the model. They look alike except the region where there is no data points (white space), Now I want to optimize this formulation by further looking into the high performing formulation (both upper ...

    BJK_JerseyBoy BJK_JerseyBoy
    Discussions |
    Apr 2, 2024 4:58 PM
    777 views | 2 replies
  • Update name column

    HelloI have 2 tables1) Pareto_table with name columns 1 and 2 2) the second Date_table I have the same numbers 1 and 2 in column "Rank"my question is,  how I can update by the script JSL in Pareto_table the column 1 to value of 2024-01-05 and  and 2 to value 2024-03-13?in the end it will look like in this table exampleThank you

    Dennisbur Dennisbur
    Discussions |
    Apr 2, 2024 2:11 PM
    729 views | 1 replies
  • How to get Col Sum of a row in a conditional statement?

    Hi all, I have a column where I need to filter out some values to get the sum of columns (using Col Sum). Is it possible to get the col sum according to the condition? For example, every 0 code will be excluded from the computation: CodeQtyTotal CountTotal % (Col Sum (qty)/total count)050250-025250-160250205/250 x 100 = 82%667250205/250 x 100 = 82%378250205/250 x 100 = 82% I tried using an If stat...

    UserID16644 UserID16644
    Discussions |
    Apr 2, 2024 1:40 PM
    1280 views | 3 replies
  • Understanding Fit Response Screening Effect Tests

    Hello!  I am new to using jmp as a whole and this is m first time using it for DOE. I used the software for a fractional factorial screening design. I had three different factors to evaluate all of which were categorical. My data was collected/recorded using 0 and 1 to represent fail or pass respectively.  I have now inputted the data into my design and I am trying to understand the analysis provi...

    MedianPuppy4982 MedianPuppy4982
    Discussions |
    Apr 2, 2024 11:10 AM
    3245 views | 4 replies
  • How can you calculate the product of non-empty rows up to the current row?

    I'm trying to write a column formula that will calculate the product of all of the (non-empty) rows up to the current row.I've attached an example data table (& screenshot). I am trying to get the "Product" column to be the product of all of the non-empty rows from the "Value" column. I show the manually calculated result and math in the "Desired Result" & "Desired Result Explanation" to the right...

    Kast Kast
    Discussions |
    Apr 2, 2024 11:10 AM
    889 views | 2 replies

Latest Discussions

  • Utilizing contour map to set up the constraints for Augment Design

    Hi community, I am working on a formulation work. I got initial 3 by 3 Design as below with replicates.  Then I got decet predictive model. Below is the controur plot with raw data vs plot predicted by the model. They look alike except the region where there is no data points (white space), Now I want to optimize this formulation by further looking into the high performing formulation (both upper ...

    BJK_JerseyBoy BJK_JerseyBoy
    Discussions |
    Apr 2, 2024 4:58 PM
    777 views | 2 replies
  • Understanding Fit Response Screening Effect Tests

    Hello!  I am new to using jmp as a whole and this is m first time using it for DOE. I used the software for a fractional factorial screening design. I had three different factors to evaluate all of which were categorical. My data was collected/recorded using 0 and 1 to represent fail or pass respectively.  I have now inputted the data into my design and I am trying to understand the analysis provi...

    MedianPuppy4982 MedianPuppy4982
    Discussions |
    Apr 2, 2024 11:10 AM
    3245 views | 4 replies
  • Generating summary table with p-values from iterative t-test

    I am looking for a script that will automatically generate a summary/pivoted table of means and p-values for pairwise t-tests compared with one reference group. I am using JMP 17.In the below data table, there are columns for SubjectId, measured BMI, measured VO2max, year, and Reference to indicate whether or not the row has a SubjectID that is a reference.I have been generating summary tables man...

    LinkageBee996 LinkageBee996
    Discussions |
    Apr 2, 2024 9:33 AM
    3086 views | 8 replies
  • Formula application

    IF(MONTH(A151)=MONTH(A150),NA(),COUNTIF(W151:W181,1)*100/(COUNTIF(W151:W181,1)+COUNTIF(W151:W181,0))) . This is a formula applied in excel to create a new column, where Column A has date & column W contains only 0 & 1 as values. How to apply this same formula in JMP if we have columns A & W values.

    Chitranshu Chitranshu
    Discussions |
    Apr 2, 2024 7:28 AM
    1440 views | 6 replies
  • How to choose heredity rules in definitive screen

    Hi, When performing a DSD, you are given the option for applying rules of "obeys strong heredity" for quadratics, and for interactions. I believe that this limits the model and allows only for interactions that contains both as main effects. I'm not positive how this works for quadratics unless it only allows for quadratics that are found to have a main effect as well. When evaluating your DSD, ho...

    MetaLizard62080 MetaLizard62080
    Discussions |
    Apr 1, 2024 12:00 PM
    1365 views | 5 replies

Latest Discussions

  • Multiple imputation of ordinal data

    HiWe're doing a study regarding whole number ordinal data, answers being 0 to 4. It probably being MAR and not knowing the probability of each response, made us wonder how to do multiple imputation of this data. A post showed:go to analyze > consumer research > categorical But we're stuck...Thank you in advance! 

    CovariateFilter CovariateFilter
    Discussions |
    Mar 28, 2024 10:00 AM
    488 views | 0 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
    677 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
    416 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
    675 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
    609 views | 0 replies
view all discussions