Poll
Question:
So how old are you?
Option 1: 10 or younger
Option 2: 11-13
Option 3: 14-16
Option 4: 17-19
Option 5: 20-29
Option 6: 30-39
Option 7: 40 or older
pretty sure the results are anonymous on polls
Yep, results are anonymous so this is the good forum section. We can reply our current age or year of birth if we don't mind sharing. Anyway I think this is a good initiative
@kotu , if people are checking, because it might help us gather more information about our demographics (eg to see how young/old our userbase is, overall, and other things). Perhaps this should be a poll on Cemetech, TI-Planet, Omnimaga, etc.
:3=
that's what i was thinking it could be useful with your demographics
I'm 20
(cpost to get past 20 post limit for polls)
I'm 25
(useless cpost because I'm way above any limit ever here)
On a side note I think we got quite a bunch of 40+ years old members. I'm starting to wonder if we have enough older members to actually have an higher active user age average than Cemetech? O.O (it was the complete opposite about two years ago when most of our users were 14-17 lol)
Sorry to double post
@kotu but I wonder if it would be better to replace the poll ages options by birth years, eg instead of under 10, 11-13, 14-16, 17-19, 20-29, 30-39, 40 or older, you could use the following options:
2007 or later
2004-2006
2001-2003
1998-2000
1988-1997
1978-1987
1977 or earlier
That way, people will not have to change their poll option every few year. The years above are weird because I kept the exact same age ranges as your current poll. That said, the fact it's currently fixed age could also help giving an indication about which age range in which each user remains active.
Well actually I didn't allow the option to change your answer.
I think it is ok as it is tbh....... it just represents the age someone was when they first joined the site / completed the poll.
What you could do (seeing as you guys run the site) is record each entry given, then you keep that information separately, and update it as the years pass.
Good enough?? :)
I am unsure if I am willing to update a poll manually every year via MySQL db :P. I guess we could start a new poll next year, though.
Quote from: DJ Omnimaga on April 06, 2017, 04:43:39 AM
I am unsure if I am willing to update a poll manually every year via MySQL db :P.
well then get
@Juju to automate it
think man!!
If you put your birthdate in your profile, then I can derive a ton of stats from there, no need of polls.
you lazy bastad
Please keep in mind that those demographics are not representative at all...
@Juju could definitively run a script across the entire db, ignoring those with no age or fake ages
Pls do I'd really love to see the graphs for that :thumbsup:
Quote from: DJ Omnimaga on April 06, 2017, 04:31:45 PM
@Juju could definitively run a script across the entire db, ignoring those with no age or fake ages
I have written an automated CW profile crawler ;)
It has statistics of anything: Gender, Age, ...
I have written super fancy SQL code. Kinda simpler that way.
Quote from: Juju on April 08, 2017, 08:50:32 PM
I have written super fancy SQL code. Kinda simpler that way.
If I would have had database access, this would've indeed been the easier way... :P
Yep. Just ask and I'll deliver, I guess.
MariaDB [smf]> select count(*) as count, floor(TIMESTAMPDIFF(YEAR,birthdate,CURDATE())/5)*5 as age from smf_members where TIMESTAMPDIFF(YEAR,birthdate,CURDATE())>10 and TIMESTAMPDIFF(YEAR,birthdate,CURDATE())<100 group by floor(TIMESTAMPDIFF(YEAR,birthdate,CURDATE())/5)*5;
+-------+------+
| count | age |
+-------+------+
| 4 | 10 |
| 27 | 15 |
| 19 | 20 |
| 14 | 25 |
| 9 | 30 |
| 2 | 40 |
+-------+------+
6 rows in set (0.01 sec)
Quote from: DarkestEx on April 08, 2017, 08:23:34 PM
Quote from: DJ Omnimaga on April 06, 2017, 04:31:45 PM
@Juju could definitively run a script across the entire db, ignoring those with no age or fake ages
I have written an automated CW profile crawler ;)
It has statistics of anything: Gender, Age, ...
Yeah but didn't it only open 1 user at a time?
Anyway
@Juju the best would be if you calculated the average of all ages rather than per groups, so that we got the media forum age.
We have to consider, however, that at least four of our 30-39 years old user did not include their age in his profile, same for three of our 40+ years old users, so technically, we have at least 13 30-39 years old users and 5 40+ years old users.
In other words, our median age could be approximately the following:
+-------+------+
| count | age |
+-------+------+
| 4 | 10 |
| 27 | 15 |
| 19 | 20 |
| 14 | 25 |
| 13 | 30 |
| 5 | 40 |
+-------+------+21.5 years old.
Quote from: DJ Omnimaga on April 08, 2017, 09:02:25 PM
Quote from: DarkestEx on April 08, 2017, 08:23:34 PM
Quote from: DJ Omnimaga on April 06, 2017, 04:31:45 PM
@Juju could definitively run a script across the entire db, ignoring those with no age or fake ages
I have written an automated CW profile crawler ;)
It has statistics of anything: Gender, Age, ...
Yeah but didn't it only open 1 user at a time?
Yes it did. But it repeated this process for many times.
Ah ok good. Also does it only include users who made at least 1 post?
Quote from: DJ Omnimaga on April 08, 2017, 10:36:26 PM
Ah ok good. Also does it only include users who made at least 1 post?
No, everyone.
A dump can be found here:
http://jsonviewer.stack.hu/#http://ninjabyte.eu/dl/cw_database_2017_04_08.json
Simply click on "Viewer" and explore the data!
Unfortunately, I can't use the poll. I don't have twenty posts yet :banghead:
Nice. Also thanks for the PM. With the extra data I provided, this puts our average age at 23.1266. Which is surprising considering CodeWalrus' randomness nature O.O