Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have to analyze a survey. The survey consists of some yes/no questions, some numeric questions and some questions like the following (free text where respondents have entered multiple answers).

Do you have any social networking accounts (Facebook, Twitter, Myspace etc) Y N
If yes, which ones _____________________________

Respondents answer: Facebook and Twitter

How do I put these types of answer into Excel to gain some sort of useful analysis?

PS. I know Excel is not great for surveys, but can't spend $1000 on SPSS or similar.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

How are you asking your survey? Paper, email? You might look at one of the free online survey tools, or something you can run on a Linux server (if you have access to one) like LimeSurvey that will export results directly in Excel format and also give you stats on the screen too.

share|improve this answer
    
LimeSurvey will also export directly to SPSS. –  Deckard Jul 2 '12 at 22:14

If you really insist on using Excel, you could try CooWire, or transforming your text data to numeric to be able to graph manually. E.g.: making Excel count the "Twitter" and "Facebook" words in a column and plot it.

I would rather use a software more comfortable with survey analyzing, and you do not have to pay for it by all means, look for the command-line R, PSPP (a free alternative to SPSS) or any GUI to R, like Rcommander, R.net, RKWard and so on,

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.