Using the ANOVA - Single Factor Function
The ANOVA function in EZAnalyze allows you to conduct a statistical hypothesis test on more than two group means. Since this is an Advanced feature of EZAnalyze, it will not be discussed at length here. Feel free to consult a statistics textbook or the Internet for information on what ANOVA is and how it works. If you are already familiar with ANOVA and want EZAnalyze to crunch the numbers for you, read on!
To ensure that your data is ready for an ANOVA, make sure that you have a single dependent variable in mind and that your categorical variable contains all of the groups. SO, for example, if you wanted to see if different ethnic groups in your school had significantly different GPA's, you would have one variable in your data to represent GPA, and another variable to represent Ethnicity.
To perform an ANOVA on your data, select "Advanced" from the EZAnalyze menu in Excel, and then choose "ANOVA".
When the "ANOVA" dialog box appears, select a dependent variable from the list on the left, and a categorical (independent) variable (your grouping variable) from the list on the right. When you are satisfied with your choices, click OK.
When you click OK, a results report will be printed on a separate sheet for your review. (click on "results report" for information on how to interpret this analysis)