daenerys comments on 2012 Less Wrong Census Survey: Call For Critiques/Questions - Less Wrong Discussion
You are viewing a comment permalink. View the original post to see all comments and the full post content.
You are viewing a comment permalink. View the original post to see all comments and the full post content.
Comments (479)
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:
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
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.