tranthidung (OP)
Legendary
Online
Activity: 2268
Merit: 4004
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 | +---------------------------+
Distributions of outliers over years:- 2018: 46 (76.7%)
- 2019: 14 (23.3%)
- 2020: 0 (0%)
|
|
|
|
|
|
|
The grue lurks in the darkest places of the earth. Its favorite diet is adventurers, but its insatiable appetite is tempered by its fear of light. No grue has ever been seen by the light of day, and few have survived its fearsome jaws to tell the tale.
|
|
|
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
|
tranthidung (OP)
Legendary
Online
Activity: 2268
Merit: 4004
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
Online
Activity: 2268
Merit: 4004
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 -------------------------------------------------------------------------------------------
Box plotsOutliers 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
Online
Activity: 2268
Merit: 4004
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 | +-----------------+
Time series plotBasic statistics:- 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 ----------------------------------------------------------------------------------------------
Potential outliers:. 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
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
Online
Activity: 2268
Merit: 4004
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
Online
Activity: 2268
Merit: 4004
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
Online
Activity: 2268
Merit: 4004
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 | +---------------------------+
Distributions of outliers over years:- 2018: 43 (74.1%)
- 2019: 14 (24.1%)
- 2020: 1 (1.7%)
|
|
|
|
tranthidung (OP)
Legendary
Online
Activity: 2268
Merit: 4004
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
Online
Activity: 2268
Merit: 4004
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 -------------------------------------------------------------------------------------------
Box plotsOutliers 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
Online
Activity: 2268
Merit: 4004
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 | +-----------------+
Time series plotBasic statistics:- 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 ----------------------------------------------------------------------------------------------
Potential outliers:. 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
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
Online
Activity: 2268
Merit: 4004
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
Online
Activity: 2268
Merit: 4004
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
Online
Activity: 2268
Merit: 4004
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 | +---------------------------+
Distributions of outliers over years:- 2018: 42 (75%)
- 2019: 14 (25%)
- 2020: 0 (0%)
|
|
|
|
tranthidung (OP)
Legendary
Online
Activity: 2268
Merit: 4004
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
Online
Activity: 2268
Merit: 4004
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 -------------------------------------------------------------------------------------------
Box plotsOutliers 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
Online
Activity: 2268
Merit: 4004
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 | +-----------------+
Time series plotBasic statistics:- 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 ----------------------------------------------------------------------------------------------
Potential outliers:. 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
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
Online
Activity: 2268
Merit: 4004
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
Online
Activity: 2268
Merit: 4004
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
Online
Activity: 2268
Merit: 4004
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 | +---------------------------+
Distributions of outliers over years:- 2018: 42 (75%)
- 2019: 14 (25%)
- 2020: 0 (0%)
|
|
|
|
tranthidung (OP)
Legendary
Online
Activity: 2268
Merit: 4004
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 | +-----------------------------------------------------------------------------+
|
|
|
|
|