O
OutdoorRuss
I have data from a survey that contains multiple-answer values.
The student can choose up to 18 different answers depending on the
question.
These answers are being entered in a single cell and separated by a
comma, such as 1,3,4,7. For example:
ID Q1 Q2 Q3
1 1,3,4,7 2,4 1,12,18
2 4,5 1,6 1, 7, 9
I am trying to prepare histograms and graphs of the reponses. I've
done this successfully for surveys with single responses, but not with
multiple options.
I have tried to do a frequency function. Excel doesn't want to accept
numbers separated by commas or
spaces as it doesn't count numbers in lists such as above.
I appreciate any help. Thanks!
The student can choose up to 18 different answers depending on the
question.
These answers are being entered in a single cell and separated by a
comma, such as 1,3,4,7. For example:
ID Q1 Q2 Q3
1 1,3,4,7 2,4 1,12,18
2 4,5 1,6 1, 7, 9
I am trying to prepare histograms and graphs of the reponses. I've
done this successfully for surveys with single responses, but not with
multiple options.
I have tried to do a frequency function. Excel doesn't want to accept
numbers separated by commas or
spaces as it doesn't count numbers in lists such as above.
I appreciate any help. Thanks!