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

Click the Tools tab, and then click

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

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

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


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

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