tranthidung (OP)
Legendary
 Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
 |
January 18, 2020, 04:47:34 AM
Last edit: January 19, 2020, 09:27:47 AM by tranthidung |
|
Time-series plots:Full dataset:Truncated dataset:
Basic statistics (for full dataset): Only drop last 3 days that belong to the 2020w3 (daydi = 722, 723), the incomplete week & incomlete day (dayid = 724). variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 721 787.8017 697.7451 653 549 788 300 12676
----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 191 or 1147. . di 788-549
239
. di 239*1.5
358.5
. di 788+358.5
1146.5
. di 549-358.5
190.5
There are 60 outliers (beyond 1147 or 191) in full dataset, in total. . count if (merit >= 1147 | merit <= 191) & merit != .
60
Those days are: +---------------------------+
| dayid merit date |
|---------------------------|
2. | 2 12676 25jan2018 |
3. | 3 6348 26jan2018 |
4. | 4 4627 27jan2018 |
5. | 5 3240 28jan2018 |
6. | 6 3343 29jan2018 |
7. | 7 3804 30jan2018 |
8. | 8 4103 31jan2018 |
9. | 9 2793 01feb2018 |
10. | 10 2621 02feb2018 |
11. | 11 2476 03feb2018 |
12. | 12 1790 04feb2018 |
13. | 13 2263 05feb2018 |
14. | 14 2003 06feb2018 |
15. | 15 2367 07feb2018 |
16. | 16 2059 08feb2018 |
17. | 17 2223 09feb2018 |
18. | 18 1334 10feb2018 |
19. | 19 1793 11feb2018 |
20. | 20 1475 12feb2018 |
21. | 21 1289 13feb2018 |
22. | 22 1580 14feb2018 |
23. | 23 2797 15feb2018 |
24. | 24 1740 16feb2018 |
25. | 25 1431 17feb2018 |
26. | 26 1589 18feb2018 |
27. | 27 1289 19feb2018 |
28. | 28 1442 20feb2018 |
30. | 30 1277 22feb2018 |
31. | 31 1249 23feb2018 |
33. | 33 1372 25feb2018 |
34. | 34 1156 26feb2018 |
35. | 35 1414 27feb2018 |
36. | 36 1302 28feb2018 |
38. | 38 1345 02mar2018 |
39. | 39 1727 03mar2018 |
42. | 42 1162 06mar2018 |
49. | 49 1316 13mar2018 |
51. | 51 1224 15mar2018 |
57. | 57 1390 21mar2018 |
58. | 58 1211 22mar2018 |
69. | 69 1181 02apr2018 |
70. | 70 1186 03apr2018 |
237. | 237 2553 17sep2018 |
238. | 238 1807 18sep2018 |
239. | 239 1347 19sep2018 |
240. | 240 1221 20sep2018 |
|---------------------------|
429. | 429 1247 28mar2019 |
476. | 476 1215 14may2019 |
505. | 505 1227 12jun2019 |
660. | 660 1630 14nov2019 |
661. | 661 2374 15nov2019 |
662. | 662 1585 16nov2019 |
663. | 663 1377 17nov2019 |
664. | 664 2783 18nov2019 |
665. | 665 3826 19nov2019 |
666. | 666 2584 20nov2019 |
667. | 667 4889 21nov2019 |
668. | 668 5515 22nov2019 |
669. | 669 1590 23nov2019 |
678. | 678 1465 02dec2019 |
+---------------------------+
- 2018: 46 (76.7%)
- 2019: 14 (23.3%)
- 2020: 0 (0%)
|
|
|
|
|
|
|
|
|
|
|
The Bitcoin software, network, and concept is called "Bitcoin" with a capitalized "B". Bitcoin currency units are called "bitcoins" with a lowercase "b" -- this is often abbreviated BTC.
|
|
|
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
January 18, 2020, 04:58:36 AM |
|
During the period from 24/1/2018 to 14/1/2020 (last 3 days dropped due to incomplete week, 2020w3 and incomplete day - dayid = 724), the minimum and maximum of intra-day merit are 300 and 12676, on 04/8/2019 and 25/1/2018, respectively. List of the top 50-highest day in terms of intra-day merits: +-----------------------------------------------------------------------------+
| rank_max merit dayid date dofw week month year |
|-----------------------------------------------------------------------------|
1. | 1 12676 2 25jan2018 Thursday 2018w4 2018m1 2018 |
2. | 2 6348 3 26jan2018 Friday 2018w4 2018m1 2018 |
3. | 3 5515 668 22nov2019 Friday 2019w47 2019m11 2019 |
4. | 4 4889 667 21nov2019 Thursday 2019w47 2019m11 2019 |
5. | 5 4627 4 27jan2018 Saturday 2018w4 2018m1 2018 |
|-----------------------------------------------------------------------------|
6. | 6 4103 8 31jan2018 Wednesday 2018w5 2018m1 2018 |
7. | 7 3826 665 19nov2019 Tuesday 2019w47 2019m11 2019 |
8. | 8 3804 7 30jan2018 Tuesday 2018w5 2018m1 2018 |
9. | 9 3343 6 29jan2018 Monday 2018w5 2018m1 2018 |
10. | 10 3240 5 28jan2018 Sunday 2018w4 2018m1 2018 |
|-----------------------------------------------------------------------------|
11. | 11 2797 23 15feb2018 Thursday 2018w7 2018m2 2018 |
12. | 12 2793 9 01feb2018 Thursday 2018w5 2018m2 2018 |
13. | 13 2783 664 18nov2019 Monday 2019w46 2019m11 2019 |
14. | 14 2621 10 02feb2018 Friday 2018w5 2018m2 2018 |
15. | 15 2584 666 20nov2019 Wednesday 2019w47 2019m11 2019 |
|-----------------------------------------------------------------------------|
16. | 16 2553 237 17sep2018 Monday 2018w38 2018m9 2018 |
17. | 17 2476 11 03feb2018 Saturday 2018w5 2018m2 2018 |
18. | 18 2374 661 15nov2019 Friday 2019w46 2019m11 2019 |
19. | 19 2367 15 07feb2018 Wednesday 2018w6 2018m2 2018 |
20. | 20 2263 13 05feb2018 Monday 2018w6 2018m2 2018 |
|-----------------------------------------------------------------------------|
21. | 21 2223 17 09feb2018 Friday 2018w6 2018m2 2018 |
22. | 22 2059 16 08feb2018 Thursday 2018w6 2018m2 2018 |
23. | 23 2003 14 06feb2018 Tuesday 2018w6 2018m2 2018 |
24. | 24 1807 238 18sep2018 Tuesday 2018w38 2018m9 2018 |
25. | 25 1793 19 11feb2018 Sunday 2018w6 2018m2 2018 |
|-----------------------------------------------------------------------------|
26. | 26 1790 12 04feb2018 Sunday 2018w5 2018m2 2018 |
27. | 27 1740 24 16feb2018 Friday 2018w7 2018m2 2018 |
28. | 28 1727 39 03mar2018 Saturday 2018w9 2018m3 2018 |
29. | 29 1630 660 14nov2019 Thursday 2019w46 2019m11 2019 |
30. | 30 1590 669 23nov2019 Saturday 2019w47 2019m11 2019 |
|-----------------------------------------------------------------------------|
31. | 31 1589 26 18feb2018 Sunday 2018w7 2018m2 2018 |
32. | 32 1585 662 16nov2019 Saturday 2019w46 2019m11 2019 |
33. | 33 1580 22 14feb2018 Wednesday 2018w7 2018m2 2018 |
34. | 34 1475 20 12feb2018 Monday 2018w7 2018m2 2018 |
35. | 35 1465 678 02dec2019 Monday 2019w48 2019m12 2019 |
|-----------------------------------------------------------------------------|
36. | 36 1442 28 20feb2018 Tuesday 2018w8 2018m2 2018 |
37. | 37 1431 25 17feb2018 Saturday 2018w7 2018m2 2018 |
38. | 38 1414 35 27feb2018 Tuesday 2018w9 2018m2 2018 |
39. | 39 1390 57 21mar2018 Wednesday 2018w12 2018m3 2018 |
40. | 40 1377 663 17nov2019 Sunday 2019w46 2019m11 2019 |
|-----------------------------------------------------------------------------|
41. | 41 1372 33 25feb2018 Sunday 2018w8 2018m2 2018 |
42. | 42 1347 239 19sep2018 Wednesday 2018w38 2018m9 2018 |
43. | 43 1345 38 02mar2018 Friday 2018w9 2018m3 2018 |
44. | 44 1334 18 10feb2018 Saturday 2018w6 2018m2 2018 |
45. | 45 1316 49 13mar2018 Tuesday 2018w11 2018m3 2018 |
|-----------------------------------------------------------------------------|
46. | 46 1302 36 28feb2018 Wednesday 2018w9 2018m2 2018 |
47. | 47 1289 21 13feb2018 Tuesday 2018w7 2018m2 2018 |
48. | 48 1289 27 19feb2018 Monday 2018w8 2018m2 2018 |
49. | 49 1277 30 22feb2018 Thursday 2018w8 2018m2 2018 |
50. | 50 1249 31 23feb2018 Friday 2018w8 2018m2 2018 |
+-----------------------------------------------------------------------------+
List of the top 50-lowest days in terms of intra-day merits: +-----------------------------------------------------------------------------+
| rank_min merit dayid date dofw week month year |
|-----------------------------------------------------------------------------|
1. | 1 300 558 04aug2019 Sunday 2019w31 2019m8 2019 |
2. | 2 333 341 30dec2018 Sunday 2018w52 2018m12 2018 |
3. | 3 339 343 01jan2019 Tuesday 2019w1 2019m1 2019 |
4. | 4 347 299 18nov2018 Sunday 2018w46 2018m11 2018 |
5. | 5 347 330 19dec2018 Wednesday 2018w51 2018m12 2018 |
|-----------------------------------------------------------------------------|
6. | 6 351 334 23dec2018 Sunday 2018w51 2018m12 2018 |
7. | 7 366 218 29aug2018 Wednesday 2018w35 2018m8 2018 |
8. | 8 367 565 11aug2019 Sunday 2019w32 2019m8 2019 |
9. | 9 370 223 03sep2018 Monday 2018w36 2018m9 2018 |
10. | 10 373 339 28dec2018 Friday 2018w52 2018m12 2018 |
|-----------------------------------------------------------------------------|
11. | 11 375 340 29dec2018 Saturday 2018w52 2018m12 2018 |
12. | 12 377 600 15sep2019 Sunday 2019w37 2019m9 2019 |
13. | 13 378 305 24nov2018 Saturday 2018w47 2018m11 2018 |
14. | 14 378 566 12aug2019 Monday 2019w32 2019m8 2019 |
15. | 15 378 567 13aug2019 Tuesday 2019w33 2019m8 2019 |
|-----------------------------------------------------------------------------|
16. | 16 380 192 03aug2018 Friday 2018w31 2018m8 2018 |
17. | 17 381 336 25dec2018 Tuesday 2018w52 2018m12 2018 |
18. | 18 385 327 16dec2018 Sunday 2018w50 2018m12 2018 |
19. | 19 385 215 26aug2018 Sunday 2018w34 2018m8 2018 |
20. | 20 391 221 01sep2018 Saturday 2018w35 2018m9 2018 |
|-----------------------------------------------------------------------------|
21. | 21 394 188 30jul2018 Monday 2018w31 2018m7 2018 |
22. | 22 399 593 08sep2019 Sunday 2019w36 2019m9 2019 |
23. | 23 401 557 03aug2019 Saturday 2019w31 2019m8 2019 |
24. | 24 401 288 07nov2018 Wednesday 2018w45 2018m11 2018 |
25. | 25 402 263 13oct2018 Saturday 2018w41 2018m10 2018 |
|-----------------------------------------------------------------------------|
26. | 26 404 229 09sep2018 Sunday 2018w36 2018m9 2018 |
27. | 27 406 277 27oct2018 Saturday 2018w43 2018m10 2018 |
28. | 28 408 530 07jul2019 Sunday 2019w27 2019m7 2019 |
29. | 29 409 123 26may2018 Saturday 2018w21 2018m5 2018 |
30. | 30 409 589 04sep2019 Wednesday 2019w36 2019m9 2019 |
|-----------------------------------------------------------------------------|
31. | 31 410 279 29oct2018 Monday 2018w44 2018m10 2018 |
32. | 32 411 569 15aug2019 Thursday 2019w33 2019m8 2019 |
33. | 33 411 578 24aug2019 Saturday 2019w34 2019m8 2019 |
34. | 34 414 528 05jul2019 Friday 2019w27 2019m7 2019 |
35. | 35 421 193 04aug2018 Saturday 2018w31 2018m8 2018 |
|-----------------------------------------------------------------------------|
36. | 36 425 588 03sep2019 Tuesday 2019w36 2019m9 2019 |
37. | 37 426 230 10sep2018 Monday 2018w37 2018m9 2018 |
38. | 38 426 346 04jan2019 Friday 2019w1 2019m1 2019 |
39. | 39 427 141 13jun2018 Wednesday 2018w24 2018m6 2018 |
40. | 40 430 207 18aug2018 Saturday 2018w33 2018m8 2018 |
|-----------------------------------------------------------------------------|
41. | 41 432 587 02sep2019 Monday 2019w35 2019m9 2019 |
42. | 42 435 522 29jun2019 Saturday 2019w26 2019m6 2019 |
43. | 43 436 419 18mar2019 Monday 2019w11 2019m3 2019 |
44. | 44 440 265 15oct2018 Monday 2018w42 2018m10 2018 |
45. | 45 440 559 05aug2019 Monday 2019w31 2019m8 2019 |
|-----------------------------------------------------------------------------|
46. | 46 440 585 31aug2019 Saturday 2019w35 2019m8 2019 |
47. | 47 441 319 08dec2018 Saturday 2018w49 2018m12 2018 |
48. | 48 441 404 03mar2019 Sunday 2019w9 2019m3 2019 |
49. | 49 442 342 31dec2018 Monday 2018w52 2018m12 2018 |
50. | 50 442 278 28oct2018 Sunday 2018w43 2018m10 2018 |
+-----------------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
January 18, 2020, 05:08:28 AM
Last edit: January 27, 2020, 07:49:47 AM by tranthidung |
|
Medians and means of intra-day merits over days of weeks GMT timeColors: - Green: highest.
- Red: Lowest.
- In median, the highest days are Tuesday, Friday, and Thursday at 692, 683, and 669, respectively; whislt the lowest days are Saturday, Sunday, and Wednesday at 592, 605, and 654, respectively. - In means, the highest days are Thursday, Friday, and Tuesday at 915, 850, and 809, respectively; whilst the lowest days are Sunday, Saturday, and Monday, at 692, 704, and 769, respectively. Basic statistics:Summary for variables: merit
by categories of: dofw
dofw | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
Sunday | 103 692.0583 375.7855 605 487 747 300 3240
Monday | 103 768.6796 461.5542 656 545 825 370 3343
Tuesday | 103 808.068 507.2756 692 592 825 339 3826
Wednesday | 103 778.3301 462.8325 654 595 810 347 4103
Thursday | 103 914.3301 1295.614 669 566 787 411 12676
Friday | 103 849.1359 805.0485 683 554 827 373 6348
Saturday | 103 704.0097 496.8707 592 499 711 375 4627
----------+--------------------------------------------------------------------------------
Total | 721 787.8017 697.7451 653 549 788 300 12676
-------------------------------------------------------------------------------------------
Outliers displayed as red circles. Outliers non-displayed. Details on ranks:In medians +----------------------------------------------------------------------+
| rankmedian dofw median mean p25 p75 min max |
|----------------------------------------------------------------------|
1. | 1 Tuesday 692 808.0679 592 825 339 3826 |
2. | 2 Friday 683 849.1359 554 827 373 6348 |
3. | 3 Thursday 669 914.3301 566 787 411 12676 |
4. | 4 Monday 656 768.6796 545 825 370 3343 |
5. | 5 Wednesday 654 778.3301 595 810 347 4103 |
|----------------------------------------------------------------------|
6. | 6 Sunday 605 692.0582 487 747 300 3240 |
7. | 7 Saturday 592 704.0097 499 711 375 4627 |
+----------------------------------------------------------------------+
In means +--------------------------------------------------------------------+
| rankmean dofw mean median p25 p75 min max |
|--------------------------------------------------------------------|
1. | 1 Thursday 914.3301 669 566 787 411 12676 |
2. | 2 Friday 849.1359 683 554 827 373 6348 |
3. | 3 Tuesday 808.0679 692 592 825 339 3826 |
4. | 4 Wednesday 778.3301 654 595 810 347 4103 |
5. | 5 Monday 768.6796 656 545 825 370 3343 |
|--------------------------------------------------------------------|
6. | 6 Saturday 704.0097 592 499 711 375 4627 |
7. | 7 Sunday 692.0582 605 487 747 300 3240 |
+--------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
January 18, 2020, 05:17:21 AM
Last edit: January 19, 2020, 09:26:27 AM by tranthidung |
|
Intra-week merits (from 24/1/2018 to 14/1/2020)Last 3 days dropped due to incomplete week (2020w3) and incomplete day (dayid = 724)Converted dataset: +-----------------+
| merit week |
|-----------------|
1. | 27920 2018w4 |
2. | 20930 2018w5 |
3. | 14042 2018w6 |
4. | 11901 2018w7 |
5. | 8879 2018w8 |
|-----------------|
6. | 9005 2018w9 |
7. | 7178 2018w10 |
8. | 7340 2018w11 |
9. | 7138 2018w12 |
10. | 6392 2018w13 |
|-----------------|
11. | 6542 2018w14 |
12. | 5946 2018w15 |
13. | 4449 2018w16 |
14. | 4820 2018w17 |
15. | 5043 2018w18 |
|-----------------|
16. | 4685 2018w19 |
17. | 4431 2018w20 |
18. | 3903 2018w21 |
19. | 4248 2018w22 |
20. | 4473 2018w23 |
|-----------------|
21. | 3953 2018w24 |
22. | 4574 2018w25 |
23. | 4684 2018w26 |
24. | 4367 2018w27 |
25. | 4109 2018w28 |
|-----------------|
26. | 4277 2018w29 |
27. | 3809 2018w30 |
28. | 3489 2018w31 |
29. | 4199 2018w32 |
30. | 3767 2018w33 |
|-----------------|
31. | 3763 2018w34 |
32. | 3186 2018w35 |
33. | 3536 2018w36 |
34. | 3586 2018w37 |
35. | 9587 2018w38 |
|-----------------|
36. | 4508 2018w39 |
37. | 4325 2018w40 |
38. | 3981 2018w41 |
39. | 4424 2018w42 |
40. | 4386 2018w43 |
|-----------------|
41. | 3321 2018w44 |
42. | 4175 2018w45 |
43. | 4047 2018w46 |
44. | 4606 2018w47 |
45. | 3791 2018w48 |
|-----------------|
46. | 3596 2018w49 |
47. | 3689 2018w50 |
48. | 3615 2018w51 |
49. | 3687 2018w52 |
50. | 4584 2019w1 |
|-----------------|
51. | 6102 2019w2 |
52. | 5776 2019w3 |
53. | 4582 2019w4 |
54. | 4408 2019w5 |
55. | 4505 2019w6 |
|-----------------|
56. | 4259 2019w7 |
57. | 4314 2019w8 |
58. | 4726 2019w9 |
59. | 4979 2019w10 |
60. | 4295 2019w11 |
|-----------------|
61. | 4690 2019w12 |
62. | 5728 2019w13 |
63. | 4695 2019w14 |
64. | 5253 2019w15 |
65. | 4880 2019w16 |
|-----------------|
66. | 4260 2019w17 |
67. | 4817 2019w18 |
68. | 5002 2019w19 |
69. | 5596 2019w20 |
70. | 4693 2019w21 |
|-----------------|
71. | 4342 2019w22 |
72. | 4597 2019w23 |
73. | 5373 2019w24 |
74. | 4629 2019w25 |
75. | 4672 2019w26 |
|-----------------|
76. | 3882 2019w27 |
77. | 4462 2019w28 |
78. | 4005 2019w29 |
79. | 4377 2019w30 |
80. | 3603 2019w31 |
|-----------------|
81. | 3346 2019w32 |
82. | 3965 2019w33 |
83. | 3811 2019w34 |
84. | 3579 2019w35 |
85. | 3683 2019w36 |
|-----------------|
86. | 4005 2019w37 |
87. | 4382 2019w38 |
88. | 4348 2019w39 |
89. | 4209 2019w40 |
90. | 4701 2019w41 |
|-----------------|
91. | 5160 2019w42 |
92. | 5375 2019w43 |
93. | 4816 2019w44 |
94. | 4753 2019w45 |
95. | 11070 2019w46 |
|-----------------|
96. | 20397 2019w47 |
97. | 6271 2019w48 |
98. | 4650 2019w49 |
99. | 4832 2019w50 |
100. | 6066 2019w51 |
|-----------------|
101. | 7058 2019w52 |
102. | 5745 2020w1 |
103. | 5395 2020w2 |
+-----------------+
- 50% of observed weeks ( 103 weeks) have total intra-week merits above 4574, whilst the rest 50% of them have total intra-week merits below 4574. 4574 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 4047 to 5373 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3186 - 27920. variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 103.0 5514.6 3563.7 4574.0 4047.0 5373.0 3186.0 27920.0
----------------------------------------------------------------------------------------------
. di 5373-4047
1326
. di 1326*1.5
1989
. di 5373+1989
7362
. di 4047-1989
2058
It means that potential outliers are weeks that have intra-week merits beyond 2058 or 7362. How many weeks are potential outliers? . count if (merit >= 7362 | merit < 2058) & merit != .
9
weeks are outliers, in total. List of those 9 weeks: +-----------------+
| merit week |
|-----------------|
1. | 27920 2018w4 |
2. | 20930 2018w5 |
3. | 14042 2018w6 |
4. | 11901 2018w7 |
5. | 8879 2018w8 |
|-----------------|
6. | 9005 2018w9 |
35. | 9587 2018w38 |
95. | 11070 2019w46 |
96. | 20397 2019w47 |
+-----------------+
Most of them occured in the year 2018, and there is only 2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 ( 20397).  List of weeks in descending weekly meritsThe last week (with 5395 merits) stays at the 24th position, among 103 weeks. +------------------------------+
| weeklyrank merit week |
|------------------------------|
1. | 1 27920 2018w4 |
2. | 2 20930 2018w5 |
3. | 3 20397 2019w47 |
4. | 4 14042 2018w6 |
5. | 5 11901 2018w7 |
|------------------------------|
6. | 6 11070 2019w46 |
7. | 7 9587 2018w38 |
8. | 8 9005 2018w9 |
9. | 9 8879 2018w8 |
10. | 10 7340 2018w11 |
|------------------------------|
11. | 11 7178 2018w10 |
12. | 12 7138 2018w12 |
13. | 13 7058 2019w52 |
14. | 14 6542 2018w14 |
15. | 15 6392 2018w13 |
|------------------------------|
16. | 16 6271 2019w48 |
17. | 17 6102 2019w2 |
18. | 18 6066 2019w51 |
19. | 19 5946 2018w15 |
20. | 20 5776 2019w3 |
|------------------------------|
21. | 21 5745 2020w1 |
22. | 22 5728 2019w13 |
23. | 23 5596 2019w20 |
24. | 24 5395 2020w2 |
25. | 25 5375 2019w43 |
|------------------------------|
26. | 26 5373 2019w24 |
27. | 27 5253 2019w15 |
28. | 28 5160 2019w42 |
29. | 29 5043 2018w18 |
30. | 30 5002 2019w19 |
|------------------------------|
31. | 31 4979 2019w10 |
32. | 32 4880 2019w16 |
33. | 33 4832 2019w50 |
34. | 34 4820 2018w17 |
35. | 35 4817 2019w18 |
|------------------------------|
36. | 36 4816 2019w44 |
37. | 37 4753 2019w45 |
38. | 38 4726 2019w9 |
39. | 39 4701 2019w41 |
40. | 40 4695 2019w14 |
|------------------------------|
41. | 41 4693 2019w21 |
42. | 42 4690 2019w12 |
43. | 43 4685 2018w19 |
44. | 44 4684 2018w26 |
45. | 45 4672 2019w26 |
|------------------------------|
46. | 46 4650 2019w49 |
47. | 47 4629 2019w25 |
48. | 48 4606 2018w47 |
49. | 49 4597 2019w23 |
50. | 50 4584 2019w1 |
|------------------------------|
51. | 51 4582 2019w4 |
52. | 52 4574 2018w25 |
53. | 53 4508 2018w39 |
54. | 54 4505 2019w6 |
55. | 55 4473 2018w23 |
|------------------------------|
56. | 56 4462 2019w28 |
57. | 57 4449 2018w16 |
58. | 58 4431 2018w20 |
59. | 59 4424 2018w42 |
60. | 60 4408 2019w5 |
|------------------------------|
61. | 61 4386 2018w43 |
62. | 62 4382 2019w38 |
63. | 63 4377 2019w30 |
64. | 64 4367 2018w27 |
65. | 65 4348 2019w39 |
|------------------------------|
66. | 66 4342 2019w22 |
67. | 67 4325 2018w40 |
68. | 68 4314 2019w8 |
69. | 69 4295 2019w11 |
70. | 70 4277 2018w29 |
|------------------------------|
71. | 71 4260 2019w17 |
72. | 72 4259 2019w7 |
73. | 73 4248 2018w22 |
74. | 74 4209 2019w40 |
75. | 75 4199 2018w32 |
|------------------------------|
76. | 76 4175 2018w45 |
77. | 77 4109 2018w28 |
78. | 78 4047 2018w46 |
79. | 79 4005 2019w37 |
80. | 80 4005 2019w29 |
|------------------------------|
81. | 81 3981 2018w41 |
82. | 82 3965 2019w33 |
83. | 83 3953 2018w24 |
84. | 84 3903 2018w21 |
85. | 85 3882 2019w27 |
|------------------------------|
86. | 86 3811 2019w34 |
87. | 87 3809 2018w30 |
88. | 88 3791 2018w48 |
89. | 89 3767 2018w33 |
90. | 90 3763 2018w34 |
|------------------------------|
91. | 91 3689 2018w50 |
92. | 92 3687 2018w52 |
93. | 93 3683 2019w36 |
94. | 94 3615 2018w51 |
95. | 95 3603 2019w31 |
|------------------------------|
96. | 96 3596 2018w49 |
97. | 97 3586 2018w37 |
98. | 98 3579 2019w35 |
99. | 99 3536 2018w36 |
100. | 100 3489 2018w31 |
|------------------------------|
101. | 101 3346 2019w32 |
102. | 102 3321 2018w44 |
103. | 103 3186 2018w35 |
+------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
January 18, 2020, 05:25:49 AM |
|
ABSTRACT 2020w2, GMT timeData is the full dataset since 24/1/2018, and only dropped last 3 days belong to incomplete week - 2020w3 and incomplete day (dayid = 724). Details on days dropped, please see above posts.
Intra-day merits:- Total observed days: 721
- Potential outliers are days that have intraday total merits beyond 191 or 1147
- Median of intraday merits over the period is 653
- 50% of observed days have their intra-day merits range from 549 to 788 (the interquartile range)
- In medians, the highest and lowest days are Tuesday and Saturday, respectively; whilst the highest and lowest days in means are Thursday and Sunday, respectively. See here.
- There are 60 potential outliers (beyond 191 or 1147) in total, and only 14 (23.3%) of them occured in 2019. (see details)
- Minimum and maximum of intraday merits (full dataset) are 300, and 12676, on 04/8/2019 and 25/1/2018, respectively.
Intra-week merits:- Total observed weeks: 103
- The median of intra-week merits is 4574
- 50% of observed weeks (103 weeks in total), have total merits in the range from 4047 to 5373 (the interquartile range of intra-week merits).
- Minimum and maximum of intra-week merits are 3186 and 27920, in 2018w35, and 2018w4, respectively;
- 9 potential outliers [beyond 2058 or 7362], only 2 of them occurred in the year 2019, on 2019w46 (11070), and 2019w47 (20397).
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
January 27, 2020, 05:19:58 AM
Last edit: January 27, 2020, 07:37:51 AM by tranthidung |
|
Converted dataset: In 2020 at 24jan2020 01:49:34 (GMT time)The last one, with dayid == 731 is an incomplete day. +----------------------------------------------------------------+
| dayid date merit dofw week month year |
|----------------------------------------------------------------|
708. | 708 01jan2020 810 Wednesday 2020w1 2020m1 2020 |
709. | 709 02jan2020 854 Thursday 2020w1 2020m1 2020 |
710. | 710 03jan2020 837 Friday 2020w1 2020m1 2020 |
711. | 711 04jan2020 637 Saturday 2020w1 2020m1 2020 |
712. | 712 05jan2020 777 Sunday 2020w1 2020m1 2020 |
|----------------------------------------------------------------|
713. | 713 06jan2020 959 Monday 2020w1 2020m1 2020 |
714. | 714 07jan2020 871 Tuesday 2020w1 2020m1 2020 |
715. | 715 08jan2020 860 Wednesday 2020w2 2020m1 2020 |
716. | 716 09jan2020 733 Thursday 2020w2 2020m1 2020 |
717. | 717 10jan2020 745 Friday 2020w2 2020m1 2020 |
|----------------------------------------------------------------|
718. | 718 11jan2020 743 Saturday 2020w2 2020m1 2020 |
719. | 719 12jan2020 689 Sunday 2020w2 2020m1 2020 |
720. | 720 13jan2020 754 Monday 2020w2 2020m1 2020 |
721. | 721 14jan2020 871 Tuesday 2020w2 2020m1 2020 |
722. | 722 15jan2020 979 Wednesday 2020w3 2020m1 2020 |
|----------------------------------------------------------------|
723. | 723 16jan2020 972 Thursday 2020w3 2020m1 2020 |
724. | 724 17jan2020 1063 Friday 2020w3 2020m1 2020 |
725. | 725 18jan2020 823 Saturday 2020w3 2020m1 2020 |
726. | 726 19jan2020 1192 Sunday 2020w3 2020m1 2020 |
727. | 727 20jan2020 1136 Monday 2020w3 2020m1 2020 |
|----------------------------------------------------------------|
728. | 728 21jan2020 1082 Tuesday 2020w3 2020m1 2020 |
729. | 729 22jan2020 863 Wednesday 2020w4 2020m1 2020 |
730. | 730 23jan2020 1050 Thursday 2020w4 2020m1 2020 |
731. | 731 24jan2020 70 Friday 2020w4 2020m1 2020 |
+----------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
January 27, 2020, 07:42:47 AM
Last edit: January 27, 2020, 08:12:23 AM by tranthidung |
|
Time-series plots:Full dataset:Truncated dataset:
Basic statistics (for full dataset): Only drop last 3 days that belong to the 2020w4 (daydi = 729, 730), the incomplete week & incomlete day (dayid = 731). variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 728 790.1813 694.8872 654.5 549.5 804 300 12676
----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 168 or 1186. . di 804-549.5
254.5
. di 254.5*1.5
381.75
. di 804+381.75
1185.75
. di 549.5-381.75
167.75
There are 58 outliers (beyond 1186 or 168) in full dataset, in total. . count if (merit >= 1186 | merit <= 168) & merit != .
58
Those days are:
+---------------------------+
| dayid merit date |
|---------------------------|
2. | 2 12676 25jan2018 |
3. | 3 6348 26jan2018 |
4. | 4 4627 27jan2018 |
5. | 5 3240 28jan2018 |
6. | 6 3343 29jan2018 |
7. | 7 3804 30jan2018 |
8. | 8 4103 31jan2018 |
9. | 9 2793 01feb2018 |
10. | 10 2621 02feb2018 |
11. | 11 2476 03feb2018 |
12. | 12 1790 04feb2018 |
13. | 13 2263 05feb2018 |
14. | 14 2003 06feb2018 |
15. | 15 2367 07feb2018 |
16. | 16 2059 08feb2018 |
17. | 17 2223 09feb2018 |
18. | 18 1334 10feb2018 |
19. | 19 1793 11feb2018 |
20. | 20 1475 12feb2018 |
21. | 21 1289 13feb2018 |
22. | 22 1580 14feb2018 |
23. | 23 2797 15feb2018 |
24. | 24 1740 16feb2018 |
25. | 25 1431 17feb2018 |
26. | 26 1589 18feb2018 |
27. | 27 1289 19feb2018 |
28. | 28 1442 20feb2018 |
30. | 30 1277 22feb2018 |
31. | 31 1249 23feb2018 |
33. | 33 1372 25feb2018 |
35. | 35 1414 27feb2018 |
36. | 36 1302 28feb2018 |
38. | 38 1345 02mar2018 |
39. | 39 1727 03mar2018 |
49. | 49 1316 13mar2018 |
51. | 51 1224 15mar2018 |
57. | 57 1390 21mar2018 |
58. | 58 1211 22mar2018 |
70. | 70 1186 03apr2018 |
237. | 237 2553 17sep2018 |
238. | 238 1807 18sep2018 |
239. | 239 1347 19sep2018 |
240. | 240 1221 20sep2018 |
|---------------------------|
429. | 429 1247 28mar2019 |
476. | 476 1215 14may2019 |
505. | 505 1227 12jun2019 |
660. | 660 1630 14nov2019 |
661. | 661 2374 15nov2019 |
662. | 662 1585 16nov2019 |
663. | 663 1377 17nov2019 |
664. | 664 2783 18nov2019 |
665. | 665 3826 19nov2019 |
666. | 666 2584 20nov2019 |
667. | 667 4889 21nov2019 |
668. | 668 5515 22nov2019 |
669. | 669 1590 23nov2019 |
678. | 678 1465 02dec2019 |
|---------------------------|
726. | 726 1192 19jan2020 |
+---------------------------+
- 2018: 43 (74.1%)
- 2019: 14 (24.1%)
- 2020: 1 (1.7%)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
January 27, 2020, 07:45:06 AM |
|
During the period from 24/1/2018 to 21/1/2020 (last 3 days dropped due to incomplete week, 2020w4 and an incomplete day - dayid = 731), the minimum and maximum of intra-day merit are 300 and 12676, on 04/8/2019 and 25/1/2018, respectively. List of the top 50-highest day in terms of intra-day merits: +-----------------------------------------------------------------------------+
| rank_max merit dayid date dofw week month year |
|-----------------------------------------------------------------------------|
1. | 1 12676 2 25jan2018 Thursday 2018w4 2018m1 2018 |
2. | 2 6348 3 26jan2018 Friday 2018w4 2018m1 2018 |
3. | 3 5515 668 22nov2019 Friday 2019w47 2019m11 2019 |
4. | 4 4889 667 21nov2019 Thursday 2019w47 2019m11 2019 |
5. | 5 4627 4 27jan2018 Saturday 2018w4 2018m1 2018 |
|-----------------------------------------------------------------------------|
6. | 6 4103 8 31jan2018 Wednesday 2018w5 2018m1 2018 |
7. | 7 3826 665 19nov2019 Tuesday 2019w47 2019m11 2019 |
8. | 8 3804 7 30jan2018 Tuesday 2018w5 2018m1 2018 |
9. | 9 3343 6 29jan2018 Monday 2018w5 2018m1 2018 |
10. | 10 3240 5 28jan2018 Sunday 2018w4 2018m1 2018 |
|-----------------------------------------------------------------------------|
11. | 11 2797 23 15feb2018 Thursday 2018w7 2018m2 2018 |
12. | 12 2793 9 01feb2018 Thursday 2018w5 2018m2 2018 |
13. | 13 2783 664 18nov2019 Monday 2019w46 2019m11 2019 |
14. | 14 2621 10 02feb2018 Friday 2018w5 2018m2 2018 |
15. | 15 2584 666 20nov2019 Wednesday 2019w47 2019m11 2019 |
|-----------------------------------------------------------------------------|
16. | 16 2553 237 17sep2018 Monday 2018w38 2018m9 2018 |
17. | 17 2476 11 03feb2018 Saturday 2018w5 2018m2 2018 |
18. | 18 2374 661 15nov2019 Friday 2019w46 2019m11 2019 |
19. | 19 2367 15 07feb2018 Wednesday 2018w6 2018m2 2018 |
20. | 20 2263 13 05feb2018 Monday 2018w6 2018m2 2018 |
|-----------------------------------------------------------------------------|
21. | 21 2223 17 09feb2018 Friday 2018w6 2018m2 2018 |
22. | 22 2059 16 08feb2018 Thursday 2018w6 2018m2 2018 |
23. | 23 2003 14 06feb2018 Tuesday 2018w6 2018m2 2018 |
24. | 24 1807 238 18sep2018 Tuesday 2018w38 2018m9 2018 |
25. | 25 1793 19 11feb2018 Sunday 2018w6 2018m2 2018 |
|-----------------------------------------------------------------------------|
26. | 26 1790 12 04feb2018 Sunday 2018w5 2018m2 2018 |
27. | 27 1740 24 16feb2018 Friday 2018w7 2018m2 2018 |
28. | 28 1727 39 03mar2018 Saturday 2018w9 2018m3 2018 |
29. | 29 1630 660 14nov2019 Thursday 2019w46 2019m11 2019 |
30. | 30 1590 669 23nov2019 Saturday 2019w47 2019m11 2019 |
|-----------------------------------------------------------------------------|
31. | 31 1589 26 18feb2018 Sunday 2018w7 2018m2 2018 |
32. | 32 1585 662 16nov2019 Saturday 2019w46 2019m11 2019 |
33. | 33 1580 22 14feb2018 Wednesday 2018w7 2018m2 2018 |
34. | 34 1475 20 12feb2018 Monday 2018w7 2018m2 2018 |
35. | 35 1465 678 02dec2019 Monday 2019w48 2019m12 2019 |
|-----------------------------------------------------------------------------|
36. | 36 1442 28 20feb2018 Tuesday 2018w8 2018m2 2018 |
37. | 37 1431 25 17feb2018 Saturday 2018w7 2018m2 2018 |
38. | 38 1414 35 27feb2018 Tuesday 2018w9 2018m2 2018 |
39. | 39 1390 57 21mar2018 Wednesday 2018w12 2018m3 2018 |
40. | 40 1377 663 17nov2019 Sunday 2019w46 2019m11 2019 |
|-----------------------------------------------------------------------------|
41. | 41 1372 33 25feb2018 Sunday 2018w8 2018m2 2018 |
42. | 42 1347 239 19sep2018 Wednesday 2018w38 2018m9 2018 |
43. | 43 1345 38 02mar2018 Friday 2018w9 2018m3 2018 |
44. | 44 1334 18 10feb2018 Saturday 2018w6 2018m2 2018 |
45. | 45 1316 49 13mar2018 Tuesday 2018w11 2018m3 2018 |
|-----------------------------------------------------------------------------|
46. | 46 1302 36 28feb2018 Wednesday 2018w9 2018m2 2018 |
47. | 47 1289 27 19feb2018 Monday 2018w8 2018m2 2018 |
48. | 48 1289 21 13feb2018 Tuesday 2018w7 2018m2 2018 |
49. | 49 1277 30 22feb2018 Thursday 2018w8 2018m2 2018 |
50. | 50 1249 31 23feb2018 Friday 2018w8 2018m2 2018 |
+-----------------------------------------------------------------------------+
List of the top 50-lowest days in terms of intra-day merits: +-----------------------------------------------------------------------------+
| rank_min merit dayid date dofw week month year |
|-----------------------------------------------------------------------------|
1. | 1 300 558 04aug2019 Sunday 2019w31 2019m8 2019 |
2. | 2 333 341 30dec2018 Sunday 2018w52 2018m12 2018 |
3. | 3 339 343 01jan2019 Tuesday 2019w1 2019m1 2019 |
4. | 4 347 299 18nov2018 Sunday 2018w46 2018m11 2018 |
5. | 5 347 330 19dec2018 Wednesday 2018w51 2018m12 2018 |
|-----------------------------------------------------------------------------|
6. | 6 351 334 23dec2018 Sunday 2018w51 2018m12 2018 |
7. | 7 366 218 29aug2018 Wednesday 2018w35 2018m8 2018 |
8. | 8 367 565 11aug2019 Sunday 2019w32 2019m8 2019 |
9. | 9 370 223 03sep2018 Monday 2018w36 2018m9 2018 |
10. | 10 373 339 28dec2018 Friday 2018w52 2018m12 2018 |
|-----------------------------------------------------------------------------|
11. | 11 375 340 29dec2018 Saturday 2018w52 2018m12 2018 |
12. | 12 377 600 15sep2019 Sunday 2019w37 2019m9 2019 |
13. | 13 378 566 12aug2019 Monday 2019w32 2019m8 2019 |
14. | 14 378 567 13aug2019 Tuesday 2019w33 2019m8 2019 |
15. | 15 378 305 24nov2018 Saturday 2018w47 2018m11 2018 |
|-----------------------------------------------------------------------------|
16. | 16 380 192 03aug2018 Friday 2018w31 2018m8 2018 |
17. | 17 381 336 25dec2018 Tuesday 2018w52 2018m12 2018 |
18. | 18 385 327 16dec2018 Sunday 2018w50 2018m12 2018 |
19. | 19 385 215 26aug2018 Sunday 2018w34 2018m8 2018 |
20. | 20 391 221 01sep2018 Saturday 2018w35 2018m9 2018 |
|-----------------------------------------------------------------------------|
21. | 21 394 188 30jul2018 Monday 2018w31 2018m7 2018 |
22. | 22 399 593 08sep2019 Sunday 2019w36 2019m9 2019 |
23. | 23 401 288 07nov2018 Wednesday 2018w45 2018m11 2018 |
24. | 24 401 557 03aug2019 Saturday 2019w31 2019m8 2019 |
25. | 25 402 263 13oct2018 Saturday 2018w41 2018m10 2018 |
|-----------------------------------------------------------------------------|
26. | 26 404 229 09sep2018 Sunday 2018w36 2018m9 2018 |
27. | 27 406 277 27oct2018 Saturday 2018w43 2018m10 2018 |
28. | 28 408 530 07jul2019 Sunday 2019w27 2019m7 2019 |
29. | 29 409 123 26may2018 Saturday 2018w21 2018m5 2018 |
30. | 30 409 589 04sep2019 Wednesday 2019w36 2019m9 2019 |
|-----------------------------------------------------------------------------|
31. | 31 410 279 29oct2018 Monday 2018w44 2018m10 2018 |
32. | 32 411 578 24aug2019 Saturday 2019w34 2019m8 2019 |
33. | 33 411 569 15aug2019 Thursday 2019w33 2019m8 2019 |
34. | 34 414 528 05jul2019 Friday 2019w27 2019m7 2019 |
35. | 35 421 193 04aug2018 Saturday 2018w31 2018m8 2018 |
|-----------------------------------------------------------------------------|
36. | 36 425 588 03sep2019 Tuesday 2019w36 2019m9 2019 |
37. | 37 426 230 10sep2018 Monday 2018w37 2018m9 2018 |
38. | 38 426 346 04jan2019 Friday 2019w1 2019m1 2019 |
39. | 39 427 141 13jun2018 Wednesday 2018w24 2018m6 2018 |
40. | 40 430 207 18aug2018 Saturday 2018w33 2018m8 2018 |
|-----------------------------------------------------------------------------|
41. | 41 432 587 02sep2019 Monday 2019w35 2019m9 2019 |
42. | 42 435 522 29jun2019 Saturday 2019w26 2019m6 2019 |
43. | 43 436 419 18mar2019 Monday 2019w11 2019m3 2019 |
44. | 44 440 585 31aug2019 Saturday 2019w35 2019m8 2019 |
45. | 45 440 265 15oct2018 Monday 2018w42 2018m10 2018 |
|-----------------------------------------------------------------------------|
46. | 46 440 559 05aug2019 Monday 2019w31 2019m8 2019 |
47. | 47 441 319 08dec2018 Saturday 2018w49 2018m12 2018 |
48. | 48 441 404 03mar2019 Sunday 2019w9 2019m3 2019 |
49. | 49 442 278 28oct2018 Sunday 2018w43 2018m10 2018 |
50. | 50 442 342 31dec2018 Monday 2018w52 2018m12 2018 |
+-----------------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
January 27, 2020, 07:49:30 AM
Last edit: January 27, 2020, 08:11:45 AM by tranthidung |
|
Medians and means of intra-day merits over days of weeks GMT timeColors: - Green: highest.
- Red: Lowest.
- In median, the highest days are Tuesday, Friday, and Thursday at 696, 687, and 673, respectively; whislt the lowest days are Saturday, Sunday, and Wednesday at 592, 608, and 655, respectively. - In means, the highest days are Thursday, Friday, and Tuesday at 915, 852, and 811, respectively; whilst the lowest days are Sunday, Saturday, and Monday, at 697, 706, and 773, respectively. Basic statistics:Summary for variables: merit
by categories of: dofw
dofw | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
Sunday | 104 696.8654 377.1565 607.5 489.5 755.5 300 3240
Monday | 104 772.2115 460.7183 657 549 829.5 370 3343
Tuesday | 104 810.7019 505.5212 696 592 844 339 3826
Wednesday | 104 780.2596 461.0004 655 597 811 347 4103
Thursday | 104 914.8846 1289.322 673 569.5 789.5 411 12676
Friday | 104 851.1923 801.4054 686.5 557.5 827.5 373 6348
Saturday | 104 705.1538 494.5905 592 500 717.5 375 4627
----------+--------------------------------------------------------------------------------
Total | 728 790.1813 694.8872 654.5 549.5 804 300 12676
-------------------------------------------------------------------------------------------
Outliers displayed as red circles. Outliers non-displayed. Details on ranks:In medians
+--------------------------------------------------------------------------+
| rankmedian dofw median mean p25 p75 min max |
|--------------------------------------------------------------------------|
1. | 1 Tuesday 696 810.7019 592 844 339 3826 |
2. | 2 Friday 686.5 851.1923 557.5 827.5 373 6348 |
3. | 3 Thursday 673 914.8846 569.5 789.5 411 12676 |
4. | 4 Monday 657 772.2115 549 829.5 370 3343 |
5. | 5 Wednesday 655 780.2596 597 811 347 4103 |
|--------------------------------------------------------------------------|
6. | 6 Sunday 607.5 696.8654 489.5 755.5 300 3240 |
7. | 7 Saturday 592 705.1539 500 717.5 375 4627 |
+--------------------------------------------------------------------------+
In means
+------------------------------------------------------------------------+
| rankmean dofw mean median p25 p75 min max |
|------------------------------------------------------------------------|
1. | 1 Thursday 914.8846 673 569.5 789.5 411 12676 |
2. | 2 Friday 851.1923 686.5 557.5 827.5 373 6348 |
3. | 3 Tuesday 810.7019 696 592 844 339 3826 |
4. | 4 Wednesday 780.2596 655 597 811 347 4103 |
5. | 5 Monday 772.2115 657 549 829.5 370 3343 |
|------------------------------------------------------------------------|
6. | 6 Saturday 705.1539 592 500 717.5 375 4627 |
7. | 7 Sunday 696.8654 607.5 489.5 755.5 300 3240 |
+------------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
January 27, 2020, 07:55:40 AM
Last edit: January 27, 2020, 08:11:03 AM by tranthidung |
|
Intra-week merits (from 24/1/2018 to 21/1/2020)Last 3 days dropped due to incomplete week (2020w4) and an incomplete day (dayid = 731)Converted dataset: +-----------------+
| merit week |
|-----------------|
1. | 27920 2018w4 |
2. | 20930 2018w5 |
3. | 14042 2018w6 |
4. | 11901 2018w7 |
5. | 8879 2018w8 |
|-----------------|
6. | 9005 2018w9 |
7. | 7178 2018w10 |
8. | 7340 2018w11 |
9. | 7138 2018w12 |
10. | 6392 2018w13 |
|-----------------|
11. | 6542 2018w14 |
12. | 5946 2018w15 |
13. | 4449 2018w16 |
14. | 4820 2018w17 |
15. | 5043 2018w18 |
|-----------------|
16. | 4685 2018w19 |
17. | 4431 2018w20 |
18. | 3903 2018w21 |
19. | 4248 2018w22 |
20. | 4473 2018w23 |
|-----------------|
21. | 3953 2018w24 |
22. | 4574 2018w25 |
23. | 4684 2018w26 |
24. | 4367 2018w27 |
25. | 4109 2018w28 |
|-----------------|
26. | 4277 2018w29 |
27. | 3809 2018w30 |
28. | 3489 2018w31 |
29. | 4199 2018w32 |
30. | 3767 2018w33 |
|-----------------|
31. | 3763 2018w34 |
32. | 3186 2018w35 |
33. | 3536 2018w36 |
34. | 3586 2018w37 |
35. | 9587 2018w38 |
|-----------------|
36. | 4508 2018w39 |
37. | 4325 2018w40 |
38. | 3981 2018w41 |
39. | 4424 2018w42 |
40. | 4386 2018w43 |
|-----------------|
41. | 3321 2018w44 |
42. | 4175 2018w45 |
43. | 4047 2018w46 |
44. | 4606 2018w47 |
45. | 3791 2018w48 |
|-----------------|
46. | 3596 2018w49 |
47. | 3689 2018w50 |
48. | 3615 2018w51 |
49. | 3687 2018w52 |
50. | 4584 2019w1 |
|-----------------|
51. | 6102 2019w2 |
52. | 5776 2019w3 |
53. | 4582 2019w4 |
54. | 4408 2019w5 |
55. | 4505 2019w6 |
|-----------------|
56. | 4259 2019w7 |
57. | 4314 2019w8 |
58. | 4726 2019w9 |
59. | 4979 2019w10 |
60. | 4295 2019w11 |
|-----------------|
61. | 4690 2019w12 |
62. | 5728 2019w13 |
63. | 4695 2019w14 |
64. | 5253 2019w15 |
65. | 4880 2019w16 |
|-----------------|
66. | 4260 2019w17 |
67. | 4817 2019w18 |
68. | 5002 2019w19 |
69. | 5596 2019w20 |
70. | 4693 2019w21 |
|-----------------|
71. | 4342 2019w22 |
72. | 4597 2019w23 |
73. | 5373 2019w24 |
74. | 4629 2019w25 |
75. | 4672 2019w26 |
|-----------------|
76. | 3882 2019w27 |
77. | 4462 2019w28 |
78. | 4005 2019w29 |
79. | 4377 2019w30 |
80. | 3603 2019w31 |
|-----------------|
81. | 3346 2019w32 |
82. | 3965 2019w33 |
83. | 3811 2019w34 |
84. | 3579 2019w35 |
85. | 3683 2019w36 |
|-----------------|
86. | 4005 2019w37 |
87. | 4382 2019w38 |
88. | 4348 2019w39 |
89. | 4209 2019w40 |
90. | 4701 2019w41 |
|-----------------|
91. | 5160 2019w42 |
92. | 5375 2019w43 |
93. | 4816 2019w44 |
94. | 4753 2019w45 |
95. | 11070 2019w46 |
|-----------------|
96. | 20397 2019w47 |
97. | 6271 2019w48 |
98. | 4650 2019w49 |
99. | 4832 2019w50 |
100. | 6066 2019w51 |
|-----------------|
101. | 7058 2019w52 |
102. | 5745 2020w1 |
103. | 5395 2020w2 |
104. | 7247 2020w3 |
+-----------------+
- 50% of observed weeks ( 104 weeks) have total intra-week merits above 4578, whilst the rest 50% of them have total intra-week merits below 4578. 4578 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 4078 to 5374 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3186 - 27920. variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 104.0 5531.3 3550.4 4578.0 4078.0 5374.0 3186.0 27920.0
----------------------------------------------------------------------------------------------
. di 5374-4078
1296
. di 1296*1.5
1944
. di 5374+1944
7318
. di 4078-1944
2134
It means that potential outliers are weeks that have intra-week merits beyond 2134 or 7318. How many weeks are potential outliers? . count if (merit >= 7318 | merit < 2134) & merit != .
10
weeks are outliers, in total. List of those 10 weeks: +-----------------+
| merit week |
|-----------------|
1. | 27920 2018w4 |
2. | 20930 2018w5 |
3. | 14042 2018w6 |
4. | 11901 2018w7 |
5. | 8879 2018w8 |
|-----------------|
6. | 9005 2018w9 |
8. | 7340 2018w11 |
35. | 9587 2018w38 |
95. | 11070 2019w46 |
96. | 20397 2019w47 |
+-----------------+
Most of them occured in the year 2018, and there is only 2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 ( 20397). List of weeks in descending weekly meritsThe last week (with 7247 merits) stays at the 11th position, among 104 weeks. +------------------------------+
| weeklyrank merit week |
|------------------------------|
1. | 1 27920 2018w4 |
2. | 2 20930 2018w5 |
3. | 3 20397 2019w47 |
4. | 4 14042 2018w6 |
5. | 5 11901 2018w7 |
|------------------------------|
6. | 6 11070 2019w46 |
7. | 7 9587 2018w38 |
8. | 8 9005 2018w9 |
9. | 9 8879 2018w8 |
10. | 10 7340 2018w11 |
|------------------------------|
11. | 11 7247 2020w3 |
12. | 12 7178 2018w10 |
13. | 13 7138 2018w12 |
14. | 14 7058 2019w52 |
15. | 15 6542 2018w14 |
|------------------------------|
16. | 16 6392 2018w13 |
17. | 17 6271 2019w48 |
18. | 18 6102 2019w2 |
19. | 19 6066 2019w51 |
20. | 20 5946 2018w15 |
|------------------------------|
21. | 21 5776 2019w3 |
22. | 22 5745 2020w1 |
23. | 23 5728 2019w13 |
24. | 24 5596 2019w20 |
25. | 25 5395 2020w2 |
|------------------------------|
26. | 26 5375 2019w43 |
27. | 27 5373 2019w24 |
28. | 28 5253 2019w15 |
29. | 29 5160 2019w42 |
30. | 30 5043 2018w18 |
|------------------------------|
31. | 31 5002 2019w19 |
32. | 32 4979 2019w10 |
33. | 33 4880 2019w16 |
34. | 34 4832 2019w50 |
35. | 35 4820 2018w17 |
|------------------------------|
36. | 36 4817 2019w18 |
37. | 37 4816 2019w44 |
38. | 38 4753 2019w45 |
39. | 39 4726 2019w9 |
40. | 40 4701 2019w41 |
|------------------------------|
41. | 41 4695 2019w14 |
42. | 42 4693 2019w21 |
43. | 43 4690 2019w12 |
44. | 44 4685 2018w19 |
45. | 45 4684 2018w26 |
|------------------------------|
46. | 46 4672 2019w26 |
47. | 47 4650 2019w49 |
48. | 48 4629 2019w25 |
49. | 49 4606 2018w47 |
50. | 50 4597 2019w23 |
|------------------------------|
51. | 51 4584 2019w1 |
52. | 52 4582 2019w4 |
53. | 53 4574 2018w25 |
54. | 54 4508 2018w39 |
55. | 55 4505 2019w6 |
|------------------------------|
56. | 56 4473 2018w23 |
57. | 57 4462 2019w28 |
58. | 58 4449 2018w16 |
59. | 59 4431 2018w20 |
60. | 60 4424 2018w42 |
|------------------------------|
61. | 61 4408 2019w5 |
62. | 62 4386 2018w43 |
63. | 63 4382 2019w38 |
64. | 64 4377 2019w30 |
65. | 65 4367 2018w27 |
|------------------------------|
66. | 66 4348 2019w39 |
67. | 67 4342 2019w22 |
68. | 68 4325 2018w40 |
69. | 69 4314 2019w8 |
70. | 70 4295 2019w11 |
|------------------------------|
71. | 71 4277 2018w29 |
72. | 72 4260 2019w17 |
73. | 73 4259 2019w7 |
74. | 74 4248 2018w22 |
75. | 75 4209 2019w40 |
|------------------------------|
76. | 76 4199 2018w32 |
77. | 77 4175 2018w45 |
78. | 78 4109 2018w28 |
79. | 79 4047 2018w46 |
80. | 80 4005 2019w29 |
|------------------------------|
81. | 81 4005 2019w37 |
82. | 82 3981 2018w41 |
83. | 83 3965 2019w33 |
84. | 84 3953 2018w24 |
85. | 85 3903 2018w21 |
|------------------------------|
86. | 86 3882 2019w27 |
87. | 87 3811 2019w34 |
88. | 88 3809 2018w30 |
89. | 89 3791 2018w48 |
90. | 90 3767 2018w33 |
|------------------------------|
91. | 91 3763 2018w34 |
92. | 92 3689 2018w50 |
93. | 93 3687 2018w52 |
94. | 94 3683 2019w36 |
95. | 95 3615 2018w51 |
|------------------------------|
96. | 96 3603 2019w31 |
97. | 97 3596 2018w49 |
98. | 98 3586 2018w37 |
99. | 99 3579 2019w35 |
100. | 100 3536 2018w36 |
|------------------------------|
101. | 101 3489 2018w31 |
102. | 102 3346 2019w32 |
103. | 103 3321 2018w44 |
104. | 104 3186 2018w35 |
+------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
January 27, 2020, 08:00:35 AM |
|
ABSTRACT 2020w3, GMT timeData is the full dataset since 24/1/2018, and only dropped last 3 days belong to incomplete week - 2020w4 and an incomplete day (dayid = 731). Details on days dropped, please see above posts.
Intra-day merits:- Total observed days: 728
- Potential outliers are days that have intraday total merits beyond 168 or 1186
- Median of intraday merits over the period is 655
- 50% of observed days have their intra-day merits range from 550 to 804 (the interquartile range)
- In medians, the highest and lowest days are Tuesday and Saturday, respectively; whilst the highest and lowest days in means are Thursday and Sunday, respectively. See here.
- There are 58 potential outliers (beyond 168 or 1186) in total.
- The distribution of outliers over years are: 43 (74.1%) for 2018, 14 (24.1%) for 2019, and 1 (1.7%) for 2020. (see details)
- Minimum and maximum of intraday merits (full dataset) are 300, and 12676, on 04/8/2019 and 25/1/2018, respectively.
Intra-week merits:- Total observed weeks: 104
- The median of intra-week merits is 4578
- 50% of observed weeks (104 weeks in total), have total merits in the range from 4078 to 5374 (the interquartile range of intra-week merits).
- Minimum and maximum of intra-week merits are 3186 and 27920, in 2018w35, and 2018w4, respectively;
- 10 potential outliers [beyond 2134 or 7318], only 2 of them occurred in the year 2019, on 2019w46 (11070), and 2019w47 (20397).
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
February 01, 2020, 07:52:05 AM |
|
Converted dataset: - In 2020 at 31jan2020 02:51:21 (GMT time)
- The last one, with dayid == 738 is an incomplete day.
+----------------------------------------------------------------+
| dayid date merit dofw week month year |
|----------------------------------------------------------------|
708. | 708 01jan2020 810 Wednesday 2020w1 2020m1 2020 |
709. | 709 02jan2020 854 Thursday 2020w1 2020m1 2020 |
710. | 710 03jan2020 837 Friday 2020w1 2020m1 2020 |
711. | 711 04jan2020 637 Saturday 2020w1 2020m1 2020 |
712. | 712 05jan2020 777 Sunday 2020w1 2020m1 2020 |
|----------------------------------------------------------------|
713. | 713 06jan2020 959 Monday 2020w1 2020m1 2020 |
714. | 714 07jan2020 871 Tuesday 2020w1 2020m1 2020 |
715. | 715 08jan2020 860 Wednesday 2020w2 2020m1 2020 |
716. | 716 09jan2020 733 Thursday 2020w2 2020m1 2020 |
717. | 717 10jan2020 745 Friday 2020w2 2020m1 2020 |
|----------------------------------------------------------------|
718. | 718 11jan2020 743 Saturday 2020w2 2020m1 2020 |
719. | 719 12jan2020 689 Sunday 2020w2 2020m1 2020 |
720. | 720 13jan2020 754 Monday 2020w2 2020m1 2020 |
721. | 721 14jan2020 871 Tuesday 2020w2 2020m1 2020 |
722. | 722 15jan2020 979 Wednesday 2020w3 2020m1 2020 |
|----------------------------------------------------------------|
723. | 723 16jan2020 972 Thursday 2020w3 2020m1 2020 |
724. | 724 17jan2020 1063 Friday 2020w3 2020m1 2020 |
725. | 725 18jan2020 823 Saturday 2020w3 2020m1 2020 |
726. | 726 19jan2020 1192 Sunday 2020w3 2020m1 2020 |
727. | 727 20jan2020 1136 Monday 2020w3 2020m1 2020 |
|----------------------------------------------------------------|
728. | 728 21jan2020 1082 Tuesday 2020w3 2020m1 2020 |
729. | 729 22jan2020 863 Wednesday 2020w4 2020m1 2020 |
730. | 730 23jan2020 1050 Thursday 2020w4 2020m1 2020 |
731. | 731 24jan2020 1061 Friday 2020w4 2020m1 2020 |
732. | 732 25jan2020 1043 Saturday 2020w4 2020m1 2020 |
|----------------------------------------------------------------|
733. | 733 26jan2020 715 Sunday 2020w4 2020m1 2020 |
734. | 734 27jan2020 961 Monday 2020w4 2020m1 2020 |
735. | 735 28jan2020 953 Tuesday 2020w4 2020m1 2020 |
736. | 736 29jan2020 1051 Wednesday 2020w5 2020m1 2020 |
737. | 737 30jan2020 1125 Thursday 2020w5 2020m1 2020 |
|----------------------------------------------------------------|
738. | 738 31jan2020 63 Friday 2020w5 2020m1 2020 |
+----------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
February 01, 2020, 07:57:05 AM
Last edit: February 01, 2020, 08:24:59 AM by tranthidung |
|
Time-series plots:Full dataset:Truncated dataset:
Basic statistics (for full dataset): Only drop last 3 days that belong to the 2020w5 (daydi = 736, 737), the incomplete week & incomlete day (dayid = 738). variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 735 791.698 691.8314 656 551 808 300 12676
----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 166 or 1194. . di 808-551
257
. di 257*1.5
385.5
. di 808+385.5
1193.5
. di 551-385.5
165.5
There are 56 outliers (beyond 1186 or 168) in full dataset, in total. . count if (merit >= 1194 | merit <= 166) & merit != .
56
Those days are: +---------------------------+
| dayid merit date |
|---------------------------|
2. | 2 12676 25jan2018 |
3. | 3 6348 26jan2018 |
4. | 4 4627 27jan2018 |
5. | 5 3240 28jan2018 |
6. | 6 3343 29jan2018 |
7. | 7 3804 30jan2018 |
8. | 8 4103 31jan2018 |
9. | 9 2793 01feb2018 |
10. | 10 2621 02feb2018 |
11. | 11 2476 03feb2018 |
12. | 12 1790 04feb2018 |
13. | 13 2263 05feb2018 |
14. | 14 2003 06feb2018 |
15. | 15 2367 07feb2018 |
16. | 16 2059 08feb2018 |
17. | 17 2223 09feb2018 |
18. | 18 1334 10feb2018 |
19. | 19 1793 11feb2018 |
20. | 20 1475 12feb2018 |
21. | 21 1289 13feb2018 |
22. | 22 1580 14feb2018 |
23. | 23 2797 15feb2018 |
24. | 24 1740 16feb2018 |
25. | 25 1431 17feb2018 |
26. | 26 1589 18feb2018 |
27. | 27 1289 19feb2018 |
28. | 28 1442 20feb2018 |
30. | 30 1277 22feb2018 |
31. | 31 1249 23feb2018 |
33. | 33 1372 25feb2018 |
35. | 35 1414 27feb2018 |
36. | 36 1302 28feb2018 |
38. | 38 1345 02mar2018 |
39. | 39 1727 03mar2018 |
49. | 49 1316 13mar2018 |
51. | 51 1224 15mar2018 |
57. | 57 1390 21mar2018 |
58. | 58 1211 22mar2018 |
237. | 237 2553 17sep2018 |
238. | 238 1807 18sep2018 |
239. | 239 1347 19sep2018 |
240. | 240 1221 20sep2018 |
|---------------------------|
429. | 429 1247 28mar2019 |
476. | 476 1215 14may2019 |
505. | 505 1227 12jun2019 |
660. | 660 1630 14nov2019 |
661. | 661 2374 15nov2019 |
662. | 662 1585 16nov2019 |
663. | 663 1377 17nov2019 |
664. | 664 2783 18nov2019 |
665. | 665 3826 19nov2019 |
666. | 666 2584 20nov2019 |
667. | 667 4889 21nov2019 |
668. | 668 5515 22nov2019 |
669. | 669 1590 23nov2019 |
678. | 678 1465 02dec2019 |
+---------------------------+
- 2018: 42 (75%)
- 2019: 14 (25%)
- 2020: 0 (0%)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
February 01, 2020, 07:59:01 AM |
|
During the period from 24/1/2018 to 28/1/2020 (last 3 days dropped due to incomplete week, 2020w5 and an incomplete day - dayid = 738), the minimum and maximum of intra-day merit are 300 and 12676, on 04/8/2019 and 25/1/2018, respectively. List of the top 50-highest day in terms of intra-day merits: +-----------------------------------------------------------------------------+
| rank_max merit dayid date dofw week month year |
|-----------------------------------------------------------------------------|
1. | 1 12676 2 25jan2018 Thursday 2018w4 2018m1 2018 |
2. | 2 6348 3 26jan2018 Friday 2018w4 2018m1 2018 |
3. | 3 5515 668 22nov2019 Friday 2019w47 2019m11 2019 |
4. | 4 4889 667 21nov2019 Thursday 2019w47 2019m11 2019 |
5. | 5 4627 4 27jan2018 Saturday 2018w4 2018m1 2018 |
|-----------------------------------------------------------------------------|
6. | 6 4103 8 31jan2018 Wednesday 2018w5 2018m1 2018 |
7. | 7 3826 665 19nov2019 Tuesday 2019w47 2019m11 2019 |
8. | 8 3804 7 30jan2018 Tuesday 2018w5 2018m1 2018 |
9. | 9 3343 6 29jan2018 Monday 2018w5 2018m1 2018 |
10. | 10 3240 5 28jan2018 Sunday 2018w4 2018m1 2018 |
|-----------------------------------------------------------------------------|
11. | 11 2797 23 15feb2018 Thursday 2018w7 2018m2 2018 |
12. | 12 2793 9 01feb2018 Thursday 2018w5 2018m2 2018 |
13. | 13 2783 664 18nov2019 Monday 2019w46 2019m11 2019 |
14. | 14 2621 10 02feb2018 Friday 2018w5 2018m2 2018 |
15. | 15 2584 666 20nov2019 Wednesday 2019w47 2019m11 2019 |
|-----------------------------------------------------------------------------|
16. | 16 2553 237 17sep2018 Monday 2018w38 2018m9 2018 |
17. | 17 2476 11 03feb2018 Saturday 2018w5 2018m2 2018 |
18. | 18 2374 661 15nov2019 Friday 2019w46 2019m11 2019 |
19. | 19 2367 15 07feb2018 Wednesday 2018w6 2018m2 2018 |
20. | 20 2263 13 05feb2018 Monday 2018w6 2018m2 2018 |
|-----------------------------------------------------------------------------|
21. | 21 2223 17 09feb2018 Friday 2018w6 2018m2 2018 |
22. | 22 2059 16 08feb2018 Thursday 2018w6 2018m2 2018 |
23. | 23 2003 14 06feb2018 Tuesday 2018w6 2018m2 2018 |
24. | 24 1807 238 18sep2018 Tuesday 2018w38 2018m9 2018 |
25. | 25 1793 19 11feb2018 Sunday 2018w6 2018m2 2018 |
|-----------------------------------------------------------------------------|
26. | 26 1790 12 04feb2018 Sunday 2018w5 2018m2 2018 |
27. | 27 1740 24 16feb2018 Friday 2018w7 2018m2 2018 |
28. | 28 1727 39 03mar2018 Saturday 2018w9 2018m3 2018 |
29. | 29 1630 660 14nov2019 Thursday 2019w46 2019m11 2019 |
30. | 30 1590 669 23nov2019 Saturday 2019w47 2019m11 2019 |
|-----------------------------------------------------------------------------|
31. | 31 1589 26 18feb2018 Sunday 2018w7 2018m2 2018 |
32. | 32 1585 662 16nov2019 Saturday 2019w46 2019m11 2019 |
33. | 33 1580 22 14feb2018 Wednesday 2018w7 2018m2 2018 |
34. | 34 1475 20 12feb2018 Monday 2018w7 2018m2 2018 |
35. | 35 1465 678 02dec2019 Monday 2019w48 2019m12 2019 |
|-----------------------------------------------------------------------------|
36. | 36 1442 28 20feb2018 Tuesday 2018w8 2018m2 2018 |
37. | 37 1431 25 17feb2018 Saturday 2018w7 2018m2 2018 |
38. | 38 1414 35 27feb2018 Tuesday 2018w9 2018m2 2018 |
39. | 39 1390 57 21mar2018 Wednesday 2018w12 2018m3 2018 |
40. | 40 1377 663 17nov2019 Sunday 2019w46 2019m11 2019 |
|-----------------------------------------------------------------------------|
41. | 41 1372 33 25feb2018 Sunday 2018w8 2018m2 2018 |
42. | 42 1347 239 19sep2018 Wednesday 2018w38 2018m9 2018 |
43. | 43 1345 38 02mar2018 Friday 2018w9 2018m3 2018 |
44. | 44 1334 18 10feb2018 Saturday 2018w6 2018m2 2018 |
45. | 45 1316 49 13mar2018 Tuesday 2018w11 2018m3 2018 |
|-----------------------------------------------------------------------------|
46. | 46 1302 36 28feb2018 Wednesday 2018w9 2018m2 2018 |
47. | 47 1289 27 19feb2018 Monday 2018w8 2018m2 2018 |
48. | 48 1289 21 13feb2018 Tuesday 2018w7 2018m2 2018 |
49. | 49 1277 30 22feb2018 Thursday 2018w8 2018m2 2018 |
50. | 50 1249 31 23feb2018 Friday 2018w8 2018m2 2018 |
+-----------------------------------------------------------------------------+
List of the top 50-lowest days in terms of intra-day merits: +-----------------------------------------------------------------------------+
| rank_min merit dayid date dofw week month year |
|-----------------------------------------------------------------------------|
1. | 1 300 558 04aug2019 Sunday 2019w31 2019m8 2019 |
2. | 2 333 341 30dec2018 Sunday 2018w52 2018m12 2018 |
3. | 3 339 343 01jan2019 Tuesday 2019w1 2019m1 2019 |
4. | 4 347 299 18nov2018 Sunday 2018w46 2018m11 2018 |
5. | 5 347 330 19dec2018 Wednesday 2018w51 2018m12 2018 |
|-----------------------------------------------------------------------------|
6. | 6 351 334 23dec2018 Sunday 2018w51 2018m12 2018 |
7. | 7 366 218 29aug2018 Wednesday 2018w35 2018m8 2018 |
8. | 8 367 565 11aug2019 Sunday 2019w32 2019m8 2019 |
9. | 9 370 223 03sep2018 Monday 2018w36 2018m9 2018 |
10. | 10 373 339 28dec2018 Friday 2018w52 2018m12 2018 |
|-----------------------------------------------------------------------------|
11. | 11 375 340 29dec2018 Saturday 2018w52 2018m12 2018 |
12. | 12 377 600 15sep2019 Sunday 2019w37 2019m9 2019 |
13. | 13 378 305 24nov2018 Saturday 2018w47 2018m11 2018 |
14. | 14 378 567 13aug2019 Tuesday 2019w33 2019m8 2019 |
15. | 15 378 566 12aug2019 Monday 2019w32 2019m8 2019 |
|-----------------------------------------------------------------------------|
16. | 16 380 192 03aug2018 Friday 2018w31 2018m8 2018 |
17. | 17 381 336 25dec2018 Tuesday 2018w52 2018m12 2018 |
18. | 18 385 215 26aug2018 Sunday 2018w34 2018m8 2018 |
19. | 19 385 327 16dec2018 Sunday 2018w50 2018m12 2018 |
20. | 20 391 221 01sep2018 Saturday 2018w35 2018m9 2018 |
|-----------------------------------------------------------------------------|
21. | 21 394 188 30jul2018 Monday 2018w31 2018m7 2018 |
22. | 22 399 593 08sep2019 Sunday 2019w36 2019m9 2019 |
23. | 23 401 557 03aug2019 Saturday 2019w31 2019m8 2019 |
24. | 24 401 288 07nov2018 Wednesday 2018w45 2018m11 2018 |
25. | 25 402 263 13oct2018 Saturday 2018w41 2018m10 2018 |
|-----------------------------------------------------------------------------|
26. | 26 404 229 09sep2018 Sunday 2018w36 2018m9 2018 |
27. | 27 406 277 27oct2018 Saturday 2018w43 2018m10 2018 |
28. | 28 408 530 07jul2019 Sunday 2019w27 2019m7 2019 |
29. | 29 409 589 04sep2019 Wednesday 2019w36 2019m9 2019 |
30. | 30 409 123 26may2018 Saturday 2018w21 2018m5 2018 |
|-----------------------------------------------------------------------------|
31. | 31 410 279 29oct2018 Monday 2018w44 2018m10 2018 |
32. | 32 411 569 15aug2019 Thursday 2019w33 2019m8 2019 |
33. | 33 411 578 24aug2019 Saturday 2019w34 2019m8 2019 |
34. | 34 414 528 05jul2019 Friday 2019w27 2019m7 2019 |
35. | 35 421 193 04aug2018 Saturday 2018w31 2018m8 2018 |
|-----------------------------------------------------------------------------|
36. | 36 425 588 03sep2019 Tuesday 2019w36 2019m9 2019 |
37. | 37 426 230 10sep2018 Monday 2018w37 2018m9 2018 |
38. | 38 426 346 04jan2019 Friday 2019w1 2019m1 2019 |
39. | 39 427 141 13jun2018 Wednesday 2018w24 2018m6 2018 |
40. | 40 430 207 18aug2018 Saturday 2018w33 2018m8 2018 |
|-----------------------------------------------------------------------------|
41. | 41 432 587 02sep2019 Monday 2019w35 2019m9 2019 |
42. | 42 435 522 29jun2019 Saturday 2019w26 2019m6 2019 |
43. | 43 436 419 18mar2019 Monday 2019w11 2019m3 2019 |
44. | 44 440 559 05aug2019 Monday 2019w31 2019m8 2019 |
45. | 45 440 265 15oct2018 Monday 2018w42 2018m10 2018 |
|-----------------------------------------------------------------------------|
46. | 46 440 585 31aug2019 Saturday 2019w35 2019m8 2019 |
47. | 47 441 404 03mar2019 Sunday 2019w9 2019m3 2019 |
48. | 48 441 319 08dec2018 Saturday 2018w49 2018m12 2018 |
49. | 49 442 342 31dec2018 Monday 2018w52 2018m12 2018 |
50. | 50 442 278 28oct2018 Sunday 2018w43 2018m10 2018 |
+-----------------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
February 01, 2020, 08:04:36 AM
Last edit: February 01, 2020, 08:25:37 AM by tranthidung |
|
Medians and means of intra-day merits over days of weeks GMT timeColors: - Green: highest.
- Red: Lowest.
- In median, the highest days are Tuesday, Friday, and Thursday at 700, 690, and 677, respectively; whislt the lowest days are Saturday, Sunday, and Wednesday at 592, 610, and 656, respectively. - In means, the highest days are Thursday, Friday, and Tuesday at 917, 854, and 812, respectively; whilst the lowest days are Sunday, Saturday, and Monday, at 697, 709, and 774, respectively. Basic statistics:Summary for variables: merit
by categories of: dofw
dofw | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
Sunday | 105 697.0381 375.343 610 492 747 300 3240
Monday | 105 774.0095 458.868 658 553 834 370 3343
Tuesday | 105 812.0571 503.2766 700 592 863 339 3826
Wednesday | 105 781.0476 458.8497 656 599 812 347 4103
Thursday | 105 916.1714 1283.176 677 573 792 411 12676
Friday | 105 853.1905 797.8059 690 561 828 373 6348
Saturday | 105 708.3714 493.3099 592 501 724 375 4627
----------+--------------------------------------------------------------------------------
Total | 735 791.698 691.8314 656 551 808 300 12676
-------------------------------------------------------------------------------------------
Outliers displayed as red circles. Outliers non-displayed. Details on ranks:In medians +----------------------------------------------------------------------+
| rankmedian dofw median mean p25 p75 min max |
|----------------------------------------------------------------------|
1. | 1 Tuesday 700 812.0571 592 863 339 3826 |
2. | 2 Friday 690 853.1905 561 828 373 6348 |
3. | 3 Thursday 677 916.1714 573 792 411 12676 |
4. | 4 Monday 658 774.0095 553 834 370 3343 |
5. | 5 Wednesday 656 781.0476 599 812 347 4103 |
|----------------------------------------------------------------------|
6. | 6 Sunday 610 697.0381 492 747 300 3240 |
7. | 7 Saturday 592 708.3714 501 724 375 4627 |
+----------------------------------------------------------------------+
In means +--------------------------------------------------------------------+
| rankmean dofw mean median p25 p75 min max |
|--------------------------------------------------------------------|
1. | 1 Thursday 916.1714 677 573 792 411 12676 |
2. | 2 Friday 853.1905 690 561 828 373 6348 |
3. | 3 Tuesday 812.0571 700 592 863 339 3826 |
4. | 4 Wednesday 781.0476 656 599 812 347 4103 |
5. | 5 Monday 774.0095 658 553 834 370 3343 |
|--------------------------------------------------------------------|
6. | 6 Saturday 708.3714 592 501 724 375 4627 |
7. | 7 Sunday 697.0381 610 492 747 300 3240 |
+--------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
February 01, 2020, 08:10:53 AM
Last edit: February 01, 2020, 08:26:07 AM by tranthidung |
|
Intra-week merits (from 24/1/2018 to 28/1/2020)Last 3 days dropped due to incomplete week (2020w5) and an incomplete day (dayid = 738)Converted dataset: +-----------------+
| merit week |
|-----------------|
1. | 27920 2018w4 |
2. | 20930 2018w5 |
3. | 14042 2018w6 |
4. | 11901 2018w7 |
5. | 8879 2018w8 |
|-----------------|
6. | 9005 2018w9 |
7. | 7178 2018w10 |
8. | 7340 2018w11 |
9. | 7138 2018w12 |
10. | 6392 2018w13 |
|-----------------|
11. | 6542 2018w14 |
12. | 5946 2018w15 |
13. | 4449 2018w16 |
14. | 4820 2018w17 |
15. | 5043 2018w18 |
|-----------------|
16. | 4685 2018w19 |
17. | 4431 2018w20 |
18. | 3903 2018w21 |
19. | 4248 2018w22 |
20. | 4473 2018w23 |
|-----------------|
21. | 3953 2018w24 |
22. | 4574 2018w25 |
23. | 4684 2018w26 |
24. | 4367 2018w27 |
25. | 4109 2018w28 |
|-----------------|
26. | 4277 2018w29 |
27. | 3809 2018w30 |
28. | 3489 2018w31 |
29. | 4199 2018w32 |
30. | 3767 2018w33 |
|-----------------|
31. | 3763 2018w34 |
32. | 3186 2018w35 |
33. | 3536 2018w36 |
34. | 3586 2018w37 |
35. | 9587 2018w38 |
|-----------------|
36. | 4508 2018w39 |
37. | 4325 2018w40 |
38. | 3981 2018w41 |
39. | 4424 2018w42 |
40. | 4386 2018w43 |
|-----------------|
41. | 3321 2018w44 |
42. | 4175 2018w45 |
43. | 4047 2018w46 |
44. | 4606 2018w47 |
45. | 3791 2018w48 |
|-----------------|
46. | 3596 2018w49 |
47. | 3689 2018w50 |
48. | 3615 2018w51 |
49. | 3687 2018w52 |
50. | 4584 2019w1 |
|-----------------|
51. | 6102 2019w2 |
52. | 5776 2019w3 |
53. | 4582 2019w4 |
54. | 4408 2019w5 |
55. | 4505 2019w6 |
|-----------------|
56. | 4259 2019w7 |
57. | 4314 2019w8 |
58. | 4726 2019w9 |
59. | 4979 2019w10 |
60. | 4295 2019w11 |
|-----------------|
61. | 4690 2019w12 |
62. | 5728 2019w13 |
63. | 4695 2019w14 |
64. | 5253 2019w15 |
65. | 4880 2019w16 |
|-----------------|
66. | 4260 2019w17 |
67. | 4817 2019w18 |
68. | 5002 2019w19 |
69. | 5596 2019w20 |
70. | 4693 2019w21 |
|-----------------|
71. | 4342 2019w22 |
72. | 4597 2019w23 |
73. | 5373 2019w24 |
74. | 4629 2019w25 |
75. | 4672 2019w26 |
|-----------------|
76. | 3882 2019w27 |
77. | 4462 2019w28 |
78. | 4005 2019w29 |
79. | 4377 2019w30 |
80. | 3603 2019w31 |
|-----------------|
81. | 3346 2019w32 |
82. | 3965 2019w33 |
83. | 3811 2019w34 |
84. | 3579 2019w35 |
85. | 3683 2019w36 |
|-----------------|
86. | 4005 2019w37 |
87. | 4382 2019w38 |
88. | 4348 2019w39 |
89. | 4209 2019w40 |
90. | 4701 2019w41 |
|-----------------|
91. | 5160 2019w42 |
92. | 5375 2019w43 |
93. | 4816 2019w44 |
94. | 4753 2019w45 |
95. | 11070 2019w46 |
|-----------------|
96. | 20397 2019w47 |
97. | 6271 2019w48 |
98. | 4650 2019w49 |
99. | 4832 2019w50 |
100. | 6066 2019w51 |
|-----------------|
101. | 7058 2019w52 |
102. | 5745 2020w1 |
103. | 5395 2020w2 |
104. | 7247 2020w3 |
105. | 6646 2020w4 |
+-----------------+
- 50% of observed weeks ( 105 weeks) have total intra-week merits above 4582, whilst the rest 50% of them have total intra-week merits below 4582. 4582 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 4109 to 5375 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3186 - 27920. variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 105.0 5541.9 3535.0 4582.0 4109.0 5375.0 3186.0 27920.0
----------------------------------------------------------------------------------------------
. di 5375-4109
1266
. di 1266*1.5
1899
. di 5375+1899
7274
. di 4109-1899
2210
It means that potential outliers are weeks that have intra-week merits beyond 2210 or 7274. How many weeks are potential outliers? . count if (merit >= 7274 | merit < 2210) & merit != .
10
weeks are outliers, in total. List of those 10 weeks: +-----------------+
| merit week |
|-----------------|
1. | 27920 2018w4 |
2. | 20930 2018w5 |
3. | 14042 2018w6 |
4. | 11901 2018w7 |
5. | 8879 2018w8 |
|-----------------|
6. | 9005 2018w9 |
8. | 7340 2018w11 |
35. | 9587 2018w38 |
95. | 11070 2019w46 |
96. | 20397 2019w47 |
+-----------------+
Most of them occured in the year 2018, and there is only 2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 ( 20397). List of weeks in descending weekly meritsThe last week (with 6646 merits) stays at the 15th position, among 105 weeks. +------------------------------+
| weeklyrank merit week |
|------------------------------|
1. | 1 27920 2018w4 |
2. | 2 20930 2018w5 |
3. | 3 20397 2019w47 |
4. | 4 14042 2018w6 |
5. | 5 11901 2018w7 |
|------------------------------|
6. | 6 11070 2019w46 |
7. | 7 9587 2018w38 |
8. | 8 9005 2018w9 |
9. | 9 8879 2018w8 |
10. | 10 7340 2018w11 |
|------------------------------|
11. | 11 7247 2020w3 |
12. | 12 7178 2018w10 |
13. | 13 7138 2018w12 |
14. | 14 7058 2019w52 |
15. | 15 6646 2020w4 |
|------------------------------|
16. | 16 6542 2018w14 |
17. | 17 6392 2018w13 |
18. | 18 6271 2019w48 |
19. | 19 6102 2019w2 |
20. | 20 6066 2019w51 |
|------------------------------|
21. | 21 5946 2018w15 |
22. | 22 5776 2019w3 |
23. | 23 5745 2020w1 |
24. | 24 5728 2019w13 |
25. | 25 5596 2019w20 |
|------------------------------|
26. | 26 5395 2020w2 |
27. | 27 5375 2019w43 |
28. | 28 5373 2019w24 |
29. | 29 5253 2019w15 |
30. | 30 5160 2019w42 |
|------------------------------|
31. | 31 5043 2018w18 |
32. | 32 5002 2019w19 |
33. | 33 4979 2019w10 |
34. | 34 4880 2019w16 |
35. | 35 4832 2019w50 |
|------------------------------|
36. | 36 4820 2018w17 |
37. | 37 4817 2019w18 |
38. | 38 4816 2019w44 |
39. | 39 4753 2019w45 |
40. | 40 4726 2019w9 |
|------------------------------|
41. | 41 4701 2019w41 |
42. | 42 4695 2019w14 |
43. | 43 4693 2019w21 |
44. | 44 4690 2019w12 |
45. | 45 4685 2018w19 |
|------------------------------|
46. | 46 4684 2018w26 |
47. | 47 4672 2019w26 |
48. | 48 4650 2019w49 |
49. | 49 4629 2019w25 |
50. | 50 4606 2018w47 |
|------------------------------|
51. | 51 4597 2019w23 |
52. | 52 4584 2019w1 |
53. | 53 4582 2019w4 |
54. | 54 4574 2018w25 |
55. | 55 4508 2018w39 |
|------------------------------|
56. | 56 4505 2019w6 |
57. | 57 4473 2018w23 |
58. | 58 4462 2019w28 |
59. | 59 4449 2018w16 |
60. | 60 4431 2018w20 |
|------------------------------|
61. | 61 4424 2018w42 |
62. | 62 4408 2019w5 |
63. | 63 4386 2018w43 |
64. | 64 4382 2019w38 |
65. | 65 4377 2019w30 |
|------------------------------|
66. | 66 4367 2018w27 |
67. | 67 4348 2019w39 |
68. | 68 4342 2019w22 |
69. | 69 4325 2018w40 |
70. | 70 4314 2019w8 |
|------------------------------|
71. | 71 4295 2019w11 |
72. | 72 4277 2018w29 |
73. | 73 4260 2019w17 |
74. | 74 4259 2019w7 |
75. | 75 4248 2018w22 |
|------------------------------|
76. | 76 4209 2019w40 |
77. | 77 4199 2018w32 |
78. | 78 4175 2018w45 |
79. | 79 4109 2018w28 |
80. | 80 4047 2018w46 |
|------------------------------|
81. | 81 4005 2019w29 |
82. | 82 4005 2019w37 |
83. | 83 3981 2018w41 |
84. | 84 3965 2019w33 |
85. | 85 3953 2018w24 |
|------------------------------|
86. | 86 3903 2018w21 |
87. | 87 3882 2019w27 |
88. | 88 3811 2019w34 |
89. | 89 3809 2018w30 |
90. | 90 3791 2018w48 |
|------------------------------|
91. | 91 3767 2018w33 |
92. | 92 3763 2018w34 |
93. | 93 3689 2018w50 |
94. | 94 3687 2018w52 |
95. | 95 3683 2019w36 |
|------------------------------|
96. | 96 3615 2018w51 |
97. | 97 3603 2019w31 |
98. | 98 3596 2018w49 |
99. | 99 3586 2018w37 |
100. | 100 3579 2019w35 |
|------------------------------|
101. | 101 3536 2018w36 |
102. | 102 3489 2018w31 |
103. | 103 3346 2019w32 |
104. | 104 3321 2018w44 |
105. | 105 3186 2018w35 |
+------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
February 01, 2020, 08:15:14 AM |
|
ABSTRACT 2020w4, GMT timeData is the full dataset since 24/1/2018, and only dropped last 3 days belong to incomplete week - 2020w5 and an incomplete day (dayid = 738). Details on days dropped, please see above posts.
Intra-day merits:- Total observed days: 735
- Potential outliers are days that have intraday total merits beyond 166 or 1194
- Median of intraday merits over the period is 656
- 50% of observed days have their intra-day merits range from 551 to 808 (the interquartile range)
- In medians, the highest and lowest days are Tuesday and Saturday, respectively; whilst the highest and lowest days in means are Thursday and Sunday, respectively. See here.
- There are 56 potential outliers (beyond 168 or 1186) in total.
- The distribution of outliers over years are: 42 (75%) for 2018, 14 (25%) for 2019, and 0 (0%) for 2020. (see details)
- Minimum and maximum of intraday merits (full dataset) are 300, and 12676, on 04/8/2019 and 25/1/2018, respectively.
Intra-week merits:- Total observed weeks: 105
- The median of intra-week merits is 4582
- 50% of observed weeks (104 weeks in total), have total merits in the range from 4109 to 5375 (the interquartile range of intra-week merits).
- Minimum and maximum of intra-week merits are 3186 and 27920, in 2018w35, and 2018w4, respectively;
- 10 potential outliers [beyond 2210 or 7274], only 2 of them occurred in the year 2019, on 2019w46 (11070), and 2019w47 (20397).
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
February 09, 2020, 01:30:50 AM |
|
Converted dataset: - In 2020 at 07feb2020 02:47:27 (GMT time)
- The last one, with dayid == 745 is an incomplete day.
+----------------------------------------------------------------+
| dayid date merit dofw week month year |
|----------------------------------------------------------------|
708. | 708 01jan2020 810 Wednesday 2020w1 2020m1 2020 |
709. | 709 02jan2020 854 Thursday 2020w1 2020m1 2020 |
710. | 710 03jan2020 837 Friday 2020w1 2020m1 2020 |
711. | 711 04jan2020 637 Saturday 2020w1 2020m1 2020 |
712. | 712 05jan2020 777 Sunday 2020w1 2020m1 2020 |
|----------------------------------------------------------------|
713. | 713 06jan2020 959 Monday 2020w1 2020m1 2020 |
714. | 714 07jan2020 871 Tuesday 2020w1 2020m1 2020 |
715. | 715 08jan2020 860 Wednesday 2020w2 2020m1 2020 |
716. | 716 09jan2020 733 Thursday 2020w2 2020m1 2020 |
717. | 717 10jan2020 745 Friday 2020w2 2020m1 2020 |
|----------------------------------------------------------------|
718. | 718 11jan2020 743 Saturday 2020w2 2020m1 2020 |
719. | 719 12jan2020 689 Sunday 2020w2 2020m1 2020 |
720. | 720 13jan2020 754 Monday 2020w2 2020m1 2020 |
721. | 721 14jan2020 871 Tuesday 2020w2 2020m1 2020 |
722. | 722 15jan2020 979 Wednesday 2020w3 2020m1 2020 |
|----------------------------------------------------------------|
723. | 723 16jan2020 972 Thursday 2020w3 2020m1 2020 |
724. | 724 17jan2020 1063 Friday 2020w3 2020m1 2020 |
725. | 725 18jan2020 823 Saturday 2020w3 2020m1 2020 |
726. | 726 19jan2020 1192 Sunday 2020w3 2020m1 2020 |
727. | 727 20jan2020 1136 Monday 2020w3 2020m1 2020 |
|----------------------------------------------------------------|
728. | 728 21jan2020 1082 Tuesday 2020w3 2020m1 2020 |
729. | 729 22jan2020 863 Wednesday 2020w4 2020m1 2020 |
730. | 730 23jan2020 1050 Thursday 2020w4 2020m1 2020 |
731. | 731 24jan2020 1061 Friday 2020w4 2020m1 2020 |
732. | 732 25jan2020 1043 Saturday 2020w4 2020m1 2020 |
|----------------------------------------------------------------|
733. | 733 26jan2020 715 Sunday 2020w4 2020m1 2020 |
734. | 734 27jan2020 961 Monday 2020w4 2020m1 2020 |
735. | 735 28jan2020 953 Tuesday 2020w4 2020m1 2020 |
736. | 736 29jan2020 1051 Wednesday 2020w5 2020m1 2020 |
737. | 737 30jan2020 1125 Thursday 2020w5 2020m1 2020 |
|----------------------------------------------------------------|
738. | 738 31jan2020 1072 Friday 2020w5 2020m1 2020 |
739. | 739 01feb2020 705 Saturday 2020w5 2020m2 2020 |
740. | 740 02feb2020 836 Sunday 2020w5 2020m2 2020 |
741. | 741 03feb2020 908 Monday 2020w5 2020m2 2020 |
742. | 742 04feb2020 1059 Tuesday 2020w5 2020m2 2020 |
|----------------------------------------------------------------|
743. | 743 05feb2020 873 Wednesday 2020w6 2020m2 2020 |
744. | 744 06feb2020 932 Thursday 2020w6 2020m2 2020 |
745. | 745 07feb2020 46 Friday 2020w6 2020m2 2020 |
+----------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
February 09, 2020, 01:35:24 AM |
|
Time-series plots:Plots will be updated later.Full dataset:Truncated dataset:
Basic statistics (for full dataset): Only drop last 3 days that belong to the 2020w5 (daydi = 743, 744), the incomplete week & incomlete day (dayid = 745). variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 742 793.3342 688.8982 658.5 552 812 300 12676
----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 162 or 1202. . di 812-552
260
. di 260*1.5
390
. di 812+390
1202
. di 552-390
162
There are 56 outliers (beyond 1202 or 162) in full dataset, in total. . count if (merit >= 1202 | merit <= 162) & merit != .
56
Those days are: +---------------------------+
| dayid merit date |
|---------------------------|
2. | 2 12676 25jan2018 |
3. | 3 6348 26jan2018 |
4. | 4 4627 27jan2018 |
5. | 5 3240 28jan2018 |
6. | 6 3343 29jan2018 |
7. | 7 3804 30jan2018 |
8. | 8 4103 31jan2018 |
9. | 9 2793 01feb2018 |
10. | 10 2621 02feb2018 |
11. | 11 2476 03feb2018 |
12. | 12 1790 04feb2018 |
13. | 13 2263 05feb2018 |
14. | 14 2003 06feb2018 |
15. | 15 2367 07feb2018 |
16. | 16 2059 08feb2018 |
17. | 17 2223 09feb2018 |
18. | 18 1334 10feb2018 |
19. | 19 1793 11feb2018 |
20. | 20 1475 12feb2018 |
21. | 21 1289 13feb2018 |
22. | 22 1580 14feb2018 |
23. | 23 2797 15feb2018 |
24. | 24 1740 16feb2018 |
25. | 25 1431 17feb2018 |
26. | 26 1589 18feb2018 |
27. | 27 1289 19feb2018 |
28. | 28 1442 20feb2018 |
30. | 30 1277 22feb2018 |
31. | 31 1249 23feb2018 |
33. | 33 1372 25feb2018 |
35. | 35 1414 27feb2018 |
36. | 36 1302 28feb2018 |
38. | 38 1345 02mar2018 |
39. | 39 1727 03mar2018 |
49. | 49 1316 13mar2018 |
51. | 51 1224 15mar2018 |
57. | 57 1390 21mar2018 |
58. | 58 1211 22mar2018 |
237. | 237 2553 17sep2018 |
238. | 238 1807 18sep2018 |
239. | 239 1347 19sep2018 |
240. | 240 1221 20sep2018 |
|---------------------------|
429. | 429 1247 28mar2019 |
476. | 476 1215 14may2019 |
505. | 505 1227 12jun2019 |
660. | 660 1630 14nov2019 |
661. | 661 2374 15nov2019 |
662. | 662 1585 16nov2019 |
663. | 663 1377 17nov2019 |
664. | 664 2783 18nov2019 |
665. | 665 3826 19nov2019 |
666. | 666 2584 20nov2019 |
667. | 667 4889 21nov2019 |
668. | 668 5515 22nov2019 |
669. | 669 1590 23nov2019 |
678. | 678 1465 02dec2019 |
+---------------------------+
- 2018: 42 (75%)
- 2019: 14 (25%)
- 2020: 0 (0%)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4005
Farewell o_e_l_e_o
|
|
February 09, 2020, 01:38:37 AM |
|
During the period from 24/1/2018 to 04/2/2020 (last 3 days dropped due to incomplete week, 2020w6 and an incomplete day - dayid = 745), the minimum and maximum of intra-day merit are 300 and 12676, on 04/8/2019 and 25/1/2018, respectively. List of the top 50-highest day in terms of intra-day merits: +-----------------------------------------------------------------------------+
| rank_max merit dayid date dofw week month year |
|-----------------------------------------------------------------------------|
1. | 1 12676 2 25jan2018 Thursday 2018w4 2018m1 2018 |
2. | 2 6348 3 26jan2018 Friday 2018w4 2018m1 2018 |
3. | 3 5515 668 22nov2019 Friday 2019w47 2019m11 2019 |
4. | 4 4889 667 21nov2019 Thursday 2019w47 2019m11 2019 |
5. | 5 4627 4 27jan2018 Saturday 2018w4 2018m1 2018 |
|-----------------------------------------------------------------------------|
6. | 6 4103 8 31jan2018 Wednesday 2018w5 2018m1 2018 |
7. | 7 3826 665 19nov2019 Tuesday 2019w47 2019m11 2019 |
8. | 8 3804 7 30jan2018 Tuesday 2018w5 2018m1 2018 |
9. | 9 3343 6 29jan2018 Monday 2018w5 2018m1 2018 |
10. | 10 3240 5 28jan2018 Sunday 2018w4 2018m1 2018 |
|-----------------------------------------------------------------------------|
11. | 11 2797 23 15feb2018 Thursday 2018w7 2018m2 2018 |
12. | 12 2793 9 01feb2018 Thursday 2018w5 2018m2 2018 |
13. | 13 2783 664 18nov2019 Monday 2019w46 2019m11 2019 |
14. | 14 2621 10 02feb2018 Friday 2018w5 2018m2 2018 |
15. | 15 2584 666 20nov2019 Wednesday 2019w47 2019m11 2019 |
|-----------------------------------------------------------------------------|
16. | 16 2553 237 17sep2018 Monday 2018w38 2018m9 2018 |
17. | 17 2476 11 03feb2018 Saturday 2018w5 2018m2 2018 |
18. | 18 2374 661 15nov2019 Friday 2019w46 2019m11 2019 |
19. | 19 2367 15 07feb2018 Wednesday 2018w6 2018m2 2018 |
20. | 20 2263 13 05feb2018 Monday 2018w6 2018m2 2018 |
|-----------------------------------------------------------------------------|
21. | 21 2223 17 09feb2018 Friday 2018w6 2018m2 2018 |
22. | 22 2059 16 08feb2018 Thursday 2018w6 2018m2 2018 |
23. | 23 2003 14 06feb2018 Tuesday 2018w6 2018m2 2018 |
24. | 24 1807 238 18sep2018 Tuesday 2018w38 2018m9 2018 |
25. | 25 1793 19 11feb2018 Sunday 2018w6 2018m2 2018 |
|-----------------------------------------------------------------------------|
26. | 26 1790 12 04feb2018 Sunday 2018w5 2018m2 2018 |
27. | 27 1740 24 16feb2018 Friday 2018w7 2018m2 2018 |
28. | 28 1727 39 03mar2018 Saturday 2018w9 2018m3 2018 |
29. | 29 1630 660 14nov2019 Thursday 2019w46 2019m11 2019 |
30. | 30 1590 669 23nov2019 Saturday 2019w47 2019m11 2019 |
|-----------------------------------------------------------------------------|
31. | 31 1589 26 18feb2018 Sunday 2018w7 2018m2 2018 |
32. | 32 1585 662 16nov2019 Saturday 2019w46 2019m11 2019 |
33. | 33 1580 22 14feb2018 Wednesday 2018w7 2018m2 2018 |
34. | 34 1475 20 12feb2018 Monday 2018w7 2018m2 2018 |
35. | 35 1465 678 02dec2019 Monday 2019w48 2019m12 2019 |
|-----------------------------------------------------------------------------|
36. | 36 1442 28 20feb2018 Tuesday 2018w8 2018m2 2018 |
37. | 37 1431 25 17feb2018 Saturday 2018w7 2018m2 2018 |
38. | 38 1414 35 27feb2018 Tuesday 2018w9 2018m2 2018 |
39. | 39 1390 57 21mar2018 Wednesday 2018w12 2018m3 2018 |
40. | 40 1377 663 17nov2019 Sunday 2019w46 2019m11 2019 |
|-----------------------------------------------------------------------------|
41. | 41 1372 33 25feb2018 Sunday 2018w8 2018m2 2018 |
42. | 42 1347 239 19sep2018 Wednesday 2018w38 2018m9 2018 |
43. | 43 1345 38 02mar2018 Friday 2018w9 2018m3 2018 |
44. | 44 1334 18 10feb2018 Saturday 2018w6 2018m2 2018 |
45. | 45 1316 49 13mar2018 Tuesday 2018w11 2018m3 2018 |
|-----------------------------------------------------------------------------|
46. | 46 1302 36 28feb2018 Wednesday 2018w9 2018m2 2018 |
47. | 47 1289 21 13feb2018 Tuesday 2018w7 2018m2 2018 |
48. | 48 1289 27 19feb2018 Monday 2018w8 2018m2 2018 |
49. | 49 1277 30 22feb2018 Thursday 2018w8 2018m2 2018 |
50. | 50 1249 31 23feb2018 Friday 2018w8 2018m2 2018 |
+-----------------------------------------------------------------------------+
List of the top 50-lowest days in terms of intra-day merits: +-----------------------------------------------------------------------------+
| rank_min merit dayid date dofw week month year |
|-----------------------------------------------------------------------------|
1. | 1 300 558 04aug2019 Sunday 2019w31 2019m8 2019 |
2. | 2 333 341 30dec2018 Sunday 2018w52 2018m12 2018 |
3. | 3 339 343 01jan2019 Tuesday 2019w1 2019m1 2019 |
4. | 4 347 299 18nov2018 Sunday 2018w46 2018m11 2018 |
5. | 5 347 330 19dec2018 Wednesday 2018w51 2018m12 2018 |
|-----------------------------------------------------------------------------|
6. | 6 351 334 23dec2018 Sunday 2018w51 2018m12 2018 |
7. | 7 366 218 29aug2018 Wednesday 2018w35 2018m8 2018 |
8. | 8 367 565 11aug2019 Sunday 2019w32 2019m8 2019 |
9. | 9 370 223 03sep2018 Monday 2018w36 2018m9 2018 |
10. | 10 373 339 28dec2018 Friday 2018w52 2018m12 2018 |
|-----------------------------------------------------------------------------|
11. | 11 375 340 29dec2018 Saturday 2018w52 2018m12 2018 |
12. | 12 377 600 15sep2019 Sunday 2019w37 2019m9 2019 |
13. | 13 378 566 12aug2019 Monday 2019w32 2019m8 2019 |
14. | 14 378 305 24nov2018 Saturday 2018w47 2018m11 2018 |
15. | 15 378 567 13aug2019 Tuesday 2019w33 2019m8 2019 |
|-----------------------------------------------------------------------------|
16. | 16 380 192 03aug2018 Friday 2018w31 2018m8 2018 |
17. | 17 381 336 25dec2018 Tuesday 2018w52 2018m12 2018 |
18. | 18 385 327 16dec2018 Sunday 2018w50 2018m12 2018 |
19. | 19 385 215 26aug2018 Sunday 2018w34 2018m8 2018 |
20. | 20 391 221 01sep2018 Saturday 2018w35 2018m9 2018 |
|-----------------------------------------------------------------------------|
21. | 21 394 188 30jul2018 Monday 2018w31 2018m7 2018 |
22. | 22 399 593 08sep2019 Sunday 2019w36 2019m9 2019 |
23. | 23 401 288 07nov2018 Wednesday 2018w45 2018m11 2018 |
24. | 24 401 557 03aug2019 Saturday 2019w31 2019m8 2019 |
25. | 25 402 263 13oct2018 Saturday 2018w41 2018m10 2018 |
|-----------------------------------------------------------------------------|
26. | 26 404 229 09sep2018 Sunday 2018w36 2018m9 2018 |
27. | 27 406 277 27oct2018 Saturday 2018w43 2018m10 2018 |
28. | 28 408 530 07jul2019 Sunday 2019w27 2019m7 2019 |
29. | 29 409 123 26may2018 Saturday 2018w21 2018m5 2018 |
30. | 30 409 589 04sep2019 Wednesday 2019w36 2019m9 2019 |
|-----------------------------------------------------------------------------|
31. | 31 410 279 29oct2018 Monday 2018w44 2018m10 2018 |
32. | 32 411 578 24aug2019 Saturday 2019w34 2019m8 2019 |
33. | 33 411 569 15aug2019 Thursday 2019w33 2019m8 2019 |
34. | 34 414 528 05jul2019 Friday 2019w27 2019m7 2019 |
35. | 35 421 193 04aug2018 Saturday 2018w31 2018m8 2018 |
|-----------------------------------------------------------------------------|
36. | 36 425 588 03sep2019 Tuesday 2019w36 2019m9 2019 |
37. | 37 426 346 04jan2019 Friday 2019w1 2019m1 2019 |
38. | 38 426 230 10sep2018 Monday 2018w37 2018m9 2018 |
39. | 39 427 141 13jun2018 Wednesday 2018w24 2018m6 2018 |
40. | 40 430 207 18aug2018 Saturday 2018w33 2018m8 2018 |
|-----------------------------------------------------------------------------|
41. | 41 432 587 02sep2019 Monday 2019w35 2019m9 2019 |
42. | 42 435 522 29jun2019 Saturday 2019w26 2019m6 2019 |
43. | 43 436 419 18mar2019 Monday 2019w11 2019m3 2019 |
44. | 44 440 559 05aug2019 Monday 2019w31 2019m8 2019 |
45. | 45 440 265 15oct2018 Monday 2018w42 2018m10 2018 |
|-----------------------------------------------------------------------------|
46. | 46 440 585 31aug2019 Saturday 2019w35 2019m8 2019 |
47. | 47 441 319 08dec2018 Saturday 2018w49 2018m12 2018 |
48. | 48 441 404 03mar2019 Sunday 2019w9 2019m3 2019 |
49. | 49 442 278 28oct2018 Sunday 2018w43 2018m10 2018 |
50. | 50 442 342 31dec2018 Monday 2018w52 2018m12 2018 |
+-----------------------------------------------------------------------------+
|
|
|
|
|
