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

  • Standardizing attributes by column name

    I tend to work with the same types of data every day.  Every time I load a file, JMP sets some columns as "Continuous" that really work better as nominals. Is there a way to tell JMP that if it sees a column with a specific name, e.g. "case_id", that it should always flag it as nominal? I know scripts can do this, but having to run a script every time I open a file has gotten a bit tedious.

    BHarris BHarris
    Discussions |
    Apr 2, 2024 7:10 PM
    5919 views | 3 replies
  • 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
    1138 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
    1014 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
    1786 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
    4633 views | 4 replies

Latest Discussions

  • Standardizing attributes by column name

    I tend to work with the same types of data every day.  Every time I load a file, JMP sets some columns as "Continuous" that really work better as nominals. Is there a way to tell JMP that if it sees a column with a specific name, e.g. "case_id", that it should always flag it as nominal? I know scripts can do this, but having to run a script every time I open a file has gotten a bit tedious.

    BHarris BHarris
    Discussions |
    Apr 2, 2024 7:10 PM
    5919 views | 3 replies
  • 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
    1138 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
    4633 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
    4460 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
    2101 views | 6 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
    617 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
    933 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
    554 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
    806 views | 0 replies
view all discussions