I am curious on the stats (percentages in particular) of users who earned and gave away merits; the level they did it after excluding Autobanned and Nuked users.
So here you go.
* Updates will be made with new posts, not in OP (likely weekly or monthly)
ABSTRACT- There are 11487 users who both earned and sent at least 1 merit (since the merit system's birthday), from initial sample with 39147 users.
- Totally, they earned merits 423 478 merits.
- Users who earned above 100 merits account for only 6.9% of total users (11487) but their total earned merits account for 68.2% (of 423 478 total earned merits). Impressively! (see the summary table below)
- There are two groups of users account for more than 20% of total earned merits: group 11 - 100 (23.9%) and group 1001+ (20.1%).
- The groups 101 - 250 and 501 - 1000 account for nearly the same percentage, at 17% and 17.5%, respectively.
- The lowest group is group 1-10 that accounts for about 8% of total earned merits.
A summary table:Groups | Feq. | Percent | Total earned merits | Percent |
_________________________ | ___________ | _________ | ___________________ | _______ |
1-10 | 7276 | 63.3 | 33795 | 7.98 |
11-100 | 3418 | 29.8 | 101103 | 23.87 |
101-250 | 467 | 4.1 | 72043 | 17.01 |
251-500 | 165 | 1.4 | 57078 | 13.48 |
501-1000 | 107 | 0.9 | 74257 | 17.54 |
1001+ | 54 | 0.5 | 85202 | 20.12 |
Total | 11487 | 100 | 423478 | 100 |
_________________________ | ___________ | _________ | ___________________ | _______ |
Pie charts:Note:- Data on autobanned/ nuked users began at January 04, 2019, 08:03:06 AM
*Counted at the start of this topic
- Variable notes for 6 groups
Groups | Earned merits |
_________________________ | ______________ |
1-10 | 1 - 10 |
11-100 | 11 - 100 |
101-250 | 101 - 250 |
251-500 | 251 - 500 |
501-1000 | 501 - 1000 |
1001+ | 1001+ |
_________________________ | ______________ |
- They are not reallly active users (for now, I can't get such data). Active here means they actively received and used their sMerits at least once. Even this term does not guarentee they are really active.
Data:Link to get raw data dump from theymos, stored in loyce's club.
http://loyce.club/Merit/merit.all.txtLinks to get data for autobanned and nuked users' ids
http://loyce.club/bans/Autobanned.txthttp://loyce.club/bans/Nuked.txtYou can get more details here:
LIST banned usersStatistics:- Earned: 31736
- Sent: 21366 (drop userid == 0).
Total cases of users earned or sent at least 1 merit: 39147.
- Autobanned: 134 582 cases (6636 cases matched in 39147 cases)
- Nuked: 59288 cases (only 156 cases matched in 39147 cases)
- Total cases: 39147
- Legit: 32357 (82.66%)
- Autobanned: 6636 (16.95%)
- Nuked: 156 (0.39%)
- Autobanned & nuked: 2 (0.01%)
. tab status
status | Freq. Percent Cum.
-------------------+-----------------------------------
legit | 32,357 82.66 82.66
autobanned | 6,634 16.95 99.60
nuked | 154 0.39 99.99
autobanned & nuked | 2 0.01 100.00
-------------------+-----------------------------------
Total | 39,147 100.00
After excluding autobanned / nuked users, and excluding users who only earned or sent at least 1 merit (I meant I analysed for users who both earned and sent at least 1 merit), we only have 11487 cases for further analysis.
. tab meritstatus
meritstatus | Freq. Percent Cum.
--------------------+-----------------------------------
only earned or sent | 20,870 64.50 64.50
both earned & sent | 11,487 35.50 100.00
--------------------+-----------------------------------
Total | 32,357 100.00
From 11487 users, I categorized them into 6 groups.
. tab group
group | Freq. Percent Cum.
------------+-----------------------------------
1-10 | 7,276 63.34 63.34
11-100 | 3,418 29.76 93.10
101-250 | 467 4.07 97.16
251-500 | 165 1.44 98.60
501-1000 | 107 0.93 99.53
1001+ | 54 0.47 100.00
------------+-----------------------------------
Total | 11,487 100.00
Total earned merits of 11487 users are 423.478.
Sample of converted dataset: +-----------------------------------------------------------------------------------------------------+
| userid gmerit sent emerit earned autoban nuked status meritstatus group |
|-----------------------------------------------------------------------------------------------------|
1. | 13 2 yes 13 yes no no legit both earned & sent 11-100 |
2. | 30 186 yes 232 yes no no legit both earned & sent 101-250 |
3. | 35 11812 yes 6287 yes no no legit both earned & sent 1001+ |
4. | 198 2 yes 55 yes no no legit both earned & sent 11-100 |
5. | 203 53 yes 92 yes no no legit both earned & sent 11-100 |
|-----------------------------------------------------------------------------------------------------|
6. | 413 35 yes 5 yes no no legit both earned & sent 1-10 |
7. | 430 1 yes 1 yes no no legit both earned & sent 1-10 |
8. | 464 110 yes 1 yes no no legit both earned & sent 1-10 |
9. | 554 179 yes 501 yes no no legit both earned & sent 501-1000 |
10. | 575 4 yes 2 yes no no legit both earned & sent 1-10 |
+-----------------------------------------------------------------------------------------------------+
or without variable labels (0: No; 1: Yes)
+-----------------------------------------------------------------------------------------------------+
| userid gmerit sent emerit earned autoban nuked status meritstatus group |
|-----------------------------------------------------------------------------------------------------|
1. | 13 2 1 13 1 0 0 legit both earned & sent 11-100 |
2. | 30 186 1 232 1 0 0 legit both earned & sent 101-250 |
3. | 35 11812 1 6287 1 0 0 legit both earned & sent 1001+ |
4. | 198 2 1 55 1 0 0 legit both earned & sent 11-100 |
5. | 203 53 1 92 1 0 0 legit both earned & sent 11-100 |
|-----------------------------------------------------------------------------------------------------|
6. | 413 35 1 5 1 0 0 legit both earned & sent 1-10 |
7. | 430 1 1 1 1 0 0 legit both earned & sent 1-10 |
8. | 464 110 1 1 1 0 0 legit both earned & sent 1-10 |
9. | 554 179 1 501 1 0 0 legit both earned & sent 501-1000 |
10. | 575 4 1 2 1 0 0 legit both earned & sent 1-10 |
+-----------------------------------------------------------------------------------------------------+
If one request, I might consider to publish the full dataset.