Chi Squared and Cross Tabulation
Wednesday, May 20th, 2009Qualtrics provides users with a Cross Tabulation feature that can be used to find relationships between two variables. When making a Cross Tabulation, at the bottom of the table, there is a Chi-Squared statistic and a p-value. This statistic helps you measure the probability of seeing the distributions we do in the data, assuming the two variables of interest are independent. A low p-value (less that 0.05) suggests there is a relationship between the two variables. The Chi-Squared is best used to find a relationship between two categorical variables like any Likert scale question and many demographic questions. If you want to find a relationship between two continuous variables, consider using R2 in Excel, SPSS, or another statistics package.
Many Qualtrics users want to evaluate how several variables affect a single response variable. The Cross Tabulation would be an exhausting process since each variable would have to be evaluated separately. The better way to do this would be to run a linear regression or logistic regression analysis in a statistics software package. This would allow you to see which variables influence your response and which ones do not. This will also help you make forecasts for your response variable. The data may have to be transformed to account for categorical variables, but this is not hard in most software packages.
