JMP User Community

Latest Discussions

DCE Experiment Design Choice Sets

Hello everyone,I am trying to learn how conduct a study which includes to analysing a willing to pay by discrete choice experiment. Never use such a method so may I ask some questions.3 attribute: A1: 2 level A2: 2 level A3 (price): 3 level. > 3x2x2= 12 product optionI didn’t understand which approach is more accurate. In the first one; for two options each choice set 12x11/2= 66 choice set option...
RD_0991

Discussions |
Feb 21, 2022 3:54 AM

1967 views | 1 replies
How to insert a column with specified column index with JMP script?

I met a problem when writting my JMP script, I want to add the new column with a formula Y/X but there are serveal colunms and I want to add the new colunm after specified column,For example:A Table like:A B C D1 2 3 42 4 6 8 and I want to add a new column after B column(like below), but the B/A column will always after D when I use New Column function, and I cannot fi...
Jiaxiang

Discussions |
Feb 21, 2022 12:10 AM

1341 views | 1 replies
How to check if graph builder legend is showing or not

I was wondering what the script would be to check if the graph builder legend is showing or not. I want to make a toolbar shortcut that would show or hide the legend depending on the state the legend is in (if showing then hide and if hidden then show). thanks for any suggestions! Steve
shampton82

Discussions |
Feb 19, 2022 5:59 PM

1724 views | 3 replies
Is there a way to Center Justify a NumberColBox?

Hi. I'm wondering if there's a way to center justify the values in a NumberColBox. I have a GUI and it would help make things more readable to the user if all my columns were center justified. I can center justify strings in a StringColBox using << Set Justify(center), but I see no corresponding option for a NumberColBox. I'm aware I could convert all my numeric values to text and use a String...
nikles

Discussions |
Feb 18, 2022 3:24 PM

1302 views | 3 replies
Group Columns by a list of values from another column?

I'm working to group several thousand columns together by name that matches with something from a list of values from an initial column example:Col1 values = {step1, step2, step3}Col2:5000 names :step1_blahblahblah, step2_blahblbahblah, etc I guess I'm not quite sure how to define the if(contain) statement uses the list of values from Col1. dt = current data table(); Summarize( dt, StepIDIndex= by...
aliegner1

Discussions |
Feb 18, 2022 2:39 PM

1103 views | 1 replies

Previous
Next

Latest Discussions

How to insert a column with specified column index with JMP script?

I met a problem when writting my JMP script, I want to add the new column with a formula Y/X but there are serveal colunms and I want to add the new colunm after specified column,For example:A Table like:A B C D1 2 3 42 4 6 8 and I want to add a new column after B column(like below), but the B/A column will always after D when I use New Column function, and I cannot fi...
Jiaxiang

Discussions |
Feb 21, 2022 12:10 AM

1341 views | 1 replies
Is there a way to Center Justify a NumberColBox?

Hi. I'm wondering if there's a way to center justify the values in a NumberColBox. I have a GUI and it would help make things more readable to the user if all my columns were center justified. I can center justify strings in a StringColBox using << Set Justify(center), but I see no corresponding option for a NumberColBox. I'm aware I could convert all my numeric values to text and use a String...
nikles

Discussions |
Feb 18, 2022 3:24 PM

1302 views | 3 replies
Group Columns by a list of values from another column?

I'm working to group several thousand columns together by name that matches with something from a list of values from an initial column example:Col1 values = {step1, step2, step3}Col2:5000 names :step1_blahblahblah, step2_blahblbahblah, etc I guess I'm not quite sure how to define the if(contain) statement uses the list of values from Col1. dt = current data table(); Summarize( dt, StepIDIndex= by...
aliegner1

Discussions |
Feb 18, 2022 2:39 PM

1103 views | 1 replies
Prediction Expression from DOE not matching

I have a prediction expression from my DOE that when popped into excel to make a calculator, the results are not consistent with what populates the imp table column when I create a "Predict Formula" column in my table. It is very close for the center values but off for the values towards the limits of the model. What am I missing??
JasonMLawhorn

Discussions |
Feb 18, 2022 11:29 AM

877 views | 1 replies
Looping ANOVA to determine most similar group

Hi all,

I'm looking to loop a procedure that would otherwise be tedious. Potentially, someone may have a better workflow and I'm all ears if you do. For my dataset, I have 5 ethnicities and I'm trying to figure out what ethnicity 2 and ethnicity 5 match best to so I can combine the ethnicities. What I want to do is run an ANOVA and Welche's Test between 2 and the rest of the ethnicities and see if...
MikeDereviankin

Discussions |
Feb 18, 2022 11:27 AM

1153 views | 3 replies

Previous
Next

Latest Discussions

No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

599 views | 0 replies
Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

770 views | 0 replies
How to introduce lower bounds for simulated data in Profiler platform

Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...
SDF1

Discussions |
Feb 1, 2022 11:09 AM

589 views | 0 replies
Query Builder filtering on date stored in Varchar(20)

Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO] ,[DESPA...
HansD

Discussions |
Jan 25, 2022 6:12 AM

1391 views | 0 replies
M1 Macbook Pro JMP Capabilities

Hi all,
I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...
MikeDereviankin

Discussions |
Jan 21, 2022 1:52 PM

790 views | 0 replies