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!!!