Age/Stats Data Analysis Part II: Electric Boogaloo

Greetings friends, TC citizens, data enthusiasts. I have returned from my cave of spreadsheets bearing good tidings. Some of you may remember my previous attempt at analyzing battle stats for age groups for the age range of 500-600 days old

First Attempt



After hearing your feedback and feeling the deep desire to expand upon this project, I have spend the past few weeks collecting even more beautiful data and generating glorious graphs. Behold: Raw Data/Histograms and User Input Stat Analysis Graphs for age ranges 100-200, 201-300, 301-400, 401-500, 501-600, and 601-700! (I redid 501-600 with a wider range of stats).

As with before, my process was:

1. Collect 150 usernames from each age range

2. Select 100 of those usernames at random for each age range

3. Pay for full battle spies for all 600 users

4. Delete usernames and randomize numbers each stat area to protect identities

5. Generate graphs!

I didn't remove the outliers this time, so the graphs on the user input sheets look weird, but they still tell you what percentage you're in for your age group.

Without further ado, here are the goods:

Age/Stats Analysis Spreadsheets

That link opens to a folder where you can download the raw data or user input spreadsheets for each age range.

Isn't it beautiful?

I've been recruiting help to try and make it all the way to 1000 by getting 300 more spies and some helpers with gathering data, so look for that in the near future.

Hooray for data nerds! Analyze away!



Edit Note- some people have been suspicious of a certain n00b suddenly having a spike in networth. That's simply because thejungle is an amazing new player who I've hired to be my right hand man in handling all of the data we're drowning in.



Edit Part Two: Electric Boogalo!

The moment you're all been waiting for

Ages 700-1000

Download the spreadsheets to be able to edit them (especially the user input ones)

It's 3am and my dreams will be full of data. I'll post this again at the end of the thread so people see it.

Now you can all look forward to my utterly crappily dubbed version of the badger badger song feauturing "data data spreadsheet spreadsheet oooooh it's a graph"

I found that the total column does not match up when adding the other columns? Example: the age table for 201-300 line 60 total of all four stats is 124492 but the table says the total is 145955.



Not sure exactly what that means or how the totals where truly determined so ignore if I am egregiously missing something

The individual stat columns were randomized independently from one other to protect the identity of the users

Ah, that makes sense. And thanks for the awesome amount of data and time that went into this. Pretty amazing.

Great work lad

[image: s1.postimg.org]

Thnx for adding more age groups. Highly appreciated. Great work!

Update- just finished getting 300 spies for ages 700-1000 so I'll have the raw data/histogram and user input sheets for those age ranges by the weekend probably

great work and thx again for all the business...me and my employees sure appreciate it :)

DATA!!! As someone who makes spreadsheets for all kinds of random Torn related stuff, this is relevant to my interests.

That's one sexy sheet you have there! Pity I was inactive for so long, as I can't really compare myself to any age group :(

Hmmm it should work if you go through your user activity history and subtract all the time spend inactive from total user activity. Then convert values to days and you have your approx active age.

~730 days active atm xD so I guess I could use the one you'll release soon :D

Yeah... I used my stats from 03/03/17 (Thanks Torn Stats!) in the 600-700 day sheet just to kind of try it out. 659 day Orionis was pretty okay!

Nice work, looking forward to see how low I am in 700-1000 xD

u shd try the monster area of 1000-1100 days !

Any news on the 700-1000 range sheet?

Rated + solely for the use of the suffix 'Electric Boogaloo'.

Things got busy at work so I had to put it on the back burner but I should have it done soon

Great work Actuariolam. I really enjoyed looking through these spreadsheets. Too bad there's no data for us oldies. :P

I'd also like to become one of your helpers since I work in TV company. >> Job points: 535. Haven't used any in a while, and don't intend to, so it's all yours!

Cheers!

700-1000 Data

Finally. Apologies. Deepest condolences. Severe insomnia. Major drop in networth. But worth it if a single other data nerd alone in their house squeals at the possibilities.