Most statistical software and spreadsheets will allow you to compute a one-way analysis of variance when you have the actual data. This Excel spreadsheet application is written to allow you to compute a one-way ANOVA table when you know the summary data.

The data that is already in the spreadsheet corresponds to the data from the example used in the one-way ANOVA powerpoint where the mean scores of the front, middle, and back rows in a statistics course were compared.

Enter your summary statistics into the table at the bottom of the spreadsheet and the resulting one-way ANOVA table will be displayed at the top of the spreadsheet. You may enter the summary statistics for up to ten samples.

If you have problems with the embedded Excel spreadsheet, you may open the spreadsheet directly.