JMP User Community

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

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

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

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

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

Discussions |
Apr 2, 2024 11:10 AM

889 views | 2 replies

Previous
Next

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

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

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

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

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

Discussions |
Apr 1, 2024 12:00 PM

1365 views | 5 replies

Previous
Next

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

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

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

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

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

Discussions |
Mar 21, 2024 12:49 AM

609 views | 0 replies