Need help analyzing survey in Excel!!?

I need to analyze survey results in Excel. I don't need to compare one question with another question (i.e. How many 15-19 year olds think smoking is harmful) so the Pivot Table component is no use (or is it?). I just need to know how many of people answered Q1 with a response of A, how many with a response of B, etc.





I can only think of analyzing each question separately. Any suggestions? Thanks!

Need help analyzing survey in Excel!!?
Yes, a pivot table should be just the thing.





Let's say you have Question#s (Q1, Q2, etc.) in col. A, and Answers in col. B (A, B, C, etc.).





1) select all your data; just be sure that each column in your selected data has a heading at the top.





2) Data - PivotTable and PivotChart Report, this will bring up the pivot table wizard


- step 1: say OK


- step 2: make sure all your data is selected


- step 3: pick whether you want it in a new sheet


This will create the empty table structure.





3) You should have a list of fields on the right, showing Question#, Answer, and whatever else you selected.


- drag the Question# field to where it says "Drop Row fields here" on the left


- drag the Answer field to top of the table, where it says "Drop Column fields here"


- drag the Question# again, this time to where it says "Drop Data Items here"





You will end up with a table that has a row for each Question, and columns for how many people answered A, how many answered B, etc.





If you need more info, pls. add detail or e-mail.


Good luck!


.
Reply:if you have access to a mac with office installed, excel contains a feature called "list manager" that can easily do what you want. if not, your best bet is to set up a counter for each possible response and do it that way (don't know the formula off the top of my head). should be fairly quick, unless you have a lot of questions.