I am analysing data from a 34 question survey. I’m using Excel. I want to separate the data in multiple ways, for example one question is “Gender?”: (2 response options: Male, Female) Can I separate the data so I can compare all answers for male participants with all answers for female participants. Similarly another question is “Participation in study group?”: (2 response options: Yes, No). Can I separate so I can compare all answers for those who participated in a study group with all answers for those who did not?
You may also use
- group by for Kobo Report on server level
- column filter in table view.
2 Likes