topic Re: Mean from several columns in ANOVA in Discussions

Mean from several columns in ANOVA

ninasor — Sat, 23 May 2020 21:59:32 GMT

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?

Re: Mean from several columns in ANOVA

Dan_Obermiller — Sat, 23 May 2020 22:04:32 GMT

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.

Re: Mean from several columns in ANOVA

txnelson — Sat, 23 May 2020 22:37:15 GMT

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

Re: Mean from several columns in ANOVA

ninasor — Sun, 24 May 2020 10:43:40 GMT

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

Re: Mean from several columns in ANOVA

Byron_JMP — Wed, 27 May 2020 21:52:40 GMT

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