Solved
Why are totals in crosstabs incorrect?
We're new to using Qualtrics :)
We have put together some crosstabs from our survey and when we look at them the totals don't add up when we merge categories. For example, there's 45 and 45 and the total is 88. We want to use the Chi squares, but we can't if it looks like the data is messed up somehow.
Best answer by LaurenK
Hey @MNyouthresearch! For a question such as this, I would recommend reaching out to our Support Team as they will be able to further troubleshoot this and escalate if needed!
+43what is the question type you are using for cross tabs.
As for Single select sigma adds to 100%
while for Multi select it can be greater than 100%
Best Regards, Peeyush
Thanks for the response!
We have a Likert scale (Strongly Agree, Agree, Somewhat Agree, Neither Agree or Disagree, Somewhat Disagree, Disagree, and Strong Disagree) that we merged so all of the Agrees are together and all of the Disagrees are together. And we merged demographic categories into two categories.
For the demographic categories, they could select more than one, so is that what is contributing to the totals being less than 100%? That sounds like what you're saying.
+43How are you showing results is it like your nets agree, disagrees as rows and demographic as banner or columns.
If this is the case your column sum should be 100% not the row sum.
+13Hey @MNyouthresearch! For a question such as this, I would recommend reaching out to our Support Team as they will be able to further troubleshoot this and escalate if needed!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.