A balanced design has an equal number of observations for all possible combinations of factor levels. An unbalanced design has an unequal number of observations.

### Balanced Design

You have exactly the same number of observations for all possible combinations of the factor levels for factors A and B: (0,0), (1,0), (0,1), and (1,1).

C1 |
C2 |

A |
B |

0 |
0 |

0 |
0 |

0 |
1 |

0 |
1 |

1 |
0 |

1 |
0 |

1 |
1 |

1 |
1 |

### Unbalanced Design

Here, you have three (0, 0) factor level combinations, one (1,1) factor level combination, and two of the other combinations. Either the extra combination or the missing combination, by itself, makes this design unbalanced.

C1 |
C2 |

A |
B |

0 |
0 |

0 |
0 |

0 |
0 |

0 |
1 |

0 |
1 |

1 |
0 |

1 |
0 |

1 |
1 |

Analysis of a balanced design is usually straightforward because you can use the differences between the raw factor level means for your estimates of the main and interaction effects. If your design is not balanced, either by plan or by accidental loss of data, differences in the raw factor level means may show the unbalanced observations instead of changes in factor levels. For unbalanced designs, you can use fitted means to predict the results a balanced design would have produced.

## Determine whether your data are balanced

For a small data set, you can look in the worksheet and easily see if the data are balanced. To determine whether your data are balanced with large data sets, create a cross tabulation table:

Examine the cells in the resulting output. A cell is the intersection of a row and a column. If a cell's count is not equal to the counts of all other cells, you have unbalanced data.