Using the Chi Square Function
The chi square function of EZAnalyze allows you to conduct a "non-parametric" statistical hypothesis test to see if observed frequencies differ from expected values significantly. To keep the EZAnalyze functions consistent, the chi square function requires that the data be "raw" data for analysis. This is different than how chi square is typically used, where you create a chi square table first. The good news is that EZAnalyze creates the chi square table for you from your raw data, so you can interpret the results exactly the same as you would with any other chi square calculator.
To conduct a chi square analysis, you need to identify two categorical variables. For example, if you wanted to know if the number of male and female nurses is significantly different than the number of male and female police officers, your categorical variables would be "gender" and "occupation," with each containing two categories (male/female, and nurse/police officer). This would create a "two by two" chi square table, and tell you if the observed differences in your data are statistically significant. If you asked the same question, but also included firefighters as another occupation, you would then have a two by three chi square table. In EZAnalyze, there is technically no limit to the number of rows and columns your chi square table can contain, but larger tables are difficult to interpret and often not useful unless you have a very large sample.
To conduct a chi square analysis, select "Advanced" from the EZAnalyze menu in Excel, and then choose "Chi square".
When the "Chi square " dialogue box appears, you will be presented with two lists of the variables in your data sheet. Select a variable from the list under "Rows variable" and a different variable from "Columns variable" to create your chi square table. It is usually better to have more rows than columns, but it is really a matter of personal preference!
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)