JMP User Community

Latest Discussions

Simple start for script

Hi I am a bit embarrased that I get stuck on this simple task. It is a simple task: I have 2 data-tables (dt-1 and dt-2). I want to step through the first and for each row compare a value with a value in the second table, starting with first row in that table. If it is close enough I will collect a value from that dt-2 and save in a field in dt-1, put a special marker in a field in dt-2 so I kno...
gueriniere

Discussions |
Feb 24, 2022 11:11 AM

2128 views | 3 replies
How do I add a time stamp when printing a data table?

I want to add a time stamp to a print of my data table. I know how to add the date with the &d; option in Page Setup. Is there a way to also add the time?
StefanC

Discussions |
Feb 24, 2022 9:18 AM

1317 views | 1 replies
Adding constraints to design with discrete factors

Hello,I am trying to add constraints to design with 4 discrete factors (X1,X2,X3,X4), where all the factors have 3 levels. What is the best way to add constraint to specify that three factors (X2,X3,X4) should add up to 97%? I am assuming I'll have to add disallowed combinations script option for this but not sure about the script.
billi

Discussions |
Feb 24, 2022 8:36 AM

1205 views | 2 replies
Incorrect 95% confidence interval range for matched pairs plot?

I am trying to create a bland-altman plot using the matched pairs function in JMP. I created the plot below and decided to double-check some of the statistics calculated on excel. I found that while the standard error and mean difference were correct, my upper and lower 95% confidence interval values were very different than the ones provided by JMP Pro 16 I tried to test out their match pair exa...
Querida

Discussions |
Feb 24, 2022 8:25 AM

3834 views | 2 replies
MSA Gauge R&R AIAG Version?

Hallo!JMP Verion 16.1Vorrede zu meinen Daten:Ich möchte einen Datensatz (2 nahezu gleiche Messysteme, darauf jeweils die 10 gleichen Personen mit 5 Wiederholungen gemessen) auswerten und den Varianzanteil durch die verscheidnen Massysteme zu erhalten. Dazu kann ich ja Gauge R&R oder EMP zur Analyse verwenden. Da alles mit dem gleichen Bediener gemessen wurde, würde ich bei der Analyse die 2 Messys...
CountableMarten

Discussions |
Feb 24, 2022 8:23 AM

2776 views | 4 replies

Previous
Next

Latest Discussions

Adding constraints to design with discrete factors

Hello,I am trying to add constraints to design with 4 discrete factors (X1,X2,X3,X4), where all the factors have 3 levels. What is the best way to add constraint to specify that three factors (X2,X3,X4) should add up to 97%? I am assuming I'll have to add disallowed combinations script option for this but not sure about the script.
billi

Discussions |
Feb 24, 2022 8:36 AM

1205 views | 2 replies
MSA Gauge R&R AIAG Version?

Hallo!JMP Verion 16.1Vorrede zu meinen Daten:Ich möchte einen Datensatz (2 nahezu gleiche Messysteme, darauf jeweils die 10 gleichen Personen mit 5 Wiederholungen gemessen) auswerten und den Varianzanteil durch die verscheidnen Massysteme zu erhalten. Dazu kann ich ja Gauge R&R oder EMP zur Analyse verwenden. Da alles mit dem gleichen Bediener gemessen wurde, würde ich bei der Analyse die 2 Messys...
CountableMarten

Discussions |
Feb 24, 2022 8:23 AM

2776 views | 4 replies
How to set values for last 30 rows of a column?

Hi guys, I'm a complete scripting newbie here so please have patience with me :crossed_fingers:. I have a data set with multiple columns and am trying to make a script that will automatically select the last 30 rows of a column and change the content from "baseline" to "CLCR". Please see my attempt: dt = Current Data Table(); dt1 = dt << Select Columns( :CLCR ); dt1 << select where( Row() > N Row...
kkrog

Discussions |
Feb 24, 2022 1:07 AM

1755 views | 1 replies
Conditional If then to return values for ranges

I have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days? (Examples: campaign 1, 2, 3=>No value whereas campaigns showing 1,2,3,4,5,6,7,8,9 would show the appropriate number 19,20,21,22,23,24,25,26,27 etc.)
ByrdQuestions

Discussions |
Feb 23, 2022 3:11 PM

1716 views | 2 replies
All possible models - what criteria are used to determine the order of independent variables retained by a model?

16.1.0Hi All, I've been experimenting with the All Possible Models option within the stepwise linear regression module. I was wondering what determines the order of the independent variables (IV) listed? Does the order infer some measure of effect/sensitivity, if so is there a way to identify what the relative sensitivity is? Thanks in advance. Cheers
Clint
RegressionOwl23

Discussions |
Feb 23, 2022 11:21 AM

1211 views | 1 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

749 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

946 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

722 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

1607 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

957 views | 0 replies