JMP User Community

Latest Discussions

How to get only "Cp" value for a column in a Datatable?

Hi, I would like to get Cp value for a column in my data table to use it in multiple script location to tabulate it. With the available function "obj << Process Capability( LSL( 5 ), Target( 40 ), USL( 75 ) );" it is clear that we can get all process capability parameters in a plot. However i would like to get Cp value for a column and assign it to a variable in my script to use it in multiple sc...
AlexR846

Discussions |
Mar 12, 2022 12:00 AM

4155 views | 8 replies
Help needed with nested if and else statement

I'm using if else statement to bucket certain FS*/SS* as CAT1 and CAT2 .All remaining FS*/SS* that do not belong to CAT1/CAT2 need to be classified as CAT3.Having trouble with writing else part for CAT3.Any help appreciated. cdt = open("temp\data.csv"); cdt=current data table(); sum_lst2 = {}; sum_lst3 = {}; sum_lst4 = {}; col_lst2 = cdt << get column names( Numeric ); For( i = 1, i <= N Items( c...
ENTHU

Discussions |
Mar 11, 2022 5:35 PM

6813 views | 9 replies
How to see what messages an object accepts?

I know there is a message that shows what messages an object accepts. Can't remember and can't find. Can somebody let me know? Thanks, M.
miguello

Discussions |
Mar 11, 2022 12:24 PM

1519 views | 2 replies
How do I multiply all data values by a multiplier for each column that is identified in another table?

How do I multiply all data values by a multiplier for each column that is in another table, by column name? (The multiplier table has a column with the column names and a second column with the multipliers to apply to each column in the other table. Not all columns have a multiplier.) I can get as far as adding the multiplier to the data table in its own row, but then I'm stuck. I know I can do it...
dlifke

Discussions |
Mar 11, 2022 10:30 AM

2538 views | 3 replies
How is power calculated in optimal designs?

How is power calculated in optimal designs? I designed a D-optimal split-split plot experiment, and as in classical split-split-plot designs, the power associated with the main plots and subplots are lower than the sub-sub plots, but I struggle to understand if power (and effect size) calculations in optimal designs are computed the same way as classical designs. In other words, how does applying ...
elb89

Discussions |
Mar 11, 2022 9:55 AM

1095 views | 1 replies

Previous
Next

Latest Discussions

How is power calculated in optimal designs?

How is power calculated in optimal designs? I designed a D-optimal split-split plot experiment, and as in classical split-split-plot designs, the power associated with the main plots and subplots are lower than the sub-sub plots, but I struggle to understand if power (and effect size) calculations in optimal designs are computed the same way as classical designs. In other words, how does applying ...
elb89

Discussions |
Mar 11, 2022 9:55 AM

1095 views | 1 replies
Manage spec limits will not accept -/- or +/+ tolerances when using JSL

Hi all I made a nice script importing text files from my Zeiss CMM and adding Spec limits to each results column, it uses Manage spec limitsbut my script will not accept -/- or +/+ tolerances when using JSL, because a warning box pops up.So no tolerances are added to my columns, when I retry manually I can accept the import Thanks Jakob
Jakob

Discussions |
Mar 11, 2022 6:36 AM

1051 views | 1 replies
How to Create a Fit Model with Different Sized Data Tables

I have 12 serialized assemblies. Each assembly has 8 parts, each part has a set of data of the same column structure. Each assembly goes through 1 qualification test.Each assembly then goes through 10 rounds of life testing (each round has the same column structure). That leaves me with 3 tables Table 1 has 8 rows per assemblyTable 2 has 1 row per assemblyTable 3 has 10 rows per assembly I am inte...
Phigene

Discussions |
Mar 10, 2022 3:26 AM

1736 views | 2 replies
Change Display of Values for Sharing

Hello Everybody, My peers and I will be sharing some of our work soon. We want to be able to share this work without giving out key parameters that were used for IP purposes. I remember seeing in the JMP courses that we can use -1, 0, 1 etc in place of some of the actual values. But I can't find it in the JMP help or online. Is there a function that can automatically do it for us? If not, how woul...
tnorthen

Discussions |
Mar 9, 2022 12:47 PM

1264 views | 2 replies
Mixed Model Trouble

What is the issue with this data? I can't get any output for the fixed effects tests.I am performing a mixed model of a randomized complete block design. Rep is a random factor while S Rate and N Rate are continuous variables. I would like to see if S Rate or N Rate impact yield. Yield is also a continuous variable. I can get output when I run it as a standard least squares with the reml method,...
KernDawg

Discussions |
Mar 8, 2022 8:52 PM

2161 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

834 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

1022 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

773 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

1685 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

1012 views | 0 replies