tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 09, 2019, 03:20:42 AM Last edit: December 09, 2019, 04:02:52 AM by tranthidung |
|
Time-series plots:Full dataset:Truncated dataset: Basic statistics (for full dataset): Since this week, I am going to use the full dataset for analysis. Because we have gone almost two years and the data has become bigger enough to self-adjust for its outliers. . tabstat merit, s(n mean sd p50 p25 p75 min max)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 680 789.0382 731.862 643.5 538 777.5 295 13018 ----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 179 or 1137. . di 777.5-538 239.5
. di 239.5*1.5 359.25
. di 777.5+359.25 1136.75
. di 538-359.25 178.75
There are 64 outliers (beyond 1137 or 179) in full dataset, in total. . count if (merit >= 1137 | merit <= 179) & merit != . 64
Those days are: . list id merit date if (merit >= 1137 | merit <= 179) & merit != .
+-------------------------+ | id merit date | |-------------------------| 1. | 1 13018 24jan2018 | 2. | 2 6762 25jan2018 | 3. | 3 4500 26jan2018 | 4. | 4 3490 27jan2018 | 5. | 5 3190 28jan2018 | |-------------------------| 6. | 6 3800 29jan2018 | 7. | 7 4193 30jan2018 | 8. | 8 2821 31jan2018 | 9. | 9 2546 01feb2018 | 10. | 10 2569 02feb2018 | |-------------------------| 11. | 11 1868 03feb2018 | 12. | 12 2182 04feb2018 | 13. | 13 2078 05feb2018 | 14. | 14 2310 06feb2018 | 15. | 15 2142 07feb2018 | |-------------------------| 16. | 16 2143 08feb2018 | 17. | 17 1449 09feb2018 | 18. | 18 1748 10feb2018 | 19. | 19 1443 11feb2018 | 20. | 20 1332 12feb2018 | |-------------------------| 21. | 21 1580 13feb2018 | 22. | 22 2514 14feb2018 | 23. | 23 1992 15feb2018 | 24. | 24 1416 16feb2018 | 25. | 25 1618 17feb2018 | |-------------------------| 26. | 26 1293 18feb2018 | 27. | 27 1404 19feb2018 | 28. | 28 1170 20feb2018 | 29. | 29 1268 21feb2018 | 30. | 30 1280 22feb2018 | |-------------------------| 32. | 32 1410 24feb2018 | 33. | 33 1187 25feb2018 | 34. | 34 1392 26feb2018 | 35. | 35 1327 27feb2018 | 37. | 37 1335 01mar2018 | |-------------------------| 38. | 38 1706 02mar2018 | 41. | 41 1246 05mar2018 | 48. | 48 1355 12mar2018 | 50. | 50 1160 14mar2018 | 56. | 56 1324 20mar2018 | |-------------------------| 57. | 57 1229 21mar2018 | 68. | 68 1258 01apr2018 | 69. | 69 1147 02apr2018 | 153. | 153 1139 25jun2018 | 236. | 236 2464 16sep2018 | |-------------------------| 237. | 237 1863 17sep2018 | 238. | 238 1295 18sep2018 | 239. | 239 1271 19sep2018 | 351. | 351 1162 09jan2019 | 428. | 428 1250 27mar2019 | |-------------------------| 475. | 475 1151 13may2019 | 504. | 504 1188 11jun2019 | 659. | 659 1476 13nov2019 | 660. | 660 2510 14nov2019 | 661. | 661 1542 15nov2019 | |-------------------------| 662. | 662 1441 16nov2019 | 663. | 663 2753 17nov2019 | 664. | 664 3854 18nov2019 | 665. | 665 2182 19nov2019 | 666. | 666 5275 20nov2019 | |-------------------------| 667. | 667 5412 21nov2019 | 668. | 668 1660 22nov2019 | 669. | 669 1153 23nov2019 | 677. | 677 1466 01dec2019 | +-------------------------+
Only 16 of them occured in 2019. See details in the list of outliers above.
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 09, 2019, 03:24:21 AM |
|
During the period from 24/1/2018 to 02/12/2019 (last two days dropped due to incomplete week), the minimum and maximum of intra-day merit are 295 and 13018, on 03/8/2019 and 24/1/2018, respectively. List of the top 50-highest day in terms of intra-day merits: . list merit id date dofw day month2 year week month
+-------------------------------------------------------------------------------+ | merit id date dofw day month2 year week month | |-------------------------------------------------------------------------------| 1. | 13018 1 24jan2018 Wednesday 24 1 2018 2018w4 2018m1 | 2. | 6762 2 25jan2018 Thursday 25 1 2018 2018w4 2018m1 | 3. | 5412 667 21nov2019 Thursday 21 11 2019 2019w47 2019m11 | 4. | 5275 666 20nov2019 Wednesday 20 11 2019 2019w47 2019m11 | 5. | 4500 3 26jan2018 Friday 26 1 2018 2018w4 2018m1 | |-------------------------------------------------------------------------------| 6. | 4193 7 30jan2018 Tuesday 30 1 2018 2018w5 2018m1 | 7. | 3854 664 18nov2019 Monday 18 11 2019 2019w46 2019m11 | 8. | 3800 6 29jan2018 Monday 29 1 2018 2018w5 2018m1 | 9. | 3490 4 27jan2018 Saturday 27 1 2018 2018w4 2018m1 | 10. | 3190 5 28jan2018 Sunday 28 1 2018 2018w4 2018m1 | |-------------------------------------------------------------------------------| 11. | 2821 8 31jan2018 Wednesday 31 1 2018 2018w5 2018m1 | 12. | 2753 663 17nov2019 Sunday 17 11 2019 2019w46 2019m11 | 13. | 2569 10 02feb2018 Friday 2 2 2018 2018w5 2018m2 | 14. | 2546 9 01feb2018 Thursday 1 2 2018 2018w5 2018m2 | 15. | 2514 22 14feb2018 Wednesday 14 2 2018 2018w7 2018m2 | |-------------------------------------------------------------------------------| 16. | 2510 660 14nov2019 Thursday 14 11 2019 2019w46 2019m11 | 17. | 2464 236 16sep2018 Sunday 16 9 2018 2018w37 2018m9 | 18. | 2310 14 06feb2018 Tuesday 6 2 2018 2018w6 2018m2 | 19. | 2182 665 19nov2019 Tuesday 19 11 2019 2019w47 2019m11 | 20. | 2182 12 04feb2018 Sunday 4 2 2018 2018w5 2018m2 | |-------------------------------------------------------------------------------| 21. | 2143 16 08feb2018 Thursday 8 2 2018 2018w6 2018m2 | 22. | 2142 15 07feb2018 Wednesday 7 2 2018 2018w6 2018m2 | 23. | 2078 13 05feb2018 Monday 5 2 2018 2018w6 2018m2 | 24. | 1992 23 15feb2018 Thursday 15 2 2018 2018w7 2018m2 | 25. | 1868 11 03feb2018 Saturday 3 2 2018 2018w5 2018m2 | |-------------------------------------------------------------------------------| 26. | 1863 237 17sep2018 Monday 17 9 2018 2018w38 2018m9 | 27. | 1748 18 10feb2018 Saturday 10 2 2018 2018w6 2018m2 | 28. | 1706 38 02mar2018 Friday 2 3 2018 2018w9 2018m3 | 29. | 1660 668 22nov2019 Friday 22 11 2019 2019w47 2019m11 | 30. | 1618 25 17feb2018 Saturday 17 2 2018 2018w7 2018m2 | |-------------------------------------------------------------------------------| 31. | 1580 21 13feb2018 Tuesday 13 2 2018 2018w7 2018m2 | 32. | 1542 661 15nov2019 Friday 15 11 2019 2019w46 2019m11 | 33. | 1476 659 13nov2019 Wednesday 13 11 2019 2019w46 2019m11 | 34. | 1466 677 01dec2019 Sunday 1 12 2019 2019w48 2019m12 | 35. | 1449 17 09feb2018 Friday 9 2 2018 2018w6 2018m2 | |-------------------------------------------------------------------------------| 36. | 1443 19 11feb2018 Sunday 11 2 2018 2018w6 2018m2 | 37. | 1441 662 16nov2019 Saturday 16 11 2019 2019w46 2019m11 | 38. | 1416 24 16feb2018 Friday 16 2 2018 2018w7 2018m2 | 39. | 1410 32 24feb2018 Saturday 24 2 2018 2018w8 2018m2 | 40. | 1404 27 19feb2018 Monday 19 2 2018 2018w8 2018m2 | |-------------------------------------------------------------------------------| 41. | 1392 34 26feb2018 Monday 26 2 2018 2018w9 2018m2 | 42. | 1355 48 12mar2018 Monday 12 3 2018 2018w11 2018m3 | 43. | 1335 37 01mar2018 Thursday 1 3 2018 2018w9 2018m3 | 44. | 1332 20 12feb2018 Monday 12 2 2018 2018w7 2018m2 | 45. | 1327 35 27feb2018 Tuesday 27 2 2018 2018w9 2018m2 | |-------------------------------------------------------------------------------| 46. | 1324 56 20mar2018 Tuesday 20 3 2018 2018w12 2018m3 | 47. | 1295 238 18sep2018 Tuesday 18 9 2018 2018w38 2018m9 | 48. | 1293 26 18feb2018 Sunday 18 2 2018 2018w7 2018m2 | 49. | 1280 30 22feb2018 Thursday 22 2 2018 2018w8 2018m2 | 50. | 1271 239 19sep2018 Wednesday 19 9 2018 2018w38 2018m9 |
List of the top 50-lowest days in terms of intra-day merits: . list merit id date dofw day month2 year week month
+-------------------------------------------------------------------------------+ | merit id date dofw day month2 year week month | |-------------------------------------------------------------------------------| 1. | 295 557 03aug2019 Saturday 3 8 2019 2019w31 2019m8 | 2. | 313 335 24dec2018 Monday 24 12 2018 2018w52 2018m12 | 3. | 317 333 22dec2018 Saturday 22 12 2018 2018w51 2018m12 | 4. | 328 564 10aug2019 Saturday 10 8 2019 2019w32 2019m8 | 5. | 344 340 29dec2018 Saturday 29 12 2018 2018w52 2018m12 | |-------------------------------------------------------------------------------| 6. | 348 298 17nov2018 Saturday 17 11 2018 2018w46 2018m11 | 7. | 348 338 27dec2018 Thursday 27 12 2018 2018w52 2018m12 | 8. | 349 304 23nov2018 Friday 23 11 2018 2018w47 2018m11 | 9. | 368 566 12aug2019 Monday 12 8 2019 2019w32 2019m8 | 10. | 371 122 25may2018 Friday 25 5 2018 2018w21 2018m5 | |-------------------------------------------------------------------------------| 11. | 377 191 02aug2018 Thursday 2 8 2018 2018w31 2018m8 | 12. | 377 342 31dec2018 Monday 31 12 2018 2018w52 2018m12 | 13. | 379 326 15dec2018 Saturday 15 12 2018 2018w50 2018m12 | 14. | 380 220 31aug2018 Friday 31 8 2018 2018w35 2018m8 | 15. | 382 599 14sep2019 Saturday 14 9 2019 2019w37 2019m9 | |-------------------------------------------------------------------------------| 16. | 384 217 28aug2018 Tuesday 28 8 2018 2018w35 2018m8 | 17. | 386 214 25aug2018 Saturday 25 8 2018 2018w34 2018m8 | 18. | 387 339 28dec2018 Friday 28 12 2018 2018w52 2018m12 | 19. | 394 568 14aug2019 Wednesday 14 8 2019 2019w33 2019m8 | 20. | 394 341 30dec2018 Sunday 30 12 2018 2018w52 2018m12 | |-------------------------------------------------------------------------------| 21. | 395 345 03jan2019 Thursday 3 1 2019 2019w1 2019m1 | 22. | 395 529 06jul2019 Saturday 6 7 2019 2019w27 2019m7 | 23. | 396 228 08sep2018 Saturday 8 9 2018 2018w36 2018m9 | 24. | 398 320 09dec2018 Sunday 9 12 2018 2018w49 2018m12 | 25. | 399 558 04aug2019 Sunday 4 8 2019 2019w31 2019m8 | |-------------------------------------------------------------------------------| 26. | 400 262 12oct2018 Friday 12 10 2018 2018w41 2018m10 | 27. | 403 329 18dec2018 Tuesday 18 12 2018 2018w51 2018m12 | 28. | 406 287 06nov2018 Tuesday 6 11 2018 2018w45 2018m11 | 29. | 407 556 02aug2019 Friday 2 8 2019 2019w31 2019m8 | 30. | 411 565 11aug2019 Sunday 11 8 2019 2019w32 2019m8 | |-------------------------------------------------------------------------------| 31. | 413 403 02mar2019 Saturday 2 3 2019 2019w9 2019m3 | 32. | 413 222 02sep2018 Sunday 2 9 2018 2018w35 2018m9 | 33. | 414 527 04jul2019 Thursday 4 7 2019 2019w27 2019m7 | 34. | 416 533 10jul2019 Wednesday 10 7 2019 2019w28 2019m7 | 35. | 416 278 28oct2018 Sunday 28 10 2018 2018w43 2018m10 | |-------------------------------------------------------------------------------| 36. | 416 588 03sep2019 Tuesday 3 9 2019 2019w36 2019m9 | 37. | 417 587 02sep2019 Monday 2 9 2019 2019w35 2019m9 | 38. | 417 109 12may2018 Saturday 12 5 2018 2018w19 2018m5 | 39. | 417 592 07sep2019 Saturday 7 9 2019 2019w36 2019m9 | 40. | 419 186 28jul2018 Saturday 28 7 2018 2018w30 2018m7 | |-------------------------------------------------------------------------------| 41. | 421 187 29jul2018 Sunday 29 7 2018 2018w30 2018m7 | 42. | 422 192 03aug2018 Friday 3 8 2018 2018w31 2018m8 | 43. | 425 276 26oct2018 Friday 26 10 2018 2018w43 2018m10 | 44. | 427 140 12jun2018 Tuesday 12 6 2018 2018w24 2018m6 | 45. | 427 277 27oct2018 Saturday 27 10 2018 2018w43 2018m10 | |-------------------------------------------------------------------------------| 46. | 429 313 02dec2018 Sunday 2 12 2018 2018w48 2018m12 | 47. | 429 418 17mar2019 Sunday 17 3 2019 2019w11 2019m3 | 48. | 431 284 03nov2018 Saturday 3 11 2018 2018w44 2018m11 | 49. | 431 264 14oct2018 Sunday 14 10 2018 2018w41 2018m10 | 50. | 433 208 19aug2018 Sunday 19 8 2018 2018w33 2018m8 |
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 09, 2019, 03:36:54 AM |
|
Medians and means of intra-day merits over days of weeks.Colors: - Green: highest.
- Red: Lowest.
- In median, the highest days are Monday, Thursday, and Wednesday at 685, 674, and 667, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 596, 614, and 625, respectively. - In means, the highest days are Wednesday, Thursday, and Monday at 932, 858, and 814, respectively; whilst the lowest days are Saturday, Friday, and Sunday, at 693, 709, and 753, respectively. Calendar day is in GMT time.To take away all doubt: the first Merit was this one: 1516831941 1 2818066.msg28853325 35 877396 Use EpochConverter to convert 1516831941 (Unix Time) to GMT: Wednesday 24 January 2018 22:12:21. Basic statistics:. tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f) by(dofw)
Summary for variables: merit by categories of: dofw
dofw | N mean sd p50 p25 p75 min max ----------+-------------------------------------------------------------------------------- Sunday | 97.0 752.7 460.0 625.0 517.0 789.0 394.0 3190.0 Monday | 97.0 813.5 526.5 685.0 574.0 825.0 313.0 3854.0 Tuesday | 97.0 765.6 464.7 660.0 592.0 761.0 384.0 4193.0 Wednesday | 98.0 931.4 1367.2 666.5 563.0 788.0 394.0 13018.0 Thursday | 97.0 857.1 855.0 674.0 550.0 805.0 348.0 6762.0 Friday | 97.0 708.6 504.6 596.0 510.0 713.0 349.0 4500.0 Saturday | 97.0 692.8 406.8 614.0 486.0 717.0 295.0 3490.0 ----------+-------------------------------------------------------------------------------- Total | 680.0 789.0 731.9 643.5 538.0 777.5 295.0 13018.0 -------------------------------------------------------------------------------------------
Box plotsOutliers displayed as red circles. Outliers non-displayed. Details on ranks:In medians +----------------------------------------------------------------------+ | rankmedian dofw median mean p25 p75 min max | |----------------------------------------------------------------------| 1. | 1 Monday 685 813.5051 574 825 313 3854 | 2. | 2 Thursday 674 857.0516 550 805 348 6762 | 3. | 3 Wednesday 666.5 931.449 563 788 394 13018 | 4. | 4 Tuesday 660 765.6288 592 761 384 4193 | 5. | 5 Sunday 625 752.6701 517 789 394 3190 | |----------------------------------------------------------------------| 6. | 6 Saturday 614 692.8453 486 717 295 3490 | 7. | 7 Friday 596 708.6495 510 713 349 4500 | +----------------------------------------------------------------------+
In means +--------------------------------------------------------------------+ | rankmean dofw mean median p25 p75 min max | |--------------------------------------------------------------------| 1. | 1 Wednesday 931.449 666.5 563 788 394 13018 | 2. | 2 Thursday 857.0516 674 550 805 348 6762 | 3. | 3 Monday 813.5051 685 574 825 313 3854 | 4. | 4 Tuesday 765.6288 660 592 761 384 4193 | 5. | 5 Sunday 752.6701 625 517 789 394 3190 | |--------------------------------------------------------------------| 6. | 6 Friday 708.6495 596 510 713 349 4500 | 7. | 7 Saturday 692.8453 614 486 717 295 3490 | +--------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 09, 2019, 03:44:07 AM Last edit: December 10, 2019, 01:17:53 AM by tranthidung |
|
Intra-week merits (from 24/1/2018 to 02/12/2019)Last two days dropped due to incomplete weeks (2019w49)Converted dataset:. list merit week
+-----------------+ | merit week | |-----------------| 1. | 30960 2018w4 | 2. | 19979 2018w5 | 3. | 13313 2018w6 | 4. | 11745 2018w7 | 5. | 8767 2018w8 | |-----------------| 6. | 8833 2018w9 | 7. | 7261 2018w10 | 8. | 7317 2018w11 | 9. | 6952 2018w12 | 10. | 6744 2018w13 | |-----------------| 11. | 6423 2018w14 | 12. | 5494 2018w15 | 13. | 4742 2018w16 | 14. | 4612 2018w17 | 15. | 4965 2018w18 | |-----------------| 16. | 4766 2018w19 | 17. | 4353 2018w20 | 18. | 3864 2018w21 | 19. | 4194 2018w22 | 20. | 4538 2018w23 | |-----------------| 21. | 3839 2018w24 | 22. | 4929 2018w25 | 23. | 4465 2018w26 | 24. | 4278 2018w27 | 25. | 4247 2018w28 | |-----------------| 26. | 4167 2018w29 | 27. | 3661 2018w30 | 28. | 3863 2018w31 | 29. | 4011 2018w32 | 30. | 3631 2018w33 | |-----------------| 31. | 3805 2018w34 | 32. | 3072 2018w35 | 33. | 3590 2018w36 | 34. | 5644 2018w37 | 35. | 7837 2018w38 | |-----------------| 36. | 4395 2018w39 | 37. | 4310 2018w40 | 38. | 3816 2018w41 | 39. | 4829 2018w42 | 40. | 3953 2018w43 | |-----------------| 41. | 3347 2018w44 | 42. | 4525 2018w45 | 43. | 3747 2018w46 | 44. | 4575 2018w47 | 45. | 3765 2018w48 | |-----------------| 46. | 3571 2018w49 | 47. | 3805 2018w50 | 48. | 3769 2018w51 | 49. | 3338 2018w52 | 50. | 4803 2019w1 | |-----------------| 51. | 6632 2019w2 | 52. | 5317 2019w3 | 53. | 4667 2019w4 | 54. | 4491 2019w5 | 55. | 4332 2019w6 | |-----------------| 56. | 4221 2019w7 | 57. | 4521 2019w8 | 58. | 4638 2019w9 | 59. | 4913 2019w10 | 60. | 4326 2019w11 | |-----------------| 61. | 4609 2019w12 | 62. | 6130 2019w13 | 63. | 4526 2019w14 | 64. | 5271 2019w15 | 65. | 4688 2019w16 | |-----------------| 66. | 4448 2019w17 | 67. | 4764 2019w18 | 68. | 5454 2019w19 | 69. | 5214 2019w20 | 70. | 4580 2019w21 | |-----------------| 71. | 4445 2019w22 | 72. | 4687 2019w23 | 73. | 5354 2019w24 | 74. | 4726 2019w25 | 75. | 4367 2019w26 | |-----------------| 76. | 4225 2019w27 | 77. | 4119 2019w28 | 78. | 4277 2019w29 | 79. | 4176 2019w30 | 80. | 3549 2019w31 | |-----------------| 81. | 3207 2019w32 | 82. | 4236 2019w33 | 83. | 3622 2019w34 | 84. | 3540 2019w35 | 85. | 3809 2019w36 | |-----------------| 86. | 4043 2019w37 | 87. | 4520 2019w38 | 88. | 4318 2019w39 | 89. | 4357 2019w40 | 90. | 4565 2019w41 | |-----------------| 91. | 5542 2019w42 | 92. | 4975 2019w43 | 93. | 4730 2019w44 | 94. | 4735 2019w45 | 95. | 14251 2019w46 | |-----------------| 96. | 17685 2019w47 | 97. | 5907 2019w48 | +-----------------+
Time series plotBasic statistics:- 50% of observed weeks ( 97 weeks) have total intra-week merits above 4525, whilst the rest 50% of them have total intra-week merits below 4525. 4525 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 4119 to 5214 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3072 - 30960. . tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 97.0 5516.7 3754.4 4525.0 4119.0 5214.0 3072.0 30960.0 ----------------------------------------------------------------------------------------------
Potential outliers:. di 5214-4119 1095
. di 1095*1.5 1642.5
. di 5214+1642.5 6856.5
. di 4119-1642.5 2476.5
It means that potential outliers are weeks that have intra-week merits beyond 2477 or 6857. How many weeks are potential outliers? . count if (merit >= 6857 | merit < 2477) & merit != . 12
12 weeks are outliers, in total. List of those 12 weeks: . list merit week if merit >= 6857 | merit <= 2477
+-----------------+ | merit week | |-----------------| 1. | 30960 2018w4 | 2. | 19979 2018w5 | 3. | 13313 2018w6 | 4. | 11745 2018w7 | 5. | 8767 2018w8 | |-----------------| 6. | 8833 2018w9 | 7. | 7261 2018w10 | 8. | 7317 2018w11 | 9. | 6952 2018w12 | 35. | 7837 2018w38 | |-----------------| 95. | 14251 2019w46 | 96. | 17685 2019w47 | +-----------------+
Most of them occured in the year 2018, and there is only two outliers week occured in 2019, in 2019w46 (14251), 2019w47 ( 17685). List of weeks in descending weekly merits. list weeklyrank merit week, abb(30)
+------------------------------+ | weeklyrank merit week | |------------------------------| 1. | 1 30960 2018w4 | 2. | 2 19979 2018w5 | 3. | 3 17685 2019w47 | 4. | 4 14251 2019w46 | 5. | 5 13313 2018w6 | |------------------------------| 6. | 6 11745 2018w7 | 7. | 7 8833 2018w9 | 8. | 8 8767 2018w8 | 9. | 9 7837 2018w38 | 10. | 10 7317 2018w11 | |------------------------------| 11. | 11 7261 2018w10 | 12. | 12 6952 2018w12 | 13. | 13 6744 2018w13 | 14. | 14 6632 2019w2 | 15. | 15 6423 2018w14 | |------------------------------| 16. | 16 6130 2019w13 | 17. | 17 5907 2019w48 | 18. | 18 5644 2018w37 | 19. | 19 5542 2019w42 | 20. | 20 5494 2018w15 | |------------------------------| 21. | 21 5454 2019w19 | 22. | 22 5354 2019w24 | 23. | 23 5317 2019w3 | 24. | 24 5271 2019w15 | 25. | 25 5214 2019w20 | |------------------------------| 26. | 26 4975 2019w43 | 27. | 27 4965 2018w18 | 28. | 28 4929 2018w25 | 29. | 29 4913 2019w10 | 30. | 30 4829 2018w42 | |------------------------------| 31. | 31 4803 2019w1 | 32. | 32 4766 2018w19 | 33. | 33 4764 2019w18 | 34. | 34 4742 2018w16 | 35. | 35 4735 2019w45 | |------------------------------| 36. | 36 4730 2019w44 | 37. | 37 4726 2019w25 | 38. | 38 4688 2019w16 | 39. | 39 4687 2019w23 | 40. | 40 4667 2019w4 | |------------------------------| 41. | 41 4638 2019w9 | 42. | 42 4612 2018w17 | 43. | 43 4609 2019w12 | 44. | 44 4580 2019w21 | 45. | 45 4575 2018w47 | |------------------------------| 46. | 46 4565 2019w41 | 47. | 47 4538 2018w23 | 48. | 48 4526 2019w14 | 49. | 49 4525 2018w45 | 50. | 50 4521 2019w8 | |------------------------------| 51. | 51 4520 2019w38 | 52. | 52 4491 2019w5 | 53. | 53 4465 2018w26 | 54. | 54 4448 2019w17 | 55. | 55 4445 2019w22 | |------------------------------| 56. | 56 4395 2018w39 | 57. | 57 4367 2019w26 | 58. | 58 4357 2019w40 | 59. | 59 4353 2018w20 | 60. | 60 4332 2019w6 | |------------------------------| 61. | 61 4326 2019w11 | 62. | 62 4318 2019w39 | 63. | 63 4310 2018w40 | 64. | 64 4278 2018w27 | 65. | 65 4277 2019w29 | |------------------------------| 66. | 66 4247 2018w28 | 67. | 67 4236 2019w33 | 68. | 68 4225 2019w27 | 69. | 69 4221 2019w7 | 70. | 70 4194 2018w22 | |------------------------------| 71. | 71 4176 2019w30 | 72. | 72 4167 2018w29 | 73. | 73 4119 2019w28 | 74. | 74 4043 2019w37 | 75. | 75 4011 2018w32 | |------------------------------| 76. | 76 3953 2018w43 | 77. | 77 3864 2018w21 | 78. | 78 3863 2018w31 | 79. | 79 3839 2018w24 | 80. | 80 3816 2018w41 | |------------------------------| 81. | 81 3809 2019w36 | 82. | 82 3805 2018w34 | 83. | 83 3805 2018w50 | 84. | 84 3769 2018w51 | 85. | 85 3765 2018w48 | |------------------------------| 86. | 86 3747 2018w46 | 87. | 87 3661 2018w30 | 88. | 88 3631 2018w33 | 89. | 89 3622 2019w34 | 90. | 90 3590 2018w36 | |------------------------------| 91. | 91 3571 2018w49 | 92. | 92 3549 2019w31 | 93. | 93 3540 2019w35 | 94. | 94 3347 2018w44 | 95. | 95 3338 2018w52 | |------------------------------| 96. | 96 3207 2019w32 | 97. | 97 3072 2018w35 | +------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 09, 2019, 03:55:21 AM |
|
Intra-month merits (from 24/1/2018 to 30/11/2019)There are days dropped in order to get data for entire month. Days with id > 676 dropped because those days belong to the incomplete December (2019m12).Converted dataset:. list merit month
+-----------------+ | merit month | |-----------------| 1. | 41774 2018m1 | 2. | 46701 2018m2 | 3. | 32138 2018m3 | 4. | 23354 2018m4 | 5. | 19644 2018m5 | |-----------------| 6. | 18802 2018m6 | 7. | 18149 2018m7 | 8. | 16382 2018m8 | 9. | 22312 2018m9 | 10. | 18470 2018m10 | |-----------------| 11. | 17437 2018m11 | 12. | 15443 2018m12 | 13. | 22994 2019m1 | 14. | 17989 2019m2 | 15. | 21629 2019m3 | |-----------------| 16. | 20545 2019m4 | 17. | 22068 2019m5 | 18. | 20408 2019m6 | 19. | 18413 2019m7 | 20. | 16163 2019m8 | |-----------------| 21. | 17556 2019m9 | 22. | 21590 2019m10 | 23. | 42976 2019m11 | +-----------------+
Time series plotBasic statistics:- 50% of observed months ( 23 months) have total intra-month merits above 20408, whilst the rest 50% of them have total intra-month merits below 20408. 20408 is the median - p50. - 50% of observed months have total intra-month merits fluctuated in the range from 17989 to 22994 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 15443- 46701. . tabstat merit, s(n mean sd p50 p25 p75 min max)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 23 23171.17 8897.076 20408 17989 22994 15443 46701 ----------------------------------------------------------------------------------------------
Potential outliers:. di 22994-17989 5005
. di 5005*1.5 7507.5
. di 22994+7507.5 30501.5
. di 17989-7507.5 10481.5
It means that potential outliers are months that have intra-month merits beyond 10482 or 30502. How many months are potential outliers? . count if (merit >= 30502 | merit <= 10482) & merit != . 4
4 months are outliers, in total. List of those four months: . list merit month if (merit >= 30502 | merit <= 10482) & merit != .
+-----------------+ | merit month | |-----------------| 1. | 41774 2018m1 | 2. | 46701 2018m2 | 3. | 32138 2018m3 | 23. | 42976 2019m11 | +-----------------+
Most of them occured in the year 2018, during the first three months after merit system activated. Only one outlier month detected in 2019, that is 2019m11 (the last month) at 42976. It will make all of you surprised that the total merits distributed over the last month is the second highest in monthly merit.
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 09, 2019, 04:13:44 AM |
|
ABSTRACTData is the full dataset since 24/1/2018, and only dropped days belong to incomplete week or incomplete month. Details on days dropped, please see above posts. Intra-day merits:(1) Potential outliers are days that have intraday total merits beyond 179 or 1137; (2) Median of intraday merits over the period is 644; (3) 50% of observed days have their intra-day merits range from 538 to 778 (the interquartile range); (4) In GTM time. In medians, the highest and lowest days are Monday and Friday, respectively; whilst the highest and lowest days in means are Wednesday and Saturday, respectively. (5) There are 64 potential outliers (beyond 179 or 1137) in total, and only 16 of them occured in 2019. ( see details). (6) Minimum and maximum of intraday merits (full dataset) are 295, and 13018, on 03/8/2019 and 24/1/2018, respectively. Intra-week merits:97 weeks in total. (1) The median of intra-week merits is 4525; (2) 50% of observed weeks ( 97 weeks in total), have total merits in the range from 4119 to 5214 (the interquartile range of intra-week merits). (3) Minimum and maximum of intra-week merits are 3072 and 30960, in 2018w35, and 2018w4, respectively; (4) 12 potential outliers [beyond 2477 or 6857], only 2 of them occurred in the year 2019, on 2019w46 ( 14251), and 2019w47 ( 17685). Intra-month merits:23 months in total. (1) The median of intra-month merits is 20408; (2) 50% of observed month ( 23 months in total), have total merits in the range from 17989 to 22994 (the interquartile range of intra-month merits). (3) Minimum and maximum of intra-month merits are 15443 and 46701, in 2018m12, and 2018m2, respectively; (4) 4 potential outliers [beyond 10482 or 30502], only 1 of them occurred in the year 2019, in 2019m11 ( 42976).
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 14, 2019, 05:13:53 PM |
|
Update:Data source: http://loyce.club/Merit/tranthidung/meritperdayandweek.2019-12-14_Sat_08.08h.txtConverted intra-day merits for days in 2019: +-------------------------------------------------------------------------------+ | id merit date day month2 year week month dofw | |-------------------------------------------------------------------------------| 343. | 343 604 01jan2019 1 1 2019 2019w1 2019m1 Tuesday | 344. | 344 530 02jan2019 2 1 2019 2019w1 2019m1 Wednesday | 345. | 345 395 03jan2019 3 1 2019 2019w1 2019m1 Thursday | 346. | 346 1083 04jan2019 4 1 2019 2019w1 2019m1 Friday | 347. | 347 836 05jan2019 5 1 2019 2019w1 2019m1 Saturday | |-------------------------------------------------------------------------------| 348. | 348 784 06jan2019 6 1 2019 2019w1 2019m1 Sunday | 349. | 349 571 07jan2019 7 1 2019 2019w1 2019m1 Monday | 350. | 350 783 08jan2019 8 1 2019 2019w2 2019m1 Tuesday | 351. | 351 1162 09jan2019 9 1 2019 2019w2 2019m1 Wednesday | 352. | 352 988 10jan2019 10 1 2019 2019w2 2019m1 Thursday | |-------------------------------------------------------------------------------| 353. | 353 879 11jan2019 11 1 2019 2019w2 2019m1 Friday | 354. | 354 713 12jan2019 12 1 2019 2019w2 2019m1 Saturday | 355. | 355 979 13jan2019 13 1 2019 2019w2 2019m1 Sunday | 356. | 356 1128 14jan2019 14 1 2019 2019w2 2019m1 Monday | 357. | 357 818 15jan2019 15 1 2019 2019w3 2019m1 Tuesday | |-------------------------------------------------------------------------------| 358. | 358 881 16jan2019 16 1 2019 2019w3 2019m1 Wednesday | 359. | 359 1019 17jan2019 17 1 2019 2019w3 2019m1 Thursday | 360. | 360 612 18jan2019 18 1 2019 2019w3 2019m1 Friday | 361. | 361 644 19jan2019 19 1 2019 2019w3 2019m1 Saturday | 362. | 362 659 20jan2019 20 1 2019 2019w3 2019m1 Sunday | |-------------------------------------------------------------------------------| 363. | 363 684 21jan2019 21 1 2019 2019w3 2019m1 Monday | 364. | 364 619 22jan2019 22 1 2019 2019w4 2019m1 Tuesday | 365. | 365 737 23jan2019 23 1 2019 2019w4 2019m1 Wednesday | 366. | 366 716 24jan2019 24 1 2019 2019w4 2019m1 Thursday | 367. | 367 616 25jan2019 25 1 2019 2019w4 2019m1 Friday | |-------------------------------------------------------------------------------| 368. | 368 588 26jan2019 26 1 2019 2019w4 2019m1 Saturday | 369. | 369 656 27jan2019 27 1 2019 2019w4 2019m1 Sunday | 370. | 370 735 28jan2019 28 1 2019 2019w4 2019m1 Monday | 371. | 371 613 29jan2019 29 1 2019 2019w5 2019m1 Tuesday | 372. | 372 511 30jan2019 30 1 2019 2019w5 2019m1 Wednesday | |-------------------------------------------------------------------------------| 373. | 373 451 31jan2019 31 1 2019 2019w5 2019m1 Thursday | 374. | 374 596 01feb2019 1 2 2019 2019w5 2019m2 Friday | 375. | 375 942 02feb2019 2 2 2019 2019w5 2019m2 Saturday | 376. | 376 581 03feb2019 3 2 2019 2019w5 2019m2 Sunday | 377. | 377 797 04feb2019 4 2 2019 2019w5 2019m2 Monday | |-------------------------------------------------------------------------------| 378. | 378 780 05feb2019 5 2 2019 2019w6 2019m2 Tuesday | 379. | 379 560 06feb2019 6 2 2019 2019w6 2019m2 Wednesday | 380. | 380 549 07feb2019 7 2 2019 2019w6 2019m2 Thursday | 381. | 381 612 08feb2019 8 2 2019 2019w6 2019m2 Friday | 382. | 382 624 09feb2019 9 2 2019 2019w6 2019m2 Saturday | |-------------------------------------------------------------------------------| 383. | 383 560 10feb2019 10 2 2019 2019w6 2019m2 Sunday | 384. | 384 647 11feb2019 11 2 2019 2019w6 2019m2 Monday | 385. | 385 586 12feb2019 12 2 2019 2019w7 2019m2 Tuesday | 386. | 386 675 13feb2019 13 2 2019 2019w7 2019m2 Wednesday | 387. | 387 650 14feb2019 14 2 2019 2019w7 2019m2 Thursday | |-------------------------------------------------------------------------------| 388. | 388 611 15feb2019 15 2 2019 2019w7 2019m2 Friday | 389. | 389 525 16feb2019 16 2 2019 2019w7 2019m2 Saturday | 390. | 390 608 17feb2019 17 2 2019 2019w7 2019m2 Sunday | 391. | 391 566 18feb2019 18 2 2019 2019w7 2019m2 Monday | 392. | 392 638 19feb2019 19 2 2019 2019w8 2019m2 Tuesday | |-------------------------------------------------------------------------------| 393. | 393 698 20feb2019 20 2 2019 2019w8 2019m2 Wednesday | 394. | 394 505 21feb2019 21 2 2019 2019w8 2019m2 Thursday | 395. | 395 510 22feb2019 22 2 2019 2019w8 2019m2 Friday | 396. | 396 661 23feb2019 23 2 2019 2019w8 2019m2 Saturday | 397. | 397 609 24feb2019 24 2 2019 2019w8 2019m2 Sunday | |-------------------------------------------------------------------------------| 398. | 398 900 25feb2019 25 2 2019 2019w8 2019m2 Monday | 399. | 399 737 26feb2019 26 2 2019 2019w9 2019m2 Tuesday | 400. | 400 554 27feb2019 27 2 2019 2019w9 2019m2 Wednesday | 401. | 401 708 28feb2019 28 2 2019 2019w9 2019m2 Thursday | 402. | 402 510 01mar2019 1 3 2019 2019w9 2019m3 Friday | |-------------------------------------------------------------------------------| 403. | 403 413 02mar2019 2 3 2019 2019w9 2019m3 Saturday | 404. | 404 1003 03mar2019 3 3 2019 2019w9 2019m3 Sunday | 405. | 405 713 04mar2019 4 3 2019 2019w9 2019m3 Monday | 406. | 406 681 05mar2019 5 3 2019 2019w10 2019m3 Tuesday | 407. | 407 788 06mar2019 6 3 2019 2019w10 2019m3 Wednesday | |-------------------------------------------------------------------------------| 408. | 408 714 07mar2019 7 3 2019 2019w10 2019m3 Thursday | 409. | 409 713 08mar2019 8 3 2019 2019w10 2019m3 Friday | 410. | 410 724 09mar2019 9 3 2019 2019w10 2019m3 Saturday | 411. | 411 657 10mar2019 10 3 2019 2019w10 2019m3 Sunday | 412. | 412 636 11mar2019 11 3 2019 2019w10 2019m3 Monday | |-------------------------------------------------------------------------------| 413. | 413 681 12mar2019 12 3 2019 2019w11 2019m3 Tuesday | 414. | 414 689 13mar2019 13 3 2019 2019w11 2019m3 Wednesday | 415. | 415 805 14mar2019 14 3 2019 2019w11 2019m3 Thursday | 416. | 416 581 15mar2019 15 3 2019 2019w11 2019m3 Friday | 417. | 417 483 16mar2019 16 3 2019 2019w11 2019m3 Saturday | |-------------------------------------------------------------------------------| 418. | 418 429 17mar2019 17 3 2019 2019w11 2019m3 Sunday | 419. | 419 658 18mar2019 18 3 2019 2019w11 2019m3 Monday | 420. | 420 759 19mar2019 19 3 2019 2019w12 2019m3 Tuesday | 421. | 421 652 20mar2019 20 3 2019 2019w12 2019m3 Wednesday | 422. | 422 721 21mar2019 21 3 2019 2019w12 2019m3 Thursday | |-------------------------------------------------------------------------------| 423. | 423 676 22mar2019 22 3 2019 2019w12 2019m3 Friday | 424. | 424 626 23mar2019 23 3 2019 2019w12 2019m3 Saturday | 425. | 425 596 24mar2019 24 3 2019 2019w12 2019m3 Sunday | 426. | 426 579 25mar2019 25 3 2019 2019w12 2019m3 Monday | 427. | 427 727 26mar2019 26 3 2019 2019w13 2019m3 Tuesday | |-------------------------------------------------------------------------------| 428. | 428 1250 27mar2019 27 3 2019 2019w13 2019m3 Wednesday | 429. | 429 928 28mar2019 28 3 2019 2019w13 2019m3 Thursday | 430. | 430 729 29mar2019 29 3 2019 2019w13 2019m3 Friday | 431. | 431 656 30mar2019 30 3 2019 2019w13 2019m3 Saturday | 432. | 432 852 31mar2019 31 3 2019 2019w13 2019m3 Sunday | |-------------------------------------------------------------------------------| 433. | 433 988 01apr2019 1 4 2019 2019w13 2019m4 Monday | 434. | 434 701 02apr2019 2 4 2019 2019w14 2019m4 Tuesday | 435. | 435 617 03apr2019 3 4 2019 2019w14 2019m4 Wednesday | 436. | 436 533 04apr2019 4 4 2019 2019w14 2019m4 Thursday | 437. | 437 617 05apr2019 5 4 2019 2019w14 2019m4 Friday | |-------------------------------------------------------------------------------| 438. | 438 620 06apr2019 6 4 2019 2019w14 2019m4 Saturday | 439. | 439 729 07apr2019 7 4 2019 2019w14 2019m4 Sunday | 440. | 440 709 08apr2019 8 4 2019 2019w14 2019m4 Monday | 441. | 441 708 09apr2019 9 4 2019 2019w15 2019m4 Tuesday | 442. | 442 742 10apr2019 10 4 2019 2019w15 2019m4 Wednesday | |-------------------------------------------------------------------------------| 443. | 443 909 11apr2019 11 4 2019 2019w15 2019m4 Thursday | 444. | 444 613 12apr2019 12 4 2019 2019w15 2019m4 Friday | 445. | 445 791 13apr2019 13 4 2019 2019w15 2019m4 Saturday | 446. | 446 770 14apr2019 14 4 2019 2019w15 2019m4 Sunday | 447. | 447 738 15apr2019 15 4 2019 2019w15 2019m4 Monday | |-------------------------------------------------------------------------------| 448. | 448 678 16apr2019 16 4 2019 2019w16 2019m4 Tuesday | 449. | 449 629 17apr2019 17 4 2019 2019w16 2019m4 Wednesday | 450. | 450 785 18apr2019 18 4 2019 2019w16 2019m4 Thursday | 451. | 451 609 19apr2019 19 4 2019 2019w16 2019m4 Friday | 452. | 452 663 20apr2019 20 4 2019 2019w16 2019m4 Saturday | |-------------------------------------------------------------------------------| 453. | 453 777 21apr2019 21 4 2019 2019w16 2019m4 Sunday | 454. | 454 547 22apr2019 22 4 2019 2019w16 2019m4 Monday | 455. | 455 525 23apr2019 23 4 2019 2019w17 2019m4 Tuesday | 456. | 456 535 24apr2019 24 4 2019 2019w17 2019m4 Wednesday | 457. | 457 930 25apr2019 25 4 2019 2019w17 2019m4 Thursday | |-------------------------------------------------------------------------------| 458. | 458 651 26apr2019 26 4 2019 2019w17 2019m4 Friday | 459. | 459 478 27apr2019 27 4 2019 2019w17 2019m4 Saturday | 460. | 460 598 28apr2019 28 4 2019 2019w17 2019m4 Sunday | 461. | 461 731 29apr2019 29 4 2019 2019w17 2019m4 Monday | 462. | 462 624 30apr2019 30 4 2019 2019w18 2019m4 Tuesday | |-------------------------------------------------------------------------------| 463. | 463 589 01may2019 1 5 2019 2019w18 2019m5 Wednesday | 464. | 464 550 02may2019 2 5 2019 2019w18 2019m5 Thursday | 465. | 465 523 03may2019 3 5 2019 2019w18 2019m5 Friday | 466. | 466 919 04may2019 4 5 2019 2019w18 2019m5 Saturday | 467. | 467 864 05may2019 5 5 2019 2019w18 2019m5 Sunday | |-------------------------------------------------------------------------------| 468. | 468 695 06may2019 6 5 2019 2019w18 2019m5 Monday | 469. | 469 734 07may2019 7 5 2019 2019w19 2019m5 Tuesday | 470. | 470 755 08may2019 8 5 2019 2019w19 2019m5 Wednesday | 471. | 471 892 09may2019 9 5 2019 2019w19 2019m5 Thursday | 472. | 472 702 10may2019 10 5 2019 2019w19 2019m5 Friday | |-------------------------------------------------------------------------------| 473. | 473 593 11may2019 11 5 2019 2019w19 2019m5 Saturday | 474. | 474 627 12may2019 12 5 2019 2019w19 2019m5 Sunday | 475. | 475 1151 13may2019 13 5 2019 2019w19 2019m5 Monday | 476. | 476 913 14may2019 14 5 2019 2019w20 2019m5 Tuesday | 477. | 477 845 15may2019 15 5 2019 2019w20 2019m5 Wednesday | |-------------------------------------------------------------------------------| 478. | 478 752 16may2019 16 5 2019 2019w20 2019m5 Thursday | 479. | 479 643 17may2019 17 5 2019 2019w20 2019m5 Friday | 480. | 480 612 18may2019 18 5 2019 2019w20 2019m5 Saturday | 481. | 481 647 19may2019 19 5 2019 2019w20 2019m5 Sunday | 482. | 482 802 20may2019 20 5 2019 2019w20 2019m5 Monday | |-------------------------------------------------------------------------------| 483. | 483 730 21may2019 21 5 2019 2019w21 2019m5 Tuesday | 484. | 484 823 22may2019 22 5 2019 2019w21 2019m5 Wednesday | 485. | 485 673 23may2019 23 5 2019 2019w21 2019m5 Thursday | 486. | 486 627 24may2019 24 5 2019 2019w21 2019m5 Friday | 487. | 487 513 25may2019 25 5 2019 2019w21 2019m5 Saturday | |-------------------------------------------------------------------------------| 488. | 488 552 26may2019 26 5 2019 2019w21 2019m5 Sunday | 489. | 489 662 27may2019 27 5 2019 2019w21 2019m5 Monday | 490. | 490 592 28may2019 28 5 2019 2019w22 2019m5 Tuesday | 491. | 491 729 29may2019 29 5 2019 2019w22 2019m5 Wednesday | 492. | 492 733 30may2019 30 5 2019 2019w22 2019m5 Thursday | |-------------------------------------------------------------------------------| 493. | 493 626 31may2019 31 5 2019 2019w22 2019m5 Friday | 494. | 494 639 01jun2019 1 6 2019 2019w22 2019m6 Saturday | 495. | 495 475 02jun2019 2 6 2019 2019w22 2019m6 Sunday | 496. | 496 651 03jun2019 3 6 2019 2019w22 2019m6 Monday | 497. | 497 675 04jun2019 4 6 2019 2019w23 2019m6 Tuesday | |-------------------------------------------------------------------------------| 498. | 498 489 05jun2019 5 6 2019 2019w23 2019m6 Wednesday | 499. | 499 634 06jun2019 6 6 2019 2019w23 2019m6 Thursday | 500. | 500 587 07jun2019 7 6 2019 2019w23 2019m6 Friday | 501. | 501 994 08jun2019 8 6 2019 2019w23 2019m6 Saturday | 502. | 502 517 09jun2019 9 6 2019 2019w23 2019m6 Sunday | |-------------------------------------------------------------------------------| 503. | 503 791 10jun2019 10 6 2019 2019w23 2019m6 Monday | 504. | 504 1188 11jun2019 11 6 2019 2019w24 2019m6 Tuesday | 505. | 505 792 12jun2019 12 6 2019 2019w24 2019m6 Wednesday | 506. | 506 654 13jun2019 13 6 2019 2019w24 2019m6 Thursday | 507. | 507 538 14jun2019 14 6 2019 2019w24 2019m6 Friday | |-------------------------------------------------------------------------------| 508. | 508 778 15jun2019 15 6 2019 2019w24 2019m6 Saturday | 509. | 509 692 16jun2019 16 6 2019 2019w24 2019m6 Sunday | 510. | 510 712 17jun2019 17 6 2019 2019w24 2019m6 Monday | 511. | 511 660 18jun2019 18 6 2019 2019w25 2019m6 Tuesday | 512. | 512 673 19jun2019 19 6 2019 2019w25 2019m6 Wednesday | |-------------------------------------------------------------------------------| 513. | 513 761 20jun2019 20 6 2019 2019w25 2019m6 Thursday | 514. | 514 618 21jun2019 21 6 2019 2019w25 2019m6 Friday | 515. | 515 545 22jun2019 22 6 2019 2019w25 2019m6 Saturday | 516. | 516 490 23jun2019 23 6 2019 2019w25 2019m6 Sunday | 517. | 517 979 24jun2019 24 6 2019 2019w25 2019m6 Monday | |-------------------------------------------------------------------------------| 518. | 518 844 25jun2019 25 6 2019 2019w26 2019m6 Tuesday | 519. | 519 769 26jun2019 26 6 2019 2019w26 2019m6 Wednesday | 520. | 520 755 27jun2019 27 6 2019 2019w26 2019m6 Thursday | 521. | 521 442 28jun2019 28 6 2019 2019w26 2019m6 Friday | 522. | 522 486 29jun2019 29 6 2019 2019w26 2019m6 Saturday | |-------------------------------------------------------------------------------| 523. | 523 580 30jun2019 30 6 2019 2019w26 2019m6 Sunday | 524. | 524 491 01jul2019 1 7 2019 2019w26 2019m7 Monday | 525. | 525 723 02jul2019 2 7 2019 2019w27 2019m7 Tuesday | 526. | 526 617 03jul2019 3 7 2019 2019w27 2019m7 Wednesday | 527. | 527 414 04jul2019 4 7 2019 2019w27 2019m7 Thursday | |-------------------------------------------------------------------------------| 528. | 528 522 05jul2019 5 7 2019 2019w27 2019m7 Friday | 529. | 529 395 06jul2019 6 7 2019 2019w27 2019m7 Saturday | 530. | 530 689 07jul2019 7 7 2019 2019w27 2019m7 Sunday | 531. | 531 865 08jul2019 8 7 2019 2019w27 2019m7 Monday | 532. | 532 688 09jul2019 9 7 2019 2019w28 2019m7 Tuesday | |-------------------------------------------------------------------------------| 533. | 533 416 10jul2019 10 7 2019 2019w28 2019m7 Wednesday | 534. | 534 811 11jul2019 11 7 2019 2019w28 2019m7 Thursday | 535. | 535 528 12jul2019 12 7 2019 2019w28 2019m7 Friday | 536. | 536 604 13jul2019 13 7 2019 2019w28 2019m7 Saturday | 537. | 537 559 14jul2019 14 7 2019 2019w28 2019m7 Sunday | |-------------------------------------------------------------------------------| 538. | 538 513 15jul2019 15 7 2019 2019w28 2019m7 Monday | 539. | 539 622 16jul2019 16 7 2019 2019w29 2019m7 Tuesday | 540. | 540 666 17jul2019 17 7 2019 2019w29 2019m7 Wednesday | 541. | 541 696 18jul2019 18 7 2019 2019w29 2019m7 Thursday | 542. | 542 487 19jul2019 19 7 2019 2019w29 2019m7 Friday | |-------------------------------------------------------------------------------| 543. | 543 538 20jul2019 20 7 2019 2019w29 2019m7 Saturday | 544. | 544 487 21jul2019 21 7 2019 2019w29 2019m7 Sunday | 545. | 545 781 22jul2019 22 7 2019 2019w29 2019m7 Monday | 546. | 546 495 23jul2019 23 7 2019 2019w30 2019m7 Tuesday | 547. | 547 670 24jul2019 24 7 2019 2019w30 2019m7 Wednesday | |-------------------------------------------------------------------------------| 548. | 548 599 25jul2019 25 7 2019 2019w30 2019m7 Thursday | 549. | 549 629 26jul2019 26 7 2019 2019w30 2019m7 Friday | 550. | 550 571 27jul2019 27 7 2019 2019w30 2019m7 Saturday | 551. | 551 625 28jul2019 28 7 2019 2019w30 2019m7 Sunday | 552. | 552 587 29jul2019 29 7 2019 2019w30 2019m7 Monday | |-------------------------------------------------------------------------------| 553. | 553 623 30jul2019 30 7 2019 2019w31 2019m7 Tuesday | 554. | 554 502 31jul2019 31 7 2019 2019w31 2019m7 Wednesday | 555. | 555 760 01aug2019 1 8 2019 2019w31 2019m8 Thursday | 556. | 556 407 02aug2019 2 8 2019 2019w31 2019m8 Friday | 557. | 557 295 03aug2019 3 8 2019 2019w31 2019m8 Saturday | |-------------------------------------------------------------------------------| 558. | 558 399 04aug2019 4 8 2019 2019w31 2019m8 Sunday | 559. | 559 563 05aug2019 5 8 2019 2019w31 2019m8 Monday | 560. | 560 459 06aug2019 6 8 2019 2019w32 2019m8 Tuesday | 561. | 561 547 07aug2019 7 8 2019 2019w32 2019m8 Wednesday | 562. | 562 594 08aug2019 8 8 2019 2019w32 2019m8 Thursday | |-------------------------------------------------------------------------------| 563. | 563 500 09aug2019 9 8 2019 2019w32 2019m8 Friday | 564. | 564 328 10aug2019 10 8 2019 2019w32 2019m8 Saturday | 565. | 565 411 11aug2019 11 8 2019 2019w32 2019m8 Sunday | 566. | 566 368 12aug2019 12 8 2019 2019w32 2019m8 Monday | 567. | 567 620 13aug2019 13 8 2019 2019w33 2019m8 Tuesday | |-------------------------------------------------------------------------------| 568. | 568 394 14aug2019 14 8 2019 2019w33 2019m8 Wednesday | 569. | 569 652 15aug2019 15 8 2019 2019w33 2019m8 Thursday | 570. | 570 763 16aug2019 16 8 2019 2019w33 2019m8 Friday | 571. | 571 535 17aug2019 17 8 2019 2019w33 2019m8 Saturday | 572. | 572 627 18aug2019 18 8 2019 2019w33 2019m8 Sunday | |-------------------------------------------------------------------------------| 573. | 573 645 19aug2019 19 8 2019 2019w33 2019m8 Monday | 574. | 574 493 20aug2019 20 8 2019 2019w34 2019m8 Tuesday | 575. | 575 607 21aug2019 21 8 2019 2019w34 2019m8 Wednesday | 576. | 576 602 22aug2019 22 8 2019 2019w34 2019m8 Thursday | 577. | 577 434 23aug2019 23 8 2019 2019w34 2019m8 Friday | |-------------------------------------------------------------------------------| 578. | 578 516 24aug2019 24 8 2019 2019w34 2019m8 Saturday | 579. | 579 515 25aug2019 25 8 2019 2019w34 2019m8 Sunday | 580. | 580 455 26aug2019 26 8 2019 2019w34 2019m8 Monday | 581. | 581 629 27aug2019 27 8 2019 2019w35 2019m8 Tuesday | 582. | 582 470 28aug2019 28 8 2019 2019w35 2019m8 Wednesday | |-------------------------------------------------------------------------------| 583. | 583 584 29aug2019 29 8 2019 2019w35 2019m8 Thursday | 584. | 584 453 30aug2019 30 8 2019 2019w35 2019m8 Friday | 585. | 585 538 31aug2019 31 8 2019 2019w35 2019m8 Saturday | 586. | 586 449 01sep2019 1 9 2019 2019w35 2019m9 Sunday | 587. | 587 417 02sep2019 2 9 2019 2019w35 2019m9 Monday | |-------------------------------------------------------------------------------| 588. | 588 416 03sep2019 3 9 2019 2019w36 2019m9 Tuesday | 589. | 589 553 04sep2019 4 9 2019 2019w36 2019m9 Wednesday | 590. | 590 613 05sep2019 5 9 2019 2019w36 2019m9 Thursday | 591. | 591 717 06sep2019 6 9 2019 2019w36 2019m9 Friday | 592. | 592 417 07sep2019 7 9 2019 2019w36 2019m9 Saturday | |-------------------------------------------------------------------------------| 593. | 593 534 08sep2019 8 9 2019 2019w36 2019m9 Sunday | 594. | 594 559 09sep2019 9 9 2019 2019w36 2019m9 Monday | 595. | 595 525 10sep2019 10 9 2019 2019w37 2019m9 Tuesday | 596. | 596 646 11sep2019 11 9 2019 2019w37 2019m9 Wednesday | 597. | 597 768 12sep2019 12 9 2019 2019w37 2019m9 Thursday | |-------------------------------------------------------------------------------| 598. | 598 482 13sep2019 13 9 2019 2019w37 2019m9 Friday | 599. | 599 382 14sep2019 14 9 2019 2019w37 2019m9 Saturday | 600. | 600 666 15sep2019 15 9 2019 2019w37 2019m9 Sunday | 601. | 601 574 16sep2019 16 9 2019 2019w37 2019m9 Monday | 602. | 602 576 17sep2019 17 9 2019 2019w38 2019m9 Tuesday | |-------------------------------------------------------------------------------| 603. | 603 788 18sep2019 18 9 2019 2019w38 2019m9 Wednesday | 604. | 604 582 19sep2019 19 9 2019 2019w38 2019m9 Thursday | 605. | 605 607 20sep2019 20 9 2019 2019w38 2019m9 Friday | 606. | 606 614 21sep2019 21 9 2019 2019w38 2019m9 Saturday | 607. | 607 621 22sep2019 22 9 2019 2019w38 2019m9 Sunday | |-------------------------------------------------------------------------------| 608. | 608 732 23sep2019 23 9 2019 2019w38 2019m9 Monday | 609. | 609 691 24sep2019 24 9 2019 2019w39 2019m9 Tuesday | 610. | 610 749 25sep2019 25 9 2019 2019w39 2019m9 Wednesday | 611. | 611 479 26sep2019 26 9 2019 2019w39 2019m9 Thursday | 612. | 612 588 27sep2019 27 9 2019 2019w39 2019m9 Friday | |-------------------------------------------------------------------------------| 613. | 613 639 28sep2019 28 9 2019 2019w39 2019m9 Saturday | 614. | 614 481 29sep2019 29 9 2019 2019w39 2019m9 Sunday | 615. | 615 691 30sep2019 30 9 2019 2019w39 2019m9 Monday | 616. | 616 654 01oct2019 1 10 2019 2019w40 2019m10 Tuesday | 617. | 617 501 02oct2019 2 10 2019 2019w40 2019m10 Wednesday | |-------------------------------------------------------------------------------| 618. | 618 467 03oct2019 3 10 2019 2019w40 2019m10 Thursday | 619. | 619 733 04oct2019 4 10 2019 2019w40 2019m10 Friday | 620. | 620 508 05oct2019 5 10 2019 2019w40 2019m10 Saturday | 621. | 621 559 06oct2019 6 10 2019 2019w40 2019m10 Sunday | 622. | 622 935 07oct2019 7 10 2019 2019w40 2019m10 Monday | |-------------------------------------------------------------------------------| 623. | 623 659 08oct2019 8 10 2019 2019w41 2019m10 Tuesday | 624. | 624 799 09oct2019 9 10 2019 2019w41 2019m10 Wednesday | 625. | 625 581 10oct2019 10 10 2019 2019w41 2019m10 Thursday | 626. | 626 574 11oct2019 11 10 2019 2019w41 2019m10 Friday | 627. | 627 474 12oct2019 12 10 2019 2019w41 2019m10 Saturday | |-------------------------------------------------------------------------------| 628. | 628 721 13oct2019 13 10 2019 2019w41 2019m10 Sunday | 629. | 629 757 14oct2019 14 10 2019 2019w41 2019m10 Monday | 630. | 630 508 15oct2019 15 10 2019 2019w42 2019m10 Tuesday | 631. | 631 588 16oct2019 16 10 2019 2019w42 2019m10 Wednesday | 632. | 632 858 17oct2019 17 10 2019 2019w42 2019m10 Thursday | |-------------------------------------------------------------------------------| 633. | 633 926 18oct2019 18 10 2019 2019w42 2019m10 Friday | 634. | 634 874 19oct2019 19 10 2019 2019w42 2019m10 Saturday | 635. | 635 706 20oct2019 20 10 2019 2019w42 2019m10 Sunday | 636. | 636 1082 21oct2019 21 10 2019 2019w42 2019m10 Monday | 637. | 637 719 22oct2019 22 10 2019 2019w43 2019m10 Tuesday | |-------------------------------------------------------------------------------| 638. | 638 877 23oct2019 23 10 2019 2019w43 2019m10 Wednesday | 639. | 639 767 24oct2019 24 10 2019 2019w43 2019m10 Thursday | 640. | 640 596 25oct2019 25 10 2019 2019w43 2019m10 Friday | 641. | 641 653 26oct2019 26 10 2019 2019w43 2019m10 Saturday | 642. | 642 665 27oct2019 27 10 2019 2019w43 2019m10 Sunday | |-------------------------------------------------------------------------------| 643. | 643 698 28oct2019 28 10 2019 2019w43 2019m10 Monday | 644. | 644 833 29oct2019 29 10 2019 2019w44 2019m10 Tuesday | 645. | 645 594 30oct2019 30 10 2019 2019w44 2019m10 Wednesday | 646. | 646 724 31oct2019 31 10 2019 2019w44 2019m10 Thursday | 647. | 647 701 01nov2019 1 11 2019 2019w44 2019m11 Friday | |-------------------------------------------------------------------------------| 648. | 648 559 02nov2019 2 11 2019 2019w44 2019m11 Saturday | 649. | 649 683 03nov2019 3 11 2019 2019w44 2019m11 Sunday | 650. | 650 636 04nov2019 4 11 2019 2019w44 2019m11 Monday | 651. | 651 779 05nov2019 5 11 2019 2019w45 2019m11 Tuesday | 652. | 652 837 06nov2019 6 11 2019 2019w45 2019m11 Wednesday | |-------------------------------------------------------------------------------| 653. | 653 602 07nov2019 7 11 2019 2019w45 2019m11 Thursday | 654. | 654 508 08nov2019 8 11 2019 2019w45 2019m11 Friday | 655. | 655 747 09nov2019 9 11 2019 2019w45 2019m11 Saturday | 656. | 656 640 10nov2019 10 11 2019 2019w45 2019m11 Sunday | 657. | 657 622 11nov2019 11 11 2019 2019w45 2019m11 Monday | |-------------------------------------------------------------------------------| 658. | 658 675 12nov2019 12 11 2019 2019w46 2019m11 Tuesday | 659. | 659 1476 13nov2019 13 11 2019 2019w46 2019m11 Wednesday | 660. | 660 2510 14nov2019 14 11 2019 2019w46 2019m11 Thursday | 661. | 661 1542 15nov2019 15 11 2019 2019w46 2019m11 Friday | 662. | 662 1441 16nov2019 16 11 2019 2019w46 2019m11 Saturday | |-------------------------------------------------------------------------------| 663. | 663 2753 17nov2019 17 11 2019 2019w46 2019m11 Sunday | 664. | 664 3854 18nov2019 18 11 2019 2019w46 2019m11 Monday | 665. | 665 2182 19nov2019 19 11 2019 2019w47 2019m11 Tuesday | 666. | 666 5275 20nov2019 20 11 2019 2019w47 2019m11 Wednesday | 667. | 667 5412 21nov2019 21 11 2019 2019w47 2019m11 Thursday | |-------------------------------------------------------------------------------| 668. | 668 1660 22nov2019 22 11 2019 2019w47 2019m11 Friday | 669. | 669 1153 23nov2019 23 11 2019 2019w47 2019m11 Saturday | 670. | 670 877 24nov2019 24 11 2019 2019w47 2019m11 Sunday | 671. | 671 1126 25nov2019 25 11 2019 2019w47 2019m11 Monday | 672. | 672 804 26nov2019 26 11 2019 2019w48 2019m11 Tuesday | |-------------------------------------------------------------------------------| 673. | 673 619 27nov2019 27 11 2019 2019w48 2019m11 Wednesday | 674. | 674 744 28nov2019 28 11 2019 2019w48 2019m11 Thursday | 675. | 675 739 29nov2019 29 11 2019 2019w48 2019m11 Friday | 676. | 676 820 30nov2019 30 11 2019 2019w48 2019m11 Saturday | 677. | 677 1466 01dec2019 1 12 2019 2019w48 2019m12 Sunday | |-------------------------------------------------------------------------------| 678. | 678 715 02dec2019 2 12 2019 2019w48 2019m12 Monday | 679. | 679 683 03dec2019 3 12 2019 2019w49 2019m12 Tuesday | 680. | 680 745 04dec2019 4 12 2019 2019w49 2019m12 Wednesday | 681. | 681 813 05dec2019 5 12 2019 2019w49 2019m12 Thursday | 682. | 682 567 06dec2019 6 12 2019 2019w49 2019m12 Friday | |-------------------------------------------------------------------------------| 683. | 683 542 07dec2019 7 12 2019 2019w49 2019m12 Saturday | 684. | 684 560 08dec2019 8 12 2019 2019w49 2019m12 Sunday | 685. | 685 614 09dec2019 9 12 2019 2019w49 2019m12 Monday | 686. | 686 611 10dec2019 10 12 2019 2019w50 2019m12 Tuesday | 687. | 687 714 11dec2019 11 12 2019 2019w50 2019m12 Wednesday | +-------------------------------------------------------------------------------+
For the year of 2018, please get it there
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 16, 2019, 02:18:01 AM |
|
Time-series plots:Full dataset:] Truncated dataset: Basic statistics (for full dataset): Only drop last two days that belong to the 2019w50, incomplete week. . tabstat merit, s(n mean sd p50 p25 p75 min max)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 685 787.7985 729.3756 642 538 777 295 13018 ----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 180 or 1136. . di 777-538 239
. di 239*1.5 358.5
. di 777+358.5 1135.5
. di 538-358.5 179.5
There are 64 outliers (beyond 1136 or 180) in full dataset, in total. . count if (merit >= 1136 | merit <= 180) & merit != . 64
Those days are: . list id merit date if (merit >= 1136 | merit <= 180) & merit != .
+-------------------------+ | id merit date | |-------------------------| 1. | 1 13018 24jan2018 | 2. | 2 6762 25jan2018 | 3. | 3 4500 26jan2018 | 4. | 4 3490 27jan2018 | 5. | 5 3190 28jan2018 | |-------------------------| 6. | 6 3800 29jan2018 | 7. | 7 4193 30jan2018 | 8. | 8 2821 31jan2018 | 9. | 9 2546 01feb2018 | 10. | 10 2569 02feb2018 | |-------------------------| 11. | 11 1868 03feb2018 | 12. | 12 2182 04feb2018 | 13. | 13 2078 05feb2018 | 14. | 14 2310 06feb2018 | 15. | 15 2142 07feb2018 | |-------------------------| 16. | 16 2143 08feb2018 | 17. | 17 1449 09feb2018 | 18. | 18 1748 10feb2018 | 19. | 19 1443 11feb2018 | 20. | 20 1332 12feb2018 | |-------------------------| 21. | 21 1580 13feb2018 | 22. | 22 2514 14feb2018 | 23. | 23 1992 15feb2018 | 24. | 24 1416 16feb2018 | 25. | 25 1618 17feb2018 | |-------------------------| 26. | 26 1293 18feb2018 | 27. | 27 1404 19feb2018 | 28. | 28 1170 20feb2018 | 29. | 29 1268 21feb2018 | 30. | 30 1280 22feb2018 | |-------------------------| 32. | 32 1410 24feb2018 | 33. | 33 1187 25feb2018 | 34. | 34 1392 26feb2018 | 35. | 35 1327 27feb2018 | 37. | 37 1335 01mar2018 | |-------------------------| 38. | 38 1706 02mar2018 | 41. | 41 1246 05mar2018 | 48. | 48 1355 12mar2018 | 50. | 50 1160 14mar2018 | 56. | 56 1324 20mar2018 | |-------------------------| 57. | 57 1229 21mar2018 | 68. | 68 1258 01apr2018 | 69. | 69 1147 02apr2018 | 153. | 153 1139 25jun2018 | 236. | 236 2464 16sep2018 | |-------------------------| 237. | 237 1863 17sep2018 | 238. | 238 1295 18sep2018 | 239. | 239 1271 19sep2018 | 351. | 351 1162 09jan2019 | 428. | 428 1250 27mar2019 | |-------------------------| 475. | 475 1151 13may2019 | 504. | 504 1188 11jun2019 | 659. | 659 1476 13nov2019 | 660. | 660 2510 14nov2019 | 661. | 661 1542 15nov2019 | |-------------------------| 662. | 662 1441 16nov2019 | 663. | 663 2753 17nov2019 | 664. | 664 3854 18nov2019 | 665. | 665 2182 19nov2019 | 666. | 666 5275 20nov2019 | |-------------------------| 667. | 667 5412 21nov2019 | 668. | 668 1660 22nov2019 | 669. | 669 1153 23nov2019 | 677. | 677 1466 01dec2019 | +-------------------------+
Only 16 of them occured in 2019. See details in the list of outliers above.
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 16, 2019, 02:20:32 AM |
|
During the period from 24/1/2018 to 09/12/2019 (last two days dropped due to incomplete week), the minimum and maximum of intra-day merit are 295 and 13018, on 03/8/2019 and 24/1/2018, respectively. List of the top 50-highest day in terms of intra-day merits: +-------------------------------------------------------------------------------+ | merit id date dofw day month2 year week month | |-------------------------------------------------------------------------------| 1. | 13018 1 24jan2018 Wednesday 24 1 2018 2018w4 2018m1 | 2. | 6762 2 25jan2018 Thursday 25 1 2018 2018w4 2018m1 | 3. | 5412 667 21nov2019 Thursday 21 11 2019 2019w47 2019m11 | 4. | 5275 666 20nov2019 Wednesday 20 11 2019 2019w47 2019m11 | 5. | 4500 3 26jan2018 Friday 26 1 2018 2018w4 2018m1 | |-------------------------------------------------------------------------------| 6. | 4193 7 30jan2018 Tuesday 30 1 2018 2018w5 2018m1 | 7. | 3854 664 18nov2019 Monday 18 11 2019 2019w46 2019m11 | 8. | 3800 6 29jan2018 Monday 29 1 2018 2018w5 2018m1 | 9. | 3490 4 27jan2018 Saturday 27 1 2018 2018w4 2018m1 | 10. | 3190 5 28jan2018 Sunday 28 1 2018 2018w4 2018m1 | |-------------------------------------------------------------------------------| 11. | 2821 8 31jan2018 Wednesday 31 1 2018 2018w5 2018m1 | 12. | 2753 663 17nov2019 Sunday 17 11 2019 2019w46 2019m11 | 13. | 2569 10 02feb2018 Friday 2 2 2018 2018w5 2018m2 | 14. | 2546 9 01feb2018 Thursday 1 2 2018 2018w5 2018m2 | 15. | 2514 22 14feb2018 Wednesday 14 2 2018 2018w7 2018m2 | |-------------------------------------------------------------------------------| 16. | 2510 660 14nov2019 Thursday 14 11 2019 2019w46 2019m11 | 17. | 2464 236 16sep2018 Sunday 16 9 2018 2018w37 2018m9 | 18. | 2310 14 06feb2018 Tuesday 6 2 2018 2018w6 2018m2 | 19. | 2182 12 04feb2018 Sunday 4 2 2018 2018w5 2018m2 | 20. | 2182 665 19nov2019 Tuesday 19 11 2019 2019w47 2019m11 | |-------------------------------------------------------------------------------| 21. | 2143 16 08feb2018 Thursday 8 2 2018 2018w6 2018m2 | 22. | 2142 15 07feb2018 Wednesday 7 2 2018 2018w6 2018m2 | 23. | 2078 13 05feb2018 Monday 5 2 2018 2018w6 2018m2 | 24. | 1992 23 15feb2018 Thursday 15 2 2018 2018w7 2018m2 | 25. | 1868 11 03feb2018 Saturday 3 2 2018 2018w5 2018m2 | |-------------------------------------------------------------------------------| 26. | 1863 237 17sep2018 Monday 17 9 2018 2018w38 2018m9 | 27. | 1748 18 10feb2018 Saturday 10 2 2018 2018w6 2018m2 | 28. | 1706 38 02mar2018 Friday 2 3 2018 2018w9 2018m3 | 29. | 1660 668 22nov2019 Friday 22 11 2019 2019w47 2019m11 | 30. | 1618 25 17feb2018 Saturday 17 2 2018 2018w7 2018m2 | |-------------------------------------------------------------------------------| 31. | 1580 21 13feb2018 Tuesday 13 2 2018 2018w7 2018m2 | 32. | 1542 661 15nov2019 Friday 15 11 2019 2019w46 2019m11 | 33. | 1476 659 13nov2019 Wednesday 13 11 2019 2019w46 2019m11 | 34. | 1466 677 01dec2019 Sunday 1 12 2019 2019w48 2019m12 | 35. | 1449 17 09feb2018 Friday 9 2 2018 2018w6 2018m2 | |-------------------------------------------------------------------------------| 36. | 1443 19 11feb2018 Sunday 11 2 2018 2018w6 2018m2 | 37. | 1441 662 16nov2019 Saturday 16 11 2019 2019w46 2019m11 | 38. | 1416 24 16feb2018 Friday 16 2 2018 2018w7 2018m2 | 39. | 1410 32 24feb2018 Saturday 24 2 2018 2018w8 2018m2 | 40. | 1404 27 19feb2018 Monday 19 2 2018 2018w8 2018m2 | |-------------------------------------------------------------------------------| 41. | 1392 34 26feb2018 Monday 26 2 2018 2018w9 2018m2 | 42. | 1355 48 12mar2018 Monday 12 3 2018 2018w11 2018m3 | 43. | 1335 37 01mar2018 Thursday 1 3 2018 2018w9 2018m3 | 44. | 1332 20 12feb2018 Monday 12 2 2018 2018w7 2018m2 | 45. | 1327 35 27feb2018 Tuesday 27 2 2018 2018w9 2018m2 | |-------------------------------------------------------------------------------| 46. | 1324 56 20mar2018 Tuesday 20 3 2018 2018w12 2018m3 | 47. | 1295 238 18sep2018 Tuesday 18 9 2018 2018w38 2018m9 | 48. | 1293 26 18feb2018 Sunday 18 2 2018 2018w7 2018m2 | 49. | 1280 30 22feb2018 Thursday 22 2 2018 2018w8 2018m2 | 50. | 1271 239 19sep2018 Wednesday 19 9 2018 2018w38 2018m9 |
List of the top 50-lowest days in terms of intra-day merits: +-------------------------------------------------------------------------------+ | merit id date dofw day month2 year week month | |-------------------------------------------------------------------------------| 1. | 295 557 03aug2019 Saturday 3 8 2019 2019w31 2019m8 | 2. | 313 335 24dec2018 Monday 24 12 2018 2018w52 2018m12 | 3. | 317 333 22dec2018 Saturday 22 12 2018 2018w51 2018m12 | 4. | 328 564 10aug2019 Saturday 10 8 2019 2019w32 2019m8 | 5. | 344 340 29dec2018 Saturday 29 12 2018 2018w52 2018m12 | |-------------------------------------------------------------------------------| 6. | 348 298 17nov2018 Saturday 17 11 2018 2018w46 2018m11 | 7. | 348 338 27dec2018 Thursday 27 12 2018 2018w52 2018m12 | 8. | 349 304 23nov2018 Friday 23 11 2018 2018w47 2018m11 | 9. | 368 566 12aug2019 Monday 12 8 2019 2019w32 2019m8 | 10. | 371 122 25may2018 Friday 25 5 2018 2018w21 2018m5 | |-------------------------------------------------------------------------------| 11. | 377 342 31dec2018 Monday 31 12 2018 2018w52 2018m12 | 12. | 377 191 02aug2018 Thursday 2 8 2018 2018w31 2018m8 | 13. | 379 326 15dec2018 Saturday 15 12 2018 2018w50 2018m12 | 14. | 380 220 31aug2018 Friday 31 8 2018 2018w35 2018m8 | 15. | 382 599 14sep2019 Saturday 14 9 2019 2019w37 2019m9 | |-------------------------------------------------------------------------------| 16. | 384 217 28aug2018 Tuesday 28 8 2018 2018w35 2018m8 | 17. | 386 214 25aug2018 Saturday 25 8 2018 2018w34 2018m8 | 18. | 387 339 28dec2018 Friday 28 12 2018 2018w52 2018m12 | 19. | 394 568 14aug2019 Wednesday 14 8 2019 2019w33 2019m8 | 20. | 394 341 30dec2018 Sunday 30 12 2018 2018w52 2018m12 | |-------------------------------------------------------------------------------| 21. | 395 529 06jul2019 Saturday 6 7 2019 2019w27 2019m7 | 22. | 395 345 03jan2019 Thursday 3 1 2019 2019w1 2019m1 | 23. | 396 228 08sep2018 Saturday 8 9 2018 2018w36 2018m9 | 24. | 398 320 09dec2018 Sunday 9 12 2018 2018w49 2018m12 | 25. | 399 558 04aug2019 Sunday 4 8 2019 2019w31 2019m8 | |-------------------------------------------------------------------------------| 26. | 400 262 12oct2018 Friday 12 10 2018 2018w41 2018m10 | 27. | 403 329 18dec2018 Tuesday 18 12 2018 2018w51 2018m12 | 28. | 406 287 06nov2018 Tuesday 6 11 2018 2018w45 2018m11 | 29. | 407 556 02aug2019 Friday 2 8 2019 2019w31 2019m8 | 30. | 411 565 11aug2019 Sunday 11 8 2019 2019w32 2019m8 | |-------------------------------------------------------------------------------| 31. | 413 403 02mar2019 Saturday 2 3 2019 2019w9 2019m3 | 32. | 413 222 02sep2018 Sunday 2 9 2018 2018w35 2018m9 | 33. | 414 527 04jul2019 Thursday 4 7 2019 2019w27 2019m7 | 34. | 416 278 28oct2018 Sunday 28 10 2018 2018w43 2018m10 | 35. | 416 533 10jul2019 Wednesday 10 7 2019 2019w28 2019m7 | |-------------------------------------------------------------------------------| 36. | 416 588 03sep2019 Tuesday 3 9 2019 2019w36 2019m9 | 37. | 417 592 07sep2019 Saturday 7 9 2019 2019w36 2019m9 | 38. | 417 109 12may2018 Saturday 12 5 2018 2018w19 2018m5 | 39. | 417 587 02sep2019 Monday 2 9 2019 2019w35 2019m9 | 40. | 419 186 28jul2018 Saturday 28 7 2018 2018w30 2018m7 | |-------------------------------------------------------------------------------| 41. | 421 187 29jul2018 Sunday 29 7 2018 2018w30 2018m7 | 42. | 422 192 03aug2018 Friday 3 8 2018 2018w31 2018m8 | 43. | 425 276 26oct2018 Friday 26 10 2018 2018w43 2018m10 | 44. | 427 140 12jun2018 Tuesday 12 6 2018 2018w24 2018m6 | 45. | 427 277 27oct2018 Saturday 27 10 2018 2018w43 2018m10 | |-------------------------------------------------------------------------------| 46. | 429 418 17mar2019 Sunday 17 3 2019 2019w11 2019m3 | 47. | 429 313 02dec2018 Sunday 2 12 2018 2018w48 2018m12 | 48. | 431 284 03nov2018 Saturday 3 11 2018 2018w44 2018m11 | 49. | 431 264 14oct2018 Sunday 14 10 2018 2018w41 2018m10 | 50. | 433 208 19aug2018 Sunday 19 8 2018 2018w33 2018m8 |
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 16, 2019, 02:25:38 AM |
|
Medians and means of intra-day merits over days of weeks.Colors: - Green: highest.
- Red: Lowest.
- In median, the highest days are Monday, Thursday, and Wednesday at 685, 675, and 667, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 596, 613, and 623, respectively. - In means, the highest days are Wednesday, Thursday, and Monday at 932, 857, and 812, respectively; whilst the lowest days are Saturday, Friday, and Sunday, at 692, 708, and 751, respectively. Calendar day is in GMT time.To take away all doubt: the first Merit was this one: 1516831941 1 2818066.msg28853325 35 877396 Use EpochConverter to convert 1516831941 (Unix Time) to GMT: Wednesday 24 January 2018 22:12:21. Basic statistics:. tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f) by(dofw)
Summary for variables: merit by categories of: dofw
dofw | N mean sd p50 p25 p75 min max ----------+-------------------------------------------------------------------------------- Sunday | 98.0 750.7 458.1 623.0 517.0 789.0 394.0 3190.0 Monday | 98.0 811.5 524.2 684.5 574.0 825.0 313.0 3854.0 Tuesday | 97.0 765.6 464.7 660.0 592.0 761.0 384.0 4193.0 Wednesday | 98.0 931.4 1367.2 666.5 563.0 788.0 394.0 13018.0 Thursday | 98.0 856.6 850.6 675.0 550.0 811.0 348.0 6762.0 Friday | 98.0 707.2 502.2 596.0 510.0 713.0 349.0 4500.0 Saturday | 98.0 691.3 405.0 613.0 486.0 717.0 295.0 3490.0 ----------+-------------------------------------------------------------------------------- Total | 685.0 787.8 729.4 642.0 538.0 777.0 295.0 13018.0 -------------------------------------------------------------------------------------------
Box plotsOutliers displayed as red circles. Outliers non-displayed. Details on ranks:In medians +----------------------------------------------------------------------+ | rankmedian dofw median mean p25 p75 min max | |----------------------------------------------------------------------| 1. | 1 Monday 684.5 811.4694 574 825 313 3854 | 2. | 2 Thursday 675 856.6021 550 811 348 6762 | 3. | 3 Wednesday 666.5 931.449 563 788 394 13018 | 4. | 4 Tuesday 660 765.6288 592 761 384 4193 | 5. | 5 Sunday 623 750.7041 517 789 394 3190 | |----------------------------------------------------------------------| 6. | 6 Saturday 613 691.3062 486 717 295 3490 | 7. | 7 Friday 596 707.2041 510 713 349 4500 | +----------------------------------------------------------------------+
In means +--------------------------------------------------------------------+ | rankmean dofw mean median p25 p75 min max | |--------------------------------------------------------------------| 1. | 1 Wednesday 931.449 666.5 563 788 394 13018 | 2. | 2 Thursday 856.6021 675 550 811 348 6762 | 3. | 3 Monday 811.4694 684.5 574 825 313 3854 | 4. | 4 Tuesday 765.6288 660 592 761 384 4193 | 5. | 5 Sunday 750.7041 623 517 789 394 3190 | |--------------------------------------------------------------------| 6. | 6 Friday 707.2041 596 510 713 349 4500 | 7. | 7 Saturday 691.3062 613 486 717 295 3490 | +--------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 16, 2019, 02:29:36 AM |
|
Intra-week merits (from 24/1/2018 to 09/12/2019)Last two days dropped due to incomplete weeks (2019w50)Converted dataset: +-----------------+ | merit week | |-----------------| 1. | 30960 2018w4 | 2. | 19979 2018w5 | 3. | 13313 2018w6 | 4. | 11745 2018w7 | 5. | 8767 2018w8 | |-----------------| 6. | 8833 2018w9 | 7. | 7261 2018w10 | 8. | 7317 2018w11 | 9. | 6952 2018w12 | 10. | 6744 2018w13 | |-----------------| 11. | 6423 2018w14 | 12. | 5494 2018w15 | 13. | 4742 2018w16 | 14. | 4612 2018w17 | 15. | 4965 2018w18 | |-----------------| 16. | 4766 2018w19 | 17. | 4353 2018w20 | 18. | 3864 2018w21 | 19. | 4194 2018w22 | 20. | 4538 2018w23 | |-----------------| 21. | 3839 2018w24 | 22. | 4929 2018w25 | 23. | 4465 2018w26 | 24. | 4278 2018w27 | 25. | 4247 2018w28 | |-----------------| 26. | 4167 2018w29 | 27. | 3661 2018w30 | 28. | 3863 2018w31 | 29. | 4011 2018w32 | 30. | 3631 2018w33 | |-----------------| 31. | 3805 2018w34 | 32. | 3072 2018w35 | 33. | 3590 2018w36 | 34. | 5644 2018w37 | 35. | 7837 2018w38 | |-----------------| 36. | 4395 2018w39 | 37. | 4310 2018w40 | 38. | 3816 2018w41 | 39. | 4829 2018w42 | 40. | 3953 2018w43 | |-----------------| 41. | 3347 2018w44 | 42. | 4525 2018w45 | 43. | 3747 2018w46 | 44. | 4575 2018w47 | 45. | 3765 2018w48 | |-----------------| 46. | 3571 2018w49 | 47. | 3805 2018w50 | 48. | 3769 2018w51 | 49. | 3338 2018w52 | 50. | 4803 2019w1 | |-----------------| 51. | 6632 2019w2 | 52. | 5317 2019w3 | 53. | 4667 2019w4 | 54. | 4491 2019w5 | 55. | 4332 2019w6 | |-----------------| 56. | 4221 2019w7 | 57. | 4521 2019w8 | 58. | 4638 2019w9 | 59. | 4913 2019w10 | 60. | 4326 2019w11 | |-----------------| 61. | 4609 2019w12 | 62. | 6130 2019w13 | 63. | 4526 2019w14 | 64. | 5271 2019w15 | 65. | 4688 2019w16 | |-----------------| 66. | 4448 2019w17 | 67. | 4764 2019w18 | 68. | 5454 2019w19 | 69. | 5214 2019w20 | 70. | 4580 2019w21 | |-----------------| 71. | 4445 2019w22 | 72. | 4687 2019w23 | 73. | 5354 2019w24 | 74. | 4726 2019w25 | 75. | 4367 2019w26 | |-----------------| 76. | 4225 2019w27 | 77. | 4119 2019w28 | 78. | 4277 2019w29 | 79. | 4176 2019w30 | 80. | 3549 2019w31 | |-----------------| 81. | 3207 2019w32 | 82. | 4236 2019w33 | 83. | 3622 2019w34 | 84. | 3540 2019w35 | 85. | 3809 2019w36 | |-----------------| 86. | 4043 2019w37 | 87. | 4520 2019w38 | 88. | 4318 2019w39 | 89. | 4357 2019w40 | 90. | 4565 2019w41 | |-----------------| 91. | 5542 2019w42 | 92. | 4975 2019w43 | 93. | 4730 2019w44 | 94. | 4735 2019w45 | 95. | 14251 2019w46 | |-----------------| 96. | 17685 2019w47 | 97. | 5907 2019w48 | 98. | 4524 2019w49 | +-----------------+
Time series plotBasic statistics:- 50% of observed weeks ( 98 weeks) have total intra-week merits above 4525, whilst the rest 50% of them have total intra-week merits below 4525. 4525 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 4119 to 5214 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3072 - 30960. . tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 98.0 5506.6 3736.4 4524.5 4119.0 5214.0 3072.0 30960.0 ----------------------------------------------------------------------------------------------
Potential outliers:. di 5214-4119 1095
. di 1095*1.5 1642.5
. di 5214+1642.5 6856.5
. di 4119-1642.5 2476.5
It means that potential outliers are weeks that have intra-week merits beyond 2477 or 6857. How many weeks are potential outliers? . count if (merit >= 6857 | merit < 2477) & merit != . 12
12 weeks are outliers, in total. List of those 12 weeks: . list merit week if merit >= 6857 | merit <= 2477
+-----------------+ | merit week | |-----------------| 1. | 30960 2018w4 | 2. | 19979 2018w5 | 3. | 13313 2018w6 | 4. | 11745 2018w7 | 5. | 8767 2018w8 | |-----------------| 6. | 8833 2018w9 | 7. | 7261 2018w10 | 8. | 7317 2018w11 | 9. | 6952 2018w12 | 35. | 7837 2018w38 | |-----------------| 95. | 14251 2019w46 | 96. | 17685 2019w47 | +-----------------+
Most of them occured in the year 2018, and there is only two outliers week occured in 2019, in 2019w46 (14251), 2019w47 ( 17685). List of weeks in descending weekly merits +------------------------------+ | weeklyrank merit week | |------------------------------| 1. | 1 30960 2018w4 | 2. | 2 19979 2018w5 | 3. | 3 17685 2019w47 | 4. | 4 14251 2019w46 | 5. | 5 13313 2018w6 | |------------------------------| 6. | 6 11745 2018w7 | 7. | 7 8833 2018w9 | 8. | 8 8767 2018w8 | 9. | 9 7837 2018w38 | 10. | 10 7317 2018w11 | |------------------------------| 11. | 11 7261 2018w10 | 12. | 12 6952 2018w12 | 13. | 13 6744 2018w13 | 14. | 14 6632 2019w2 | 15. | 15 6423 2018w14 | |------------------------------| 16. | 16 6130 2019w13 | 17. | 17 5907 2019w48 | 18. | 18 5644 2018w37 | 19. | 19 5542 2019w42 | 20. | 20 5494 2018w15 | |------------------------------| 21. | 21 5454 2019w19 | 22. | 22 5354 2019w24 | 23. | 23 5317 2019w3 | 24. | 24 5271 2019w15 | 25. | 25 5214 2019w20 | |------------------------------| 26. | 26 4975 2019w43 | 27. | 27 4965 2018w18 | 28. | 28 4929 2018w25 | 29. | 29 4913 2019w10 | 30. | 30 4829 2018w42 | |------------------------------| 31. | 31 4803 2019w1 | 32. | 32 4766 2018w19 | 33. | 33 4764 2019w18 | 34. | 34 4742 2018w16 | 35. | 35 4735 2019w45 | |------------------------------| 36. | 36 4730 2019w44 | 37. | 37 4726 2019w25 | 38. | 38 4688 2019w16 | 39. | 39 4687 2019w23 | 40. | 40 4667 2019w4 | |------------------------------| 41. | 41 4638 2019w9 | 42. | 42 4612 2018w17 | 43. | 43 4609 2019w12 | 44. | 44 4580 2019w21 | 45. | 45 4575 2018w47 | |------------------------------| 46. | 46 4565 2019w41 | 47. | 47 4538 2018w23 | 48. | 48 4526 2019w14 | 49. | 49 4525 2018w45 | 50. | 50 4524 2019w49 | |------------------------------| 51. | 51 4521 2019w8 | 52. | 52 4520 2019w38 | 53. | 53 4491 2019w5 | 54. | 54 4465 2018w26 | 55. | 55 4448 2019w17 | |------------------------------| 56. | 56 4445 2019w22 | 57. | 57 4395 2018w39 | 58. | 58 4367 2019w26 | 59. | 59 4357 2019w40 | 60. | 60 4353 2018w20 | |------------------------------| 61. | 61 4332 2019w6 | 62. | 62 4326 2019w11 | 63. | 63 4318 2019w39 | 64. | 64 4310 2018w40 | 65. | 65 4278 2018w27 | |------------------------------| 66. | 66 4277 2019w29 | 67. | 67 4247 2018w28 | 68. | 68 4236 2019w33 | 69. | 69 4225 2019w27 | 70. | 70 4221 2019w7 | |------------------------------| 71. | 71 4194 2018w22 | 72. | 72 4176 2019w30 | 73. | 73 4167 2018w29 | 74. | 74 4119 2019w28 | 75. | 75 4043 2019w37 | |------------------------------| 76. | 76 4011 2018w32 | 77. | 77 3953 2018w43 | 78. | 78 3864 2018w21 | 79. | 79 3863 2018w31 | 80. | 80 3839 2018w24 | |------------------------------| 81. | 81 3816 2018w41 | 82. | 82 3809 2019w36 | 83. | 83 3805 2018w50 | 84. | 84 3805 2018w34 | 85. | 85 3769 2018w51 | |------------------------------| 86. | 86 3765 2018w48 | 87. | 87 3747 2018w46 | 88. | 88 3661 2018w30 | 89. | 89 3631 2018w33 | 90. | 90 3622 2019w34 | |------------------------------| 91. | 91 3590 2018w36 | 92. | 92 3571 2018w49 | 93. | 93 3549 2019w31 | 94. | 94 3540 2019w35 | 95. | 95 3347 2018w44 | |------------------------------| 96. | 96 3338 2018w52 | 97. | 97 3207 2019w32 | 98. | 98 3072 2018w35 | +------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 16, 2019, 02:33:30 AM |
|
ABSTRACTData is the full dataset since 24/1/2018, and only dropped last two days belong to incomplete week - 2019w50. Details on days dropped, please see above posts. Intra-day merits:(1) Potential outliers are days that have intraday total merits beyond 180 or 1136; (2) Median of intraday merits over the period is 642; (3) 50% of observed days have their intra-day merits range from 538 to 777 (the interquartile range); (4) In GTM time. In medians, the highest and lowest days are Monday and Friday, respectively; whilst the highest and lowest days in means are Wednesday and Saturday, respectively. See here. (5) There are 64 potential outliers (beyond 180 or 1136) in total, and only 16 of them occured in 2019. ( see details). (6) Minimum and maximum of intraday merits (full dataset) are 295, and 13018, on 03/8/2019 and 24/1/2018, respectively. Intra-week merits:98 weeks in total. (1) The median of intra-week merits is 4525; (2) 50% of observed weeks ( 98 weeks in total), have total merits in the range from 4119 to 5214 (the interquartile range of intra-week merits). (3) Minimum and maximum of intra-week merits are 3072 and 30960, in 2018w35, and 2018w4, respectively; (4) 12 potential outliers [beyond 2477 or 6857], only 2 of them occurred in the year 2019, on 2019w46 ( 14251), and 2019w47 ( 17685).
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 27, 2019, 01:54:14 AM |
|
Update:Data source: http://loyce.club/Merit/tranthidung/meritperdayandweek.2019-12-24_Tue_11.45h.txtConverted dataset for the last week: +-------------------------------------------------------------------------------+ | id merit date day month2 year week month dofw | |-------------------------------------------------------------------------------| 688. | 688 577 12dec2019 12 12 2019 2019w50 2019m12 Thursday | 689. | 689 467 13dec2019 13 12 2019 2019w50 2019m12 Friday | 690. | 690 1013 14dec2019 14 12 2019 2019w50 2019m12 Saturday | 691. | 691 866 15dec2019 15 12 2019 2019w50 2019m12 Sunday | 692. | 692 938 16dec2019 16 12 2019 2019w50 2019m12 Monday | |-------------------------------------------------------------------------------| 693. | 693 920 17dec2019 17 12 2019 2019w51 2019m12 Tuesday | 694. | 694 836 18dec2019 18 12 2019 2019w51 2019m12 Wednesday | +-------------------------------------------------------------------------------+
For data:
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 27, 2019, 02:08:29 AM Last edit: December 27, 2019, 02:49:31 AM by tranthidung |
|
Time-series plots:Full dataset:Truncated dataset: Basic statistics (for full dataset): Only drop last two days that belong to the 2019w51, incomplete week. variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 692 787.3237 725.9343 642.5 538.5 778 295 13018 ----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 180 or 1138. . di 778-538.5 239.5
. di 239.5*1.5 359.25
. di 778+359.25 1137.25
. di 538.5-359.25 179.25
There are 64 outliers (beyond 1138 or 180) in full dataset, in total. . count if (merit >= 1138 | merit <= 180) & merit != . 64
Those days are: +-------------------------+ | id merit date | |-------------------------| 1. | 1 13018 24jan2018 | 2. | 2 6762 25jan2018 | 3. | 3 4500 26jan2018 | 4. | 4 3490 27jan2018 | 5. | 5 3190 28jan2018 | 6. | 6 3800 29jan2018 | 7. | 7 4193 30jan2018 | 8. | 8 2821 31jan2018 | 9. | 9 2546 01feb2018 | 10. | 10 2569 02feb2018 | 11. | 11 1868 03feb2018 | 12. | 12 2182 04feb2018 | 13. | 13 2078 05feb2018 | 14. | 14 2310 06feb2018 | 15. | 15 2142 07feb2018 | 16. | 16 2143 08feb2018 | 17. | 17 1449 09feb2018 | 18. | 18 1748 10feb2018 | 19. | 19 1443 11feb2018 | 20. | 20 1332 12feb2018 | 21. | 21 1580 13feb2018 | 22. | 22 2514 14feb2018 | 23. | 23 1992 15feb2018 | 24. | 24 1416 16feb2018 | 25. | 25 1618 17feb2018 | 26. | 26 1293 18feb2018 | 27. | 27 1404 19feb2018 | 28. | 28 1170 20feb2018 | 29. | 29 1268 21feb2018 | 30. | 30 1280 22feb2018 | 32. | 32 1410 24feb2018 | 33. | 33 1187 25feb2018 | 34. | 34 1392 26feb2018 | 35. | 35 1327 27feb2018 | 37. | 37 1335 01mar2018 | 38. | 38 1706 02mar2018 | 41. | 41 1246 05mar2018 | 48. | 48 1355 12mar2018 | 50. | 50 1160 14mar2018 | 56. | 56 1324 20mar2018 | 57. | 57 1229 21mar2018 | 68. | 68 1258 01apr2018 | 69. | 69 1147 02apr2018 | 153. | 153 1139 25jun2018 | 236. | 236 2464 16sep2018 | 237. | 237 1863 17sep2018 | 238. | 238 1295 18sep2018 | 239. | 239 1271 19sep2018 | |-------------------------| 351. | 351 1162 09jan2019 | 428. | 428 1250 27mar2019 | 475. | 475 1151 13may2019 | 504. | 504 1188 11jun2019 | 659. | 659 1476 13nov2019 | 660. | 660 2510 14nov2019 | 661. | 661 1542 15nov2019 | 662. | 662 1441 16nov2019 | 663. | 663 2753 17nov2019 | 664. | 664 3854 18nov2019 | 665. | 665 2182 19nov2019 | 666. | 666 5275 20nov2019 | 667. | 667 5412 21nov2019 | 668. | 668 1660 22nov2019 | 669. | 669 1153 23nov2019 | 677. | 677 1466 01dec2019 | +-------------------------+
Only 16 of them occured in 2019. See details in the list of outliers above.
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 27, 2019, 02:12:15 AM |
|
During the period from 24/1/2018 to 16/12/2019 (last two days dropped due to incomplete week), the minimum and maximum of intra-day merit are 295 and 13018, on 03/8/2019 and 24/1/2018, respectively. List of the top 50-highest day in terms of intra-day merits: +-------------------------------------------------------------------------------+ | merit id date dofw day month2 year week month | |-------------------------------------------------------------------------------| 1. | 13018 1 24jan2018 Wednesday 24 1 2018 2018w4 2018m1 | 2. | 6762 2 25jan2018 Thursday 25 1 2018 2018w4 2018m1 | 3. | 5412 667 21nov2019 Thursday 21 11 2019 2019w47 2019m11 | 4. | 5275 666 20nov2019 Wednesday 20 11 2019 2019w47 2019m11 | 5. | 4500 3 26jan2018 Friday 26 1 2018 2018w4 2018m1 | |-------------------------------------------------------------------------------| 6. | 4193 7 30jan2018 Tuesday 30 1 2018 2018w5 2018m1 | 7. | 3854 664 18nov2019 Monday 18 11 2019 2019w46 2019m11 | 8. | 3800 6 29jan2018 Monday 29 1 2018 2018w5 2018m1 | 9. | 3490 4 27jan2018 Saturday 27 1 2018 2018w4 2018m1 | 10. | 3190 5 28jan2018 Sunday 28 1 2018 2018w4 2018m1 | |-------------------------------------------------------------------------------| 11. | 2821 8 31jan2018 Wednesday 31 1 2018 2018w5 2018m1 | 12. | 2753 663 17nov2019 Sunday 17 11 2019 2019w46 2019m11 | 13. | 2569 10 02feb2018 Friday 2 2 2018 2018w5 2018m2 | 14. | 2546 9 01feb2018 Thursday 1 2 2018 2018w5 2018m2 | 15. | 2514 22 14feb2018 Wednesday 14 2 2018 2018w7 2018m2 | |-------------------------------------------------------------------------------| 16. | 2510 660 14nov2019 Thursday 14 11 2019 2019w46 2019m11 | 17. | 2464 236 16sep2018 Sunday 16 9 2018 2018w37 2018m9 | 18. | 2310 14 06feb2018 Tuesday 6 2 2018 2018w6 2018m2 | 19. | 2182 12 04feb2018 Sunday 4 2 2018 2018w5 2018m2 | 20. | 2182 665 19nov2019 Tuesday 19 11 2019 2019w47 2019m11 | |-------------------------------------------------------------------------------| 21. | 2143 16 08feb2018 Thursday 8 2 2018 2018w6 2018m2 | 22. | 2142 15 07feb2018 Wednesday 7 2 2018 2018w6 2018m2 | 23. | 2078 13 05feb2018 Monday 5 2 2018 2018w6 2018m2 | 24. | 1992 23 15feb2018 Thursday 15 2 2018 2018w7 2018m2 | 25. | 1868 11 03feb2018 Saturday 3 2 2018 2018w5 2018m2 | |-------------------------------------------------------------------------------| 26. | 1863 237 17sep2018 Monday 17 9 2018 2018w38 2018m9 | 27. | 1748 18 10feb2018 Saturday 10 2 2018 2018w6 2018m2 | 28. | 1706 38 02mar2018 Friday 2 3 2018 2018w9 2018m3 | 29. | 1660 668 22nov2019 Friday 22 11 2019 2019w47 2019m11 | 30. | 1618 25 17feb2018 Saturday 17 2 2018 2018w7 2018m2 | |-------------------------------------------------------------------------------| 31. | 1580 21 13feb2018 Tuesday 13 2 2018 2018w7 2018m2 | 32. | 1542 661 15nov2019 Friday 15 11 2019 2019w46 2019m11 | 33. | 1476 659 13nov2019 Wednesday 13 11 2019 2019w46 2019m11 | 34. | 1466 677 01dec2019 Sunday 1 12 2019 2019w48 2019m12 | 35. | 1449 17 09feb2018 Friday 9 2 2018 2018w6 2018m2 | |-------------------------------------------------------------------------------| 36. | 1443 19 11feb2018 Sunday 11 2 2018 2018w6 2018m2 | 37. | 1441 662 16nov2019 Saturday 16 11 2019 2019w46 2019m11 | 38. | 1416 24 16feb2018 Friday 16 2 2018 2018w7 2018m2 | 39. | 1410 32 24feb2018 Saturday 24 2 2018 2018w8 2018m2 | 40. | 1404 27 19feb2018 Monday 19 2 2018 2018w8 2018m2 | |-------------------------------------------------------------------------------| 41. | 1392 34 26feb2018 Monday 26 2 2018 2018w9 2018m2 | 42. | 1355 48 12mar2018 Monday 12 3 2018 2018w11 2018m3 | 43. | 1335 37 01mar2018 Thursday 1 3 2018 2018w9 2018m3 | 44. | 1332 20 12feb2018 Monday 12 2 2018 2018w7 2018m2 | 45. | 1327 35 27feb2018 Tuesday 27 2 2018 2018w9 2018m2 | |-------------------------------------------------------------------------------| 46. | 1324 56 20mar2018 Tuesday 20 3 2018 2018w12 2018m3 | 47. | 1295 238 18sep2018 Tuesday 18 9 2018 2018w38 2018m9 | 48. | 1293 26 18feb2018 Sunday 18 2 2018 2018w7 2018m2 | 49. | 1280 30 22feb2018 Thursday 22 2 2018 2018w8 2018m2 | 50. | 1271 239 19sep2018 Wednesday 19 9 2018 2018w38 2018m9 | |-------------------------------------------------------------------------------|
List of the top 50-lowest days in terms of intra-day merits: +-------------------------------------------------------------------------------+ | merit id date dofw day month2 year week month | |-------------------------------------------------------------------------------| 1. | 295 557 03aug2019 Saturday 3 8 2019 2019w31 2019m8 | 2. | 313 335 24dec2018 Monday 24 12 2018 2018w52 2018m12 | 3. | 317 333 22dec2018 Saturday 22 12 2018 2018w51 2018m12 | 4. | 328 564 10aug2019 Saturday 10 8 2019 2019w32 2019m8 | 5. | 344 340 29dec2018 Saturday 29 12 2018 2018w52 2018m12 | |-------------------------------------------------------------------------------| 6. | 348 338 27dec2018 Thursday 27 12 2018 2018w52 2018m12 | 7. | 348 298 17nov2018 Saturday 17 11 2018 2018w46 2018m11 | 8. | 349 304 23nov2018 Friday 23 11 2018 2018w47 2018m11 | 9. | 368 566 12aug2019 Monday 12 8 2019 2019w32 2019m8 | 10. | 371 122 25may2018 Friday 25 5 2018 2018w21 2018m5 | |-------------------------------------------------------------------------------| 11. | 377 342 31dec2018 Monday 31 12 2018 2018w52 2018m12 | 12. | 377 191 02aug2018 Thursday 2 8 2018 2018w31 2018m8 | 13. | 379 326 15dec2018 Saturday 15 12 2018 2018w50 2018m12 | 14. | 380 220 31aug2018 Friday 31 8 2018 2018w35 2018m8 | 15. | 382 599 14sep2019 Saturday 14 9 2019 2019w37 2019m9 | |-------------------------------------------------------------------------------| 16. | 384 217 28aug2018 Tuesday 28 8 2018 2018w35 2018m8 | 17. | 386 214 25aug2018 Saturday 25 8 2018 2018w34 2018m8 | 18. | 387 339 28dec2018 Friday 28 12 2018 2018w52 2018m12 | 19. | 394 341 30dec2018 Sunday 30 12 2018 2018w52 2018m12 | 20. | 394 568 14aug2019 Wednesday 14 8 2019 2019w33 2019m8 | |-------------------------------------------------------------------------------| 21. | 395 345 03jan2019 Thursday 3 1 2019 2019w1 2019m1 | 22. | 395 529 06jul2019 Saturday 6 7 2019 2019w27 2019m7 | 23. | 396 228 08sep2018 Saturday 8 9 2018 2018w36 2018m9 | 24. | 398 320 09dec2018 Sunday 9 12 2018 2018w49 2018m12 | 25. | 399 558 04aug2019 Sunday 4 8 2019 2019w31 2019m8 | |-------------------------------------------------------------------------------| 26. | 400 262 12oct2018 Friday 12 10 2018 2018w41 2018m10 | 27. | 403 329 18dec2018 Tuesday 18 12 2018 2018w51 2018m12 | 28. | 406 287 06nov2018 Tuesday 6 11 2018 2018w45 2018m11 | 29. | 407 556 02aug2019 Friday 2 8 2019 2019w31 2019m8 | 30. | 411 565 11aug2019 Sunday 11 8 2019 2019w32 2019m8 | |-------------------------------------------------------------------------------| 31. | 413 222 02sep2018 Sunday 2 9 2018 2018w35 2018m9 | 32. | 413 403 02mar2019 Saturday 2 3 2019 2019w9 2019m3 | 33. | 414 527 04jul2019 Thursday 4 7 2019 2019w27 2019m7 | 34. | 416 278 28oct2018 Sunday 28 10 2018 2018w43 2018m10 | 35. | 416 588 03sep2019 Tuesday 3 9 2019 2019w36 2019m9 | |-------------------------------------------------------------------------------| 36. | 416 533 10jul2019 Wednesday 10 7 2019 2019w28 2019m7 | 37. | 417 592 07sep2019 Saturday 7 9 2019 2019w36 2019m9 | 38. | 417 109 12may2018 Saturday 12 5 2018 2018w19 2018m5 | 39. | 417 587 02sep2019 Monday 2 9 2019 2019w35 2019m9 | 40. | 419 186 28jul2018 Saturday 28 7 2018 2018w30 2018m7 | |-------------------------------------------------------------------------------| 41. | 421 187 29jul2018 Sunday 29 7 2018 2018w30 2018m7 | 42. | 422 192 03aug2018 Friday 3 8 2018 2018w31 2018m8 | 43. | 425 276 26oct2018 Friday 26 10 2018 2018w43 2018m10 | 44. | 427 140 12jun2018 Tuesday 12 6 2018 2018w24 2018m6 | 45. | 427 277 27oct2018 Saturday 27 10 2018 2018w43 2018m10 | |-------------------------------------------------------------------------------| 46. | 429 418 17mar2019 Sunday 17 3 2019 2019w11 2019m3 | 47. | 429 313 02dec2018 Sunday 2 12 2018 2018w48 2018m12 | 48. | 431 284 03nov2018 Saturday 3 11 2018 2018w44 2018m11 | 49. | 431 264 14oct2018 Sunday 14 10 2018 2018w41 2018m10 | 50. | 433 208 19aug2018 Sunday 19 8 2018 2018w33 2018m8 | |-------------------------------------------------------------------------------|
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 27, 2019, 02:17:20 AM Last edit: December 27, 2019, 02:50:40 AM by tranthidung |
|
Medians and means of intra-day merits over days of weeks.Colors: - Green: highest.
- Red: Lowest.
- In median, the highest days are Monday, Thursday, and Wednesday at 685, 674, and 667, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 596, 614, and 625, respectively. - In means, the highest days are Wednesday, Thursday, and Monday at 930, 853, and 813, respectively; whilst the lowest days are Saturday, Friday, and Sunday, at 695, 705, and 752, respectively. Calendar day is in GMT time.To take away all doubt: the first Merit was this one: 1516831941 1 2818066.msg28853325 35 877396 Use EpochConverter to convert 1516831941 (Unix Time) to GMT: Wednesday 24 January 2018 22:12:21. Basic statistics:Summary for variables: merit by categories of: dofw
dofw | N mean sd p50 p25 p75 min max ----------+-------------------------------------------------------------------------------- Sunday | 99.0 751.9 455.9 625.0 517.0 797.0 394.0 3190.0 Monday | 99.0 812.7 521.6 685.0 574.0 865.0 313.0 3854.0 Tuesday | 98.0 764.1 462.5 659.5 592.0 761.0 384.0 4193.0 Wednesday | 99.0 929.3 1360.4 667.0 563.0 788.0 394.0 13018.0 Thursday | 99.0 853.8 846.7 674.0 550.0 811.0 348.0 6762.0 Friday | 99.0 704.8 500.2 596.0 508.0 713.0 349.0 4500.0 Saturday | 99.0 694.6 404.2 614.0 486.0 724.0 295.0 3490.0 ----------+-------------------------------------------------------------------------------- Total | 692.0 787.3 725.9 642.5 538.5 778.0 295.0 13018.0 -------------------------------------------------------------------------------------------
Box plotsOutliers displayed as red circles. Outliers non-displayed. Details on ranks:In medians +----------------------------------------------------------------------+ | rankmedian dofw median mean p25 p75 min max | |----------------------------------------------------------------------| 1. | 1 Monday 685 812.7475 574 865 313 3854 | 2. | 2 Thursday 674 853.7778 550 811 348 6762 | 3. | 3 Wednesday 667 929.2525 563 788 394 13018 | 4. | 4 Tuesday 659.5 764.051 592 761 384 4193 | 5. | 5 Sunday 625 751.8687 517 797 394 3190 | |----------------------------------------------------------------------| 6. | 6 Saturday 614 694.5555 486 724 295 3490 | 7. | 7 Friday 596 704.7778 508 713 349 4500 | +----------------------------------------------------------------------+
In means +--------------------------------------------------------------------+ | rankmean dofw mean median p25 p75 min max | |--------------------------------------------------------------------| 1. | 1 Wednesday 929.2525 667 563 788 394 13018 | 2. | 2 Thursday 853.7778 674 550 811 348 6762 | 3. | 3 Monday 812.7475 685 574 865 313 3854 | 4. | 4 Tuesday 764.051 659.5 592 761 384 4193 | 5. | 5 Sunday 751.8687 625 517 797 394 3190 | |--------------------------------------------------------------------| 6. | 6 Friday 704.7778 596 508 713 349 4500 | 7. | 7 Saturday 694.5555 614 486 724 295 3490 | +--------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 27, 2019, 02:25:00 AM Last edit: December 27, 2019, 03:49:16 AM by tranthidung |
|
Intra-week merits (from 24/1/2018 to 16/12/2019)Last two days dropped due to incomplete weeks (2019w51)Converted dataset: +-----------------+ | merit week | |-----------------| 1. | 11180 2018w4 | 2. | 19979 2018w5 | 3. | 13313 2018w6 | 4. | 11745 2018w7 | 5. | 8767 2018w8 | |-----------------| 6. | 8833 2018w9 | 7. | 7261 2018w10 | 8. | 7317 2018w11 | 9. | 6952 2018w12 | 10. | 6744 2018w13 | |-----------------| 11. | 6423 2018w14 | 12. | 5494 2018w15 | 13. | 4742 2018w16 | 14. | 4612 2018w17 | 15. | 4965 2018w18 | |-----------------| 16. | 4766 2018w19 | 17. | 4353 2018w20 | 18. | 3864 2018w21 | 19. | 4194 2018w22 | 20. | 4538 2018w23 | |-----------------| 21. | 3839 2018w24 | 22. | 4929 2018w25 | 23. | 4465 2018w26 | 24. | 4278 2018w27 | 25. | 4247 2018w28 | |-----------------| 26. | 4167 2018w29 | 27. | 3661 2018w30 | 28. | 3863 2018w31 | 29. | 4011 2018w32 | 30. | 3631 2018w33 | |-----------------| 31. | 3805 2018w34 | 32. | 3072 2018w35 | 33. | 3590 2018w36 | 34. | 5644 2018w37 | 35. | 7837 2018w38 | |-----------------| 36. | 4395 2018w39 | 37. | 4310 2018w40 | 38. | 3816 2018w41 | 39. | 4829 2018w42 | 40. | 3953 2018w43 | |-----------------| 41. | 3347 2018w44 | 42. | 4525 2018w45 | 43. | 3747 2018w46 | 44. | 4575 2018w47 | 45. | 3765 2018w48 | |-----------------| 46. | 3571 2018w49 | 47. | 3805 2018w50 | 48. | 3769 2018w51 | 49. | 3338 2018w52 | 50. | 4803 2019w1 | |-----------------| 51. | 6632 2019w2 | 52. | 5317 2019w3 | 53. | 4667 2019w4 | 54. | 4491 2019w5 | 55. | 4332 2019w6 | |-----------------| 56. | 4221 2019w7 | 57. | 4521 2019w8 | 58. | 4638 2019w9 | 59. | 4913 2019w10 | 60. | 4326 2019w11 | |-----------------| 61. | 4609 2019w12 | 62. | 6130 2019w13 | 63. | 4526 2019w14 | 64. | 5271 2019w15 | 65. | 4688 2019w16 | |-----------------| 66. | 4448 2019w17 | 67. | 4764 2019w18 | 68. | 5454 2019w19 | 69. | 5214 2019w20 | 70. | 4580 2019w21 | |-----------------| 71. | 4445 2019w22 | 72. | 4687 2019w23 | 73. | 5354 2019w24 | 74. | 4726 2019w25 | 75. | 4367 2019w26 | |-----------------| 76. | 4225 2019w27 | 77. | 4119 2019w28 | 78. | 4277 2019w29 | 79. | 4176 2019w30 | 80. | 3549 2019w31 | |-----------------| 81. | 3207 2019w32 | 82. | 4236 2019w33 | 83. | 3622 2019w34 | 84. | 3540 2019w35 | 85. | 3809 2019w36 | |-----------------| 86. | 4043 2019w37 | 87. | 4520 2019w38 | 88. | 4318 2019w39 | 89. | 4357 2019w40 | 90. | 4565 2019w41 | |-----------------| 91. | 5542 2019w42 | 92. | 4975 2019w43 | 93. | 4730 2019w44 | 94. | 4735 2019w45 | 95. | 14251 2019w46 | |-----------------| 96. | 17685 2019w47 | 97. | 5907 2019w48 | 98. | 4524 2019w49 | 99. | 5186 2019w50 | +-----------------+
Time series plotBasic statistics:- 50% of observed weeks ( 99 weeks) have total intra-week merits above 4525, whilst the rest 50% of them have total intra-week merits below 4525. 4525 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 4119 to 5214 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3072 - 30960. variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 99.0 5503.3 3717.4 4525.0 4119.0 5214.0 3072.0 30960.0 ----------------------------------------------------------------------------------------------
Potential outliers:. di 5214-4119 1095
. di 1095*1.5 1642.5
. di 5214+1642.5 6856.5
. di 4119-1642.5 2476.5
It means that potential outliers are weeks that have intra-week merits beyond 2477 or 6857. How many weeks are potential outliers? . count if (merit >= 6857 | merit < 2477) & merit != . 12
12 weeks are outliers, in total. List of those 12 weeks: +-----------------+ | merit week | |-----------------| 1. | 30960 2018w4 | 2. | 19979 2018w5 | 3. | 13313 2018w6 | 4. | 11745 2018w7 | 5. | 8767 2018w8 | |-----------------| 6. | 8833 2018w9 | 7. | 7261 2018w10 | 8. | 7317 2018w11 | 9. | 6952 2018w12 | 35. | 7837 2018w38 | |-----------------| 95. | 14251 2019w46 | 96. | 17685 2019w47 | +-----------------+
Most of them occured in the year 2018, and there is only two outliers week occured in 2019, in 2019w46 (14251), 2019w47 ( 17685). List of weeks in descending weekly meritsThe last week stays at the 26th position, among 99 weeks. +------------------------------+ | weeklyrank merit week | |------------------------------| 1. | 1 30960 2018w4 | 2. | 2 19979 2018w5 | 3. | 3 17685 2019w47 | 4. | 4 14251 2019w46 | 5. | 5 13313 2018w6 | |------------------------------| 6. | 6 11745 2018w7 | 7. | 7 8833 2018w9 | 8. | 8 8767 2018w8 | 9. | 9 7837 2018w38 | 10. | 10 7317 2018w11 | |------------------------------| 11. | 11 7261 2018w10 | 12. | 12 6952 2018w12 | 13. | 13 6744 2018w13 | 14. | 14 6632 2019w2 | 15. | 15 6423 2018w14 | |------------------------------| 16. | 16 6130 2019w13 | 17. | 17 5907 2019w48 | 18. | 18 5644 2018w37 | 19. | 19 5542 2019w42 | 20. | 20 5494 2018w15 | |------------------------------| 21. | 21 5454 2019w19 | 22. | 22 5354 2019w24 | 23. | 23 5317 2019w3 | 24. | 24 5271 2019w15 | 25. | 25 5214 2019w20 | |------------------------------| 26. | 26 5186 2019w50 | 27. | 27 4975 2019w43 | 28. | 28 4965 2018w18 | 29. | 29 4929 2018w25 | 30. | 30 4913 2019w10 | |------------------------------| 31. | 31 4829 2018w42 | 32. | 32 4803 2019w1 | 33. | 33 4766 2018w19 | 34. | 34 4764 2019w18 | 35. | 35 4742 2018w16 | |------------------------------| 36. | 36 4735 2019w45 | 37. | 37 4730 2019w44 | 38. | 38 4726 2019w25 | 39. | 39 4688 2019w16 | 40. | 40 4687 2019w23 | |------------------------------| 41. | 41 4667 2019w4 | 42. | 42 4638 2019w9 | 43. | 43 4612 2018w17 | 44. | 44 4609 2019w12 | 45. | 45 4580 2019w21 | |------------------------------| 46. | 46 4575 2018w47 | 47. | 47 4565 2019w41 | 48. | 48 4538 2018w23 | 49. | 49 4526 2019w14 | 50. | 50 4525 2018w45 | |------------------------------| 51. | 51 4524 2019w49 | 52. | 52 4521 2019w8 | 53. | 53 4520 2019w38 | 54. | 54 4491 2019w5 | 55. | 55 4465 2018w26 | |------------------------------| 56. | 56 4448 2019w17 | 57. | 57 4445 2019w22 | 58. | 58 4395 2018w39 | 59. | 59 4367 2019w26 | 60. | 60 4357 2019w40 | |------------------------------| 61. | 61 4353 2018w20 | 62. | 62 4332 2019w6 | 63. | 63 4326 2019w11 | 64. | 64 4318 2019w39 | 65. | 65 4310 2018w40 | |------------------------------| 66. | 66 4278 2018w27 | 67. | 67 4277 2019w29 | 68. | 68 4247 2018w28 | 69. | 69 4236 2019w33 | 70. | 70 4225 2019w27 | |------------------------------| 71. | 71 4221 2019w7 | 72. | 72 4194 2018w22 | 73. | 73 4176 2019w30 | 74. | 74 4167 2018w29 | 75. | 75 4119 2019w28 | |------------------------------| 76. | 76 4043 2019w37 | 77. | 77 4011 2018w32 | 78. | 78 3953 2018w43 | 79. | 79 3864 2018w21 | 80. | 80 3863 2018w31 | |------------------------------| 81. | 81 3839 2018w24 | 82. | 82 3816 2018w41 | 83. | 83 3809 2019w36 | 84. | 84 3805 2018w34 | 85. | 85 3805 2018w50 | |------------------------------| 86. | 86 3769 2018w51 | 87. | 87 3765 2018w48 | 88. | 88 3747 2018w46 | 89. | 89 3661 2018w30 | 90. | 90 3631 2018w33 | |------------------------------| 91. | 91 3622 2019w34 | 92. | 92 3590 2018w36 | 93. | 93 3571 2018w49 | 94. | 94 3549 2019w31 | 95. | 95 3540 2019w35 | |------------------------------| 96. | 96 3347 2018w44 | 97. | 97 3338 2018w52 | 98. | 98 3207 2019w32 | 99. | 99 3072 2018w35 | +------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 27, 2019, 02:29:24 AM |
|
ABSTRACT 2019w50Data is the full dataset since 24/1/2018, and only dropped last two days belong to incomplete week - 2019w51. Details on days dropped, please see above posts. Intra-day merits:(1) Potential outliers are days that have intraday total merits beyond 180 or 1138; (2) Median of intraday merits over the period is 643; (3) 50% of observed days have their intra-day merits range from 539 to 778 (the interquartile range); (4) In GTM time. In medians, the highest and lowest days are Monday and Friday, respectively; whilst the highest and lowest days in means are Wednesday and Saturday, respectively. See here. (5) There are 64 potential outliers (beyond 180 or 1138) in total, and only 16 of them occured in 2019. ( see details). (6) Minimum and maximum of intraday merits (full dataset) are 295, and 13018, on 03/8/2019 and 24/1/2018, respectively. Intra-week merits:99 weeks in total. (1) The median of intra-week merits is 4525; (2) 50% of observed weeks ( 99 weeks in total), have total merits in the range from 4119 to 5214 (the interquartile range of intra-week merits). (3) Minimum and maximum of intra-week merits are 3072 and 30960, in 2018w35, and 2018w4, respectively; (4) 12 potential outliers [beyond 2477 or 6857], only 2 of them occurred in the year 2019, on 2019w46 ( 14251), and 2019w47 ( 17685).
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 30, 2019, 03:11:58 AM |
|
Update 2019w51Data source: http://loyce.club/Merit/tranthidung/meritperdayandweek.2019-12-28_Sat_08.28h.txtConverted dataset for the last week: +-------------------------------------------------------------------------------+ | id merit date day month2 year week month dofw | |-------------------------------------------------------------------------------| 688. | 688 577 12dec2019 12 12 2019 2019w50 2019m12 Thursday | 689. | 689 467 13dec2019 13 12 2019 2019w50 2019m12 Friday | 690. | 690 1013 14dec2019 14 12 2019 2019w50 2019m12 Saturday | 691. | 691 866 15dec2019 15 12 2019 2019w50 2019m12 Sunday | 692. | 692 938 16dec2019 16 12 2019 2019w50 2019m12 Monday | |-------------------------------------------------------------------------------| 693. | 693 920 17dec2019 17 12 2019 2019w51 2019m12 Tuesday | 694. | 694 836 18dec2019 18 12 2019 2019w51 2019m12 Wednesday | 695. | 695 1020 19dec2019 19 12 2019 2019w51 2019m12 Thursday | 696. | 696 692 20dec2019 20 12 2019 2019w51 2019m12 Friday | 697. | 697 723 21dec2019 21 12 2019 2019w51 2019m12 Saturday | |-------------------------------------------------------------------------------| 698. | 698 897 22dec2019 22 12 2019 2019w51 2019m12 Sunday | 699. | 699 1106 23dec2019 23 12 2019 2019w51 2019m12 Monday | 700. | 700 787 24dec2019 24 12 2019 2019w52 2019m12 Tuesday | 701. | 701 797 25dec2019 25 12 2019 2019w52 2019m12 Wednesday | +-------------------------------------------------------------------------------+
For data:
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2310
Merit: 4090
Farewell o_e_l_e_o
|
|
December 31, 2019, 02:30:32 AM |
|
Time-series plots:Full dataset:Truncated dataset: Basic statistics (for full dataset): Only drop last two days that belong to the 2019w51, incomplete week. variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 699 788.3004 722.4836 644 540 780 295 13018 ----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 180 or 1140. . di 780-540 240
. di 240*1.5 360
. di 780+360 1140
. di 540-360 180
There are 63 outliers (beyond 1140 or 180) in full dataset, in total. . count if (merit >= 1140 | merit <= 180) & merit != . 63
Those days are: +-------------------------+ | id merit date | |-------------------------| 1. | 1 13018 24jan2018 | 2. | 2 6762 25jan2018 | 3. | 3 4500 26jan2018 | 4. | 4 3490 27jan2018 | 5. | 5 3190 28jan2018 | 6. | 6 3800 29jan2018 | 7. | 7 4193 30jan2018 | 8. | 8 2821 31jan2018 | 9. | 9 2546 01feb2018 | 10. | 10 2569 02feb2018 | 11. | 11 1868 03feb2018 | 12. | 12 2182 04feb2018 | 13. | 13 2078 05feb2018 | 14. | 14 2310 06feb2018 | 15. | 15 2142 07feb2018 | 16. | 16 2143 08feb2018 | 17. | 17 1449 09feb2018 | 18. | 18 1748 10feb2018 | 19. | 19 1443 11feb2018 | 20. | 20 1332 12feb2018 | 21. | 21 1580 13feb2018 | 22. | 22 2514 14feb2018 | 23. | 23 1992 15feb2018 | 24. | 24 1416 16feb2018 | 25. | 25 1618 17feb2018 | 26. | 26 1293 18feb2018 | 27. | 27 1404 19feb2018 | 28. | 28 1170 20feb2018 | 29. | 29 1268 21feb2018 | 30. | 30 1280 22feb2018 | 32. | 32 1410 24feb2018 | 33. | 33 1187 25feb2018 | 34. | 34 1392 26feb2018 | 35. | 35 1327 27feb2018 | 37. | 37 1335 01mar2018 | 38. | 38 1706 02mar2018 | 41. | 41 1246 05mar2018 | 48. | 48 1355 12mar2018 | 50. | 50 1160 14mar2018 | 56. | 56 1324 20mar2018 | 57. | 57 1229 21mar2018 | 68. | 68 1258 01apr2018 | 69. | 69 1147 02apr2018 | 236. | 236 2464 16sep2018 | 237. | 237 1863 17sep2018 | 238. | 238 1295 18sep2018 | 239. | 239 1271 19sep2018 | |-------------------------| 351. | 351 1162 09jan2019 | 428. | 428 1250 27mar2019 | 475. | 475 1151 13may2019 | 504. | 504 1188 11jun2019 | 659. | 659 1476 13nov2019 | 660. | 660 2510 14nov2019 | 661. | 661 1542 15nov2019 | 662. | 662 1441 16nov2019 | 663. | 663 2753 17nov2019 | 664. | 664 3854 18nov2019 | 665. | 665 2182 19nov2019 | 666. | 666 5275 20nov2019 | 667. | 667 5412 21nov2019 | 668. | 668 1660 22nov2019 | 669. | 669 1153 23nov2019 | 677. | 677 1466 01dec2019 | +-------------------------+
Only 16 of them occured in 2019. See details in the list of outliers above.
|
|
|
|
|