05, so we can conclude that fertilizer is statistically significant. The p-value in this row (4.27031E-10) is less than.

The row labeled Sample shows the results for fertilizer. The ANOVA table shown at the bottom of the output is the one table that we will focus on. Once you click OK, the following output will appear: In the new window that appears, enter the following information:

In the window that appears, click Anova: Two-Factor With Replication and then click OK. If you don’t see this option, you need to first load the Data Analysis ToolPak in Excel. Then click the Data Analysis button within the Analyze group: To do so, click the Data tab along the top ribbon. There is no built-in Nested ANOVA function in Excel, but we can use the Anova: Two-Factor With Replication option from the Data Analysis ToolPak to perform a nested ANOVA with some tweaks. Step 1: Enter the Dataįirst, let’s enter the data in the following format: The following step-by-step example shows how to perform this nested ANOVA in Excel. It turns out that technician is nested within fertilizer: In this scenario, the response variable is plant growth and the two factors are technician and fertilizer. To test this, he has three different technicians sprinkle fertilizer A on four plants each, another three technicians sprinkle fertilizer B on four plants each, and another three technicians sprinkle fertilizer C on four plants each. A nested ANOVA is a type of ANOVA (“analysis of variance”) in which at least one factor is nested inside another factor.įor example, suppose a researcher wants to know if three different fertilizers produce different levels of plant growth.

How to do an anova in excel