Two Way ANOVA (Analysis of Variance) With Replication

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

When to Use Two Way Anova

Two Way Anova (Analysis of variance) , also known as two factor Anova, can help you determine if two or more samples have the same "mean" or average. This is a form of "hypothesis testing."

The null hypothesis is that the means are equal. The alternate hypothesis is that the means are not equal.

• H₀: Mean1 = Mean2 = Mean3
• H_a: Mean1 <> Mean2 <> Mean3

The goal is to accept or reject the null hypothesis (i.e., the samples have different means) at a certain confidence level (95% or 99%).

Two-Way ANOVA Analysis With Replication

What if you have two populations of patients (male/female) and three different kinds of medications, and you want to evaluate their effectiveness? You might run a study with three "replications", three men and three women.

Using the QI Macros, run a two-way Anova analysis with replication (alpha=0.05 for a 95% confidence).

What's cool about QI Macros ANOVA? Unlike other statistical software, the QI Macros is the only SPC software that compares the p-values (0.179) to the signficance (0.05) and tells you to "Accept the Null Hypothesis because p>0.05" and that the "Means are the same ".

Interpreting the Anova Two Way Results

In case you want to know how to do this manually, use these instructions.

Here, the P-value for Male/Female is greater than alpha (.179> .05), so we accept the null hypothesis that the means are the same. The P-Value for Drugs is greater than alpha (.106 > .05), so the null hypothesis holds as well (means are the same).

The P-value for the interaction of the drugs and patients is less than alpha (.006< .05), so we reject the null hypotheis and can say that the effectiveness of the drugs is not the same for the two categories of patients.

Tips on Setting Up Your Data in Excel

To analyze data, Excel requires you to set the data up in a way that can be analyzed.

The example below shows how to set up the data for two categories of patients treated with three different drugs.

Then, if you're just interested in the single factor DRUGS, select and run a Anova single factor on the three drug columns.

If you're interested in a Anova two-factor analysis (patients vs drugs), select and run a two-factor analysis with repetition (more than one patient in the category receives the same drug).

The QI Macros can perform the following types of tests and interpret the results for you by indicating whether you should accept or reject the null hypothesis:

• Anova One Way analysis
• Anova Two Way analysis without replication
• Anova Two Way analysis with replication

Other Statistical tests in the QI Macros

• data normality test
• test of proportion
• t test in Excel
• f test in Excel

Two Way Analysis of Variance is just one of the tools in the QI Macros Statistical Process Control Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

It's easy to do a Two-Way ANOVA with the QI Macros

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!