• Facepunch Census 2015 RESULTS
    184 replies, posted
[img]http://imgkk.com/i/iyrb.png[/img] I've kept you all waiting too long, and I'm sick of dealing with this data. SO IT'S RESULTS DAY --- THE RESULTS --- -> [url=https://docs.google.com/forms/d/1KzFkCxGif9GZHXwF9d5b8mXB2YDHqpgB-Zl5jrOTju0/viewanalytics]Google Forms summary[/url] Great for the simpler questions, with all the charts you need. But for the text-entry ones it's pretty much useless cos it just lists all the unique answers it got - which is why I went to all this effort: -> [url=https://docs.google.com/spreadsheets/d/1VTtPTJZtwjhyqgdejF4b-VKE9w8L9xxPiFDDNMQbNy4/edit?usp=sharing]Sorted Responses + Pivot Tables[/url] The first sheet is a list of all the responses the census got. The blue columns are raw data (exactly what people entered). The red columns are sorted data, where I've been through and grouped the data to make it more useful (an example I used was placing all the different spellings of 'GTAV' into the same group). The other sheets are all pivot tables - these are the main event. They rank all the (sorted) responses each question got, and show how many people put each response. There ought to be charts for most of these, but right now I've only added like a dozen or so. I figure you'd rather get the results now than wait for me to put these charts in. So for a lot of the questions you can look at the Google Forms summary, but for questions like 'what was your GOTY 2014' and fucking 'who is your waifu' you'll need to look at the pivot tables to find something meaningful. -> [url=https://docs.google.com/document/d/1IVjOVuozp6kEcjyKWjG7tR8ECj87O9t8Ofdf_BhaeZQ/edit?usp=sharing]List of questions[/url] You'll probably need this in another tab, because right now the pivot table sheets don't have the questions shown on them. I'll probably fix that later on. -> [url=https://docs.google.com/spreadsheets/d/1c_Y7uM3-PFLC8-8WVJtDgDRpmYQTWEAdzBXvOCwIqH4/edit?usp=sharing]Sorted Responses[/url] This is just the responses sheet from the first link. You'll need this if you want to fuck around with the data yourself, because the workbook with the pivot tables will hit the cell limit if you add another sheet to it. It also includes two example pivot tables for the 'how to analyse this data' section I've written below. -> [url=https://docs.google.com/spreadsheets/d/1mmWP-fA4qhHrRqXt1VcVCbRGnfmtBs_eA2PUIA92BRA/edit?usp=sharing]Raw Responses[/url] This is the exact sheet that Google Forms spat out. I'm releasing it just in case I fucked anything up with all my meddling on the main form. Hopefully you won't need this, because all the data is included on the main form anyway. --- NOTES --- - The grouping isn't perfect, but I had to go through 1000 responses so I couldn't spend too long pondering how to categorise each and every response - For questions where I asked for one answer and you put multiple things, I've just counted the first thing you put (but your full answer is still there in the raw data) - On the questions that said 'enter as many responses as you like', I've just counted the first five you put. Sorry about that. - There's various other things you might wonder about the way I've sorted certain data - feel free to ask any questions you have about that. --- STUFF MIGHT BE FUCKED --- Yeah I still need to add more charts and neaten everything up. But I just need to get these results out there at this point. I wanted everything to be all neat and tidy but this whole thing is really stressing me out now so I'm just going to release it now and maybe neaten it all up later. Some of the data could be fucked in some ways - if you find anything that's fucked let me know and I'll fix it. --- HOW TO ANALYSE THIS DATA --- I've really only done the most basic analysis on this. You can pull some more interesting findings from this data really easily using [url=https://support.google.com/docs/answer/1272898?hl=en]pivot tables[/url]. Included with the 'Sorted Responses' workbook are two examples of slightly more complex pivot tables. The first one compares users' declared user type (blue, gold, mod) with their opinion on President Obama. The second one compares users' join date with whether they consider FP their primary online community. Hopefully you should be able to get to grips with pivot tables fairly easily by just fucking around with these examples - that's how I learned to use them. Have a fuck around with pivot tables and see what you can find. Do Fast Threads posters overwhelmingly favour certain bands? Are Gold Members more likely to enjoy single player games? I dunno I just made those up, go and come up with your own questions and find the answers. MS Excel has better pivot tables as well so use those if you can. I don't think Google's can do percentages, which really sucks. --- CONCLUSION --- Sorry this took so long and I've had to initially release it without most of the charts and shit. I hope you understand that having to go through all that data and sort the text responses into meaningful groups took a long time and really kind of burned me out on this whole thing - I probably underestimated how difficult it would be. Thank you for being patient anyway and after a week in processing, hopefully it will have been worth the wait.
i see my waifu stands alone, the gas station lives to see another day
[IMG]http://puu.sh/fZ9uj/59b6b5cbbc.png[/IMG] Aw yeah
why couldn't you use the same thread I don't get it
I love reading these. Fuck there are a lot of gold members now though.
Holy shit the waifu responses lmao People gettin' so buttmad. Looking forward to graphs.
[QUOTE=Ninja Gnome;47149966]i see my waifu stands alone, the gas station lives to see another day[/QUOTE] scratch this i was looking at the wrong list, i'll see you guys on the local news
[QUOTE=Ninja Gnome;47150005]scratch this i was looking at the wrong list, i'll see you guys on the local news[/QUOTE] Shoulda picked someone more faithful like garry
[QUOTE=Empty_Shadow;47150013]Shoulda picked someone more faithful like garry[/QUOTE] garry's a slut and i say that in the nicest way possible
Oh some of the questions are down the bottom in tabs, didn't even realise. [img]http://i.imgur.com/li5wotN.png[/img] Shouldn't take a genius to figure out which graph this is.
[quote]tl;dr isn't a fucking meme[/quote] someones mad about getting banned :^)
Makes me wish I would have been more creative with my responses.
[img]http://i.imgur.com/C5mgg35.png[/img] I'm proud of you, Facepunch.
[IMG]http://i.imgur.com/OuN3Blc.png[/IMG] yep, checks out
[QUOTE=Empty_Shadow;47150032]Oh some of the questions are down the bottom in tabs, didn't even realise. [img]http://i.imgur.com/li5wotN.png[/img] Shouldn't take a genius to figure out which graph this is.[/QUOTE] Delete rust and GMF, better forum x2
Suprised by the amount of people who listed Mogwai/GY!BA in their liked/favourite bands/music, 'cuz I know fuck-all besides myself and one of my friends who listen to that wonderful garbage.
[QUOTE=sirdownloadsalot;47150080]Delete rust and GMF, better forum x2[/QUOTE] I find it kinda hilarious that the GMF and Oify both managed to rank worse than SH and fast threads.
[IMG]http://puu.sh/fZcVz/4d83830b29.png[/IMG] Aww man. I stand alone in the music survey edit: wait i didnt enter that, someone else did. I forgot to add kasabian. fuck. edit: actually i'm not even sure anymore
[QUOTE=Alice3173;47150101]I find it kinda hilarious that the GMF and Oify both managed to rank worse than SH and fast threads.[/QUOTE] And yet not surprising at all. SH is informative about 30% of the time and humorous another 30%, the remaining 40 is shitposts and arguments. Fast threads is a containment board for forum culture threads, but also contains a few really good threads and if you have a quick question about the forums or anything really you can get a decent answer. Rust is full of kids but that's fine, they're discussing the game and it's doing it's job. I guess maybe the GMF is a containment board too. I'm glad we have all of them honestly.
Relationship statuses was happier than I though. Good on you FP. Also whom answered NIGGERNIGGERNIGGERNIGGER?
[QUOTE=kimr120;47150120] Also whom answered NIGGERNIGGERNIGGERNIGGER?[/QUOTE] craptasket
[QUOTE=LuaChobo;47150102]delete sensationalist headlines first thanks[/QUOTE] Just delete every single forum except for Refugee camp and auto ban everyone
[IMG]http://i.imgur.com/TsxVJB7.png[/IMG] ok
[img]http://5crat.ch/a/81x0[/img] Shit taste
All those people asking for smartness back. those really were the good years.
[QUOTE=sirdownloadsalot;47150080]Delete rust and GMF, better forum x2[/QUOTE] nah i prefer sh and of course especially ft to be deleted since ft has fast anime thread in it
[img]http://puu.sh/fZfVv/0f362b010b.png[/img] im glad you left this part in because i'm having a fun time reading it
I'm sorting out the waifu into graphs hold on [t]http://5crat.ch/a/1uwd[/t]
[QUOTE=MilkBagz;47150144][IMG]http://i.imgur.com/TsxVJB7.png[/IMG] ok[/QUOTE] Straight and to the point, I like it.
one other fucking person is trying to steal my waifu from me I've been loyal to her since 2002 don't even try
Sorry, you need to Log In to post a reply to this thread.