Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tabulate Survey Results in Excel 2003
I have a pile of survey results that I'd like to tabulate into one
spreadsheet. Some of the data in the surveys are numerical and some are text. Id like to have one master sheet in which I can show an average of all the numerical responses and show the percentage of respondents that gave the same answer for that particular question. Example: What is the sq. footage of your store? Average store is 1000 sq ft. What do you look for in a sales rep? 43% = Honesty 22% = Appearance 19% = Accessibility And so on€¦ Right now all the returned surveys are in hand-written form on the actual surveys themselves. Should I create a worksheet for each respondent with their answers so that the master sheet can refer back to them to tabulate the averages? How do I configure the master sheet so that it can keep a running tab and continue to add new respondents as the surveys are returned to me? How do you write formulas for these calculations? Any other advice or questions that will help in understanding what I want to do? Thanks so much!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tabulate Survey Results in Excel 2003
No.
I would create one sheet for each question, not each respondent. That will put all the data needed for statistical analysis on a single sheet. -- Gary''s Student - gsnu200844 "Stoshu K" wrote: I have a pile of survey results that I'd like to tabulate into one spreadsheet. Some of the data in the surveys are numerical and some are text. Id like to have one master sheet in which I can show an average of all the numerical responses and show the percentage of respondents that gave the same answer for that particular question. Example: What is the sq. footage of your store? Average store is 1000 sq ft. What do you look for in a sales rep? 43% = Honesty 22% = Appearance 19% = Accessibility And so on€¦ Right now all the returned surveys are in hand-written form on the actual surveys themselves. Should I create a worksheet for each respondent with their answers so that the master sheet can refer back to them to tabulate the averages? How do I configure the master sheet so that it can keep a running tab and continue to add new respondents as the surveys are returned to me? How do you write formulas for these calculations? Any other advice or questions that will help in understanding what I want to do? Thanks so much!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tabulate Survey Results in Excel 2003
Thanks GS! The advice about creating a new sheet for each question was
helpful. I managed to create some formulas to tabulate the numerical values...don't know if they were the most efficient way of doing it but they work. Any thoughts as to how to create statistics for the text and phrase responses? Example, as below: Q. What do you look for in a sales rep? 43% answered = Honesty 22% answered = Appearance 19% answered = Accessibility Any thoughts? "Gary''s Student" wrote: No. I would create one sheet for each question, not each respondent. That will put all the data needed for statistical analysis on a single sheet. -- Gary''s Student - gsnu200844 "Stoshu K" wrote: I have a pile of survey results that I'd like to tabulate into one spreadsheet. Some of the data in the surveys are numerical and some are text. Id like to have one master sheet in which I can show an average of all the numerical responses and show the percentage of respondents that gave the same answer for that particular question. Example: What is the sq. footage of your store? Average store is 1000 sq ft. What do you look for in a sales rep? 43% = Honesty 22% = Appearance 19% = Accessibility And so on€¦ Right now all the returned surveys are in hand-written form on the actual surveys themselves. Should I create a worksheet for each respondent with their answers so that the master sheet can refer back to them to tabulate the averages? How do I configure the master sheet so that it can keep a running tab and continue to add new respondents as the surveys are returned to me? How do you write formulas for these calculations? Any other advice or questions that will help in understanding what I want to do? Thanks so much!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Survey Results help | Excel Worksheet Functions | |||
survey results | Excel Worksheet Functions | |||
How do I create survey results into an Excel spreadsheet? | Setting up and Configuration of Excel | |||
how can I use excel to tabulate survey results | Excel Worksheet Functions | |||
how can I use excel to tabulate survey results | Excel Worksheet Functions |