tabulating survey results

  • Thread starter Thread starter McNiwram
  • Start date Start date
M

McNiwram

I have created a survey from in excel containing 10
questions with each number having 5 choices (1-bad...5-
Very Good). I will send the survey form out to 30+
respondents. Now...how will i be able to automatically
tabulate the results in excel??? Any ideas???
 
McNiwram, one approach you might consider is data consolidation (Tools
menu). Since you are sending out 30+ identical worksheets, you should be
able to consolidate the responses by position on a master worksheet. As you
receive your responses, you can add them to the consolidated worksheet to
produce an "interim" consolidation (one that does NOT involve creating links
to the source data). When you have all your responses, you can do a "final"
consolidation (one that does create links to the source data). Then you can
massage the data from that point.

For more information, search the topics "Consolidate Data," then
"Consolidate data by position" in Excel help.
 
You might consider creating a "code string" concatenation of all 10 answers,
like "ABBCADCBDC", and have it automatically created as the user fills out
the survey and when they send it back to you, you could just use that one
cell value and reconstruct the selected answers and tabulate
them..........you might even create a macro that will open each of the
returns and extract that cell value to your evaluation sheet................

hth
Vaya con Dios,
Chuck, CABGx3
 
Thanks guys.

I'm actually confused now with your suggestions.
My intention was to count (for each question) how many
answered with a 1, 2, 3, 4, or 5. So i should be just
looking at total tally. Data consolidation might require
me to have 30+ worksheets present in the workbook before
I can consolidate it. Meanwhile, I am not keen on using
the "code string" approach.
 
Hi luzt..........

=COUNTIF(A:A,"yes")

Vaya con Dios,
Chuck, CABGx3




luzt said:
I'm trying to tabulate a similar amount of responses but have no clue how
Click to expand...
to do it. One of the questions is a "yes" or "no" question. How do I
tabulate the amount of times the response was yes or no? is there a way to
do that? I have created a worksheet to tabulate totals but can I total text
answers?
 
... but can I total text answers?

You could count the number of "Yes" responses, etc

For example, if the responses are in col A,
col header in A1, data from A2 down

Put in B1: =COUNTIF(A:A,"Yes")

B1 returns the number of "Yes" responses in col A

Put in B2: =COUNTA(A:A)-1

B2 returns the total number of all responses in col A

Put in B3: =B1/B2
Format B3 as percentage

B3 returns the percentage of "Yes" responses in col A

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----
luzt said:
I'm trying to tabulate a similar amount of responses but have no clue how
Click to expand...
to do it. One of the questions is a "yes" or "no" question. How do I
tabulate the amount of times the response was yes or no? is there a way to
do that? I have created a worksheet to tabulate totals but can I total text
answers?
 
If you are wanting to count ALL text responses, no matter what they are, you
could use a helper column and enter =IF(ISTEXT(A1),1,"") and copy it down
and then count the 1's in that column..........

Vaya con Dios,
Chuck, CABGx3



luzt said:
I'm trying to tabulate a similar amount of responses but have no clue how
Click to expand...
to do it. One of the questions is a "yes" or "no" question. How do I
tabulate the amount of times the response was yes or no? is there a way to
do that? I have created a worksheet to tabulate totals but can I total text
answers?
 
Back
Top