How to create Oneway from two different columns (without stacking)?

[#1]

Hello. It is probably a trivial question (I'm very new to JMP). I have ~300 columns in a file and want to compare  means and stdvs of only two of columns of interest using Fit Y by X (Oneway analysis), how can I do it easily without stacking? - I basically had to stack all of the data, create a new jmp. file and only then I was able to generate what I need (see below).

Thank you,

Alex.

[#2]

That is correct. You must have all the response in one data column and the group membership in a second data column. So you must stack the the two response first.

You do not have to keep all the other data columns when you stack, though.

[#3]

Thank you, @Mark_Bailey and @txnelson. One last question: is there a way to stack columns within the same (original) data table?

[#4]

There is a way to do this, but a simple script would have to be written to do it. Or, you could easily join the table back together with the original table, and it will end up in a single table. However, when you start mixing data structures in JMP data tables, you will start to reduce some of the assumed built in assumptions. But, it certainly can be done

[#5]

@txnelson Thank you! That's what I've been missing - joining tables back solves the problem.

Have a great weekend!

Alex.

[#6 · Accepted solution]

I believe you will have to stack just those 2 columns to be able to do what you want.  The thinking on JMPs part on this, is that if you are measuring the same thing, it probably should be in the same column.  If you are coming from an Excel background, there can be some paradigm differences you will need to work through.

Comparisons between columns is considered to be matched data, such as a pre and post measurement.