How do you set up the data to perform a Anova 2 Factor/w reps?
 

I keep getting the error: "each sample must conatin the same number of rows",
when I select my data. It is 32 row, but each replication is 4 rows. So
there is eight replications. I have 4 rows by 6 colums of data. I have
tried doing 4 by 4 and that still does not work, does anyone know how to get
this data analysis function to work?

How do you set up the data to perform a Anova 2 Factor/w reps?
 

Mack -

In Excel 2003 off-line Help, search for the "About Statistical Analysis
Tools" topic and expand the ANOVA section to see the proper layout of data
on the worksheet.

Or, consult a statistics book that uses Excel, like my "Data Analysis Using
Microsoft Excel: Updated for Office XP."

- Mike
www.mikemiddleton.com

"Mack" wrote in message
...
I keep getting the error: "each sample must conatin the same number of
rows",
when I select my data. It is 32 row, but each replication is 4 rows. So
there is eight replications. I have 4 rows by 6 colums of data. I have
tried doing 4 by 4 and that still does not work, does anyone know how to
get
this data analysis function to work?

How do you set up the data to perform a Anova 2 Factor/w reps?
 

I figured it out. When using the Anova 2 factor data analysis part of excel,
you need to have a blank row at the top of the page where you highlight the
cells, either that or a title at the top of the data. So in any case your
data should start on row 2 and when you highlight the data include row 1.



"Mike Middleton" wrote:

Mack -

In Excel 2003 off-line Help, search for the "About Statistical Analysis
Tools" topic and expand the ANOVA section to see the proper layout of data
on the worksheet.

Or, consult a statistics book that uses Excel, like my "Data Analysis Using
Microsoft Excel: Updated for Office XP."

- Mike
www.mikemiddleton.com

"Mack" wrote in message
...
I keep getting the error: "each sample must conatin the same number of
rows",
when I select my data. It is 32 row, but each replication is 4 rows. So
there is eight replications. I have 4 rows by 6 colums of data. I have
tried doing 4 by 4 and that still does not work, does anyone know how to
get
this data analysis function to work?