daenerys comments on 2012 Less Wrong Census Survey: Call For Critiques/Questions - Less Wrong

20 Post author: Yvain 19 October 2012 01:12AM

You are viewing a comment permalink. View the original post to see all comments and the full post content.

Comments (479)

You are viewing a single comment's thread. Show more comments above.

Comment author: [deleted] 19 October 2012 11:59:57AM *  4 points [-]

I will probably not be implementing any suggestion that requests a multi-checkbox style question... [examples] The reason is that I haven't been able to figure out how to computer process these effectively; I end out with rows of boxes like "hiking,fishing" or "fishing,boating,climbing" and it's apparently beyond my limited skills to get SPSS to separate these out into separate chunks of information....[examples] Or, teach me a good way to solve this problem using Google Forms and SPSS.

I assume you can put the spreadsheet in excel, yes? Excel is much more powerful than Google docs, and I don't know SPSS.

If so, what you need is to add columns for each option, and put in the relevant version of the line below:

=IF(ISNUMBER(SEARCH("hiking",A1)),"hikes"," ")

This will search the text in box A1 (assume column A is the one with answers like "hiking, swimming, sailing" or whatever), and if it contains the text "hiking" will write "hikes", and if not will write nothing (or "doesn't hike")

If I didn't explain well enough, let me know!

ETA: And if you don't mind just having "TRUE" and "FALSE" as your output (instead of "hikes" and " ") then you can also just use

=ISNUMBER(SEARCH("hiking",A1))

Comment author: Yvain 21 October 2012 10:56:22PM 1 point [-]

Thank you. I'm going to try this, and I might ask you for more help if I can't get it to work on my own.