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.