Calculate Two-Factor Factorial ANOVA

Enter Sum of Squares (SSA, SSB, SSAB, SSE), levels (a, b), and cell replicates (r).

Factor A $\text{SS}_A$ (e.g. 80).
Factor B $\text{SS}_B$ (e.g. 60).
Interaction $\text{SS}_{AB}$ (e.g. 40).
Error $\text{SS}_E$ (e.g. 200).
Levels $a \ge 2$ (e.g. 2).
Levels $b \ge 2$ (e.g. 3).
Replicates $r \ge 2$ (e.g. 5).

Calculation Results

Primary Metric Output --
Metric Breakdown 1--
Metric Breakdown 2--
Metric Breakdown 3--
Metric Breakdown 4--
Metric Breakdown 5--
Mathematical Standard--

Calculated using Two-Way factorial ANOVA equations: F_A = \frac{\text{MSA}}{\text{MSE}}, \quad F_B = \frac{\text{MSB}}{\text{MSE}}, \quad F_{AB} = \frac{\text{MSAB}}{\text{MSE}}

*Note: Two-Way ANOVA evaluates the simultaneous main effects of two categorical independent variables and their interaction effect on a continuous outcome.

Quick Summary

The Two-Way ANOVA Calculator evaluates Factor A main effect ($F_A$), Factor B main effect ($F_B$), and interaction effect ($F_{AB}$).

Formula Explanation

F_A = \frac{\text{SSA} / (a - 1)}{\text{SSE} / [ab(r - 1)]}, \quad F_B = \frac{\text{SSB} / (b - 1)}{\text{SSE} / [ab(r - 1)]}
F_{AB} = \frac{\text{SSAB} / [(a - 1)(b - 1)]}{\text{SSE} / [ab(r - 1)]}

How It Works

Two-Way ANOVA tests the effect of two factors (e.g. Gender and Treatment) simultaneously. The Two-Way ANOVA Calculator computes Mean Square Error ($\text{MSE} = \text{SSE} / df_E$) and tests main effects $F_A, F_B$ and interaction $F_{AB}$.

Step-by-Step Worked Example

Practical Problem: Factor A (Gender, $a = 2$), Factor B (Drug Dose, $b = 3$), with $r = 5$ replicates per cell ($N = 30$). $\text{SSA} = 80, \text{SSB} = 60, \text{SSAB} = 40, \text{SSE} = 200$. Calculate $F_A, F_B, F_{AB}$.

  1. Step 1: Calculate Error df ($df_E$): $df_E = 2 \times 3 \times (5 - 1) = 6 \times 4 = \mathbf{24}$.
  2. Step 2: Calculate Mean Square Error (MSE): $\text{MSE} = 200 / 24 = \mathbf{8.3333}$.
  3. Step 3: Calculate Factor A F-ratio ($F_A$): $df_A = 1; \text{MSA} = 80/1 = 80; F_A = 80 / 8.3333 = \mathbf{9.6000}$.
  4. Step 4: Calculate Factor B F-ratio ($F_B$): $df_B = 2; \text{MSB} = 60/2 = 30; F_B = 30 / 8.3333 = \mathbf{3.6000}$.
  5. Step 5: Calculate Interaction F-ratio ($F_{AB}$): $df_{AB} = 2; \text{MSAB} = 40/2 = 20; F_{AB} = 20 / 8.3333 = \mathbf{2.4000}$.

Real-World Calculation Examples

Scenario 1: Gender × Drug Dosage Factorial

Parameters: a = 2, b = 3, r = 5
Result: FA = 9.60, FB = 3.60, FAB = 2.40.

Scenario 2: Plant Growth (Light × Fertilizer)

Parameters: 3 Light levels × 3 Fertilizers
Result: 3x3 factorial ANOVA.

Scenario 3: Advertising Channel × Target Age

Parameters: 2 Mediums × 4 Age brackets
Result: Interaction effect analysis.

Scenario 4: Industrial Temperature × Pressure Strength

Parameters: Manufacturing process optimization
Result: Two-Way ANOVA table output.

Key Benefits of Using This Calculator

Dual Main Effects + Interaction

Tests Factor A main effect, Factor B main effect, and $A \times B$ interaction simultaneously.

Complete Factorial $a \times b$ Design

Supports any combination of factor levels and cell replicates.

Mean Squares & MSE Output

Outputs MSA, MSB, MSAB, and Mean Square Error (MSE).

100% Free & Client-Side

Executes locally in your browser with zero latency or web server transmission.

Frequently Asked Questions (FAQ)

What is Two-Way ANOVA?

Two-Way ANOVA evaluates the impact of two categorical independent variables (factors) on a continuous dependent variable.

What is an interaction effect ($A \times B$)?

An interaction effect occurs when the effect of one factor depends on the level of the other factor.

How do I calculate Two-Way ANOVA in Excel?

Use Excel Data Analysis Toolpak: Anova: Two-Factor With Replication.

What is difference between balanced and unbalanced Two-Way ANOVA?

Balanced ANOVA has equal cell counts ($r$); unbalanced ANOVA has unequal sample sizes per cell (requiring Type III SS).

What are main effects?

Main effects measure the overall impact of Factor A or Factor B independently, averaging over the other factor.

What if interaction effect is statistically significant?

If interaction $F_{AB}$ is significant, interpret main effects cautiously and inspect simple main effects plots.

What is partial Eta Squared ($\eta_p^2$)?

$\eta_p^2 = \frac{\text{SS}_{\text{factor}}}{\text{SS}_{\text{factor}} + \text{SSE}}$, measuring effect size controlling for other factors.

What assumptions are required for Two-Way ANOVA?

1. Normally distributed cell residuals. 2. Equal variances across cells (homoscedasticity). 3. Independent observations.

What is a cell replicate ($r$)?

The number of individual observations within each unique combination of Factor A and Factor B levels.

What is Three-Way ANOVA?

Three-Way ANOVA evaluates 3 factors simultaneously ($F_A, F_B, F_C, F_{AB}, F_{AC}, F_{BC}, F_{ABC}$).