Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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. Jessie1 wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
![]() |
|||
|
|||
![]()
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 "Debra Dalgleish" wrote: 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. Jessie1 wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
![]() |
|||
|
|||
![]()
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. Jessie1 wrote: 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 "Debra Dalgleish" wrote: 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. Jessie1 wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Data Analysis | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |