How to perform a Nested ANOVA Test in Excel?

A nested ANOVA is a sort of ANOVA ("examination of fluctuation") in which something like one component is settled inside another element. For instance, assume a specialist needs to know whether three unique formulas of medicine produce various degrees of treatment. To test this, he has three unique experts treat  formula A on four patients each, another three specialists test formula B on four patients each, and another three experts test formula  C on four patients each. In this situation, the response variable is patient's reaction to formula and the two elements are expert and formula. It just so happens, expert is nested inside formula. Now let us learn how to perform nested ANOVA.

Perform a Nested ANOVA in Excel

To perform a nested ANOVA follow the following steps:

Step 1: Enter the Data in the Excel Worksheet. In the first place, we should enter the information in the accompanying arrangement:

Step 2: Fit the Nested ANOVA. There is no inherent Nested ANOVA work in Excel, however, we can utilize the Anova: Two-Factor With Replication choice from the Data Analysis ToolPak to play out a settled ANOVA for certain changes. Now click the Data tab along the top strip. Then click the Data Analysis button inside the Analyze bunch:

On the off chance that you don't see this choice, you really want to initially stack the Data Analysis ToolPak in Excel. Click on add-ins in excel options and then add  Data Analysis ToolPak in Excel. In the window that shows up, click Anova: Two-Factor With Replication and afterward click OK. In the new window that shows up, enter the accompanying data:

When you click the OK button and you will get the following output:

Step 3: Now interpret the Output. The ANOVA table displayed at the lower part of the result is the one table that we will zero in on. The column marked Sample shows the outcomes for Formula. The p-esteem in this line (4.27E-10) is under .05, so we can presume that manure is genuinely huge. To decide whether the nested element "expert" is measurably huge, we should play out the accompanying manual computations:

These outcomes tell us that if we want to increase the patient's response to treatment, we should focus on the formula being used rather than the individual expert who is treating the patient.