Survey Tabulation and Analysis

[barnicoate]

WIN XP
Excel XP
Win Vista (64)
Excel 7

Hi

I have a small amount of knowledge of excel and I am trying to tabulate and analyse data from a survey.

1. 26 questions
2. Broken into 5 sections
3. Some simple Yes No
4. Some multiple choice with only 1 choice allowed
5. Some multiple choice with up to 3 choices allowed..
6. The choices at present are represented in a,b,c etc.
7. I have 100 returned survey sheets. Therefore 100 sets of unique data.

I need to be able to enter the information and then have both totals and percentiles.

I have used COUNT statements in other spreadsheets, but this appears to be un-suitable for my present needs.

Q1. In some questions I have up to 9 choices with 3 requested, how do I have excel calculate the 1st choice, 2nd choice, 3rd choice and show them ?

Q2. Should I use the a,b,c format or numerical.

Q3. Will I best be served by putting the questions/answer's into Pivot Tables (whatever they are) ?

Thank you for any help the members of the forum can give, and I am sure I will have many more as I work my way through.

[BigDat6CC]

Hello

Please supply sample spreadsheet.

[barnicoate]

Thank you for your prompt reply, I have been away for a time attached is a sample workbook with questions included.

Thank you

[barnicoate]

Sorry I attempted to attach a copy but no go database crash at forum end..

[barnicoate]

I solved the questions as per the attached spreadsheet, thanks for your help on one area I had questions for.