Hi,
I'm working on the analysis of my data and I'm having a problem with the multiple choice questions that can get multiple answers.
This particular question consists of 22 different types of activities, which belong to 4 different categories (direct, indirect, consumptive and indoor). Now, I would like to see for each respondent, how many activities they have selected for each category --> e.g. 5 direct, 3 indirect, 2 consumptive, 0 indoor.
When exporting my data to SPSS, each choice exports as its own column header, rather than having it in one column. Is there a way to change this?
I have already tried to recode my values for this question by assigning a number to each activity based on their category to make the analysis easier, but this way it doesn't register the amount of times category 1, 2, 3 or 4 is chosen.
Does anyone have a solution to this?
Best answer by bstrahin
View original