O'Reilly logo

The Complete Idiot's Guide to Statistics, 2nd Edition by Robert Donnelly

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.
Figure 19.2
Setting up the one-way ANOVA in Excel.
640
4. Set up the Anova: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required