How to do anova in excel mac

Analysis of Variance, or ANOVA, is an advanced technique that analyzes statistical data and tests to mean a hypothesis about the population. ANOVA can give you an idea if the mean between two populations is the same, as long as those two populations have roughly a normal distribution. Calculation Manual ANOVA involves multiple calculations and can be lengthy and error-prone. However, Microsoft Excel 2007 lets you calculate ANOVA in seconds. manual
1

Click the Tools tab, and then click
2

Click "Anova: Two-Factor With Replication" "Data Analysis." Or "Anova: Two-Factor Without Replication" and then click "OK."
3

Enter a range of cells for your input. For example, if you entered your data in cells A1 through A10, type "A1:. A10".
4

Enter the number of events per condition in the "Lines Per Sample" text box

5

Type a series of blank cells in the "Output Range" text box to indicate where you want the ANOVA data to go.
6

Click OK". Excel puts the results in the output location you specified.