Design of Experiments based on covariates factors from two tables

Victor_G

Hi dear JMP enthusiasts and DoE lovers,

 

I face a difficult situation and would like to know if there are any easier options. I would like to setup a DoE with 5 covariates :

• 2 covariates, from a table A, are predicted physico-chemical properties of formulations (thanks to the model of a first DoE),
• 3 covariates, independent from the first ones, from a table B, are characteristics of different packagings.

 

I would like to create a model (screening main effects and interactions) with these 5 covariates to evaluate relationships and interactions between formulation covariates and packaging characteristics on the response, but when I use "Custom Design" and want to add covariates, I only have the option to add covariates from the table on which I create a Custom DoE (table A OR table . I only see two options to solve my problem (but feel free to propose any others I may have missed):

1. I have to create a new table with all covariates, and so create all possible combinations A/B of the 2 factors from table A with 3 factors from table B (but this may require some time as table A has 10000 rows, and this is not very practical...),
2. There may be an easier solution, where I can somewhere change the current datatable during DoE creation and switch to another one to introduce new factors (or script this) ?

 

Any inputs or help will be greatly appreciated !

Thanks in advance for your help,

SDF1

Hi @Victor_G ,

 

  I believe you should be able to do this manually  and probably scripting as well. I made a mock set of three continuous X factors, X1, X2, X3, with 10k rows and then another mock table of factors X4 and X5, with 600 rows. In Custom DOE, when you go to select the covariates, just be sure to select the top level data table before adding the covariate term. This will allow you to select from the data table of interest. I did this for a DOE where I opted for 100 rows and it pulled covariates from both data tables and distributed their levels appropriately in the new DOE, which had factors X1 to X5 in it.

 

  The only drawback here is that the covariate row index is only provided from the second data table that you have selected. Presumably, if you script this and set the current data table to dt1 or dt2, you should be able to get the row number of the selected covariates and save that as a column. For example, you could have a column named Covariate Row Index dt1 and likewise for dt2. JMP will not do this for you when you do it manually, unfortunately. It would be nice if it did.

 

Hope this helps!,

DS