One-way ANOVA in Microsoft® Excel

Chapter 7, Printout 1


  1. Launch Excel.

  2. Enter the data.

    Screenshot: screenshot

  3. Generate an Analysis of Variance table.

    Excel places an Analysis of Variance table in a new worksheet in the current workbook.

    Screenshot: screenshot

    Note: you can resize all columns to fit their contents by selecting all the cells you want to resize, then selecting "Format --> Column --> Autofit Selection."