Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jessie1
 
Posts: n/a
Default Data analysis data from a survey

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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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   Report Post  
Jessie1
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 06:15 PM
Data Analysis cjfidler Charts and Charting in Excel 1 January 16th 05 02:33 AM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 17th 04 12:07 AM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 12:56 PM
Data Table - Does it work with DDE links and stock tickers? Post Tenebras Lux Excel Discussion (Misc queries) 0 December 1st 04 06:15 PM


All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"