software

I keep getting the error: quot;each sample must conatin the same number of rowsquot;,
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?Mack -

In Excel 2003 off-line Help, search for the quot;About Statistical Analysis
Toolsquot; 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 quot;Data Analysis Using
Microsoft Excel: Updated for Office XP.quot;

- Mike
www.mikemiddleton.com

quot;Mackquot; gt; wrote in message
...
gt;I keep getting the error: quot;each sample must conatin the same number of
gt;rowsquot;,
gt; when I select my data. It is 32 row, but each replication is 4 rows. So
gt; there is eight replications. I have 4 rows by 6 colums of data. I have
gt; tried doing 4 by 4 and that still does not work, does anyone know how to
gt; get
gt; this data analysis function to work?
gt;
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.
quot;Mike Middletonquot; wrote:

gt; Mack -
gt;
gt; In Excel 2003 off-line Help, search for the quot;About Statistical Analysis
gt; Toolsquot; topic and expand the ANOVA section to see the proper layout of data
gt; on the worksheet.
gt;
gt; Or, consult a statistics book that uses Excel, like my quot;Data Analysis Using
gt; Microsoft Excel: Updated for Office XP.quot;
gt;
gt; - Mike
gt; www.mikemiddleton.com
gt;
gt; quot;Mackquot; gt; wrote in message
gt; ...
gt; gt;I keep getting the error: quot;each sample must conatin the same number of
gt; gt;rowsquot;,
gt; gt; when I select my data. It is 32 row, but each replication is 4 rows. So
gt; gt; there is eight replications. I have 4 rows by 6 colums of data. I have
gt; gt; tried doing 4 by 4 and that still does not work, does anyone know how to
gt; gt; get
gt; gt; this data analysis function to work?
gt; gt;
gt;
gt;
gt;