Hi all,
I have results from about 300 print surveys that I am starting to compile in Excel, and I figured it would be wise to ask this question after I've inputted results from only 20 of them rather than after 300 and be told I did it wrong ...
My experience with Excel is very limited — I've used it twice, after others set up the documents for me. So I thank you in advance for your patience. Anyway, here's what I'd like to accomplish:
* I want to configure it so this project will calculate (and chart, if possible) the percentages for the multiple-choice answers (represented by the the range of letters a-f) to each question — i.e. I want to be able to make this statement after quickly glancing at Excel: For question 6, 23 percent of respondents answered "a", 46 percent answered "b", 3 percent answered "c", and 28 percent answered "d".
* I also would like to be able to filter the data, so I can say something like, "X percent of those who answered "a" to question 9 said (result of another question)."
I've attached the the barebones files that I've started with. When respondents failed to answer or circled multiple answers, the corresponding cell was left blank.
Again, thank you for your time & suggestions.
Bookmarks