Choose Language Hide Translation Bar
Highlighted
Level II

## Mean from several columns in ANOVA

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User

## Re: Mean from several columns in ANOVA

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

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

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

Now go to

Analyze==>Fit Y by X

and fill out the dialog box as:

Click OK and the platform will generate

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

Your Analysis of Variance analysis

Jim
4 REPLIES 4
Highlighted
Staff

## Re: Mean from several columns in ANOVA

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.

Dan Obermiller
Highlighted
Super User

## Re: Mean from several columns in ANOVA

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

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

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

Now go to

Analyze==>Fit Y by X

and fill out the dialog box as:

Click OK and the platform will generate

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

Your Analysis of Variance analysis

Jim
Highlighted
Level II

## Re: Mean from several columns in ANOVA

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

## Re: Mean from several columns in ANOVA

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

JMP Systems Engineer, Pharm and BioPharm Sciences
Article Labels

There are no labels assigned to this post.