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.
![Data used for one-way ANOVA in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-18-1.png)
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.
![Data Analysis in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-19-1.png)
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.”
![ANOVA: Single Factor in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-20-1.png)
Step 4: Add input range
Select A2 to C6, namely all cells with data, in the “Input Range.” Then, click “OK.”
![Input Range for One-way ANOVA](https://tidystat.com/wp-content/uploads/2023/01/image-21-1.png)
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.
![Output of One-way ANOVA in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-22-1.png)
If you want to download this Excel file, you can click here to download it from GitHub.