User talk:Kymara: Difference between revisions
Content deleted Content added
imported>Kymara |
imported>Kymara →Benfords Law fun: new section |
||
Line 452:
Then google accepted it
== Benfords Law fun ==
<pre>
-- xp of characters
mysql> select left(xp,1), count(*) from character_stats where xp > 0 group by left(xp,1);
+------------+----------+
| left(xp,1) | count(*) |
+------------+----------+
| 1 | 5555 |
| 2 | 3122 |
| 3 | 2380 |
| 4 | 2344 |
| 5 | 2854 |
| 6 | 996 |
| 7 | 788 |
| 8 | 667 |
| 9 | 633 |
+------------+----------+
-- age of characters
-- max is 2940058
mysql> select left(age,1), count(*) from character_stats where age > 0 group by left(age,1);
+-------------+----------+
| left(age,1) | count(*) |
+-------------+----------+
| 1 | 8810 |
| 2 | 4962 |
| 3 | 3456 |
| 4 | 2417 |
| 5 | 2854 |
| 6 | 1545 |
| 7 | 1402 |
| 8 | 1250 |
| 9 | 971 |
+-------------+----------+
9 rows in set (0.02 sec)
-- number of kills per day
-- 2160 is max
mysql> select left(cnt,1), count(*) from kills group by left(cnt,1);
+-------------+----------+
| left(cnt,1) | count(*) |
+-------------+----------+
| 1 | 527945 |
| 2 | 272803 |
| 3 | 164413 |
| 4 | 116935 |
| 5 | 81453 |
| 6 | 64920 |
| 7 | 49086 |
| 8 | 40612 |
| 9 | 32843 |
+-------------+----------+
9 rows in set (0.61 sec)
-- size of stacks of items added to other items
mysql> select left(param2,1), count(*) from itemlog where event = 'merge in' group by left(param2,1);
+----------------+----------+
| left(param2,1) | count(*) |
+----------------+----------+
| 1 | 10636326 |
| 2 | 3470611 |
| 3 | 2667505 |
| 4 | 1920918 |
| 5 | 1397535 |
| 6 | 972027 |
| 7 | 757029 |
| 8 | 683354 |
| 9 | 667485 |
+----------------+----------+
9 rows in set (5 min 38.02 sec)
</pre>
| |||