Analyzing Results of a Survey Using Option Buttons

C

colleen

I have a bunch of scenarios, for each scenario I ask a number of questions,
each question has 3 options (using option buttons) "Yes", "No", "Maybe";
It's a survey, and I will have a number of surveys coming back and need to
summarize the results.
Spreadsheet Looks Something Like:
Column A Column B Column C Column D Column E...
Scenario1 Answer Question1 Question2 Question 3...
Yes Option Button Option Button
No Option Button Option Button
Maybe Option Button Option Button
Scenario2 (same as above)

Each of the 3 options per question, per scenario, are grouped together, so
for Scenario 1, Question 1, you can select one of the 3 options (Yes, no, mb
-- in cell B) - there are only radio buttons in column C, D, etc (no text).

This survey will go out to a number of people, and I need to
summarize/analyze the results. I can save each survey that comes back in the
same file (each tab will have persons name on the tab name.) So I'm thinking
along the lines of summarizing on a separate sheet, the number of respondents
who clicked yes to scenario 1, question 1, (# clicked no, etc.), and I can
then get to percentages on my own. So I am looking for a way to summarize
across a number of sheets the results. Any ideas? Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Analyzing survey results 6
How can I use Option Buttons independently in a mutli-tabed Excelf 1
Tabulating Survey Results 3
how do I make columns independent of each other? 1
Radio Buttons 3
go to fitst column of next row when enter (or other key) is presse 1
Average if questions 2
Analyze Survey Results in Access - Matrix form 0

Top