JMP User Community

Latest Discussions

Keep column customised order after concatenation with other columns

Hello, I have attached a JMP table to reproduce my problem. In my example, I have 3 columns:Column 1: takes the values 'A', 'B', 'C'. I've customized the order of the values so that if I sort it's not A> B> C but B>C>A.Column 2: takes values 1,2,3,4. No custom order
Column 3: Is the concatenation of Column 1 || Column 2 . But if I sort, it will be in alphabetical order and won't take into account t...
SophieCuvillier

Discussions |
Mar 29, 2024 6:49 AM

1161 views | 2 replies
plotting confidence intervals in JMP "fit curve"

Hi, Is there a way to overlay the confidence interval (shaded) with the fitted curve when using the "fit curve" feature in JMP (without JSL)? Thanks.
Greeny

Discussions |
Mar 29, 2024 6:46 AM

2548 views | 5 replies
How can I parse a string in 1 column use jsl?

I want to use jsl to split data in column "result" with delimiter "|" to new column "PIN" and "value". Kindly help, thank you in advancePlease refer my attachmentnew table
ducthinh279

Discussions |
Mar 28, 2024 9:04 PM

3484 views | 7 replies
Data analysis on mixture design

Hello everyone,I've tried to create a sort of mixture design using a script.The script allows me to have 10 components (a1, a2 - b1, b2, b3, b4 - c1, c2 - d1, d2) and my mixture would consist of only:a1 or a2 or 0b1 or b2 or b3 or b4 or 0c1 and/or c2d1 or d2 or 0By selecting the steps, the script provided me with an experimental design table (which I enriched with new experiments and pure componen...
PepinLB

Discussions |
Mar 28, 2024 6:44 PM

2591 views | 6 replies
Assign variable to table based on the contain of the table name.

I have multiple table that are open and need to assign variable based on a contain(DC1,DC2,DC3) of the table name. If table name contain DC1 assign dt1, if it Table name contain DC2 assign dt2.... Table 1: ABC_25C_DC1_2024Table 2: ABC_25C_DC2_2024Table 3: ABC_25C_DC3_2024 Here is the command line that i was try to work with. tablelist = Get Data Table List() << get name; If(Contains(Concat Items(...
ConfidenceOwl94

Discussions |
Mar 28, 2024 10:58 AM

1945 views | 5 replies

Previous
Next

Latest Discussions

plotting confidence intervals in JMP "fit curve"

Hi, Is there a way to overlay the confidence interval (shaded) with the fitted curve when using the "fit curve" feature in JMP (without JSL)? Thanks.
Greeny

Discussions |
Mar 29, 2024 6:46 AM

2548 views | 5 replies
Data analysis on mixture design

Hello everyone,I've tried to create a sort of mixture design using a script.The script allows me to have 10 components (a1, a2 - b1, b2, b3, b4 - c1, c2 - d1, d2) and my mixture would consist of only:a1 or a2 or 0b1 or b2 or b3 or b4 or 0c1 and/or c2d1 or d2 or 0By selecting the steps, the script provided me with an experimental design table (which I enriched with new experiments and pure componen...
PepinLB

Discussions |
Mar 28, 2024 6:44 PM

2591 views | 6 replies
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

623 views | 0 replies
Neural Model - No 'Save Bagged Predictions' Option

Hi all, I'm using the profiler tool with a neural model and want to create confidence intervals. I'm following a step by step guide on the JMP page which says to 'save bagged predictions' on the prediction profiler red triangle. When I click on the profiler red triangle I don't see this option. Does anyone know how to create confidence bands around the profiler and why I can't see this 'save bagge...
JMP_Man

Discussions |
Mar 28, 2024 6:23 AM

679 views | 1 replies
Searching every cell in one column to find a specific content

Hi all, I have a jmp data table with a column that contains different strings at each row. I would like to know if I can loop that column to find a specific part of the string in that cell. This an example of the strings: Class: 10 Table:15 Stat:NA loc:NA teacher:Sam --> content of the cellClass: 11 Table:11 Stat:NA loc:NA teacher:Sam The challenge is that I have different class # and different...
RA899

Discussions |
Mar 27, 2024 10:05 PM

2625 views | 6 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

623 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

936 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

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

Discussions |
Mar 25, 2024 3:29 AM

893 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

810 views | 0 replies