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

M

Mack

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?
 
M

Mike Middleton

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
 
M

Mack

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.
 
Top