Pages:
Author

Topic: At-least-1 sent & earned merits users , excludes banned users. Stats! - page 3. (Read 1614 times)

legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Update 2020w5, 07feb2020 02:47:27 (GMT time)
* last 3 days belong to 2020w6.


For all users:
  • Number of users who only earned at least 1 merit: 18477
  • Number of users who only sent at least 1 merit: 7378
  • Number of users who earned AND sent at least 1 merit: 14310
  • Number of users who earned OR sent at least 1 merit: 40165
  • Total Autobanned users: 141530
  • Total Nuked users: 62597
  • Total legit users: 11811
  • Total earned merits (for all): 514905
  • Total sent merits (for all): 549692

For legit users only:
  • Total legit users: 11811
  • Total earned merits: 479841
  • Total sent merits: 521826

A summary table (for legit users only)

 |  Earned merits  |  Sent merits
Groups  |  Freq.PercentTotal earnedPercent  |  Freq.PercentTotal sentPercent
__________________  |  ________________________________________  |  ________________________________________
1-10  |  738862.6343927.2  |  841071.2296595.7
11-100  |  355530.110498321.9  |  270322.99195117.6
101-250  |  4894.17585815.8  |  4363.76916513.3
251-500  |  1771.56041712.6  |  1431.2503109.6
501-1000  |  1321.19047418.9  |  520.4372907.1
1001+  |  700.611371723.7  |  670.624345146.7
Total  |  11811100479841100  |  11811100521826100
__________________  |  ________________________________________  |  ________________________________________


Bar charts:

Note:
- Data on autobanned/ nuked users began at January 04, 2019, 08:03:06 AM
*Counted at the start of this topic

Merit status (for all)FrequencyPercent
_____________________________________________________
Sent only738218.4
Earned only1839445.9
Both1426935.6
Total40045100
_____________________________________________________
Account status (for legit only)
_____________________________________________________
Legit1181182.5
Autobanned248317.4
Nuked160.1
Total14310100
_____________________________________________________
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Update 2020w4, 31jan2020 02:51:21 (GMT time)
* last 3 days belong to 2020w5.


For all users:
  • Number of users who only earned at least 1 merit: 18394
  • Number of users who only sent at least 1 merit: 7382
  • Number of users who earned AND sent at least 1 merit: 14269
  • Number of users who earned OR sent at least 1 merit: 40045
  • Total Autobanned users: 141507
  • Total Nuked users: 62365
  • Total legit users: 11772
  • Total earned merits (for all): 508712
  • Total sent merits (for all): 543265

For legit users only:
  • Total legit users: 11772
  • Total earned merits: 473765
  • Total sent merits: 515444

A summary table (for legit users only)

 |  Earned merits  |  Sent merits
Groups  |  Freq.PercentTotal earnedPercent  |  Freq.PercentTotal sentPercent
__________________  |  ________________________________________  |  ________________________________________
1-10  |  737562.7342987.2  |  839171.3296065.7
11-100  |  35363010450422.1  |  268522.89117717.7
101-250  |  4874.17523515.9  |  4353.76848513.3
251-500  |  1821.66325313.4  |  1421.2494169.6
501-1000  |  1241.18597118.1  |  550.5398077.7
1001+  |  680.611050423.3  |  640.523695346.0
Total  |  11772100473765100  |  11772100515444100
__________________  |  ________________________________________  |  ________________________________________


Bar charts:

Note:
- Data on autobanned/ nuked users began at January 04, 2019, 08:03:06 AM
*Counted at the start of this topic

Merit status (for all)FrequencyPercent
_____________________________________________________
Sent only738218.4
Earned only1839445.9
Both1426935.6
Total40045100
_____________________________________________________
Account status (for legit only)
_____________________________________________________
Legit1177282.5
Autobanned248117.4
Nuked160.1
Total14269100
_____________________________________________________
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Update 2020w3, 24jan2020 01:49:34 (GMT time)
* last 3 days belong to 2020w4.


For all users:
  • Number of users who only earned at least 1 merit: 18336
  • Number of users who only sent at least 1 merit: 7383
  • Number of users who earned AND sent at least 1 merit: 14233
  • Number of users who earned OR sent at least 1 merit: 39952
  • Total Autobanned users: 141499
  • Total Nuked users: 62287
  • Total legit users: 11738
  • Total earned merits (for all): 502133
  • Total sent merits (for all): 536373

For legit users only:
  • Total legit users: 11738
  • Total earned merits: 467202
  • Total sent merits: 508554

A summary table (for legit users only)

 |  Earned merits  |  Sent merits
Groups  |  Freq.PercentTotal earnedPercent  |  Freq.PercentTotal sentPercent
__________________  |  ________________________________________  |  ________________________________________
1-10  |  736662.8341877.3  |  837771.4295425.8
11-100  |  35203010416022.3  |  266922.79043717.8
101-250  |  4824.17423915.9  |  4333.76786513.3
251-500  |  1801.56231713.3  |  1401.2483129.5
501-1000  |  12218360317.9  |  550.5392337.7
1001+  |  680.610869623.3  |  640.623316545.8
Total  |  11738100467202100  |  11738100508554100
__________________  |  ________________________________________  |  ________________________________________


Bar charts:

Note:
- Data on autobanned/ nuked users began at January 04, 2019, 08:03:06 AM
*Counted at the start of this topic

Merit status (for all)FrequencyPercent
_____________________________________________________
Sent only738318.5
Earned only1833645.9
Both1423335.6
Total39952100
_____________________________________________________
Account status (for legit only)
_____________________________________________________
Legit1173882.5
Autobanned248017.4
Nuked150.1
Total14233100
_____________________________________________________
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Time passes so fast. As a blink of eyes, 10 weeks passed and as consequences of Covid-19 and the shitty period, I missed updates for the past 10 weeks. I come back this week with update but I have to re-read dofiles and go through what I did 10 weeks ago (that is why I always try to keep my updates work weekly). Almost forgot what I did, so it takes time to make updates.

I planned to make a quarterly summary besides weekly updates.

Stay tuned, guys.  Cheesy
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Update 2020w2, 17jan2020 02:33:31 (GMT time)

For all users:
  • Number of users who only earned at least 1 merit: 18265
  • Number of users who only sent at least 1 merit: 7377
  • Number of users who earned or sent at least 1 merit: 39834
  • Total Autobanned users: 141448
  • Total Nuked users: 62092
  • Total legit users: 11699
  • Total earned merits (for all): 495233
  • Total sent merits (for all): 529286

For legit users only:
  • Total legit users: 11699
  • Total earned merits: 460325
  • Total sent merits: 501475

A summary table (for legit users only)

  |  Earned merits  |  Sent merits
Groups  |  Freq.PercentTotal earnedPercent  |  Freq.PercentTotal sentPercent
__________________  |  ________________________________________  |  ________________________________________
1-10  |  735062.8341257.4  |  835371.4294885.9
11-100  |  35133010428622.7  |  266322.89028718
101-250  |  4724.07307215.9  |  4313.76791913.5
251-500  |  1791.56203013.5  |  1341.2463869.2
501-1000  |  11717955517.3  |  540.5381857.6
1001+  |  680.610725723.3  |  640.622921045.7
Total  |  11699100460325100  |  11699100501475100
__________________  |  ________________________________________  |  ________________________________________


Bar charts:

Note:
- Data on autobanned/ nuked users began at January 04, 2019, 08:03:06 AM
*Counted at the start of this topic

Merit status (for all)FrequencyPercent
_____________________________________________________
Sent only737718.5
Earned only1826545.9
Both1419235.6
Total39834100
_____________________________________________________
Account status (for legit only)
_____________________________________________________
Legit1169982.4
Autobanned247817.5
Nuked150.1
Total14192100
_____________________________________________________
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Update 2020w1

  • Number of users who only earned at least 1 merit: 18201
  • Number of users who only sent at least 1 merit: 7392
  • Number of users who earned or sent at least 1 merit: 39742
  • Total Autobanned users: 141435
  • Total Nuked users: 61895
  • Total legit users: 11658
  • Total earned merits (for all): 489647
  • Total sent merits (for all): 523496

For legit users only:
  • Total legit users: 11658
  • Total earned merits: 454869
  • Total sent merits: 495804

A summary table (for legit users only)

 |  Earned merits  |  Sent merits
Groups  |  Freq.PercentTotal earnedPercent  |  Freq.PercentTotal sentPercent
__________________  |  ________________________________________  |  ________________________________________
1-10  |  733362.9340777.5  |  832571.4294075.9
11-100  |  34943010360322.8  |  265422.88998118.1
101-250  |  4734.17325116.1  |  4323.76818913.8
251-500  |  1761.56110413.4  |  1301.1449849.1
501-1000  |  11517793417.1  |  550.5390747.9
1001+  |  670.610490023.1  |  620.522416945.2
Total  |  11658100449519100  |  11658100490185100
__________________  |  ________________________________________  |  ________________________________________


Bar charts:

Note:
- Data on autobanned/ nuked users began at January 04, 2019, 08:03:06 AM
*Counted at the start of this topic

Merit status (for all)FrequencyPercent
_____________________________________________________
Sent only739218.6
Earned only1820145.8
Both1414935.6
Total39742100
_____________________________________________________
Account status (for legit only)
_____________________________________________________
Legit1165882.4
Autobanned247617.5
Nuked150.1
Total14149100
_____________________________________________________
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Update 2019w52

  • Number of users who earned at least 1 merit: 18124
  • Number of users who sent at least 1 merit: 7394
  • Number of users who earned or sent at least 1 merit: 39636
  • Total Autobanned users: 141396
  • Total Nuked users: 61790
  • Total earned merits (for all): 484287
  • Total sent merits (for all): 517859
  • Total legit users: 11630


For legit users only
  • Total legit users: 11630
  • Total earned merits: 449519
  • Total sent merits: 490185

A summary table:

 |  Earned merits  |  Sent merits
Groups  |  Freq.PercentTotal earnedPercent  |  Freq.PercentTotal sentPercent
__________________  |  ________________________________________  |  ________________________________________
1-10  |  732062.9339947.7  |  830971.4293636
11-100  |  34863010329923  |  264922.88977818.3
101-250  |  4684.07223116.1  |  4273.76737113.7
251-500  |  1781.56153613.7  |  1281.1438498.9
501-1000  |  11217588616.9  |  570.5403888.2
1001+  |  600.510257322.8  |  580.521943644.8
Total  |  11630100449519100  |  11630100490185100
__________________  |  ________________________________________  |  ________________________________________


Bar charts:

Note:
- Data on autobanned/ nuked users began at January 04, 2019, 08:03:06 AM
*Counted at the start of this topic

Merit statusFrequencyPercent
_____________________________________________________
Sent only739418.7
Earned only1812445.7
Both1411835.6
Total39636100
_____________________________________________________
Account status
_____________________________________________________
Legit1163082.4
Autobanned247317.5
Nuked150.1
Total14118100
_____________________________________________________
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Update 2019w51

  • Number of users who earned at least 1 merit: 18049
  • Number of users who sent at least 1 merit: 7393
  • Number of users who earned or sent at least 1 merit: 39535
  • Total Autobanned users: 141377
  • Total Nuked users: 61625
  • Total legit users: 11607
  • Total earned merits: 444086
  • Total sent merits: 484350

A summary table:

 |  Earned merits  |  Sent merits
Groups  |  Freq.PercentTotal earnedPercent  |  Freq.PercentTotal sentPercent
__________________  |  ________________________________________  |  ________________________________________
1-10  |  732163.1339967.7  |  830371.5293516.1
11-100  |  346729.910269123.1  |  263622.78941318.5
101-250  |  4694.07240516.3  |  4263.76700913.8
251-500  |  1771.56146113.8  |  1251.1426398.8
501-1000  |  1090.97419716.7  |  590.5416748.6
1001+  |  640.69933622.4  |  580.521426444.2
Total  |  11607100444086100  |  11607100484350100
__________________  |  ________________________________________  |  ________________________________________


Bar charts:

Note:
- Data on autobanned/ nuked users began at January 04, 2019, 08:03:06 AM
*Counted at the start of this topic

Merit statusFrequencyPercent
_____________________________________________________
Sent only739318.8
Earned only1804945.6
Both1409335.7
Total39535100
_____________________________________________________
Account status
_____________________________________________________
Legit1160782.4
Autobanned247217.5
Nuked140.1
Total14093100
_____________________________________________________
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Update:
  • Total legit users: 11576
  • Total earned merits: 438508
  • Total sent merits: 473406

A summary table:

 |  Earned merits  |  Sent merits
Groups  |  Freq.PercentTotal earnedPercent  |  Freq.PercentTotal sentPercent
__________________  |  ________________________________________  |  ________________________________________
1-10  |  731463.2339587.7  |  826571.6293456.1
11-100  |  345029.810216323.3  |  261722.78931518.7
101-250  |  4664.07176416.4  |  4233.76646713.9
251-500  |  1761.56089313.9  |  1161.0412008.6
501-1000  |  1070.97263716.6  |  620.5438029.2
1001+  |  630.59709322.1  |  540.520827743.5
Total  |  11576100438508100  |  11576100478406100
__________________  |  ________________________________________  |  ________________________________________


Bar charts:
 

Note:
- Data on autobanned/ nuked users began at January 04, 2019, 08:03:06 AM
*Counted at the start of this topic

Merit statusFrequencyPercent
_____________________________________________________
Sent only739918.8
Earned only1796945.6
Both1406035.7
Total39428100
_____________________________________________________
Account status
_____________________________________________________
Legit1157682.3
Autobanned247017.6
Nuked140.1
Total14060100
_____________________________________________________
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Update:
  • Total users: 11537
  • Total earned merits: 433079
  • Total sent merits: 472545

A summary table:

 |  Earned merits  |  Sent merits
Groups  |  Freq.PercentTotal earnedPercent  |  Freq.PercentTotal sentPercent
__________________  |  ________________________________________  |  ________________________________________
1-10  |  729963.3339057.8  |  826571.6292896.2
11-100  |  343229.810160623.5  |  261722.78883618.8
101-250  |  4654.07134016.5  |  4233.76675514.1
251-500  |  1731.55942613.7  |  1161.0398158.4
501-1000  |  1070.97263316.8  |  620.5433919.2
1001+  |  610.59416921.7  |  540.520445943.3
Total  |  11537100433079100  |  11537100472545100
__________________  |  ________________________________________  |  ________________________________________


Bar charts:
 

Note:
- Data on autobanned/ nuked users began at January 04, 2019, 08:03:06 AM
*Counted at the start of this topic

Merit statusFrequencyPercent
_____________________________________________________
None10
Sent only739818.8
Earned only1792245.6
Both1402135.6
Total39342100
_____________________________________________________
Account status
_____________________________________________________
Legit1153782.3
Autobanned247017.6
Nuked140.1
Total14021100
_____________________________________________________
hero member
Activity: 2128
Merit: 532
FREE passive income eBook @ tinyurl.com/PIA10
So the journey to Full Member is the most sought after, making it a slightly positively-skewed distribution Cheesy
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
Update:
  • Total users: 11518
  • Total earned merits: 429042
  • Total sent merits: 468127

A summary table:

Earned merits  |  Sent merits
GroupsFreq.PercentTotal earnedPercent  |  Freq.PercentTotal sentPercent
__________________________________________________________  |  ________________________________________
1-10729163.3337647.9  |  826371.7293316.27
11-100342629.710144023.64  |  260622.68863918.93
101-2504674.17176716.73  |  4203.76609414.12
251-5001681.55782813.5  |  1171.02407408.7
501-10001080.97385117.21  |  580.5407928.71
1001+580.59028221.04  |  540.4720253143.26
Total11518100429042100  |  11518100468127100
__________________________________________________________  |  ________________________________________


Bar charts:
   

Note:
- Data on autobanned/ nuked users began at January 04, 2019, 08:03:06 AM
*Counted at the start of this topic

Merit statusFrequencyPercent
_____________________________________________________
No sent & earned10
Sent only739718.84
Earned only1786445.5
Both sent & earned1399635.65
Total39258100
_____________________________________________________
Account status
_____________________________________________________
Legit1151882.3
Autobanned246417.6
Nuked140.1
Total13996100
_____________________________________________________
legendary
Activity: 2310
Merit: 4085
Farewell o_e_l_e_o
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:

GroupsFeq.PercentTotal earned meritsPercent
_______________________________________________________________________
1-10727663.3337957.98
11-100341829.810110323.87
101-2504674.17204317.01
251-5001651.45707813.48
501-10001070.97425717.54
1001+540.58520220.12
Total11487100423478100
_______________________________________________________________________


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

GroupsEarned merits
_______________________________________
1-101 - 10
11-10011 - 100
101-250101 - 250
251-500251 - 500
501-1000501 - 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.txt

Links to get data for autobanned and nuked users' ids
http://loyce.club/bans/Autobanned.txt
http://loyce.club/bans/Nuked.txt
You can get more details here: LIST banned users

Statistics:
- 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%)

Code:
.         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.
Code:
. 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.
Code:
. 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:
Code:
    +-----------------------------------------------------------------------------------------------------+
     | 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)
Code:
    +-----------------------------------------------------------------------------------------------------+
     | 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.
Pages:
Jump to: