How to Tabulate Survey Results

A survey is a great way to gather information about the needs and opinions of your target market. Many survey questions ask for answers that are too complex to tabulate (like, "What else would you like to tell us?"), but many survey questions use a multiple choice approach that lends itself to quantifying answers in a simple, direct format. Once you have tabulated your survey results, you can produce bar graphs or pie charts to depict these answers and make them even clearer and more accessible.

Create a chart for each question with a multiple choice answer. Dedicate a column for each possible choice.

Go through the completed surveys and make a scratch mark for each multiple choice answer in the column you have designated for that answer.

Count the scratch marks you have made next to each answer to determine the number of people surveyed who have chosen that option.

Count the total number of completed surveys. Divide the number of people who have chosen each answer by the total number of respondents to calculate the percentage of respondents who have chosen that particular answer.