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

- 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

May 23, 2020 2:59 PM
(1323 views)

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

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

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

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

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

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

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

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

Re: Mean from several columns in ANOVA

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

Highlighted
##

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

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.