nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

merging columns to one column

TalDamri

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

Accepted answers

txnelson

I believe all you need to do, is to use

Tables==>Stack

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

All comments

txnelson

I believe all you need to do, is to use

Tables==>Stack

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

Mark_Bailey

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

TalDamri

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

Mark_Bailey

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.