**Microsoft Excel **is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default **Excel Functions** that we can use to create formulas. Many institutions use excel files to store important data. Sometimes, they need to perform statistical analysis and it’s easier to do that in excel. This article will show you the step-by-step procedures to **Interpret Two-Way ANOVA Results **in **Excel**.

## Download Practice Workbook

Download the following workbook to practice by yourself.

## Step by Step Procedures to Interpret Two-Way ANOVA Results in Excel

Often, we experiment or study certain aspects by splitting them into multiple groups. Those groups are independent and based on various factors. In **Two-Way ANOVA**, the groups are divided into **two factors**. **ANOVA **means **Analysis of Variance**. **Two-Way ANOVA** is a statistical analysis by which we can check the significant difference in the **means **of those independent groups. This article will demonstrate how to perform the **Two-Way ANOVA **in **Excel **and **Interpret **the **Results**. Therefore, go through the steps below carefully.

### STEP 1: Input Data in Excel

- First, we’ll input accurate data to perform the two-way
**ANOVA**. - In this example, we’ll consider the
**Height**growth in**inches**for a sample of**3**plants over some time. - The plants are divided into two groups based on the
**Watering Frequency**. - Here, we’ll also observe different
**Sunlight Exposure rates.** - See the following dataset to understand clearly.

### STEP 2: Select Data Analysis

- In this step, we’ll carry out the
**Data Analysis**. - However, if you don’t find the
**Data Analysis**option in the**Data**tab, follow the process below to add it. - Firstly, go to
**File**➤**Options**. - As a result, the
**Excel Options**dialog will emerge. - Then, go to the
**Add-ins tab.** - After that, click
**Excel Add-ins**from the**Manage**drop-down. - Subsequently, press
**Go**.

- Consequently, the
**Add-ins**dialog box will pop out. - There, check the box for
**Analysis ToolPak**. - Afterward, press
**OK**.

- Thus, you’ll get the
**Data Analysis**option in the**Data tab.** - Now, click it.

### STEP 3: Choose Two-Way Anova

- Accordingly, the
**Data Analysis**dialog box will appear. - Choose
**Anova: Two-Factor With Replication**. - Next, press
**OK**.

### STEP 4: Fill in Necessary Values

- Now, in the pop-out dialog box, we have to input the necessary values for the analysis.
- Firstly, select the
**Input Range B5:F11**. - As we’re working with
**3 plants**, insert**3**in**Rows per sample**. - Next, type
**0.05**in the**Alpha**box as a significance level. - After that, we’ll spill the results in the range starting from the
**H2 cell.** - So, select the
**H2**cell as the**Output Range**. - Lastly, press
**OK**.

### STEP 5: Interpret Result

- Hence, it’ll return the
**Two-Way ANOVA Results**in the specified range. - Look at the below picture.
- For convenience, we’ll show the results in
**2 figures.** - The first table shows the results for the first group where the
**Watering Frequency**is**Daily**. - For instance, the
**Average Height**of the**3**plants was**5.27****inches**for the**Daily****Watering Frequency**and**Low**sunlight exposure. - Similarly, the second table is for the
**Weekly**watering frequency. - There, you will notice the
**Average Height**of the plants was**6.1 inches**for the**Weekly****Watering Frequency**and**Medium**sunlight exposure. - In this way, you can interpret all other outputs.

- Moreover, the third table calculates the
**Total**. - You’ll find that the
**Average**height is greater (**5.93**) for the plants that received**Medium**sunlight exposure. - Finally, the last table shows the two-way
**ANOVA**. - We can interpret the results as:
is the obtained**0.29815****Interaction****P-value**between**Sunlight Exposure**and**Watering Frequency**. We have set the**Alpha**level as**0.05**. So, this is not statistically significant.**0.55913**is the watering frequency**P-value**. This is also statistically insignificant.- But, the sunlight exposure
**P-value**(**0.00036**) is significant in the statistical analysis according to the**0.05 Alpha**level.

- These outputs clarify that only
**Sunlight Exposure**has a significant effect on plant growth. - As the interaction between
**Watering Frequency**and**Sunlight Exposure**is insignificant, the sunlight exposure effect remains consistent across different watering frequencies.

## Conclusion

Henceforth, you will be able to** Interpret Two-Way ANOVA Results **in **Excel **following the above-described procedures. Keep using them and let us know if you have more ways to do the task. Follow **the ExcelDemy** website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.