Re: [1-4 SLOTS OPEN] ChipMixer Signature Campaign | Sr Member+

Quote from: LoyceV on September 15, 2019, 07:28:22 PM

66. Hero Member tranthidung (Trust: neutral) (606 Merit earned (history)) (BPIP)

I saw @suchmoon already listed in the spreadsheet. Congratulate to @suchmoon, who is the first accepted applicant for this round. 3 more slots left for the rest of applicants.
By the way, do you have any update on that one, LoyceV?

From your given statistics, I played it around myself after doing data entry, then splitting the dataset of 82 applicants into two clusters. The cut-off (at id 41) is choosen arbitrarily, just to half-split the dataset.

First: the first 41 applicants (from id 1 to 41)
Second: the rest applicants (from id 42 to 82)
The third cluster is added later, and represents the current 55 participants

Splitted datasets
The first cluster:

Code:

. list id username first if first != .

   +-------------------------------+
   | id username first |
   |-------------------------------|
  1. | 1 cygan 57 |
  2. | 2 kingcolex 210 |
  3. | 3 subSTRATA 43 |
  4. | 4 hanspeter 26 |
  5. | 5 Pmalek 638 |
   |-------------------------------|
  6. | 6 wwzsocki 613 |
  7. | 7 Nestade 304 |
  8. | 8 aTriz 166 |
  9. | 9 2double0 20 |
10. | 10 mindrust 549 |
   |-------------------------------|
11. | 11 Buchi-88 114 |
12. | 12 Haunebu 40 |
13. | 13 suchmoon 2904 |
14. | 14 DaveF 260 |
15. | 15 dothebeats 132 |
   |-------------------------------|
16. | 16 nutildah 1258 |
17. | 17 Daniel91 119 |
18. | 18 seoincorporation 475 |
19. | 19 naska21 30 |
20. | 20 Royse777 430 |
   |-------------------------------|
21. | 21 pereira4 129 |
22. | 22 sockpuppet1911 28 |
23. | 23 Real-Duke 66 |
24. | 24 bones261 693 |
25. | 25 BitcoinTurk 279 |
   |-------------------------------|
26. | 26 asu 370 |
27. | 27 chaser15 8 |
28. | 28 TwitchySeal 107 |
29. | 29 eddie13 460 |
30. | 30 BitBustah 34 |
   |-------------------------------|
31. | 31 DaMut 6 |
32. | 32 poptok1 111 |
33. | 33 Lafu 670 |
34. | 34 eaLiTy 32 |
35. | 35 Chmel 7 |
   |-------------------------------|
36. | 36 sabotag3x 379 |
37. | 37 Cent21 27 |
38. | 38 finalshot2016 451 |
39. | 39 Theb 176 |
40. | 40 crwth 331 |
   |-------------------------------|
41. | 41 yoseph 12 |
   +-------------------------------+

The second cluster

Code:

. list id username second if second != .

   +--------------------------------------+
   | id username second |
   |--------------------------------------|
42. | 42 DroomieChikito 7 |
43. | 43 FaucetKING 0 |
44. | 44 Mpamaegbu 44 |
45. | 45 triat 5 |
46. | 46 Vispilio 272 |
   |--------------------------------------|
47. | 47 Koal-84 196 |
48. | 48 hosseinimr93 5 |
49. | 49 Scheede 461 |
50. | 50 khaled0111 437 |
51. | 51 aundroid 484 |
   |--------------------------------------|
52. | 52 Matthias9515 548 |
53. | 53 xeon131 485 |
54. | 54 roycilik 982 |
55. | 55 CryptopreneurBrainboss 760 |
56. | 56 Halab 373 |
   |--------------------------------------|
57. | 57 yazher 264 |
58. | 58 Trofo 300 |
59. | 59 amishmanish 274 |
60. | 60 VB1001 905 |
61. | 61 Veleor 818 |
   |--------------------------------------|
62. | 62 JSRAW 451 |
63. | 63 nc50lc 515 |
64. | 64 joniboini 1083 |
65. | 65 masulum 340 |
66. | 66 tranthidung 606 |
   |--------------------------------------|
67. | 67 coinlocket$ 1052 |
68. | 68 mole0815 689 |
69. | 69 witcher_sense 695 |
70. | 70 bitmover 1002 |
71. | 71 Heisenberg_Hunter 515 |
   |--------------------------------------|
72. | 72 mu_enrico 946 |
73. | 73 cabalism13 521 |
74. | 74 cryptovigi 525 |
75. | 75 morvillz7z 881 |
76. | 76 fillippone 1104 |
   |--------------------------------------|
77. | 77 Tytanowy Janusz 509 |
78. | 78 Coolcryptovator 785 |
79. | 79 kawetsriyanto 309 |
80. | 80 DireWolf14 743 |
81. | 81 TalkStar 296 |
   |--------------------------------------|
82. | 82 FontSeli 329 |
   +--------------------------------------+

The current 55 participants (I get stats from BPIP):

Code:

. list id username participants if participants != ., abb(30)

   +--------------------------------------+
   | id username participants |
   |--------------------------------------|
83. | 83 TryNinja 955 |
84. | 84 BitMaxz 238 |
85. | 85 harizen 151 |
86. | 86 hilariousetc 1684 |
87. | 87 HeRetiK 617 |
   |--------------------------------------|
88. | 88 pooya87 859 |
89. | 89 Kakmakr 352 |
90. | 90 HCP 1281 |
91. | 91 OmegaStarScream 446 |
92. | 92 1Referee 343 |
   |--------------------------------------|
93. | 93 LeGaulois 671 |
94. | 94 mocacinno 730 |
95. | 95 DooMAD 341 |
96. | 96 bitart 121 |
97. | 97 jackg 299 |
   |--------------------------------------|
98. | 98 BrewMaster 284 |
99. | 99 mjglqw 571 |
100. | 100 gentlemand 959 |
101. | 101 buwaytress 456 |
102. | 102 LoyceV 3574 |
   |--------------------------------------|
103. | 103 AdolfinWolf 552 |
104. | 104 figmentofmyass 372 |
105. | 105 Hydrogen 216 |
106. | 106 SyGambler 326 |
107. | 107 Stedsm 124 |
   |--------------------------------------|
108. | 108 jseverson 184 |
109. | 109 stompix 620 |
110. | 110 exstasie 197 |
111. | 111 Thirdspace 209 |
112. | 112 Potato Chips 151 |
   |--------------------------------------|
113. | 113 bob123 1242 |
114. | 114 squatter 389 |
115. | 115 The Pharmacist 2064 |
116. | 116 pugman 370 |
117. | 117 actmyname 725 |
   |--------------------------------------|
118. | 118 hugeblack 578 |
119. | 119 Welsh 496 |
120. | 120 d5000 551 |
121. | 121 Steamtyme 1069 |
122. | 122 ranochigo 176 |
   |--------------------------------------|
123. | 123 marlboroza 1122 |
124. | 124 iasenko 1189 |
125. | 125 DdmrDdmr 2620 |
126. | 126 BitCryptex 979 |
127. | 127 ETFbitcoin 1011 |
   |--------------------------------------|
128. | 128 Lucius 310 |
129. | 129 o_e_l_e_o 2595 |
130. | 130 1miau 1327 |
131. | 131 yogg 774 |
132. | 132 malevolent 199 |
   |--------------------------------------|
133. | 133 mikeywith 1169 |
134. | 134 taikuri13 860 |
135. | 135 asche 699 |
136. | 136 Husna QA 854 |
137. | 137 abhiseshakana 1315 |
   +--------------------------------------+

Statistics(Just for fun)

In general (all 82 applicants), median of earned merits is 336, with the interquartile range (from p25 to p75) is 107 - 606. It means 50% of applicants have their earned merits from 107 to 606.
For the first cluster: The median and interquartile range are 132 and 34 - 430.
For the second cluster: The median and interquartile range are 509 and 300 - 760.
For the 55 participants: The median and interquartile range are 578 and 310 - 1011.
Outliers (displayed via red circles in the boxplot): There are only two outliers, that found in first cluster. They are @suchmoon and nutildah, with 2904 and 1258 earned-merits.
It seems younger generation have better ability to earn merits (among those 82 applicants). The ratio of earned-merits between second and first clusters is: 509/132 ~3.86. It means users in second cluster have ability to earn merits at 3.9-fold higher rate than users in the first cluster.
It seems that median of earned merits from second cluster is closer to the figure of current 55-participants cluster (509 and 578, respectively) (see second box plot)

Details:

Code:

. tabstat whole first second participants, s(n mean sd p50 p25 p75 min max) c(s)

   variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
   whole | 82 418.0488 425.4543 335.5 107 606 0 2904
   first | 41 311.3171 492.7884 132 34 430 6 2904
   second | 41 524.7805 316.7881 509 300 760 0 1104
participants | 55 773.9273 683.1989 578 310 1011 121 3574
----------------------------------------------------------------------------------------------

There are 25% of applicants (21 applicants) self-earned >= 606 merits (p75), and only 3 open slots left for this round.
So, if applicants chosen through earned merits only (that is not, there are more criteria used). Only 3/21 (~14%) of top applicants will be chosen

Code:

. list id username whole if whole >= 606 & whole != .

   +-------------------------------------+
   | id username whole |
   |-------------------------------------|
  5. | 5 Pmalek 638 |
  6. | 6 wwzsocki 613 |
13. | 13 suchmoon 2904 |
16. | 16 nutildah 1258 |
24. | 24 bones261 693 |
   |-------------------------------------|
33. | 33 Lafu 670 |
54. | 54 roycilik 982 |
55. | 55 CryptopreneurBrainboss 760 |
60. | 60 VB1001 905 |
61. | 61 Veleor 818 |
   |-------------------------------------|
64. | 64 joniboini 1083 |
66. | 66 tranthidung 606 |
67. | 67 coinlocket$ 1052 |
68. | 68 mole0815 689 |
69. | 69 witcher_sense 695 |
   |-------------------------------------|
70. | 70 bitmover 1002 |
72. | 72 mu_enrico 946 |
75. | 75 morvillz7z 881 |
76. | 76 fillippone 1104 |
78. | 78 Coolcryptovator 785 |
   |-------------------------------------|
80. | 80 DireWolf14 743 |
   +-------------------------------------+

Two outliers in the first cluster are:

Code:

. list id username first if first >1000 & first != .

   +-----------------------+
   | id username first |
   |-----------------------|
13. | 13 suchmoon 2904 |
16. | 16 nutildah 1258 |
   +-----------------------+

Four outliers among 55 participants are:

Code:

. list id username participants if participants >= 2000 & participants != ., abb(30)

+-------------------------------------+
| id username participants |
|-------------------------------------|
102. | 102 LoyceV 3574 |
115. | 115 The Pharmacist 2064 |
125. | 125 DdmrDdmr 2620 |
129. | 129 o_e_l_e_o 2595 |
+-------------------------------------+

Boxplot