How to Tabulate Survey Results

by Devra Gartenstein

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.

Items you will need

  • Survey results

About the Author

Devra Gartenstein has owned and run a variety of food businesses for more than 20 years. She has published two cookbooks: "The Accidental Vegan" and "Local Bounty." Gartenstein holds Master of Arts degrees in philosophy and English literature.