Histogram/Frecuency for Multiple Response Questions

  • Thread starter Thread starter OutdoorRuss
  • Start date Start date
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!
 
An Excel worksheet has more than enough cells to accomodate entering
data in multiple cells rather than pounding it all into one cell.

Use data>text to columns to break your numbers out so's you can use
them effectively.


Gord
 
Back
Top