Mean from several columns in ANOVA

[#1]

Is there a way to perform an ANOVA analysis where the mean of each column is represented? For example, I have 4 different columns with answers from 1-7. I want to represent these answers using only one model. If i use "distribution" i get 4 different models, and I only want one. Anyone? 

[#2]

Not exactly sure what you are looking for. ANOVA is a method to compare several groups of data to each other. For example, you have four groups so have your data structured similar to this:

Group     Data

A             7

A             9

B             3

B             5

...

then you use Fit Y by X. The group column is the X. The Data column is the Y. 

You should start by going to the Help menu and choosing Tutorials > Many Means Tutorial.

[#3 · Accepted solution]

To expand on @Dan_Obermiller , if you have a data table

age1.PNG

You can move the data into the form required for the Anova analysis by using

     Tables==>Split

Fill the dialog box out as shown below

age2.PNG

Click OK, and you will get a data table like this

Age3.PNG

Now go to

     Analyze==>Fit Y by X

and fill out the dialog box as:

age4.PNG

Click OK and the platform will generate

age6.PNG

Now go to the red triangle and select "Means Anova" and you will get

age5.PNG

Your Analysis of Variance analysis

[#4]

Wow, just what I was looking for. Thank you so much!!

[#5]

@txnelson you're a data munging genius. Nice solution and post too.