This tutorial shows how you can do one-way **ANOVA** (analysis of variance) in Excel. Note that, **one-way ANOVA** is also called **single factor ANOVA**.

## Steps of One-Way ANOVA in Excel

## Step 1: Prepare the data

Suppose we would like to see whether 3 cities differ in terms of household size. We sample 5 households from each city. The following is the data for this analysis.

The null hypothesis and alternative hypothesis for one-way ANOVA are as follows.

**Null Hypothesis:**All 3 cities have the same household size.**Alternative Hypothesis:**At least two cities does not have the same household size.

## Step 2: Click “Data Analysis”

Next, click “**Data**” menu and find the “**Analysis**” box. Then, click “**Data Analysis**” module.

If you can not find the **Data Analysis**” module, please refer to another tutorial showing how to add “Data Analysis” to Excel.

## Step 3: Click “ANOVA: Single Factor”

On the pop-up window, click the “**ANOVA: Single Factor**” and then click “**OK**.”

## Step 4: Add input range

Select A2 to C6, namely all cells with data, in the “**Input Range**.” Then, click “**OK**.”

## Step 5: Interpret the output

Since the p-value = 0.59, which is greater than 0.05, we fail to reject the null hypothesis. Thus, we can conclude that these 3 cities have roughly the same household size.

If you want to download this Excel file, you can click here to download it from GitHub.