Using Excel to Perform One-Way ANOVA
I’m sure you’ve come to the conclusion that calculating ANOVA manually is a lot of work, and I think you’ll be amazed how easy this procedure is using Excel.
1. Start by placing the fertilizer data in Columns A, B, and C in a blank sheet.
2. Go to the Tools menu and select Data Analysis. (Refer to the section “Installing the Data Analysis Add-in” from Chapter 2 if you don’t see the Data Analysis command on the Tools menu.)
3. From the Data Analysis dialog box, select Anova: Single Factor as shown in Figure 19.2 and click OK.
Setting up the one-way ANOVA in Excel.
4. Set up the Anova: ...