ANOVA 2 factor with replication

**Layo909** · 05-20-2011, 03:33 AM

I am doing a two-factor ANOVA in Excel 2007. However each of my samples do not contain the same number of rows (see attached screenshot) and therefore excel is not allowing me to carry out the test. How can I resolve this?

**Marcol** · 05-20-2011, 03:53 AM

How can I resolve this?

How about starting by posting a workbook with some explanation for what a "a two-factor ANOVA" is?

**arthurbr** · 05-20-2011, 03:58 AM

Why post an image when you need a sheet?

**Layo909** · 05-20-2011, 04:05 AM

Thanks for the responses.

ANOVA is a type of statistical test. Sheet attached.

**Marcol** · 05-20-2011, 04:56 AM

Hmm?
Raphus cucullatus was a type of Columbidae

Some explanation of your statistical test would be a distinct help.
This is an Excel forum and not all members are familiar with this jargon.

What does it do?

[EDIT]
Does this link help?
ANOVA with Excel

**Layo909** · 05-20-2011, 05:04 AM

It tests to see whether the mean between samples are equal.

I was hoping that by posting on here, I might somebody who is familiar with using ANOVA within Excel (as opposed to posting on a statistics forum and finding somebody who is familiar with ANOVA but not within Excel).