Choose Language Hide Translation Bar
Highlighted
TalDamri
Level II

merging columns to one column

Hi evryone . 

 

I would like to merging three columns into one colum for "X to Y fit analyze"

 

The three columns is the "Y" -respond colum, and I would like to analyze the three columns as one. 

 

is that possible ? 

 

with more details, 

X is the measured ambiant temp. 

Y's is the measured temp at different points of the system. 

so for each X I got three Y

 

I would like to predicted what could be the max temp on the system at different temp. (abve the measured temp) 

 

all the best 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: merging columns to one column

I believe all you need to do, is to use

     Tables==>Stack

and stack the 3 Y columns, and then run your analysis

Jim

View solution in original post

4 REPLIES 4
Highlighted
txnelson
Super User

Re: merging columns to one column

I believe all you need to do, is to use

     Tables==>Stack

and stack the 3 Y columns, and then run your analysis

Jim

View solution in original post

Highlighted

Re: merging columns to one column

I wonder why you want to merge the three responses into one? Why not model each one separately?

Learn it once, use it forever!
Highlighted
TalDamri
Level II

Re: merging columns to one column

I am looking to predict the maximum temperature over the system, and the three responses col is three thermocouples.
Highlighted

Re: merging columns to one column

I think that you will be more satisfied by fitting each response separately, saving the individual models as column formulas, and then creating a new column formula that is the maximum of the three individual temperatures. The Graph > Profiler is very flexible. It has an option to expand intermediate formulas back to the original factors.

Learn it once, use it forever!
Article Labels

    There are no labels assigned to this post.