Data analysis data from a survey

[Guest]

I need to analysis data from a survey that was recently carried out. Does
anyone know how I could do this and keep a trail of the answers recd from
same persons

 

[Debra Dalgleish]

If you provide some details about the survey structure, and how you're
collecting the results, and what you want to analyze, someone may be
able to help you.

 

[Guest]

Hi Deborah

It is a survey that has been carried out in paper format. I have put the
questions and possible answers on a spread sheet. I will be analysing the
answers, i.e. in this case it is a crime perception survey on how people
feel. Do you need me to send you some sample questions etc?

Regards

Jessie1

 

[Dave Peterson]

I'm not Debra, but the first thing I would do is try to layout my data in a nice
manner.

If you have less than 256 questions, I'd put the questions in row 1 and the
answers for each person on separate rows.

So A1 could be Name (if not anonymous)
B1 Age
C1 Gender
D1 Income (???)
etc

Then the "real" questions.

So row 2 through ## would contain the results of each individual survey.

After you get the data entered, you could use =countif()'s, =sumif()'s,
=sumproduct()s, pivottables, charts and graphs, and anything else you can think
of.