The c2 procedure tests if there is association between the classification of one variable and the classification of another variable. The data must be summarized and presented in a table form where the cells contains frequency counts for various levels. The null hypothesis states that no association exists. ProcessMA highlights to you the number of cells with expected frequencies less than 5. This is because the chi-square test may not be reliable is more than 20% of the cells are less than 5 and especially when they have a significant contribution to chi-square statistics (small p value). An alternative method is to combine categories so that cells with small expected frequencies are treated as one.
Note: Limited to 10 variables at one time.
At the Excel Menu (For Excel 2007, go to Add-ins first)
Choose ProcessMA > Statistics > Basic Statistics > Chi-Square and Contingency Table
In Variables, select the columns containing the data (Numeric, >=2 Variables)
In Label, select column containing row labels for the variables
Click OK
You want to find out if there is a connection between age group and flavours of biscuits they like. You surveyed 200 people and recorded the number of people that chose the different flavours they like.
Open data worksheet by choosing ProcessMA > Tools > Data
Choose ProcessMA > Statistics > Basic Statistics > Chi-Square and Contingency Table
In Variables, select BZ - Chocolate, CA - Strawberry, CB - Vanilla
In Label, select BY - Age
Click OK
For a desired a = 0.05, since p = 0. 438> a, we fail to reject H0. Therefore, we conclude that there is no significant evidence that age and their liking for different flavours of biscuits are related.
Copyright © ProcessMA