A mix table: +-------------------------------------------------------------------------------------------------+
| rankwhole username median median18 median19 rankmedian18 rankmedian19 |
|-------------------------------------------------------------------------------------------------|
1. | 1 LoyceV 41 22 55.5 2 1 |
2. | 2 suchmoon 30 21 41 3 2 |
3. | 3 theymos 29 17 37 8 4 |
4. | 4 El duderino_ 28 19 36 6 5 |
5. | 5 o_e_l_e_o 28 16 41 9 3 |
|-------------------------------------------------------------------------------------------------|
6. | 6 DdmrDdmr 24 24 26 1 8 |
7. | 7 Last of the V8s 21 20 21.5 5 12 |
8. | 8 The Pharmacist 16 18 15 7 20 |
9. | 9 achow101 15 13 17 14 15 |
10. | 10 HairyMaclairy 13 13 12.5 13 32 |
|-------------------------------------------------------------------------------------------------|
11. | 11 mikeywith 12 0 27 96 7 |
12. | 12 HCP 12 9 16.5 20 18 |
13. | 13 JayJuanGee 11 8 13.5 30 26 |
14. | 14 nutildah 11 0 22 92 11 |
15. | 15 LFC_Bitcoin 11 6 20 38 13 |
|-------------------------------------------------------------------------------------------------|
16. | 16 hilariousetc 11 20 6.5 4 75 |
17. | 17 xhomerx10 11 9 12 19 38 |
18. | 18 iasenko 10 10 10.5 18 49 |
19. | 19 gmaxwell 10 8 13 28 28 |
20. | 20 abhiseshakana 10 7 14.5 32 21 |
|-------------------------------------------------------------------------------------------------|
21. | 21 Steamtyme 10 8 13 29 29 |
22. | 22 TryNinja 10 6 14 40 23 |
23. | 23 Carlton Banks 9 6 11 35 42 |
24. | 24 ETFbitcoin 9 4 12 53 35 |
25. | 25 gentlemand 9 6 12 37 34 |
|-------------------------------------------------------------------------------------------------|
26. | 26 BobLawblaw 9 11 6.5 16 74 |
27. | 27 VB1001 9 0 22 89 10 |
28. | 28 xtraelv 9 14 6 12 81 |
29. | 29 krogothmanhattan 9 9 9.5 22 56 |
30. | 30 marlboroza 9 9 8 23 62 |
|-------------------------------------------------------------------------------------------------|
31. | 31 pooya87 9 4 13.5 52 24 |
32. | 32 taikuri13 9 5 12 44 37 |
33. | 33 1miau 9 1 24.5 74 9 |
34. | 34 Jet Cash 9 15 6 10 78 |
35. | 35 bitmover 9 9 9.5 21 55 |
|-------------------------------------------------------------------------------------------------|
36. | 36 qwk 8 8 7.5 26 68 |
37. | 37 morvillz7z 8 1 13.5 73 25 |
38. | 38 fillippone 8 0 30.5 99 6 |
39. | 39 Veleor 8 0 16.5 97 16 |
40. | 40 philipma1957 8 6 10.5 39 50 |
|-------------------------------------------------------------------------------------------------|
41. | 41 Vod 8 11 7 15 71 |
42. | 42 bob123 8 7 13 31 30 |
43. | 43 Goran_ 8 4 11.5 59 39 |
44. | 44 joniboni 8 11 6 17 76 |
45. | 45 mu_enrico 8 5 11.5 43 40 |
|-------------------------------------------------------------------------------------------------|
46. | 46 minerjones 7 5 11 46 44 |
47. | 47 coinlocket$ 7 9 5 24 84 |
48. | 48 DarkStar_ 7 5 9.5 45 54 |
49. | 49 Husna QA 7 6 9 36 57 |
50. | 50 jojo69 7 7 8 33 63 |
|-------------------------------------------------------------------------------------------------|
51. | 51 BitCryptex 7 4 10 51 52 |
52. | 52 Coolcryptovator 7 4 12 57 36 |
53. | 53 mk4 7 3 10 70 53 |
54. | 54 infofront 7 8 4.5 25 87 |
55. | 55 Xal0lex 7 4 11 50 43 |
|-------------------------------------------------------------------------------------------------|
56. | 56 tvplus006 6 1 12.5 76 31 |
57. | 57 Hhampuz 6 5 8.5 41 61 |
58. | 58 yogg 6 1 11 77 46 |
59. | 59 Piggy 6 15 3 11 93 |
60. | 60 mocacino 6 5 8 48 64 |
|-------------------------------------------------------------------------------------------------|
61. | 61 DireWolfM14 6 0 14 94 22 |
62. | 62 Lafu 6 3 6 62 79 |
63. | 63 igor72 6 0 10.5 84 48 |
64. | 64 asche 6 0 9 91 59 |
65. | 65 roycilik 6 4 11.5 58 41 |
|-------------------------------------------------------------------------------------------------|
66. | 66 satoshi 6 8 4 27 90 |
67. | 67 Lauda 5 3 6 68 80 |
68. | 68 witcher_sense 5 0 16.5 95 17 |
69. | 69 hugeblack 5 3 11 66 45 |
70. | 70 yahoo62278 5 3 9 69 60 |
|-------------------------------------------------------------------------------------------------|
71. | 71 CryptopreneurBrainboss 5 0 15.5 93 19 |
72. | 72 Toxic2040 5 5 8 49 66 |
73. | 73 stompix 5 5 5.5 47 82 |
74. | 74 actmyame 5 3 7 63 72 |
75. | 75 Alex_Sr 5 6 4.5 34 86 |
|-------------------------------------------------------------------------------------------------|
76. | 76 Coding Enthusiast 5 0 7.5 100 69 |
77. | 77 TheFuzzStone 5 2 9 71 58 |
78. | 78 mole0815 4 5 4 42 89 |
79. | 79 tranthidung 4 1 12.5 80 33 |
80. | 80 Foxpup 4 4 5 56 83 |
|-------------------------------------------------------------------------------------------------|
81. | 81 LeGaulois 4 4 4.5 55 88 |
82. | 82 Quickseller 4 3 6.5 64 73 |
83. | 83 pandukelana2712 4 2 7 72 70 |
84. | 84 nc50lc 4 1 10 83 51 |
85. | 85 SaltySpitoon 4 0 8 88 65 |
|-------------------------------------------------------------------------------------------------|
86. | 86 PHI16168 3 3 3 60 94 |
87. | 87 wwzsocki 3 1 11 75 47 |
88. | 88 lovesmayfamilis 3 0 17.5 90 14 |
89. | 89 ICOEthics 3 3 3.5 61 91 |
90. | 90 kenzawak 3 3 7.5 65 67 |
|-------------------------------------------------------------------------------------------------|
91. | 91 Welsh 3 4 2.5 54 95 |
92. | 92 TheNewAnon135246 2 0 5 98 85 |
93. | 93 aundroid 2 0 6 85 77 |
94. | 94 TMAN 2 3 2 67 96 |
95. | 95 madnessteat 2 0 13 86 27 |
|-------------------------------------------------------------------------------------------------|
96. | 96 Blacknavy 2 1 3 78 92 |
97. | 97 theyoungmillionaire 1 1 2 81 97 |
98. | 98 nullius 0 1 0 79 99 |
99. | 99 Lutpin 0 1 0 82 100 |
100. | 100 Corrosive 0 0 1 87 98 |
+-------------------------------------------------------------------------------------------------+
Explanation:For ranks (in previous post), I only used one indicator, median.
If 2 users have same values of median, their ordinal numbers automatically sorted out by the software. I am not sure, maybe by alphabetical orders, and something more (from raw results, it has not been sorted out by alphabetical orders).
If I want I can set up more tightly ordering algorithm (such as the spread of interquartile range, from p25 to p75, something like
that) but I am not going to this one because I don't think we should complicate things like that. Median is enough, in my opinion, especially over very long period.
Extra information:Summary for variables: amount
by categories of: year
year | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
2018 | 4900.0 10.2 27.2 5.0 0.0 12.0 0.0 1328.0
2019 | 5200.0 15.9 19.5 11.0 4.0 21.0 0.0 521.0
2020 | 200.0 11.0 18.4 6.0 1.0 14.0 0.0 121.0
----------+--------------------------------------------------------------------------------
Total | 10300.0 13.1 23.6 7.0 2.0 17.0 0.0 1328.0
-------------------------------------------------------------------------------------------
Do you see the increases of median of the top-100 over years, from 2018 to 2019 (5 to 11, about 2-fold increases). I meant many rising stars occur in 2019.