Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- merging columns to one column

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Nov 18, 2019 4:12 AM
(1339 views)

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

I believe all you need to do, is to use

Tables==>Stack

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

Jim

4 REPLIES 4

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

I believe all you need to do, is to use

Tables==>Stack

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

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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.