The output of a crosstabs analysis contains a number of elements. The chi square test allows us to test this hypothesis.
The null hypothesis of our hypothetical study is that these variables are not associated with each other – they are independent variables. Each variable has two possible values: No Religion and Christian for the Religion variable Meat Eater and Vegetarian for the Eating variable. The crosstabs analysis above is for two categorical variables, Religion and Eating. You should be looking at a result that looks something like this in the SPSS output viewer.
( We have a different tutorial explaining how to do a chi square test in SPSS). The tutorial starts from the assumption that you have already calculated the chi square statistic for your data set, and you want to know how to interpret the result that SPSS has generated.
Observed FrequencyĬhi Squared Test of Contingency Table – Manual Calculation Such table is also known as “cross-tab” or “matrix report”.īelow is an example of a cross-tab table, illustrating how many male and female for different undergraduate degree. In Excel, Contingency Table is a Pivot Table where we have a variable in the column and a variable in row, and count the frequency that falls into the combination. This Excel / SPSS tutorial explains how to calculate Chi Squared Test of Contingency Table in Excel, SPSS and manual calculation.Įxcel SPSS Chi Squared Goodness of fit test SPSS Excel Chi Squared Test of Contingency TableĬhi Squared Test of Contingency Table is used to infer whether two nominal variables in the population are related.