337332_en-US

liliconcom

Better way to plot multiple FitY by X plots

My original source table is the tall table with ID, group and tons of params. I want to plot all params Fit Y by X (Group A vs Group B group by ID). The traditional way i do is i change the tall table to wide table and plot one params at a time. But if i have hundreds of params, it is not a good solution. Is there any better or smarter way to do this ? 

attached sample jmp files 

tall table

switch to wide table

Plot paramA A vs ParamA B 

Data TableGraphicsRe: Better way to plot multiple FitY by X plots

Taking your example data, I first split the data into your Wide form, and then I took that data table and did a multi series stack

     Tables=>Stack

specifying a 2 column stack

I then added a simple new column called Analysis which is a simple concatenation of the Label and Label 2 columns

Finally, I ran the Fit Y by X specifying Data and Data 2 as the Y and X columns and then setting the Analysis column as the By column, giving the results below

Re: Better way to plot multiple FitY by X plotsHi Nelson,

How you do the 1st step - specifying a 2 column stack? Can you further elaborate?Re: Better way to plot multiple FitY by X plots

@txnelson is referencing the 'multiple series stack' option:

 

Re: Better way to plot multiple FitY by X plots

Another platform that you might explore is response screening. I find it a helpful tool for looking at many fit y by x's. See response screening documentation .