How to create a multiple repsonse set?
Posted: Thu Jun 06, 2024 7:45 am
Hey,
I'm currently starting to analyze my questionnaire study and found a problem I can't solve.
My problem:
When you ask questions where respondents are allowed to give more than one answer, this will result is more than one variable in the excel data file [multpile response set]. But since the answers all relate to the same question, I would like to present them in a single table or graph. Now my problem is I can“t find any order to define this set of variables as belonging to a group.
Here is an example:
Why don't you like sports?
[These are the variables to choose from]
1. Nofun 2.bad 3.hurts 4.boring 5.FGH
0 1 0 0 1
1 1 0 0 0
0 0 1 0 0
I'm very thankful for any hint
Best regards from Greekfreak
I'm currently starting to analyze my questionnaire study and found a problem I can't solve.
My problem:
When you ask questions where respondents are allowed to give more than one answer, this will result is more than one variable in the excel data file [multpile response set]. But since the answers all relate to the same question, I would like to present them in a single table or graph. Now my problem is I can“t find any order to define this set of variables as belonging to a group.
Here is an example:
Why don't you like sports?
[These are the variables to choose from]
1. Nofun 2.bad 3.hurts 4.boring 5.FGH
0 1 0 0 1
1 1 0 0 0
0 0 1 0 0
I'm very thankful for any hint
Best regards from Greekfreak