cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

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 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
    1785 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
    4632 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
    1266 views | 2 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
    4458 views | 8 replies
  • How to do a Reliability analysis in JMP

    Hi everyone, I am designing a new process and I want to calculate the likelyhood of components in the process (such as pumps, etc) to break down. This in order to determine how to manage maintenance, excess stock etc. How would I need to go about this? 

    Veerle Veerle
    Discussions |
    Apr 2, 2024 7:50 AM
    3307 views | 7 replies

Latest Discussions

  • 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
    4632 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
    4458 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
    2098 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
    1970 views | 5 replies
  • Help about sample size calculation

    For my study, the primary endpoint is to determine the proportion of patients who experience a beneficial effect after receiving the treatment. We have established a null hypothesis proportion (퐻0) of 0.5, indicating our expectation that approximately 50% of the patients will exhibit a beneficial response to the treatment post-intervention. This figure serves as a clinically relevant cut-off point...

    thiennguyen thiennguyen
    Discussions |
    Apr 1, 2024 9:11 AM
    5552 views | 16 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
    616 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
    930 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
    552 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
    892 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
    805 views | 0 replies
view all discussions