If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
tabulating survey results
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??? |
#2
|
|||
|
|||
tabulating survey results
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. -- DDM "DDM's Microsoft Office Tips and Tricks" Visit us at www.ddmcomputing.com "McNiwram" wrote in message ... 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??? |
#3
|
|||
|
|||
tabulating survey results
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 "McNiwram" wrote in message ... 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??? |
#4
|
|||
|
|||
tabulating survey results
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. |
#5
|
|||
|
|||
tabulating survey results
I'm trying to tabulate a similar amount of responses but have no clue how 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?
|
#6
|
|||
|
|||
tabulating survey results
Hi luzt..........
=COUNTIF(A:A,"yes") Vaya con Dios, Chuck, CABGx3 "luzt" wrote in message ... I'm trying to tabulate a similar amount of responses but have no clue how 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? |
#7
|
|||
|
|||
tabulating survey results
... 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 atyahoodotcom ---- "luzt" wrote in message ... I'm trying to tabulate a similar amount of responses but have no clue how 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? |
#8
|
|||
|
|||
tabulating survey results
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" wrote in message ... I'm trying to tabulate a similar amount of responses but have no clue how 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? |
Thread Tools | |
Display Modes | |
|
|