Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly) - page 3.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

ABSTRACT ^{2020w33, GMT time}

Data is the full dataset since 24/1/2018, and only dropped last 3 days belong to incomplete week - 2020w34 and an incomplete day (dayid = 941). Details on days dropped, please see above posts.

Intra-day merits:

Total observed days: 938
Potential outliers are days that have intraday total merits beyond 201 or 1173
Median of intraday merits over the period is 668
50% of observed days have their intra-day merits range from 565 to 808 (the interquartile range)
In medians, the highest and lowest days are Tuesday and Saturday, respectively; whilst the highest and lowest days in means are Thursday and Sunday, respectively. See here.
There are 62 potential outliers (beyond 201 or 1173) in total.
The distribution of outliers over years are: 44 (71.0%) for 2018, 14 (22.6%) for 2019, and 4 (6.4%) for 2020. (see details)
Minimum and maximum of intraday merits (full dataset) are 300, and 12676, on 04/8/2019 and 25/1/2018, respectively.

Intra-week merits:

Total observed weeks: 134
The median of intra-week merits is 4640
50% of observed weeks (134 weeks in total), have total merits in the range from 4248 to 5573 (the interquartile range of intra-week merits).
Minimum and maximum of intra-week merits are 3186 and 27920, in 2018w35, and 2018w4, respectively;
9 potential outliers [beyond 2261 or 7561], only 2 of them occurred in the year 2019, on 2019w46 (11070), and 2019w47 (20397); none of them occured in 2020.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Intra-week merits (from 24/1/2018 to 18/8/2020)
Last 3 days dropped due to incomplete week (2020w34) and an incomplete day (dayid = 941)

Converted dataset:

Code:

+-----------------+
   | merit week |
   |-----------------|
  1. | 27920 2018w4 |
  2. | 20930 2018w5 |
  3. | 14042 2018w6 |
  4. | 11901 2018w7 |
  5. | 8879 2018w8 |
   |-----------------|
  6. | 9005 2018w9 |
  7. | 7178 2018w10 |
  8. | 7340 2018w11 |
  9. | 7138 2018w12 |
10. | 6392 2018w13 |
   |-----------------|
11. | 6542 2018w14 |
12. | 5946 2018w15 |
13. | 4449 2018w16 |
14. | 4820 2018w17 |
15. | 5043 2018w18 |
   |-----------------|
16. | 4685 2018w19 |
17. | 4431 2018w20 |
18. | 3903 2018w21 |
19. | 4248 2018w22 |
20. | 4473 2018w23 |
   |-----------------|
21. | 3953 2018w24 |
22. | 4574 2018w25 |
23. | 4684 2018w26 |
24. | 4367 2018w27 |
25. | 4109 2018w28 |
   |-----------------|
26. | 4277 2018w29 |
27. | 3809 2018w30 |
28. | 3489 2018w31 |
29. | 4199 2018w32 |
30. | 3767 2018w33 |
   |-----------------|
31. | 3763 2018w34 |
32. | 3186 2018w35 |
33. | 3536 2018w36 |
34. | 3586 2018w37 |
35. | 9587 2018w38 |
   |-----------------|
36. | 4508 2018w39 |
37. | 4325 2018w40 |
38. | 3981 2018w41 |
39. | 4424 2018w42 |
40. | 4386 2018w43 |
   |-----------------|
41. | 3321 2018w44 |
42. | 4175 2018w45 |
43. | 4047 2018w46 |
44. | 4606 2018w47 |
45. | 3791 2018w48 |
   |-----------------|
46. | 3596 2018w49 |
47. | 3689 2018w50 |
48. | 3615 2018w51 |
49. | 3687 2018w52 |
50. | 4584 2019w1 |
   |-----------------|
51. | 6102 2019w2 |
52. | 5776 2019w3 |
53. | 4582 2019w4 |
54. | 4408 2019w5 |
55. | 4505 2019w6 |
   |-----------------|
56. | 4259 2019w7 |
57. | 4314 2019w8 |
58. | 4726 2019w9 |
59. | 4979 2019w10 |
60. | 4295 2019w11 |
   |-----------------|
61. | 4690 2019w12 |
62. | 5728 2019w13 |
63. | 4695 2019w14 |
64. | 5253 2019w15 |
65. | 4880 2019w16 |
   |-----------------|
66. | 4260 2019w17 |
67. | 4817 2019w18 |
68. | 5002 2019w19 |
69. | 5596 2019w20 |
70. | 4693 2019w21 |
   |-----------------|
71. | 4342 2019w22 |
72. | 4597 2019w23 |
73. | 5373 2019w24 |
74. | 4629 2019w25 |
75. | 4672 2019w26 |
   |-----------------|
76. | 3882 2019w27 |
77. | 4462 2019w28 |
78. | 4005 2019w29 |
79. | 4377 2019w30 |
80. | 3603 2019w31 |
   |-----------------|
81. | 3346 2019w32 |
82. | 3965 2019w33 |
83. | 3811 2019w34 |
84. | 3579 2019w35 |
85. | 3683 2019w36 |
   |-----------------|
86. | 4005 2019w37 |
87. | 4382 2019w38 |
88. | 4348 2019w39 |
89. | 4209 2019w40 |
90. | 4701 2019w41 |
   |-----------------|
91. | 5160 2019w42 |
92. | 5375 2019w43 |
93. | 4816 2019w44 |
94. | 4753 2019w45 |
95. | 11070 2019w46 |
   |-----------------|
96. | 20397 2019w47 |
97. | 6271 2019w48 |
98. | 4650 2019w49 |
99. | 4832 2019w50 |
100. | 6066 2019w51 |
   |-----------------|
101. | 7058 2019w52 |
102. | 5745 2020w1 |
103. | 5395 2020w2 |
104. | 7247 2020w3 |
105. | 6646 2020w4 |
   |-----------------|
106. | 6756 2020w5 |
107. | 5573 2020w6 |
108. | 6923 2020w7 |
109. | 6314 2020w8 |
110. | 5237 2020w9 |
   |-----------------|
111. | 4622 2020w10 |
112. | 5109 2020w11 |
113. | 5603 2020w12 |
114. | 5392 2020w13 |
115. | 6061 2020w14 |
   |-----------------|
116. | 5094 2020w15 |
117. | 5052 2020w16 |
118. | 4539 2020w17 |
119. | 5699 2020w18 |
120. | 5648 2020w19 |
   |-----------------|
121. | 5802 2020w20 |
122. | 5334 2020w21 |
123. | 4662 2020w22 |
124. | 4676 2020w23 |
125. | 4190 2020w24 |
   |-----------------|
126. | 4366 2020w25 |
127. | 4474 2020w26 |
128. | 4630 2020w27 |
129. | 4673 2020w28 |
130. | 4485 2020w29 |
   |-----------------|
131. | 4518 2020w30 |
132. | 4963 2020w31 |
133. | 4074 2020w32 |
134. | 3986 2020w33 |
   +-----------------+

Time series plot

Basic statistics:
- 50% of observed weeks (134 weeks) have total intra-week merits above 4640, whilst the rest 50% of them have total intra-week merits below 4640. 4640 is the median - p50.
- 50% of observed weeks have total intra-week merits fluctuated in the range from 4248 to 5573 (the interquartile range, from p25 to p75, in raw statistics below).
- Min - max: 3186 - 27920.

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 134.0 5450.4 3150.4 4640.0 4248.0 5573.0 3186.0 27920.0
----------------------------------------------------------------------------------------------

Potential outliers:

Code:

. di 5573-4248
1325

. di 1325*1.5
1987.5

. di 5573+1987.5
7560.5

. di 4248-1987.5
2260.5

It means that potential outliers are weeks that have intra-week merits beyond 2261 or 7561.
How many weeks are potential outliers?

Code:

. count if (merit >= 7561 | merit < 2261) & merit != .
9

9 weeks are outliers, in total.
List of those 9 weeks:

Code:

+-----------------+
   | merit week |
   |-----------------|
  1. | 27920 2018w4 |
  2. | 20930 2018w5 |
  3. | 14042 2018w6 |
  4. | 11901 2018w7 |
  5. | 8879 2018w8 |
   |-----------------|
  6. | 9005 2018w9 |
35. | 9587 2018w38 |
95. | 11070 2019w46 |
96. | 20397 2019w47 |
   +-----------------+

Most of them occured in the year 2018, and there is only 2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 (20397). None of them occured in 2020 so far.

List of weeks in descending weekly merits
The last week (with 3986 merits) stays at the 111^th position, among 134 weeks.

Code:

+------------------------------+
   | weeklyrank merit week |
   |------------------------------|
  1. | 1 27920 2018w4 |
  2. | 2 20930 2018w5 |
  3. | 3 20397 2019w47 |
  4. | 4 14042 2018w6 |
  5. | 5 11901 2018w7 |
   |------------------------------|
  6. | 6 11070 2019w46 |
  7. | 7 9587 2018w38 |
  8. | 8 9005 2018w9 |
  9. | 9 8879 2018w8 |
10. | 10 7340 2018w11 |
   |------------------------------|
11. | 11 7247 2020w3 |
12. | 12 7178 2018w10 |
13. | 13 7138 2018w12 |
14. | 14 7058 2019w52 |
15. | 15 6923 2020w7 |
   |------------------------------|
16. | 16 6756 2020w5 |
17. | 17 6646 2020w4 |
18. | 18 6542 2018w14 |
19. | 19 6392 2018w13 |
20. | 20 6314 2020w8 |
   |------------------------------|
21. | 21 6271 2019w48 |
22. | 22 6102 2019w2 |
23. | 23 6066 2019w51 |
24. | 24 6061 2020w14 |
25. | 25 5946 2018w15 |
   |------------------------------|
26. | 26 5802 2020w20 |
27. | 27 5776 2019w3 |
28. | 28 5745 2020w1 |
29. | 29 5728 2019w13 |
30. | 30 5699 2020w18 |
   |------------------------------|
31. | 31 5648 2020w19 |
32. | 32 5603 2020w12 |
33. | 33 5596 2019w20 |
34. | 34 5573 2020w6 |
35. | 35 5395 2020w2 |
   |------------------------------|
36. | 36 5392 2020w13 |
37. | 37 5375 2019w43 |
38. | 38 5373 2019w24 |
39. | 39 5334 2020w21 |
40. | 40 5253 2019w15 |
   |------------------------------|
41. | 41 5237 2020w9 |
42. | 42 5160 2019w42 |
43. | 43 5109 2020w11 |
44. | 44 5094 2020w15 |
45. | 45 5052 2020w16 |
   |------------------------------|
46. | 46 5043 2018w18 |
47. | 47 5002 2019w19 |
48. | 48 4979 2019w10 |
49. | 49 4963 2020w31 |
50. | 50 4880 2019w16 |
   |------------------------------|
51. | 51 4832 2019w50 |
52. | 52 4820 2018w17 |
53. | 53 4817 2019w18 |
54. | 54 4816 2019w44 |
55. | 55 4753 2019w45 |
   |------------------------------|
56. | 56 4726 2019w9 |
57. | 57 4701 2019w41 |
58. | 58 4695 2019w14 |
59. | 59 4693 2019w21 |
60. | 60 4690 2019w12 |
   |------------------------------|
61. | 61 4685 2018w19 |
62. | 62 4684 2018w26 |
63. | 63 4676 2020w23 |
64. | 64 4673 2020w28 |
65. | 65 4672 2019w26 |
   |------------------------------|
66. | 66 4662 2020w22 |
67. | 67 4650 2019w49 |
68. | 68 4630 2020w27 |
69. | 69 4629 2019w25 |
70. | 70 4622 2020w10 |
   |------------------------------|
71. | 71 4606 2018w47 |
72. | 72 4597 2019w23 |
73. | 73 4584 2019w1 |
74. | 74 4582 2019w4 |
75. | 75 4574 2018w25 |
   |------------------------------|
76. | 76 4539 2020w17 |
77. | 77 4518 2020w30 |
78. | 78 4508 2018w39 |
79. | 79 4505 2019w6 |
80. | 80 4485 2020w29 |
   |------------------------------|
81. | 81 4474 2020w26 |
82. | 82 4473 2018w23 |
83. | 83 4462 2019w28 |
84. | 84 4449 2018w16 |
85. | 85 4431 2018w20 |
   |------------------------------|
86. | 86 4424 2018w42 |
87. | 87 4408 2019w5 |
88. | 88 4386 2018w43 |
89. | 89 4382 2019w38 |
90. | 90 4377 2019w30 |
   |------------------------------|
91. | 91 4367 2018w27 |
92. | 92 4366 2020w25 |
93. | 93 4348 2019w39 |
94. | 94 4342 2019w22 |
95. | 95 4325 2018w40 |
   |------------------------------|
96. | 96 4314 2019w8 |
97. | 97 4295 2019w11 |
98. | 98 4277 2018w29 |
99. | 99 4260 2019w17 |
100. | 100 4259 2019w7 |
   |------------------------------|
101. | 101 4248 2018w22 |
102. | 102 4209 2019w40 |
103. | 103 4199 2018w32 |
104. | 104 4190 2020w24 |
105. | 105 4175 2018w45 |
   |------------------------------|
106. | 106 4109 2018w28 |
107. | 107 4074 2020w32 |
108. | 108 4047 2018w46 |
109. | 109 4005 2019w37 |
110. | 110 4005 2019w29 |
   |------------------------------|
111. | 111 3986 2020w33 |
112. | 112 3981 2018w41 |
113. | 113 3965 2019w33 |
114. | 114 3953 2018w24 |
115. | 115 3903 2018w21 |
   |------------------------------|
116. | 116 3882 2019w27 |
117. | 117 3811 2019w34 |
118. | 118 3809 2018w30 |
119. | 119 3791 2018w48 |
120. | 120 3767 2018w33 |
   |------------------------------|
121. | 121 3763 2018w34 |
122. | 122 3689 2018w50 |
123. | 123 3687 2018w52 |
124. | 124 3683 2019w36 |
125. | 125 3615 2018w51 |
   |------------------------------|
126. | 126 3603 2019w31 |
127. | 127 3596 2018w49 |
128. | 128 3586 2018w37 |
129. | 129 3579 2019w35 |
130. | 130 3536 2018w36 |
   |------------------------------|
131. | 131 3489 2018w31 |
132. | 132 3346 2019w32 |
133. | 133 3321 2018w44 |
134. | 134 3186 2018w35 |
   +------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Medians and means of intra-day merits over days of weeks ^{GMT time}
Colors:

Green: highest.
Red: Lowest.

- In median, the highest days are Tuesday, Friday, and Thursday at 700, 696, and 696, respectively; whislt the lowest days are Saturday, Sunday, and Monday at 607, 630, and 662, respectively.
- In means, the highest days are Thursday, Friday, and Tuesday at 885, 838, and 795, respectively; whilst the lowest days are Sunday, Saturday, and Monday, at 692, 697, and 772, respectively.

Basic statistics:

Code:

Summary for variables: merit
   by categories of: dofw

   dofw | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
   Sunday | 134.0 691.2 339.8 629.5 505.0 739.0 300.0 3240.0
   Monday | 134.0 772.0 413.4 662.0 584.0 846.0 370.0 3343.0
  Tuesday | 134.0 794.4 452.7 700.0 592.0 825.0 339.0 3826.0
Wednesday | 134.0 774.5 411.3 685.5 603.0 824.0 347.0 4103.0
Thursday | 134.0 884.5 1138.9 695.5 587.0 824.0 411.0 12676.0
   Friday | 134.0 837.5 709.6 696.0 577.0 828.0 373.0 6348.0
Saturday | 134.0 696.4 440.7 606.5 503.0 736.0 375.0 4627.0
----------+--------------------------------------------------------------------------------
   Total | 938.0 778.6 617.4 668.0 565.0 808.0 300.0 12676.0
-------------------------------------------------------------------------------------------

Box plots
Outliers non-displayed.

Details on ranks:
In medians

Code:

+----------------------------------------------------------------------+
   | rankmedian dofw median mean p25 p75 min max |
   |----------------------------------------------------------------------|
  1. | 1 Tuesday 700 794.3657 592 825 339 3826 |
  2. | 2 Friday 696 837.5074 577 828 373 6348 |
  3. | 3 Thursday 695.5 884.5373 587 824 411 12676 |
  4. | 4 Wednesday 685.5 774.4702 603 824 347 4103 |
  5. | 5 Monday 662 771.9627 584 846 370 3343 |
   |----------------------------------------------------------------------|
  6. | 6 Sunday 629.5 691.1716 505 739 300 3240 |
  7. | 7 Saturday 606.5 696.3806 503 736 375 4627 |
   +----------------------------------------------------------------------+

In means

Code:

+--------------------------------------------------------------------+
   | rankmean dofw mean median p25 p75 min max |
   |--------------------------------------------------------------------|
  1. | 1 Thursday 884.5373 695.5 587 824 411 12676 |
  2. | 2 Friday 837.5074 696 577 828 373 6348 |
  3. | 3 Tuesday 794.3657 700 592 825 339 3826 |
  4. | 4 Wednesday 774.4702 685.5 603 824 347 4103 |
  5. | 5 Monday 771.9627 662 584 846 370 3343 |
   |--------------------------------------------------------------------|
  6. | 6 Saturday 696.3806 606.5 503 736 375 4627 |
  7. | 7 Sunday 691.1716 629.5 505 739 300 3240 |
   +--------------------------------------------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

During the period from 24/1/2018 to 18/8/2020 (last 3 days dropped due to incomplete week, 2020w34 and an incomplete day - dayid = 941), the minimum and maximum of intra-day merit are 300 and 12676, on 04/8/2019 and 25/1/2018, respectively.

List of the top 50-highest day in terms of intra-day merits:

Code:

+-----------------------------------------------------------------------------+
   | rank_max merit dayid date dofw week month year |
   |-----------------------------------------------------------------------------|
  1. | 1 12676 2 25jan2018 Thursday 2018w4 2018m1 2018 |
  2. | 2 6348 3 26jan2018 Friday 2018w4 2018m1 2018 |
  3. | 3 5515 668 22nov2019 Friday 2019w47 2019m11 2019 |
  4. | 4 4889 667 21nov2019 Thursday 2019w47 2019m11 2019 |
  5. | 5 4627 4 27jan2018 Saturday 2018w4 2018m1 2018 |
   |-----------------------------------------------------------------------------|
  6. | 6 4103 8 31jan2018 Wednesday 2018w5 2018m1 2018 |
  7. | 7 3826 665 19nov2019 Tuesday 2019w47 2019m11 2019 |
  8. | 8 3804 7 30jan2018 Tuesday 2018w5 2018m1 2018 |
  9. | 9 3343 6 29jan2018 Monday 2018w5 2018m1 2018 |
10. | 10 3240 5 28jan2018 Sunday 2018w4 2018m1 2018 |
   |-----------------------------------------------------------------------------|
11. | 11 2797 23 15feb2018 Thursday 2018w7 2018m2 2018 |
12. | 12 2793 9 01feb2018 Thursday 2018w5 2018m2 2018 |
13. | 13 2783 664 18nov2019 Monday 2019w46 2019m11 2019 |
14. | 14 2621 10 02feb2018 Friday 2018w5 2018m2 2018 |
15. | 15 2584 666 20nov2019 Wednesday 2019w47 2019m11 2019 |
   |-----------------------------------------------------------------------------|
16. | 16 2553 237 17sep2018 Monday 2018w38 2018m9 2018 |
17. | 17 2476 11 03feb2018 Saturday 2018w5 2018m2 2018 |
18. | 18 2374 661 15nov2019 Friday 2019w46 2019m11 2019 |
19. | 19 2366 15 07feb2018 Wednesday 2018w6 2018m2 2018 |
20. | 20 2263 13 05feb2018 Monday 2018w6 2018m2 2018 |
   |-----------------------------------------------------------------------------|
21. | 21 2223 17 09feb2018 Friday 2018w6 2018m2 2018 |
22. | 22 2059 16 08feb2018 Thursday 2018w6 2018m2 2018 |
23. | 23 2004 14 06feb2018 Tuesday 2018w6 2018m2 2018 |
24. | 24 1807 238 18sep2018 Tuesday 2018w38 2018m9 2018 |
25. | 25 1793 19 11feb2018 Sunday 2018w6 2018m2 2018 |
   |-----------------------------------------------------------------------------|
26. | 26 1790 12 04feb2018 Sunday 2018w5 2018m2 2018 |
27. | 27 1740 24 16feb2018 Friday 2018w7 2018m2 2018 |
28. | 28 1727 39 03mar2018 Saturday 2018w9 2018m3 2018 |
29. | 29 1630 660 14nov2019 Thursday 2019w46 2019m11 2019 |
30. | 30 1590 669 23nov2019 Saturday 2019w47 2019m11 2019 |
   |-----------------------------------------------------------------------------|
31. | 31 1589 26 18feb2018 Sunday 2018w7 2018m2 2018 |
32. | 32 1585 662 16nov2019 Saturday 2019w46 2019m11 2019 |
33. | 33 1580 22 14feb2018 Wednesday 2018w7 2018m2 2018 |
34. | 34 1475 20 12feb2018 Monday 2018w7 2018m2 2018 |
35. | 35 1465 678 02dec2019 Monday 2019w48 2019m12 2019 |
   |-----------------------------------------------------------------------------|
36. | 36 1442 28 20feb2018 Tuesday 2018w8 2018m2 2018 |
37. | 37 1431 25 17feb2018 Saturday 2018w7 2018m2 2018 |
38. | 38 1414 35 27feb2018 Tuesday 2018w9 2018m2 2018 |
39. | 39 1390 57 21mar2018 Wednesday 2018w12 2018m3 2018 |
40. | 40 1377 663 17nov2019 Sunday 2019w46 2019m11 2019 |
   |-----------------------------------------------------------------------------|
41. | 41 1372 33 25feb2018 Sunday 2018w8 2018m2 2018 |
42. | 42 1364 755 17feb2020 Monday 2020w7 2020m2 2020 |
43. | 43 1347 239 19sep2018 Wednesday 2018w38 2018m9 2018 |
44. | 44 1345 38 02mar2018 Friday 2018w9 2018m3 2018 |
45. | 45 1334 18 10feb2018 Saturday 2018w6 2018m2 2018 |
   |-----------------------------------------------------------------------------|
46. | 46 1316 49 13mar2018 Tuesday 2018w11 2018m3 2018 |
47. | 47 1302 36 28feb2018 Wednesday 2018w9 2018m2 2018 |
48. | 48 1289 21 13feb2018 Tuesday 2018w7 2018m2 2018 |
49. | 49 1289 27 19feb2018 Monday 2018w8 2018m2 2018 |
50. | 50 1277 30 22feb2018 Thursday 2018w8 2018m2 2018 |
   +-----------------------------------------------------------------------------+

List of the top 50-lowest days in terms of intra-day merits:

Code:

+-----------------------------------------------------------------------------+
   | rank_min merit dayid date dofw week month year |
   |-----------------------------------------------------------------------------|
  1. | 1 300 558 04aug2019 Sunday 2019w31 2019m8 2019 |
  2. | 2 333 341 30dec2018 Sunday 2018w52 2018m12 2018 |
  3. | 3 339 343 01jan2019 Tuesday 2019w1 2019m1 2019 |
  4. | 4 347 299 18nov2018 Sunday 2018w46 2018m11 2018 |
  5. | 5 347 330 19dec2018 Wednesday 2018w51 2018m12 2018 |
   |-----------------------------------------------------------------------------|
  6. | 6 351 334 23dec2018 Sunday 2018w51 2018m12 2018 |
  7. | 7 366 218 29aug2018 Wednesday 2018w35 2018m8 2018 |
  8. | 8 367 565 11aug2019 Sunday 2019w32 2019m8 2019 |
  9. | 9 370 223 03sep2018 Monday 2018w36 2018m9 2018 |
10. | 10 373 339 28dec2018 Friday 2018w52 2018m12 2018 |
   |-----------------------------------------------------------------------------|
11. | 11 375 340 29dec2018 Saturday 2018w52 2018m12 2018 |
12. | 12 377 600 15sep2019 Sunday 2019w37 2019m9 2019 |
13. | 13 378 566 12aug2019 Monday 2019w32 2019m8 2019 |
14. | 14 378 305 24nov2018 Saturday 2018w47 2018m11 2018 |
15. | 15 378 567 13aug2019 Tuesday 2019w33 2019m8 2019 |
   |-----------------------------------------------------------------------------|
16. | 16 380 192 03aug2018 Friday 2018w31 2018m8 2018 |
17. | 17 381 336 25dec2018 Tuesday 2018w52 2018m12 2018 |
18. | 18 385 215 26aug2018 Sunday 2018w34 2018m8 2018 |
19. | 19 385 327 16dec2018 Sunday 2018w50 2018m12 2018 |
20. | 20 391 221 01sep2018 Saturday 2018w35 2018m9 2018 |
   |-----------------------------------------------------------------------------|
21. | 21 394 188 30jul2018 Monday 2018w31 2018m7 2018 |
22. | 22 395 872 13jun2020 Saturday 2020w24 2020m6 2020 |
23. | 23 399 593 08sep2019 Sunday 2019w36 2019m9 2019 |
24. | 24 401 557 03aug2019 Saturday 2019w31 2019m8 2019 |
25. | 25 401 288 07nov2018 Wednesday 2018w45 2018m11 2018 |
   |-----------------------------------------------------------------------------|
26. | 26 402 263 13oct2018 Saturday 2018w41 2018m10 2018 |
27. | 27 404 229 09sep2018 Sunday 2018w36 2018m9 2018 |
28. | 28 406 277 27oct2018 Saturday 2018w43 2018m10 2018 |
29. | 29 408 530 07jul2019 Sunday 2019w27 2019m7 2019 |
30. | 30 409 123 26may2018 Saturday 2018w21 2018m5 2018 |
   |-----------------------------------------------------------------------------|
31. | 31 409 589 04sep2019 Wednesday 2019w36 2019m9 2019 |
32. | 32 410 279 29oct2018 Monday 2018w44 2018m10 2018 |
33. | 33 411 569 15aug2019 Thursday 2019w33 2019m8 2019 |
34. | 34 411 578 24aug2019 Saturday 2019w34 2019m8 2019 |
35. | 35 414 528 05jul2019 Friday 2019w27 2019m7 2019 |
   |-----------------------------------------------------------------------------|
36. | 36 421 193 04aug2018 Saturday 2018w31 2018m8 2018 |
37. | 37 425 588 03sep2019 Tuesday 2019w36 2019m9 2019 |
38. | 38 426 230 10sep2018 Monday 2018w37 2018m9 2018 |
39. | 39 426 346 04jan2019 Friday 2019w1 2019m1 2019 |
40. | 40 427 141 13jun2018 Wednesday 2018w24 2018m6 2018 |
   |-----------------------------------------------------------------------------|
41. | 41 430 207 18aug2018 Saturday 2018w33 2018m8 2018 |
42. | 42 432 587 02sep2019 Monday 2019w35 2019m9 2019 |
43. | 43 435 522 29jun2019 Saturday 2019w26 2019m6 2019 |
44. | 44 436 419 18mar2019 Monday 2019w11 2019m3 2019 |
45. | 45 439 880 21jun2020 Sunday 2020w25 2020m6 2020 |
   |-----------------------------------------------------------------------------|
46. | 46 440 559 05aug2019 Monday 2019w31 2019m8 2019 |
47. | 47 440 265 15oct2018 Monday 2018w42 2018m10 2018 |
48. | 48 440 585 31aug2019 Saturday 2019w35 2019m8 2019 |
49. | 49 441 319 08dec2018 Saturday 2018w49 2018m12 2018 |
50. | 50 441 404 03mar2019 Sunday 2019w9 2019m3 2019 |
   +-----------------------------------------------------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Time-series plots:
Full dataset:

Truncated dataset:

Basic statistics (for full dataset):
Only drop last 3 days that belong to the 2020w34 (daydi = 939, 940), the incomplete week & incomlete day (dayid = 941).

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 938 778.6279 617.3672 668 565 808 300 12676
----------------------------------------------------------------------------------------------

Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 201 or 1173.

Code:

. di 808-565
243

. di 243*1.5
364.5

. di 808+364.5
1172.5

. di 565-364.5
200.5

There are 62 outliers (beyond 1175 or 199) in full dataset, in total.

Code:

. count if (merit >= 1173 | merit <= 201) & merit != .
62

Those days are:

Code:

+---------------------------+
   | dayid merit date |
   |---------------------------|
  2. | 2 12676 25jan2018 |
  3. | 3 6348 26jan2018 |
  4. | 4 4627 27jan2018 |
  5. | 5 3240 28jan2018 |
  6. | 6 3343 29jan2018 |
  7. | 7 3804 30jan2018 |
  8. | 8 4103 31jan2018 |
  9. | 9 2793 01feb2018 |
10. | 10 2621 02feb2018 |
11. | 11 2476 03feb2018 |
12. | 12 1790 04feb2018 |
13. | 13 2263 05feb2018 |
14. | 14 2004 06feb2018 |
15. | 15 2366 07feb2018 |
16. | 16 2059 08feb2018 |
17. | 17 2223 09feb2018 |
18. | 18 1334 10feb2018 |
19. | 19 1793 11feb2018 |
20. | 20 1475 12feb2018 |
21. | 21 1289 13feb2018 |
22. | 22 1580 14feb2018 |
23. | 23 2797 15feb2018 |
24. | 24 1740 16feb2018 |
25. | 25 1431 17feb2018 |
26. | 26 1589 18feb2018 |
27. | 27 1289 19feb2018 |
28. | 28 1442 20feb2018 |
30. | 30 1277 22feb2018 |
31. | 31 1250 23feb2018 |
33. | 33 1372 25feb2018 |
35. | 35 1414 27feb2018 |
36. | 36 1302 28feb2018 |
38. | 38 1345 02mar2018 |
39. | 39 1727 03mar2018 |
49. | 49 1316 13mar2018 |
51. | 51 1224 15mar2018 |
57. | 57 1390 21mar2018 |
58. | 58 1211 22mar2018 |
69. | 69 1181 02apr2018 |
70. | 70 1186 03apr2018 |
237. | 237 2553 17sep2018 |
238. | 238 1807 18sep2018 |
239. | 239 1347 19sep2018 |
240. | 240 1221 20sep2018 |
   |---------------------------|
429. | 429 1247 28mar2019 |
476. | 476 1215 14may2019 |
505. | 505 1227 12jun2019 |
660. | 660 1630 14nov2019 |
661. | 661 2374 15nov2019 |
662. | 662 1585 16nov2019 |
663. | 663 1377 17nov2019 |
664. | 664 2783 18nov2019 |
665. | 665 3826 19nov2019 |
666. | 666 2584 20nov2019 |
667. | 667 4889 21nov2019 |
668. | 668 5515 22nov2019 |
669. | 669 1590 23nov2019 |
678. | 678 1465 02dec2019 |
   |---------------------------|
726. | 726 1192 19jan2020 |
755. | 755 1364 17feb2020 |
756. | 756 1195 18feb2020 |
845. | 845 1198 17may2020 |
   +---------------------------+

Distributions of outliers over years:

2018: 44 (71.0%)
2019: 14 (22.6%)
2020: 4 (6.4%)

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Converted dataset:

In 2020 ^{at 21aug2020 02:49:07 (GMT time)}
The last one, with dayid = 941 is an incomplete day.

Code:

+-----------------------------------------------------------------+
| dayid date merit dofw week month year |
|-----------------------------------------------------------------|
708. | 708 01jan2020 810 Wednesday 2020w1 2020m1 2020 |
709. | 709 02jan2020 854 Thursday 2020w1 2020m1 2020 |
710. | 710 03jan2020 837 Friday 2020w1 2020m1 2020 |
711. | 711 04jan2020 637 Saturday 2020w1 2020m1 2020 |
712. | 712 05jan2020 777 Sunday 2020w1 2020m1 2020 |
|-----------------------------------------------------------------|
713. | 713 06jan2020 959 Monday 2020w1 2020m1 2020 |
714. | 714 07jan2020 871 Tuesday 2020w1 2020m1 2020 |
715. | 715 08jan2020 860 Wednesday 2020w2 2020m1 2020 |
716. | 716 09jan2020 733 Thursday 2020w2 2020m1 2020 |
717. | 717 10jan2020 745 Friday 2020w2 2020m1 2020 |
|-----------------------------------------------------------------|
718. | 718 11jan2020 743 Saturday 2020w2 2020m1 2020 |
719. | 719 12jan2020 689 Sunday 2020w2 2020m1 2020 |
720. | 720 13jan2020 754 Monday 2020w2 2020m1 2020 |
721. | 721 14jan2020 871 Tuesday 2020w2 2020m1 2020 |
722. | 722 15jan2020 979 Wednesday 2020w3 2020m1 2020 |
|-----------------------------------------------------------------|
723. | 723 16jan2020 972 Thursday 2020w3 2020m1 2020 |
724. | 724 17jan2020 1063 Friday 2020w3 2020m1 2020 |
725. | 725 18jan2020 823 Saturday 2020w3 2020m1 2020 |
726. | 726 19jan2020 1192 Sunday 2020w3 2020m1 2020 |
727. | 727 20jan2020 1136 Monday 2020w3 2020m1 2020 |
|-----------------------------------------------------------------|
728. | 728 21jan2020 1082 Tuesday 2020w3 2020m1 2020 |
729. | 729 22jan2020 863 Wednesday 2020w4 2020m1 2020 |
730. | 730 23jan2020 1050 Thursday 2020w4 2020m1 2020 |
731. | 731 24jan2020 1061 Friday 2020w4 2020m1 2020 |
732. | 732 25jan2020 1043 Saturday 2020w4 2020m1 2020 |
|-----------------------------------------------------------------|
733. | 733 26jan2020 715 Sunday 2020w4 2020m1 2020 |
734. | 734 27jan2020 961 Monday 2020w4 2020m1 2020 |
735. | 735 28jan2020 953 Tuesday 2020w4 2020m1 2020 |
736. | 736 29jan2020 1051 Wednesday 2020w5 2020m1 2020 |
737. | 737 30jan2020 1125 Thursday 2020w5 2020m1 2020 |
|-----------------------------------------------------------------|
738. | 738 31jan2020 1072 Friday 2020w5 2020m1 2020 |
739. | 739 01feb2020 705 Saturday 2020w5 2020m2 2020 |
740. | 740 02feb2020 836 Sunday 2020w5 2020m2 2020 |
741. | 741 03feb2020 908 Monday 2020w5 2020m2 2020 |
742. | 742 04feb2020 1059 Tuesday 2020w5 2020m2 2020 |
|-----------------------------------------------------------------|
743. | 743 05feb2020 873 Wednesday 2020w6 2020m2 2020 |
744. | 744 06feb2020 932 Thursday 2020w6 2020m2 2020 |
745. | 745 07feb2020 800 Friday 2020w6 2020m2 2020 |
746. | 746 08feb2020 763 Saturday 2020w6 2020m2 2020 |
747. | 747 09feb2020 724 Sunday 2020w6 2020m2 2020 |
|-----------------------------------------------------------------|
748. | 748 10feb2020 812 Monday 2020w6 2020m2 2020 |
749. | 749 11feb2020 669 Tuesday 2020w6 2020m2 2020 |
750. | 750 12feb2020 596 Wednesday 2020w7 2020m2 2020 |
751. | 751 13feb2020 1047 Thursday 2020w7 2020m2 2020 |
752. | 752 14feb2020 1041 Friday 2020w7 2020m2 2020 |
|-----------------------------------------------------------------|
753. | 753 15feb2020 890 Saturday 2020w7 2020m2 2020 |
754. | 754 16feb2020 790 Sunday 2020w7 2020m2 2020 |
755. | 755 17feb2020 1364 Monday 2020w7 2020m2 2020 |
756. | 756 18feb2020 1195 Tuesday 2020w7 2020m2 2020 |
757. | 757 19feb2020 1004 Wednesday 2020w8 2020m2 2020 |
|-----------------------------------------------------------------|
758. | 758 20feb2020 782 Thursday 2020w8 2020m2 2020 |
759. | 759 21feb2020 1050 Friday 2020w8 2020m2 2020 |
760. | 760 22feb2020 729 Saturday 2020w8 2020m2 2020 |
761. | 761 23feb2020 724 Sunday 2020w8 2020m2 2020 |
762. | 762 24feb2020 1037 Monday 2020w8 2020m2 2020 |
|-----------------------------------------------------------------|
763. | 763 25feb2020 988 Tuesday 2020w8 2020m2 2020 |
764. | 764 26feb2020 857 Wednesday 2020w9 2020m2 2020 |
765. | 765 27feb2020 960 Thursday 2020w9 2020m2 2020 |
766. | 766 28feb2020 678 Friday 2020w9 2020m2 2020 |
767. | 767 29feb2020 662 Saturday 2020w9 2020m2 2020 |
|-----------------------------------------------------------------|
768. | 768 01mar2020 651 Sunday 2020w9 2020m3 2020 |
769. | 769 02mar2020 755 Monday 2020w9 2020m3 2020 |
770. | 770 03mar2020 674 Tuesday 2020w9 2020m3 2020 |
771. | 771 04mar2020 572 Wednesday 2020w10 2020m3 2020 |
772. | 772 05mar2020 727 Thursday 2020w10 2020m3 2020 |
|-----------------------------------------------------------------|
773. | 773 06mar2020 622 Friday 2020w10 2020m3 2020 |
774. | 774 07mar2020 697 Saturday 2020w10 2020m3 2020 |
775. | 775 08mar2020 670 Sunday 2020w10 2020m3 2020 |
776. | 776 09mar2020 634 Monday 2020w10 2020m3 2020 |
777. | 777 10mar2020 700 Tuesday 2020w10 2020m3 2020 |
|-----------------------------------------------------------------|
778. | 778 11mar2020 800 Wednesday 2020w11 2020m3 2020 |
779. | 779 12mar2020 790 Thursday 2020w11 2020m3 2020 |
780. | 780 13mar2020 748 Friday 2020w11 2020m3 2020 |
781. | 781 14mar2020 562 Saturday 2020w11 2020m3 2020 |
782. | 782 15mar2020 528 Sunday 2020w11 2020m3 2020 |
|-----------------------------------------------------------------|
783. | 783 16mar2020 888 Monday 2020w11 2020m3 2020 |
784. | 784 17mar2020 793 Tuesday 2020w11 2020m3 2020 |
785. | 785 18mar2020 1090 Wednesday 2020w12 2020m3 2020 |
786. | 786 19mar2020 867 Thursday 2020w12 2020m3 2020 |
787. | 787 20mar2020 999 Friday 2020w12 2020m3 2020 |
|-----------------------------------------------------------------|
788. | 788 21mar2020 628 Saturday 2020w12 2020m3 2020 |
789. | 789 22mar2020 549 Sunday 2020w12 2020m3 2020 |
790. | 790 23mar2020 683 Monday 2020w12 2020m3 2020 |
791. | 791 24mar2020 787 Tuesday 2020w12 2020m3 2020 |
792. | 792 25mar2020 786 Wednesday 2020w13 2020m3 2020 |
|-----------------------------------------------------------------|
793. | 793 26mar2020 855 Thursday 2020w13 2020m3 2020 |
794. | 794 27mar2020 934 Friday 2020w13 2020m3 2020 |
795. | 795 28mar2020 658 Saturday 2020w13 2020m3 2020 |
796. | 796 29mar2020 452 Sunday 2020w13 2020m3 2020 |
797. | 797 30mar2020 909 Monday 2020w13 2020m3 2020 |
|-----------------------------------------------------------------|
798. | 798 31mar2020 798 Tuesday 2020w13 2020m3 2020 |
799. | 799 01apr2020 858 Wednesday 2020w14 2020m4 2020 |
800. | 800 02apr2020 1062 Thursday 2020w14 2020m4 2020 |
801. | 801 03apr2020 805 Friday 2020w14 2020m4 2020 |
802. | 802 04apr2020 943 Saturday 2020w14 2020m4 2020 |
|-----------------------------------------------------------------|
803. | 803 05apr2020 661 Sunday 2020w14 2020m4 2020 |
804. | 804 06apr2020 846 Monday 2020w14 2020m4 2020 |
805. | 805 07apr2020 886 Tuesday 2020w14 2020m4 2020 |
806. | 806 08apr2020 875 Wednesday 2020w15 2020m4 2020 |
807. | 807 09apr2020 687 Thursday 2020w15 2020m4 2020 |
|-----------------------------------------------------------------|
808. | 808 10apr2020 758 Friday 2020w15 2020m4 2020 |
809. | 809 11apr2020 615 Saturday 2020w15 2020m4 2020 |
810. | 810 12apr2020 660 Sunday 2020w15 2020m4 2020 |
811. | 811 13apr2020 592 Monday 2020w15 2020m4 2020 |
812. | 812 14apr2020 907 Tuesday 2020w15 2020m4 2020 |
|-----------------------------------------------------------------|
813. | 813 15apr2020 734 Wednesday 2020w16 2020m4 2020 |
814. | 814 16apr2020 763 Thursday 2020w16 2020m4 2020 |
815. | 815 17apr2020 827 Friday 2020w16 2020m4 2020 |
816. | 816 18apr2020 752 Saturday 2020w16 2020m4 2020 |
817. | 817 19apr2020 627 Sunday 2020w16 2020m4 2020 |
|-----------------------------------------------------------------|
818. | 818 20apr2020 626 Monday 2020w16 2020m4 2020 |
819. | 819 21apr2020 723 Tuesday 2020w16 2020m4 2020 |
820. | 820 22apr2020 700 Wednesday 2020w17 2020m4 2020 |
821. | 821 23apr2020 687 Thursday 2020w17 2020m4 2020 |
822. | 822 24apr2020 706 Friday 2020w17 2020m4 2020 |
|-----------------------------------------------------------------|
823. | 823 25apr2020 639 Saturday 2020w17 2020m4 2020 |
824. | 824 26apr2020 663 Sunday 2020w17 2020m4 2020 |
825. | 825 27apr2020 654 Monday 2020w17 2020m4 2020 |
826. | 826 28apr2020 490 Tuesday 2020w17 2020m4 2020 |
827. | 827 29apr2020 795 Wednesday 2020w18 2020m4 2020 |
|-----------------------------------------------------------------|
828. | 828 30apr2020 983 Thursday 2020w18 2020m4 2020 |
829. | 829 01may2020 1099 Friday 2020w18 2020m5 2020 |
830. | 830 02may2020 745 Saturday 2020w18 2020m5 2020 |
831. | 831 03may2020 716 Sunday 2020w18 2020m5 2020 |
832. | 832 04may2020 659 Monday 2020w18 2020m5 2020 |
|-----------------------------------------------------------------|
833. | 833 05may2020 702 Tuesday 2020w18 2020m5 2020 |
834. | 834 06may2020 707 Wednesday 2020w19 2020m5 2020 |
835. | 835 07may2020 852 Thursday 2020w19 2020m5 2020 |
836. | 836 08may2020 734 Friday 2020w19 2020m5 2020 |
837. | 837 09may2020 806 Saturday 2020w19 2020m5 2020 |
|-----------------------------------------------------------------|
838. | 838 10may2020 919 Sunday 2020w19 2020m5 2020 |
839. | 839 11may2020 988 Monday 2020w19 2020m5 2020 |
840. | 840 12may2020 642 Tuesday 2020w19 2020m5 2020 |
841. | 841 13may2020 734 Wednesday 2020w20 2020m5 2020 |
842. | 842 14may2020 929 Thursday 2020w20 2020m5 2020 |
|-----------------------------------------------------------------|
843. | 843 15may2020 681 Friday 2020w20 2020m5 2020 |
844. | 844 16may2020 749 Saturday 2020w20 2020m5 2020 |
845. | 845 17may2020 1198 Sunday 2020w20 2020m5 2020 |
846. | 846 18may2020 728 Monday 2020w20 2020m5 2020 |
847. | 847 19may2020 783 Tuesday 2020w20 2020m5 2020 |
|-----------------------------------------------------------------|
848. | 848 20may2020 759 Wednesday 2020w21 2020m5 2020 |
849. | 849 21may2020 774 Thursday 2020w21 2020m5 2020 |
850. | 850 22may2020 805 Friday 2020w21 2020m5 2020 |
851. | 851 23may2020 731 Saturday 2020w21 2020m5 2020 |
852. | 852 24may2020 598 Sunday 2020w21 2020m5 2020 |
|-----------------------------------------------------------------|
853. | 853 25may2020 937 Monday 2020w21 2020m5 2020 |
854. | 854 26may2020 730 Tuesday 2020w21 2020m5 2020 |
855. | 855 27may2020 698 Wednesday 2020w22 2020m5 2020 |
856. | 856 28may2020 690 Thursday 2020w22 2020m5 2020 |
857. | 857 29may2020 686 Friday 2020w22 2020m5 2020 |
|-----------------------------------------------------------------|
858. | 858 30may2020 565 Saturday 2020w22 2020m5 2020 |
859. | 859 31may2020 530 Sunday 2020w22 2020m5 2020 |
860. | 860 01jun2020 834 Monday 2020w22 2020m6 2020 |
861. | 861 02jun2020 659 Tuesday 2020w22 2020m6 2020 |
862. | 862 03jun2020 488 Wednesday 2020w23 2020m6 2020 |
|-----------------------------------------------------------------|
863. | 863 04jun2020 759 Thursday 2020w23 2020m6 2020 |
864. | 864 05jun2020 640 Friday 2020w23 2020m6 2020 |
865. | 865 06jun2020 589 Saturday 2020w23 2020m6 2020 |
866. | 866 07jun2020 741 Sunday 2020w23 2020m6 2020 |
867. | 867 08jun2020 638 Monday 2020w23 2020m6 2020 |
|-----------------------------------------------------------------|
868. | 868 09jun2020 821 Tuesday 2020w23 2020m6 2020 |
869. | 869 10jun2020 666 Wednesday 2020w24 2020m6 2020 |
870. | 870 11jun2020 623 Thursday 2020w24 2020m6 2020 |
871. | 871 12jun2020 688 Friday 2020w24 2020m6 2020 |
872. | 872 13jun2020 395 Saturday 2020w24 2020m6 2020 |
|-----------------------------------------------------------------|
873. | 873 14jun2020 602 Sunday 2020w24 2020m6 2020 |
874. | 874 15jun2020 682 Monday 2020w24 2020m6 2020 |
875. | 875 16jun2020 534 Tuesday 2020w24 2020m6 2020 |
876. | 876 17jun2020 570 Wednesday 2020w25 2020m6 2020 |
877. | 877 18jun2020 587 Thursday 2020w25 2020m6 2020 |
|-----------------------------------------------------------------|
878. | 878 19jun2020 675 Friday 2020w25 2020m6 2020 |
879. | 879 20jun2020 658 Saturday 2020w25 2020m6 2020 |
880. | 880 21jun2020 439 Sunday 2020w25 2020m6 2020 |
881. | 881 22jun2020 602 Monday 2020w25 2020m6 2020 |
882. | 882 23jun2020 835 Tuesday 2020w25 2020m6 2020 |
|-----------------------------------------------------------------|
883. | 883 24jun2020 700 Wednesday 2020w26 2020m6 2020 |
884. | 884 25jun2020 579 Thursday 2020w26 2020m6 2020 |
885. | 885 26jun2020 679 Friday 2020w26 2020m6 2020 |
886. | 886 27jun2020 481 Saturday 2020w26 2020m6 2020 |
887. | 887 28jun2020 657 Sunday 2020w26 2020m6 2020 |
|-----------------------------------------------------------------|
888. | 888 29jun2020 746 Monday 2020w26 2020m6 2020 |
889. | 889 30jun2020 632 Tuesday 2020w26 2020m6 2020 |
890. | 890 01jul2020 734 Wednesday 2020w27 2020m7 2020 |
891. | 891 02jul2020 531 Thursday 2020w27 2020m7 2020 |
892. | 892 03jul2020 792 Friday 2020w27 2020m7 2020 |
|-----------------------------------------------------------------|
893. | 893 04jul2020 755 Saturday 2020w27 2020m7 2020 |
894. | 894 05jul2020 556 Sunday 2020w27 2020m7 2020 |
895. | 895 06jul2020 581 Monday 2020w27 2020m7 2020 |
896. | 896 07jul2020 681 Tuesday 2020w27 2020m7 2020 |
897. | 897 08jul2020 880 Wednesday 2020w28 2020m7 2020 |
|-----------------------------------------------------------------|
898. | 898 09jul2020 591 Thursday 2020w28 2020m7 2020 |
899. | 899 10jul2020 677 Friday 2020w28 2020m7 2020 |
900. | 900 11jul2020 605 Saturday 2020w28 2020m7 2020 |
901. | 901 12jul2020 681 Sunday 2020w28 2020m7 2020 |
902. | 902 13jul2020 668 Monday 2020w28 2020m7 2020 |
|-----------------------------------------------------------------|
903. | 903 14jul2020 571 Tuesday 2020w28 2020m7 2020 |
904. | 904 15jul2020 593 Wednesday 2020w29 2020m7 2020 |
905. | 905 16jul2020 770 Thursday 2020w29 2020m7 2020 |
906. | 906 17jul2020 642 Friday 2020w29 2020m7 2020 |
907. | 907 18jul2020 484 Saturday 2020w29 2020m7 2020 |
|-----------------------------------------------------------------|
908. | 908 19jul2020 864 Sunday 2020w29 2020m7 2020 |
909. | 909 20jul2020 653 Monday 2020w29 2020m7 2020 |
910. | 910 21jul2020 479 Tuesday 2020w29 2020m7 2020 |
911. | 911 22jul2020 671 Wednesday 2020w30 2020m7 2020 |
912. | 912 23jul2020 679 Thursday 2020w30 2020m7 2020 |
|-----------------------------------------------------------------|
913. | 913 24jul2020 613 Friday 2020w30 2020m7 2020 |
914. | 914 25jul2020 476 Saturday 2020w30 2020m7 2020 |
915. | 915 26jul2020 682 Sunday 2020w30 2020m7 2020 |
916. | 916 27jul2020 816 Monday 2020w30 2020m7 2020 |
917. | 917 28jul2020 581 Tuesday 2020w30 2020m7 2020 |
|-----------------------------------------------------------------|
918. | 918 29jul2020 747 Wednesday 2020w31 2020m7 2020 |
919. | 919 30jul2020 651 Thursday 2020w31 2020m7 2020 |
920. | 920 31jul2020 957 Friday 2020w31 2020m7 2020 |
921. | 921 01aug2020 654 Saturday 2020w31 2020m8 2020 |
922. | 922 02aug2020 738 Sunday 2020w31 2020m8 2020 |
|-----------------------------------------------------------------|
923. | 923 03aug2020 635 Monday 2020w31 2020m8 2020 |
924. | 924 04aug2020 581 Tuesday 2020w31 2020m8 2020 |
925. | 925 05aug2020 592 Wednesday 2020w32 2020m8 2020 |
926. | 926 06aug2020 592 Thursday 2020w32 2020m8 2020 |
927. | 927 07aug2020 607 Friday 2020w32 2020m8 2020 |
|-----------------------------------------------------------------|
928. | 928 08aug2020 494 Saturday 2020w32 2020m8 2020 |
929. | 929 09aug2020 527 Sunday 2020w32 2020m8 2020 |
930. | 930 10aug2020 675 Monday 2020w32 2020m8 2020 |
931. | 931 11aug2020 587 Tuesday 2020w32 2020m8 2020 |
932. | 932 12aug2020 640 Wednesday 2020w33 2020m8 2020 |
|-----------------------------------------------------------------|
933. | 933 13aug2020 456 Thursday 2020w33 2020m8 2020 |
934. | 934 14aug2020 625 Friday 2020w33 2020m8 2020 |
935. | 935 15aug2020 503 Saturday 2020w33 2020m8 2020 |
936. | 936 16aug2020 449 Sunday 2020w33 2020m8 2020 |
937. | 937 17aug2020 622 Monday 2020w33 2020m8 2020 |
|-----------------------------------------------------------------|
938. | 938 18aug2020 691 Tuesday 2020w33 2020m8 2020 |
939. | 939 19aug2020 650 Wednesday 2020w34 2020m8 2020 |
940. | 940 20aug2020 761 Thursday 2020w34 2020m8 2020 |
941. | 941 21aug2020 185 Friday 2020w34 2020m8 2020 |
+-----------------------------------------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

ABSTRACT ^{2020w32, GMT time}

Data is the full dataset since 24/1/2018, and only dropped last 3 days belong to incomplete week - 2020w33 and an incomplete day (dayid = 933). Details on days dropped, please see above posts.

Intra-day merits:

Total observed days: 931
Potential outliers are days that have intraday total merits beyond 199 or 1175
Median of intraday merits over the period is 669
50% of observed days have their intra-day merits range from 565 to 809 (the interquartile range)
In medians, the highest and lowest days are Tuesday and Saturday, respectively; whilst the highest and lowest days in means are Thursday and Sunday, respectively. See here.
There are 62 potential outliers (beyond 199 or 1175) in total.
The distribution of outliers over years are: 44 (71.0%) for 2018, 14 (22.6%) for 2019, and 4 (6.4%) for 2020. (see details)
Minimum and maximum of intraday merits (full dataset) are 300, and 12676, on 04/8/2019 and 25/1/2018, respectively.

Intra-week merits:

Total observed weeks: 133
The median of intra-week merits is 4650
50% of observed weeks (133 weeks in total), have total merits in the range from 4259 to 5573 (the interquartile range of intra-week merits).
Minimum and maximum of intra-week merits are 3186 and 27920, in 2018w35, and 2018w4, respectively;
9 potential outliers [beyond 2288 or 7544], only 2 of them occurred in the year 2019, on 2019w46 (11070), and 2019w47 (20397); none of them occured in 2020.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Intra-week merits (from 24/1/2018 to 11/8/2020)
Last 3 days dropped due to incomplete week (2020w33) and an incomplete day (dayid = 933)

Converted dataset:

Code:

+-----------------+
| merit week |
|-----------------|
1. | 27920 2018w4 |
2. | 20930 2018w5 |
3. | 14042 2018w6 |
4. | 11901 2018w7 |
5. | 8879 2018w8 |
|-----------------|
6. | 9005 2018w9 |
7. | 7178 2018w10 |
8. | 7340 2018w11 |
9. | 7138 2018w12 |
10. | 6392 2018w13 |
|-----------------|
11. | 6542 2018w14 |
12. | 5946 2018w15 |
13. | 4449 2018w16 |
14. | 4820 2018w17 |
15. | 5043 2018w18 |
|-----------------|
16. | 4685 2018w19 |
17. | 4431 2018w20 |
18. | 3903 2018w21 |
19. | 4248 2018w22 |
20. | 4473 2018w23 |
|-----------------|
21. | 3953 2018w24 |
22. | 4574 2018w25 |
23. | 4684 2018w26 |
24. | 4367 2018w27 |
25. | 4109 2018w28 |
|-----------------|
26. | 4277 2018w29 |
27. | 3809 2018w30 |
28. | 3489 2018w31 |
29. | 4199 2018w32 |
30. | 3767 2018w33 |
|-----------------|
31. | 3763 2018w34 |
32. | 3186 2018w35 |
33. | 3536 2018w36 |
34. | 3586 2018w37 |
35. | 9587 2018w38 |
|-----------------|
36. | 4508 2018w39 |
37. | 4325 2018w40 |
38. | 3981 2018w41 |
39. | 4424 2018w42 |
40. | 4386 2018w43 |
|-----------------|
41. | 3321 2018w44 |
42. | 4175 2018w45 |
43. | 4047 2018w46 |
44. | 4606 2018w47 |
45. | 3791 2018w48 |
|-----------------|
46. | 3596 2018w49 |
47. | 3689 2018w50 |
48. | 3615 2018w51 |
49. | 3687 2018w52 |
50. | 4584 2019w1 |
|-----------------|
51. | 6102 2019w2 |
52. | 5776 2019w3 |
53. | 4582 2019w4 |
54. | 4408 2019w5 |
55. | 4505 2019w6 |
|-----------------|
56. | 4259 2019w7 |
57. | 4314 2019w8 |
58. | 4726 2019w9 |
59. | 4979 2019w10 |
60. | 4295 2019w11 |
|-----------------|
61. | 4690 2019w12 |
62. | 5728 2019w13 |
63. | 4695 2019w14 |
64. | 5253 2019w15 |
65. | 4880 2019w16 |
|-----------------|
66. | 4260 2019w17 |
67. | 4817 2019w18 |
68. | 5002 2019w19 |
69. | 5596 2019w20 |
70. | 4693 2019w21 |
|-----------------|
71. | 4342 2019w22 |
72. | 4597 2019w23 |
73. | 5373 2019w24 |
74. | 4629 2019w25 |
75. | 4672 2019w26 |
|-----------------|
76. | 3882 2019w27 |
77. | 4462 2019w28 |
78. | 4005 2019w29 |
79. | 4377 2019w30 |
80. | 3603 2019w31 |
|-----------------|
81. | 3346 2019w32 |
82. | 3965 2019w33 |
83. | 3811 2019w34 |
84. | 3579 2019w35 |
85. | 3683 2019w36 |
|-----------------|
86. | 4005 2019w37 |
87. | 4382 2019w38 |
88. | 4348 2019w39 |
89. | 4209 2019w40 |
90. | 4701 2019w41 |
|-----------------|
91. | 5160 2019w42 |
92. | 5375 2019w43 |
93. | 4816 2019w44 |
94. | 4753 2019w45 |
95. | 11070 2019w46 |
|-----------------|
96. | 20397 2019w47 |
97. | 6271 2019w48 |
98. | 4650 2019w49 |
99. | 4832 2019w50 |
100. | 6066 2019w51 |
|-----------------|
101. | 7058 2019w52 |
102. | 5745 2020w1 |
103. | 5395 2020w2 |
104. | 7247 2020w3 |
105. | 6646 2020w4 |
|-----------------|
106. | 6756 2020w5 |
107. | 5573 2020w6 |
108. | 6923 2020w7 |
109. | 6314 2020w8 |
110. | 5237 2020w9 |
|-----------------|
111. | 4622 2020w10 |
112. | 5109 2020w11 |
113. | 5603 2020w12 |
114. | 5392 2020w13 |
115. | 6061 2020w14 |
|-----------------|
116. | 5094 2020w15 |
117. | 5052 2020w16 |
118. | 4539 2020w17 |
119. | 5699 2020w18 |
120. | 5648 2020w19 |
|-----------------|
121. | 5802 2020w20 |
122. | 5334 2020w21 |
123. | 4662 2020w22 |
124. | 4676 2020w23 |
125. | 4190 2020w24 |
|-----------------|
126. | 4366 2020w25 |
127. | 4474 2020w26 |
128. | 4630 2020w27 |
129. | 4673 2020w28 |
130. | 4485 2020w29 |
|-----------------|
131. | 4518 2020w30 |
132. | 4963 2020w31 |
133. | 4074 2020w32 |
+-----------------+

Time series plot

Basic statistics:
- 50% of observed weeks (133 weeks) have total intra-week merits above 4650, whilst the rest 50% of them have total intra-week merits below 4650. 4650 is the median - p50.
- 50% of observed weeks have total intra-week merits fluctuated in the range from 4259 to 5573 (the interquartile range, from p25 to p75, in raw statistics below).
- Min - max: 3186 - 27920.

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 133.0 5461.4 3159.7 4650.0 4259.0 5573.0 3186.0 27920.0
----------------------------------------------------------------------------------------------

Potential outliers:

Code:

. di 5573-4259
1314

. di 1314*1.5
1971

. di 5573+1971
7544

. di 4259-1971
2288

It means that potential outliers are weeks that have intra-week merits beyond 2288 or 7544.
How many weeks are potential outliers?

Code:

. count if (merit >= 7544 | merit < 2288) & merit != .
9

9 weeks are outliers, in total.
List of those 9 weeks:

Code:

+-----------------+
| merit week |
|-----------------|
1. | 27920 2018w4 |
2. | 20930 2018w5 |
3. | 14042 2018w6 |
4. | 11901 2018w7 |
5. | 8879 2018w8 |
|-----------------|
6. | 9005 2018w9 |
35. | 9587 2018w38 |
95. | 11070 2019w46 |
96. | 20397 2019w47 |
+-----------------+

Most of them occured in the year 2018, and there is only 2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 (20397). None of them occured in 2020 so far.

List of weeks in descending weekly merits
The last week (with 4074 merits) stays at the 107^th position, among 133 weeks.

Code:

+------------------------------+
| weeklyrank merit week |
|------------------------------|
1. | 1 27920 2018w4 |
2. | 2 20930 2018w5 |
3. | 3 20397 2019w47 |
4. | 4 14042 2018w6 |
5. | 5 11901 2018w7 |
|------------------------------|
6. | 6 11070 2019w46 |
7. | 7 9587 2018w38 |
8. | 8 9005 2018w9 |
9. | 9 8879 2018w8 |
10. | 10 7340 2018w11 |
|------------------------------|
11. | 11 7247 2020w3 |
12. | 12 7178 2018w10 |
13. | 13 7138 2018w12 |
14. | 14 7058 2019w52 |
15. | 15 6923 2020w7 |
|------------------------------|
16. | 16 6756 2020w5 |
17. | 17 6646 2020w4 |
18. | 18 6542 2018w14 |
19. | 19 6392 2018w13 |
20. | 20 6314 2020w8 |
|------------------------------|
21. | 21 6271 2019w48 |
22. | 22 6102 2019w2 |
23. | 23 6066 2019w51 |
24. | 24 6061 2020w14 |
25. | 25 5946 2018w15 |
|------------------------------|
26. | 26 5802 2020w20 |
27. | 27 5776 2019w3 |
28. | 28 5745 2020w1 |
29. | 29 5728 2019w13 |
30. | 30 5699 2020w18 |
|------------------------------|
31. | 31 5648 2020w19 |
32. | 32 5603 2020w12 |
33. | 33 5596 2019w20 |
34. | 34 5573 2020w6 |
35. | 35 5395 2020w2 |
|------------------------------|
36. | 36 5392 2020w13 |
37. | 37 5375 2019w43 |
38. | 38 5373 2019w24 |
39. | 39 5334 2020w21 |
40. | 40 5253 2019w15 |
|------------------------------|
41. | 41 5237 2020w9 |
42. | 42 5160 2019w42 |
43. | 43 5109 2020w11 |
44. | 44 5094 2020w15 |
45. | 45 5052 2020w16 |
|------------------------------|
46. | 46 5043 2018w18 |
47. | 47 5002 2019w19 |
48. | 48 4979 2019w10 |
49. | 49 4963 2020w31 |
50. | 50 4880 2019w16 |
|------------------------------|
51. | 51 4832 2019w50 |
52. | 52 4820 2018w17 |
53. | 53 4817 2019w18 |
54. | 54 4816 2019w44 |
55. | 55 4753 2019w45 |
|------------------------------|
56. | 56 4726 2019w9 |
57. | 57 4701 2019w41 |
58. | 58 4695 2019w14 |
59. | 59 4693 2019w21 |
60. | 60 4690 2019w12 |
|------------------------------|
61. | 61 4685 2018w19 |
62. | 62 4684 2018w26 |
63. | 63 4676 2020w23 |
64. | 64 4673 2020w28 |
65. | 65 4672 2019w26 |
|------------------------------|
66. | 66 4662 2020w22 |
67. | 67 4650 2019w49 |
68. | 68 4630 2020w27 |
69. | 69 4629 2019w25 |
70. | 70 4622 2020w10 |
|------------------------------|
71. | 71 4606 2018w47 |
72. | 72 4597 2019w23 |
73. | 73 4584 2019w1 |
74. | 74 4582 2019w4 |
75. | 75 4574 2018w25 |
|------------------------------|
76. | 76 4539 2020w17 |
77. | 77 4518 2020w30 |
78. | 78 4508 2018w39 |
79. | 79 4505 2019w6 |
80. | 80 4485 2020w29 |
|------------------------------|
81. | 81 4474 2020w26 |
82. | 82 4473 2018w23 |
83. | 83 4462 2019w28 |
84. | 84 4449 2018w16 |
85. | 85 4431 2018w20 |
|------------------------------|
86. | 86 4424 2018w42 |
87. | 87 4408 2019w5 |
88. | 88 4386 2018w43 |
89. | 89 4382 2019w38 |
90. | 90 4377 2019w30 |
|------------------------------|
91. | 91 4367 2018w27 |
92. | 92 4366 2020w25 |
93. | 93 4348 2019w39 |
94. | 94 4342 2019w22 |
95. | 95 4325 2018w40 |
|------------------------------|
96. | 96 4314 2019w8 |
97. | 97 4295 2019w11 |
98. | 98 4277 2018w29 |
99. | 99 4260 2019w17 |
100. | 100 4259 2019w7 |
|------------------------------|
101. | 101 4248 2018w22 |
102. | 102 4209 2019w40 |
103. | 103 4199 2018w32 |
104. | 104 4190 2020w24 |
105. | 105 4175 2018w45 |
|------------------------------|
106. | 106 4109 2018w28 |
107. | 107 4074 2020w32 |
108. | 108 4047 2018w46 |
109. | 109 4005 2019w29 |
110. | 110 4005 2019w37 |
|------------------------------|
111. | 111 3981 2018w41 |
112. | 112 3965 2019w33 |
113. | 113 3953 2018w24 |
114. | 114 3903 2018w21 |
115. | 115 3882 2019w27 |
|------------------------------|
116. | 116 3811 2019w34 |
117. | 117 3809 2018w30 |
118. | 118 3791 2018w48 |
119. | 119 3767 2018w33 |
120. | 120 3763 2018w34 |
|------------------------------|
121. | 121 3689 2018w50 |
122. | 122 3687 2018w52 |
123. | 123 3683 2019w36 |
124. | 124 3615 2018w51 |
125. | 125 3603 2019w31 |
|------------------------------|
126. | 126 3596 2018w49 |
127. | 127 3586 2018w37 |
128. | 128 3579 2019w35 |
129. | 129 3536 2018w36 |
130. | 130 3489 2018w31 |
|------------------------------|
131. | 131 3346 2019w32 |
132. | 132 3321 2018w44 |
133. | 133 3186 2018w35 |
+------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Medians and means of intra-day merits over days of weeks ^{GMT time}
Colors:

Green: highest.
Red: Lowest.

- In median, the highest days are Tuesday, Thursday, and Friday at 700, 697, and 697, respectively; whislt the lowest days are Saturday, Sunday, and Monday at 608, 632, and 662, respectively.
- In means, the highest days are Thursday, Friday, and Tuesday at 888, 840, and 796, respectively; whilst the lowest days are Sunday, Saturday, and Monday, at 693, 698, and 774, respectively.

Basic statistics:

Code:

Summary for variables: merit
by categories of: dofw

dofw | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
Sunday | 133.0 693.0 340.4 632.0 520.0 739.0 300.0 3240.0
Monday | 133.0 773.1 414.8 662.0 584.0 846.0 370.0 3343.0
Tuesday | 133.0 795.1 454.4 700.0 592.0 825.0 339.0 3826.0
Wednesday | 133.0 775.5 412.7 696.0 603.0 824.0 347.0 4103.0
Thursday | 133.0 887.8 1142.6 697.0 588.0 824.0 411.0 12676.0
Friday | 133.0 839.1 712.1 697.0 577.0 828.0 373.0 6348.0
Saturday | 133.0 697.8 442.1 608.0 503.0 736.0 375.0 4627.0
----------+--------------------------------------------------------------------------------
Total | 931.0 780.2 619.4 669.0 565.0 809.0 300.0 12676.0
-------------------------------------------------------------------------------------------

Box plots
Outliers non-displayed.

Details on ranks:
In medians

Code:

+----------------------------------------------------------------------+
| rankmedian dofw median mean p25 p75 min max |
|----------------------------------------------------------------------|
1. | 1 Tuesday 700 795.1429 592 825 339 3826 |
2. | 2 Thursday 697 887.7594 588 824 411 12676 |
3. | 3 Friday 697 839.1053 577 828 373 6348 |
4. | 4 Wednesday 696 775.4812 603 824 347 4103 |
5. | 5 Monday 662 773.0902 584 846 370 3343 |
|----------------------------------------------------------------------|
6. | 6 Sunday 632 692.9925 520 739 300 3240 |
7. | 7 Saturday 608 697.8346 503 736 375 4627 |
+----------------------------------------------------------------------+

In means

Code:

+--------------------------------------------------------------------+
| rankmean dofw mean median p25 p75 min max |
|--------------------------------------------------------------------|
1. | 1 Thursday 887.7594 697 588 824 411 12676 |
2. | 2 Friday 839.1053 697 577 828 373 6348 |
3. | 3 Tuesday 795.1429 700 592 825 339 3826 |
4. | 4 Wednesday 775.4812 696 603 824 347 4103 |
5. | 5 Monday 773.0902 662 584 846 370 3343 |
|--------------------------------------------------------------------|
6. | 6 Saturday 697.8346 608 503 736 375 4627 |
7. | 7 Sunday 692.9925 632 520 739 300 3240 |
+--------------------------------------------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

During the period from 24/1/2018 to 11/8/2020 (last 3 days dropped due to incomplete week, 2020w33 and an incomplete day - dayid = 933), the minimum and maximum of intra-day merit are 300 and 12676, on 04/8/2019 and 25/1/2018, respectively.

List of the top 50-highest day in terms of intra-day merits:

Code:

+-----------------------------------------------------------------------------+
| rank_max merit dayid date dofw week month year |
|-----------------------------------------------------------------------------|
1. | 1 12676 2 25jan2018 Thursday 2018w4 2018m1 2018 |
2. | 2 6348 3 26jan2018 Friday 2018w4 2018m1 2018 |
3. | 3 5515 668 22nov2019 Friday 2019w47 2019m11 2019 |
4. | 4 4889 667 21nov2019 Thursday 2019w47 2019m11 2019 |
5. | 5 4627 4 27jan2018 Saturday 2018w4 2018m1 2018 |
|-----------------------------------------------------------------------------|
6. | 6 4103 8 31jan2018 Wednesday 2018w5 2018m1 2018 |
7. | 7 3826 665 19nov2019 Tuesday 2019w47 2019m11 2019 |
8. | 8 3804 7 30jan2018 Tuesday 2018w5 2018m1 2018 |
9. | 9 3343 6 29jan2018 Monday 2018w5 2018m1 2018 |
10. | 10 3240 5 28jan2018 Sunday 2018w4 2018m1 2018 |
|-----------------------------------------------------------------------------|
11. | 11 2797 23 15feb2018 Thursday 2018w7 2018m2 2018 |
12. | 12 2793 9 01feb2018 Thursday 2018w5 2018m2 2018 |
13. | 13 2783 664 18nov2019 Monday 2019w46 2019m11 2019 |
14. | 14 2621 10 02feb2018 Friday 2018w5 2018m2 2018 |
15. | 15 2584 666 20nov2019 Wednesday 2019w47 2019m11 2019 |
|-----------------------------------------------------------------------------|
16. | 16 2553 237 17sep2018 Monday 2018w38 2018m9 2018 |
17. | 17 2476 11 03feb2018 Saturday 2018w5 2018m2 2018 |
18. | 18 2374 661 15nov2019 Friday 2019w46 2019m11 2019 |
19. | 19 2366 15 07feb2018 Wednesday 2018w6 2018m2 2018 |
20. | 20 2263 13 05feb2018 Monday 2018w6 2018m2 2018 |
|-----------------------------------------------------------------------------|
21. | 21 2223 17 09feb2018 Friday 2018w6 2018m2 2018 |
22. | 22 2059 16 08feb2018 Thursday 2018w6 2018m2 2018 |
23. | 23 2004 14 06feb2018 Tuesday 2018w6 2018m2 2018 |
24. | 24 1807 238 18sep2018 Tuesday 2018w38 2018m9 2018 |
25. | 25 1793 19 11feb2018 Sunday 2018w6 2018m2 2018 |
|-----------------------------------------------------------------------------|
26. | 26 1790 12 04feb2018 Sunday 2018w5 2018m2 2018 |
27. | 27 1740 24 16feb2018 Friday 2018w7 2018m2 2018 |
28. | 28 1727 39 03mar2018 Saturday 2018w9 2018m3 2018 |
29. | 29 1630 660 14nov2019 Thursday 2019w46 2019m11 2019 |
30. | 30 1590 669 23nov2019 Saturday 2019w47 2019m11 2019 |
|-----------------------------------------------------------------------------|
31. | 31 1589 26 18feb2018 Sunday 2018w7 2018m2 2018 |
32. | 32 1585 662 16nov2019 Saturday 2019w46 2019m11 2019 |
33. | 33 1580 22 14feb2018 Wednesday 2018w7 2018m2 2018 |
34. | 34 1475 20 12feb2018 Monday 2018w7 2018m2 2018 |
35. | 35 1465 678 02dec2019 Monday 2019w48 2019m12 2019 |
|-----------------------------------------------------------------------------|
36. | 36 1442 28 20feb2018 Tuesday 2018w8 2018m2 2018 |
37. | 37 1431 25 17feb2018 Saturday 2018w7 2018m2 2018 |
38. | 38 1414 35 27feb2018 Tuesday 2018w9 2018m2 2018 |
39. | 39 1390 57 21mar2018 Wednesday 2018w12 2018m3 2018 |
40. | 40 1377 663 17nov2019 Sunday 2019w46 2019m11 2019 |
|-----------------------------------------------------------------------------|
41. | 41 1372 33 25feb2018 Sunday 2018w8 2018m2 2018 |
42. | 42 1364 755 17feb2020 Monday 2020w7 2020m2 2020 |
43. | 43 1347 239 19sep2018 Wednesday 2018w38 2018m9 2018 |
44. | 44 1345 38 02mar2018 Friday 2018w9 2018m3 2018 |
45. | 45 1334 18 10feb2018 Saturday 2018w6 2018m2 2018 |
|-----------------------------------------------------------------------------|
46. | 46 1316 49 13mar2018 Tuesday 2018w11 2018m3 2018 |
47. | 47 1302 36 28feb2018 Wednesday 2018w9 2018m2 2018 |
48. | 48 1289 21 13feb2018 Tuesday 2018w7 2018m2 2018 |
49. | 49 1289 27 19feb2018 Monday 2018w8 2018m2 2018 |
50. | 50 1277 30 22feb2018 Thursday 2018w8 2018m2 2018 |
+-----------------------------------------------------------------------------+

List of the top 50-lowest days in terms of intra-day merits:

Code:

+-----------------------------------------------------------------------------+
| rank_min merit dayid date dofw week month year |
|-----------------------------------------------------------------------------|
1. | 1 300 558 04aug2019 Sunday 2019w31 2019m8 2019 |
2. | 2 333 341 30dec2018 Sunday 2018w52 2018m12 2018 |
3. | 3 339 343 01jan2019 Tuesday 2019w1 2019m1 2019 |
4. | 4 347 299 18nov2018 Sunday 2018w46 2018m11 2018 |
5. | 5 347 330 19dec2018 Wednesday 2018w51 2018m12 2018 |
|-----------------------------------------------------------------------------|
6. | 6 351 334 23dec2018 Sunday 2018w51 2018m12 2018 |
7. | 7 366 218 29aug2018 Wednesday 2018w35 2018m8 2018 |
8. | 8 367 565 11aug2019 Sunday 2019w32 2019m8 2019 |
9. | 9 370 223 03sep2018 Monday 2018w36 2018m9 2018 |
10. | 10 373 339 28dec2018 Friday 2018w52 2018m12 2018 |
|-----------------------------------------------------------------------------|
11. | 11 375 340 29dec2018 Saturday 2018w52 2018m12 2018 |
12. | 12 377 600 15sep2019 Sunday 2019w37 2019m9 2019 |
13. | 13 378 567 13aug2019 Tuesday 2019w33 2019m8 2019 |
14. | 14 378 305 24nov2018 Saturday 2018w47 2018m11 2018 |
15. | 15 378 566 12aug2019 Monday 2019w32 2019m8 2019 |
|-----------------------------------------------------------------------------|
16. | 16 380 192 03aug2018 Friday 2018w31 2018m8 2018 |
17. | 17 381 336 25dec2018 Tuesday 2018w52 2018m12 2018 |
18. | 18 385 327 16dec2018 Sunday 2018w50 2018m12 2018 |
19. | 19 385 215 26aug2018 Sunday 2018w34 2018m8 2018 |
20. | 20 391 221 01sep2018 Saturday 2018w35 2018m9 2018 |
|-----------------------------------------------------------------------------|
21. | 21 394 188 30jul2018 Monday 2018w31 2018m7 2018 |
22. | 22 395 872 13jun2020 Saturday 2020w24 2020m6 2020 |
23. | 23 399 593 08sep2019 Sunday 2019w36 2019m9 2019 |
24. | 24 401 288 07nov2018 Wednesday 2018w45 2018m11 2018 |
25. | 25 401 557 03aug2019 Saturday 2019w31 2019m8 2019 |
|-----------------------------------------------------------------------------|
26. | 26 402 263 13oct2018 Saturday 2018w41 2018m10 2018 |
27. | 27 404 229 09sep2018 Sunday 2018w36 2018m9 2018 |
28. | 28 406 277 27oct2018 Saturday 2018w43 2018m10 2018 |
29. | 29 408 530 07jul2019 Sunday 2019w27 2019m7 2019 |
30. | 30 409 589 04sep2019 Wednesday 2019w36 2019m9 2019 |
|-----------------------------------------------------------------------------|
31. | 31 409 123 26may2018 Saturday 2018w21 2018m5 2018 |
32. | 32 410 279 29oct2018 Monday 2018w44 2018m10 2018 |
33. | 33 411 578 24aug2019 Saturday 2019w34 2019m8 2019 |
34. | 34 411 569 15aug2019 Thursday 2019w33 2019m8 2019 |
35. | 35 414 528 05jul2019 Friday 2019w27 2019m7 2019 |
|-----------------------------------------------------------------------------|
36. | 36 421 193 04aug2018 Saturday 2018w31 2018m8 2018 |
37. | 37 425 588 03sep2019 Tuesday 2019w36 2019m9 2019 |
38. | 38 426 230 10sep2018 Monday 2018w37 2018m9 2018 |
39. | 39 426 346 04jan2019 Friday 2019w1 2019m1 2019 |
40. | 40 427 141 13jun2018 Wednesday 2018w24 2018m6 2018 |
|-----------------------------------------------------------------------------|
41. | 41 430 207 18aug2018 Saturday 2018w33 2018m8 2018 |
42. | 42 432 587 02sep2019 Monday 2019w35 2019m9 2019 |
43. | 43 435 522 29jun2019 Saturday 2019w26 2019m6 2019 |
44. | 44 436 419 18mar2019 Monday 2019w11 2019m3 2019 |
45. | 45 439 880 21jun2020 Sunday 2020w25 2020m6 2020 |
|-----------------------------------------------------------------------------|
46. | 46 440 265 15oct2018 Monday 2018w42 2018m10 2018 |
47. | 47 440 585 31aug2019 Saturday 2019w35 2019m8 2019 |
48. | 48 440 559 05aug2019 Monday 2019w31 2019m8 2019 |
49. | 49 441 319 08dec2018 Saturday 2018w49 2018m12 2018 |
50. | 50 441 404 03mar2019 Sunday 2019w9 2019m3 2019 |
+-----------------------------------------------------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Time-series plots:
Full dataset:

Truncated dataset:

Basic statistics (for full dataset):
Only drop last 3 days that belong to the 2020w33 (daydi = 932, 933), the incomplete week & incomlete day (dayid = 934).

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 931 780.2009 619.3686 669 565 809 300 12676
----------------------------------------------------------------------------------------------

Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 199 or 1175.

Code:

. di 809-565
244

. di 244*1.5
366

. di 809+366
1175

. di 565-366
199

There are 62 outliers (beyond 1175 or 199) in full dataset, in total.

Code:

. count if (merit >= 1175 | merit <= 199) & merit != .
62

Those days are:

Code:

+---------------------------+
   | dayid merit date |
   |---------------------------|
  2. | 2 12676 25jan2018 |
  3. | 3 6348 26jan2018 |
  4. | 4 4627 27jan2018 |
  5. | 5 3240 28jan2018 |
  6. | 6 3343 29jan2018 |
  7. | 7 3804 30jan2018 |
  8. | 8 4103 31jan2018 |
  9. | 9 2793 01feb2018 |
10. | 10 2621 02feb2018 |
11. | 11 2476 03feb2018 |
12. | 12 1790 04feb2018 |
13. | 13 2263 05feb2018 |
14. | 14 2004 06feb2018 |
15. | 15 2366 07feb2018 |
16. | 16 2059 08feb2018 |
17. | 17 2223 09feb2018 |
18. | 18 1334 10feb2018 |
19. | 19 1793 11feb2018 |
20. | 20 1475 12feb2018 |
21. | 21 1289 13feb2018 |
22. | 22 1580 14feb2018 |
23. | 23 2797 15feb2018 |
24. | 24 1740 16feb2018 |
25. | 25 1431 17feb2018 |
26. | 26 1589 18feb2018 |
27. | 27 1289 19feb2018 |
28. | 28 1442 20feb2018 |
30. | 30 1277 22feb2018 |
31. | 31 1250 23feb2018 |
33. | 33 1372 25feb2018 |
35. | 35 1414 27feb2018 |
36. | 36 1302 28feb2018 |
38. | 38 1345 02mar2018 |
39. | 39 1727 03mar2018 |
49. | 49 1316 13mar2018 |
51. | 51 1224 15mar2018 |
57. | 57 1390 21mar2018 |
58. | 58 1211 22mar2018 |
69. | 69 1181 02apr2018 |
70. | 70 1186 03apr2018 |
237. | 237 2553 17sep2018 |
238. | 238 1807 18sep2018 |
239. | 239 1347 19sep2018 |
240. | 240 1221 20sep2018 |
   |---------------------------|
429. | 429 1247 28mar2019 |
476. | 476 1215 14may2019 |
505. | 505 1227 12jun2019 |
660. | 660 1630 14nov2019 |
661. | 661 2374 15nov2019 |
662. | 662 1585 16nov2019 |
663. | 663 1377 17nov2019 |
664. | 664 2783 18nov2019 |
665. | 665 3826 19nov2019 |
666. | 666 2584 20nov2019 |
667. | 667 4889 21nov2019 |
668. | 668 5515 22nov2019 |
669. | 669 1590 23nov2019 |
678. | 678 1465 02dec2019 |
   |---------------------------|
726. | 726 1192 19jan2020 |
755. | 755 1364 17feb2020 |
756. | 756 1195 18feb2020 |
845. | 845 1198 17may2020 |
   +---------------------------+

Distributions of outliers over years:

2018: 44 (71.0%)
2019: 14 (22.6%)
2020: 4 (6.4%)

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Converted dataset:

In 2020 ^{at 14aug2020 02:23:31 (GMT time)}
The last one, with dayid = 934 is an incomplete day.

Code:

+-----------------------------------------------------------------+
| dayid date merit dofw week month year |
|-----------------------------------------------------------------|
708. | 708 01jan2020 810 Wednesday 2020w1 2020m1 2020 |
709. | 709 02jan2020 854 Thursday 2020w1 2020m1 2020 |
710. | 710 03jan2020 837 Friday 2020w1 2020m1 2020 |
711. | 711 04jan2020 637 Saturday 2020w1 2020m1 2020 |
712. | 712 05jan2020 777 Sunday 2020w1 2020m1 2020 |
|-----------------------------------------------------------------|
713. | 713 06jan2020 959 Monday 2020w1 2020m1 2020 |
714. | 714 07jan2020 871 Tuesday 2020w1 2020m1 2020 |
715. | 715 08jan2020 860 Wednesday 2020w2 2020m1 2020 |
716. | 716 09jan2020 733 Thursday 2020w2 2020m1 2020 |
717. | 717 10jan2020 745 Friday 2020w2 2020m1 2020 |
|-----------------------------------------------------------------|
718. | 718 11jan2020 743 Saturday 2020w2 2020m1 2020 |
719. | 719 12jan2020 689 Sunday 2020w2 2020m1 2020 |
720. | 720 13jan2020 754 Monday 2020w2 2020m1 2020 |
721. | 721 14jan2020 871 Tuesday 2020w2 2020m1 2020 |
722. | 722 15jan2020 979 Wednesday 2020w3 2020m1 2020 |
|-----------------------------------------------------------------|
723. | 723 16jan2020 972 Thursday 2020w3 2020m1 2020 |
724. | 724 17jan2020 1063 Friday 2020w3 2020m1 2020 |
725. | 725 18jan2020 823 Saturday 2020w3 2020m1 2020 |
726. | 726 19jan2020 1192 Sunday 2020w3 2020m1 2020 |
727. | 727 20jan2020 1136 Monday 2020w3 2020m1 2020 |
|-----------------------------------------------------------------|
728. | 728 21jan2020 1082 Tuesday 2020w3 2020m1 2020 |
729. | 729 22jan2020 863 Wednesday 2020w4 2020m1 2020 |
730. | 730 23jan2020 1050 Thursday 2020w4 2020m1 2020 |
731. | 731 24jan2020 1061 Friday 2020w4 2020m1 2020 |
732. | 732 25jan2020 1043 Saturday 2020w4 2020m1 2020 |
|-----------------------------------------------------------------|
733. | 733 26jan2020 715 Sunday 2020w4 2020m1 2020 |
734. | 734 27jan2020 961 Monday 2020w4 2020m1 2020 |
735. | 735 28jan2020 953 Tuesday 2020w4 2020m1 2020 |
736. | 736 29jan2020 1051 Wednesday 2020w5 2020m1 2020 |
737. | 737 30jan2020 1125 Thursday 2020w5 2020m1 2020 |
|-----------------------------------------------------------------|
738. | 738 31jan2020 1072 Friday 2020w5 2020m1 2020 |
739. | 739 01feb2020 705 Saturday 2020w5 2020m2 2020 |
740. | 740 02feb2020 836 Sunday 2020w5 2020m2 2020 |
741. | 741 03feb2020 908 Monday 2020w5 2020m2 2020 |
742. | 742 04feb2020 1059 Tuesday 2020w5 2020m2 2020 |
|-----------------------------------------------------------------|
743. | 743 05feb2020 873 Wednesday 2020w6 2020m2 2020 |
744. | 744 06feb2020 932 Thursday 2020w6 2020m2 2020 |
745. | 745 07feb2020 800 Friday 2020w6 2020m2 2020 |
746. | 746 08feb2020 763 Saturday 2020w6 2020m2 2020 |
747. | 747 09feb2020 724 Sunday 2020w6 2020m2 2020 |
|-----------------------------------------------------------------|
748. | 748 10feb2020 812 Monday 2020w6 2020m2 2020 |
749. | 749 11feb2020 669 Tuesday 2020w6 2020m2 2020 |
750. | 750 12feb2020 596 Wednesday 2020w7 2020m2 2020 |
751. | 751 13feb2020 1047 Thursday 2020w7 2020m2 2020 |
752. | 752 14feb2020 1041 Friday 2020w7 2020m2 2020 |
|-----------------------------------------------------------------|
753. | 753 15feb2020 890 Saturday 2020w7 2020m2 2020 |
754. | 754 16feb2020 790 Sunday 2020w7 2020m2 2020 |
755. | 755 17feb2020 1364 Monday 2020w7 2020m2 2020 |
756. | 756 18feb2020 1195 Tuesday 2020w7 2020m2 2020 |
757. | 757 19feb2020 1004 Wednesday 2020w8 2020m2 2020 |
|-----------------------------------------------------------------|
758. | 758 20feb2020 782 Thursday 2020w8 2020m2 2020 |
759. | 759 21feb2020 1050 Friday 2020w8 2020m2 2020 |
760. | 760 22feb2020 729 Saturday 2020w8 2020m2 2020 |
761. | 761 23feb2020 724 Sunday 2020w8 2020m2 2020 |
762. | 762 24feb2020 1037 Monday 2020w8 2020m2 2020 |
|-----------------------------------------------------------------|
763. | 763 25feb2020 988 Tuesday 2020w8 2020m2 2020 |
764. | 764 26feb2020 857 Wednesday 2020w9 2020m2 2020 |
765. | 765 27feb2020 960 Thursday 2020w9 2020m2 2020 |
766. | 766 28feb2020 678 Friday 2020w9 2020m2 2020 |
767. | 767 29feb2020 662 Saturday 2020w9 2020m2 2020 |
|-----------------------------------------------------------------|
768. | 768 01mar2020 651 Sunday 2020w9 2020m3 2020 |
769. | 769 02mar2020 755 Monday 2020w9 2020m3 2020 |
770. | 770 03mar2020 674 Tuesday 2020w9 2020m3 2020 |
771. | 771 04mar2020 572 Wednesday 2020w10 2020m3 2020 |
772. | 772 05mar2020 727 Thursday 2020w10 2020m3 2020 |
|-----------------------------------------------------------------|
773. | 773 06mar2020 622 Friday 2020w10 2020m3 2020 |
774. | 774 07mar2020 697 Saturday 2020w10 2020m3 2020 |
775. | 775 08mar2020 670 Sunday 2020w10 2020m3 2020 |
776. | 776 09mar2020 634 Monday 2020w10 2020m3 2020 |
777. | 777 10mar2020 700 Tuesday 2020w10 2020m3 2020 |
|-----------------------------------------------------------------|
778. | 778 11mar2020 800 Wednesday 2020w11 2020m3 2020 |
779. | 779 12mar2020 790 Thursday 2020w11 2020m3 2020 |
780. | 780 13mar2020 748 Friday 2020w11 2020m3 2020 |
781. | 781 14mar2020 562 Saturday 2020w11 2020m3 2020 |
782. | 782 15mar2020 528 Sunday 2020w11 2020m3 2020 |
|-----------------------------------------------------------------|
783. | 783 16mar2020 888 Monday 2020w11 2020m3 2020 |
784. | 784 17mar2020 793 Tuesday 2020w11 2020m3 2020 |
785. | 785 18mar2020 1090 Wednesday 2020w12 2020m3 2020 |
786. | 786 19mar2020 867 Thursday 2020w12 2020m3 2020 |
787. | 787 20mar2020 999 Friday 2020w12 2020m3 2020 |
|-----------------------------------------------------------------|
788. | 788 21mar2020 628 Saturday 2020w12 2020m3 2020 |
789. | 789 22mar2020 549 Sunday 2020w12 2020m3 2020 |
790. | 790 23mar2020 683 Monday 2020w12 2020m3 2020 |
791. | 791 24mar2020 787 Tuesday 2020w12 2020m3 2020 |
792. | 792 25mar2020 786 Wednesday 2020w13 2020m3 2020 |
|-----------------------------------------------------------------|
793. | 793 26mar2020 855 Thursday 2020w13 2020m3 2020 |
794. | 794 27mar2020 934 Friday 2020w13 2020m3 2020 |
795. | 795 28mar2020 658 Saturday 2020w13 2020m3 2020 |
796. | 796 29mar2020 452 Sunday 2020w13 2020m3 2020 |
797. | 797 30mar2020 909 Monday 2020w13 2020m3 2020 |
|-----------------------------------------------------------------|
798. | 798 31mar2020 798 Tuesday 2020w13 2020m3 2020 |
799. | 799 01apr2020 858 Wednesday 2020w14 2020m4 2020 |
800. | 800 02apr2020 1062 Thursday 2020w14 2020m4 2020 |
801. | 801 03apr2020 805 Friday 2020w14 2020m4 2020 |
802. | 802 04apr2020 943 Saturday 2020w14 2020m4 2020 |
|-----------------------------------------------------------------|
803. | 803 05apr2020 661 Sunday 2020w14 2020m4 2020 |
804. | 804 06apr2020 846 Monday 2020w14 2020m4 2020 |
805. | 805 07apr2020 886 Tuesday 2020w14 2020m4 2020 |
806. | 806 08apr2020 875 Wednesday 2020w15 2020m4 2020 |
807. | 807 09apr2020 687 Thursday 2020w15 2020m4 2020 |
|-----------------------------------------------------------------|
808. | 808 10apr2020 758 Friday 2020w15 2020m4 2020 |
809. | 809 11apr2020 615 Saturday 2020w15 2020m4 2020 |
810. | 810 12apr2020 660 Sunday 2020w15 2020m4 2020 |
811. | 811 13apr2020 592 Monday 2020w15 2020m4 2020 |
812. | 812 14apr2020 907 Tuesday 2020w15 2020m4 2020 |
|-----------------------------------------------------------------|
813. | 813 15apr2020 734 Wednesday 2020w16 2020m4 2020 |
814. | 814 16apr2020 763 Thursday 2020w16 2020m4 2020 |
815. | 815 17apr2020 827 Friday 2020w16 2020m4 2020 |
816. | 816 18apr2020 752 Saturday 2020w16 2020m4 2020 |
817. | 817 19apr2020 627 Sunday 2020w16 2020m4 2020 |
|-----------------------------------------------------------------|
818. | 818 20apr2020 626 Monday 2020w16 2020m4 2020 |
819. | 819 21apr2020 723 Tuesday 2020w16 2020m4 2020 |
820. | 820 22apr2020 700 Wednesday 2020w17 2020m4 2020 |
821. | 821 23apr2020 687 Thursday 2020w17 2020m4 2020 |
822. | 822 24apr2020 706 Friday 2020w17 2020m4 2020 |
|-----------------------------------------------------------------|
823. | 823 25apr2020 639 Saturday 2020w17 2020m4 2020 |
824. | 824 26apr2020 663 Sunday 2020w17 2020m4 2020 |
825. | 825 27apr2020 654 Monday 2020w17 2020m4 2020 |
826. | 826 28apr2020 490 Tuesday 2020w17 2020m4 2020 |
827. | 827 29apr2020 795 Wednesday 2020w18 2020m4 2020 |
|-----------------------------------------------------------------|
828. | 828 30apr2020 983 Thursday 2020w18 2020m4 2020 |
829. | 829 01may2020 1099 Friday 2020w18 2020m5 2020 |
830. | 830 02may2020 745 Saturday 2020w18 2020m5 2020 |
831. | 831 03may2020 716 Sunday 2020w18 2020m5 2020 |
832. | 832 04may2020 659 Monday 2020w18 2020m5 2020 |
|-----------------------------------------------------------------|
833. | 833 05may2020 702 Tuesday 2020w18 2020m5 2020 |
834. | 834 06may2020 707 Wednesday 2020w19 2020m5 2020 |
835. | 835 07may2020 852 Thursday 2020w19 2020m5 2020 |
836. | 836 08may2020 734 Friday 2020w19 2020m5 2020 |
837. | 837 09may2020 806 Saturday 2020w19 2020m5 2020 |
|-----------------------------------------------------------------|
838. | 838 10may2020 919 Sunday 2020w19 2020m5 2020 |
839. | 839 11may2020 988 Monday 2020w19 2020m5 2020 |
840. | 840 12may2020 642 Tuesday 2020w19 2020m5 2020 |
841. | 841 13may2020 734 Wednesday 2020w20 2020m5 2020 |
842. | 842 14may2020 929 Thursday 2020w20 2020m5 2020 |
|-----------------------------------------------------------------|
843. | 843 15may2020 681 Friday 2020w20 2020m5 2020 |
844. | 844 16may2020 749 Saturday 2020w20 2020m5 2020 |
845. | 845 17may2020 1198 Sunday 2020w20 2020m5 2020 |
846. | 846 18may2020 728 Monday 2020w20 2020m5 2020 |
847. | 847 19may2020 783 Tuesday 2020w20 2020m5 2020 |
|-----------------------------------------------------------------|
848. | 848 20may2020 759 Wednesday 2020w21 2020m5 2020 |
849. | 849 21may2020 774 Thursday 2020w21 2020m5 2020 |
850. | 850 22may2020 805 Friday 2020w21 2020m5 2020 |
851. | 851 23may2020 731 Saturday 2020w21 2020m5 2020 |
852. | 852 24may2020 598 Sunday 2020w21 2020m5 2020 |
|-----------------------------------------------------------------|
853. | 853 25may2020 937 Monday 2020w21 2020m5 2020 |
854. | 854 26may2020 730 Tuesday 2020w21 2020m5 2020 |
855. | 855 27may2020 698 Wednesday 2020w22 2020m5 2020 |
856. | 856 28may2020 690 Thursday 2020w22 2020m5 2020 |
857. | 857 29may2020 686 Friday 2020w22 2020m5 2020 |
|-----------------------------------------------------------------|
858. | 858 30may2020 565 Saturday 2020w22 2020m5 2020 |
859. | 859 31may2020 530 Sunday 2020w22 2020m5 2020 |
860. | 860 01jun2020 834 Monday 2020w22 2020m6 2020 |
861. | 861 02jun2020 659 Tuesday 2020w22 2020m6 2020 |
862. | 862 03jun2020 488 Wednesday 2020w23 2020m6 2020 |
|-----------------------------------------------------------------|
863. | 863 04jun2020 759 Thursday 2020w23 2020m6 2020 |
864. | 864 05jun2020 640 Friday 2020w23 2020m6 2020 |
865. | 865 06jun2020 589 Saturday 2020w23 2020m6 2020 |
866. | 866 07jun2020 741 Sunday 2020w23 2020m6 2020 |
867. | 867 08jun2020 638 Monday 2020w23 2020m6 2020 |
|-----------------------------------------------------------------|
868. | 868 09jun2020 821 Tuesday 2020w23 2020m6 2020 |
869. | 869 10jun2020 666 Wednesday 2020w24 2020m6 2020 |
870. | 870 11jun2020 623 Thursday 2020w24 2020m6 2020 |
871. | 871 12jun2020 688 Friday 2020w24 2020m6 2020 |
872. | 872 13jun2020 395 Saturday 2020w24 2020m6 2020 |
|-----------------------------------------------------------------|
873. | 873 14jun2020 602 Sunday 2020w24 2020m6 2020 |
874. | 874 15jun2020 682 Monday 2020w24 2020m6 2020 |
875. | 875 16jun2020 534 Tuesday 2020w24 2020m6 2020 |
876. | 876 17jun2020 570 Wednesday 2020w25 2020m6 2020 |
877. | 877 18jun2020 587 Thursday 2020w25 2020m6 2020 |
|-----------------------------------------------------------------|
878. | 878 19jun2020 675 Friday 2020w25 2020m6 2020 |
879. | 879 20jun2020 658 Saturday 2020w25 2020m6 2020 |
880. | 880 21jun2020 439 Sunday 2020w25 2020m6 2020 |
881. | 881 22jun2020 602 Monday 2020w25 2020m6 2020 |
882. | 882 23jun2020 835 Tuesday 2020w25 2020m6 2020 |
|-----------------------------------------------------------------|
883. | 883 24jun2020 700 Wednesday 2020w26 2020m6 2020 |
884. | 884 25jun2020 579 Thursday 2020w26 2020m6 2020 |
885. | 885 26jun2020 679 Friday 2020w26 2020m6 2020 |
886. | 886 27jun2020 481 Saturday 2020w26 2020m6 2020 |
887. | 887 28jun2020 657 Sunday 2020w26 2020m6 2020 |
|-----------------------------------------------------------------|
888. | 888 29jun2020 746 Monday 2020w26 2020m6 2020 |
889. | 889 30jun2020 632 Tuesday 2020w26 2020m6 2020 |
890. | 890 01jul2020 734 Wednesday 2020w27 2020m7 2020 |
891. | 891 02jul2020 531 Thursday 2020w27 2020m7 2020 |
892. | 892 03jul2020 792 Friday 2020w27 2020m7 2020 |
|-----------------------------------------------------------------|
893. | 893 04jul2020 755 Saturday 2020w27 2020m7 2020 |
894. | 894 05jul2020 556 Sunday 2020w27 2020m7 2020 |
895. | 895 06jul2020 581 Monday 2020w27 2020m7 2020 |
896. | 896 07jul2020 681 Tuesday 2020w27 2020m7 2020 |
897. | 897 08jul2020 880 Wednesday 2020w28 2020m7 2020 |
|-----------------------------------------------------------------|
898. | 898 09jul2020 591 Thursday 2020w28 2020m7 2020 |
899. | 899 10jul2020 677 Friday 2020w28 2020m7 2020 |
900. | 900 11jul2020 605 Saturday 2020w28 2020m7 2020 |
901. | 901 12jul2020 681 Sunday 2020w28 2020m7 2020 |
902. | 902 13jul2020 668 Monday 2020w28 2020m7 2020 |
|-----------------------------------------------------------------|
903. | 903 14jul2020 571 Tuesday 2020w28 2020m7 2020 |
904. | 904 15jul2020 593 Wednesday 2020w29 2020m7 2020 |
905. | 905 16jul2020 770 Thursday 2020w29 2020m7 2020 |
906. | 906 17jul2020 642 Friday 2020w29 2020m7 2020 |
907. | 907 18jul2020 484 Saturday 2020w29 2020m7 2020 |
|-----------------------------------------------------------------|
908. | 908 19jul2020 864 Sunday 2020w29 2020m7 2020 |
909. | 909 20jul2020 653 Monday 2020w29 2020m7 2020 |
910. | 910 21jul2020 479 Tuesday 2020w29 2020m7 2020 |
911. | 911 22jul2020 671 Wednesday 2020w30 2020m7 2020 |
912. | 912 23jul2020 679 Thursday 2020w30 2020m7 2020 |
|-----------------------------------------------------------------|
913. | 913 24jul2020 613 Friday 2020w30 2020m7 2020 |
914. | 914 25jul2020 476 Saturday 2020w30 2020m7 2020 |
915. | 915 26jul2020 682 Sunday 2020w30 2020m7 2020 |
916. | 916 27jul2020 816 Monday 2020w30 2020m7 2020 |
917. | 917 28jul2020 581 Tuesday 2020w30 2020m7 2020 |
|-----------------------------------------------------------------|
918. | 918 29jul2020 747 Wednesday 2020w31 2020m7 2020 |
919. | 919 30jul2020 651 Thursday 2020w31 2020m7 2020 |
920. | 920 31jul2020 957 Friday 2020w31 2020m7 2020 |
921. | 921 01aug2020 654 Saturday 2020w31 2020m8 2020 |
922. | 922 02aug2020 738 Sunday 2020w31 2020m8 2020 |
|-----------------------------------------------------------------|
923. | 923 03aug2020 635 Monday 2020w31 2020m8 2020 |
924. | 924 04aug2020 581 Tuesday 2020w31 2020m8 2020 |
925. | 925 05aug2020 592 Wednesday 2020w32 2020m8 2020 |
926. | 926 06aug2020 592 Thursday 2020w32 2020m8 2020 |
927. | 927 07aug2020 607 Friday 2020w32 2020m8 2020 |
|-----------------------------------------------------------------|
928. | 928 08aug2020 494 Saturday 2020w32 2020m8 2020 |
929. | 929 09aug2020 527 Sunday 2020w32 2020m8 2020 |
930. | 930 10aug2020 675 Monday 2020w32 2020m8 2020 |
931. | 931 11aug2020 587 Tuesday 2020w32 2020m8 2020 |
932. | 932 12aug2020 640 Wednesday 2020w33 2020m8 2020 |
|-----------------------------------------------------------------|
933. | 933 13aug2020 456 Thursday 2020w33 2020m8 2020 |
934. | 934 14aug2020 56 Friday 2020w33 2020m8 2020 |
+-----------------------------------------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

ABSTRACT ^{2020w31, GMT time}

Data is the full dataset since 24/1/2018, and only dropped last 3 days belong to incomplete week - 2020w32 and an incomplete day (dayid = 927). Details on days dropped, please see above posts.

Intra-day merits:

Total observed days: 924
Potential outliers are days that have intraday total merits beyond 198 or 1178
Median of intraday merits over the period is 671
50% of observed days have their intra-day merits range from 566 to 810 (the interquartile range)
In medians, the highest and lowest days are Thursday and Saturday, respectively; whilst the highest and lowest days in means are Thursday and Sunday, respectively. See here.
There are 62 potential outliers (beyond 198 or 1178) in total.
The distribution of outliers over years are: 44 (71.0%) for 2018, 14 (22.6%) for 2019, and 4 (6.4%) for 2020. (see details)
Minimum and maximum of intraday merits (full dataset) are 300, and 12676, on 04/8/2019 and 25/1/2018, respectively.

Intra-week merits:

Total observed weeks: 132
The median of intra-week merits is 4656
50% of observed weeks (132 weeks in total), have total merits in the range from 4260 to 5585 (the interquartile range of intra-week merits).
Minimum and maximum of intra-week merits are 3186 and 27920, in 2018w35, and 2018w4, respectively;
9 potential outliers [beyond 2272 or 7572], only 2 of them occurred in the year 2019, on 2019w46 (11070), and 2019w47 (20397); none of them occured in 2020.

Intra-month merits:

Total observed months: 31
The median of intra-month merits is 21467
50% of observed months (31 months in total), have total merits in the range from 18485 to 23874 (the interquartile range of intra-month merits).
Minimum and maximum of intra-month merits are 15609 and 48374, in 2018m12, and 2018m2, respectively;
4 potential outliers [beyond 10402 or 31958], only 1 of them occurred in the year 2019, on 2019m11 (42866); none of them occured in 2020.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Intra-month merits (from 24/1/2018 to 31/7/2020)
There are days dropped in order to get data for entire month. Days with id > 920 are dropped because those days belong to the incomplete July of 2020 (2020m8).

Converted dataset:

Code:

+-----------------+
   | merit month |
   |-----------------|
  1. | 39170 2018m1 |
  2. | 48374 2018m2 |
  3. | 32141 2018m3 |
  4. | 23482 2018m4 |
  5. | 19807 2018m5 |
   |-----------------|
  6. | 18693 2018m6 |
  7. | 18286 2018m7 |
  8. | 16631 2018m8 |
  9. | 22075 2018m9 |
10. | 18592 2018m10 |
   |-----------------|
11. | 17442 2018m11 |
12. | 15609 2018m12 |
13. | 22875 2019m1 |
14. | 17756 2019m2 |
15. | 21467 2019m3 |
   |-----------------|
16. | 20698 2019m4 |
17. | 22069 2019m5 |
18. | 20355 2019m6 |
19. | 18485 2019m7 |
20. | 16094 2019m8 |
   |-----------------|
21. | 17406 2019m9 |
22. | 21583 2019m10 |
23. | 42866 2019m11 |
24. | 24909 2019m12 |
25. | 28281 2020m1 |
   |-----------------|
26. | 25475 2020m2 |
27. | 22806 2020m3 |
28. | 22524 2020m4 |
29. | 23874 2020m5 |
30. | 19199 2020m6 |
   |-----------------|
31. | 20661 2020m7 |
   +-----------------+

Time series plot

Basic statistics:
- 50% of observed months (31 months) have total intra-month merits above 21467, whilst the rest 50% of them have total intra-month merits below 21467. 21467 is the median - p50.
- 50% of observed months have total intra-month merits fluctuated in the range from 18485 to 23874 (the interquartile range, from p25 to p75, in raw statistics below).
- Min - max: 15609 - 48374.

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 31 23215.65 7708.572 21467 18485 23874 15609 48374
----------------------------------------------------------------------------------------------

Potential outliers:

Code:

. di 23874-18485
5389

. di 5389*1.5
8083.5

. di 23874+8083.5
31957.5

. di 18485-8083.5
10401.5

It means that potential outliers are months that have intra-month merits beyond 10402 or 31958.
How many months are potential outliers?

Code:

. count if (merit >= 31958 | merit <= 10402) & merit != .
4

4 months are outliers, in total.
List of those four months:

Code:

+-----------------+
   | merit month |
   |-----------------|
  1. | 39170 2018m1 |
  2. | 48374 2018m2 |
  3. | 32141 2018m3 |
23. | 42866 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, at 42866.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Intra-week merits (from 24/1/2018 to 04/8/2020)
Last 3 days dropped due to incomplete week (2020w32) and an incomplete day (dayid = 927)

Converted dataset:

Code:

+-----------------+
   | merit week |
   |-----------------|
  1. | 27920 2018w4 |
  2. | 20930 2018w5 |
  3. | 14042 2018w6 |
  4. | 11901 2018w7 |
  5. | 8879 2018w8 |
   |-----------------|
  6. | 9005 2018w9 |
  7. | 7178 2018w10 |
  8. | 7340 2018w11 |
  9. | 7138 2018w12 |
10. | 6392 2018w13 |
   |-----------------|
11. | 6542 2018w14 |
12. | 5946 2018w15 |
13. | 4449 2018w16 |
14. | 4820 2018w17 |
15. | 5043 2018w18 |
   |-----------------|
16. | 4685 2018w19 |
17. | 4431 2018w20 |
18. | 3903 2018w21 |
19. | 4248 2018w22 |
20. | 4473 2018w23 |
   |-----------------|
21. | 3953 2018w24 |
22. | 4574 2018w25 |
23. | 4684 2018w26 |
24. | 4367 2018w27 |
25. | 4109 2018w28 |
   |-----------------|
26. | 4277 2018w29 |
27. | 3809 2018w30 |
28. | 3489 2018w31 |
29. | 4199 2018w32 |
30. | 3767 2018w33 |
   |-----------------|
31. | 3763 2018w34 |
32. | 3186 2018w35 |
33. | 3536 2018w36 |
34. | 3586 2018w37 |
35. | 9587 2018w38 |
   |-----------------|
36. | 4508 2018w39 |
37. | 4325 2018w40 |
38. | 3981 2018w41 |
39. | 4424 2018w42 |
40. | 4386 2018w43 |
   |-----------------|
41. | 3321 2018w44 |
42. | 4175 2018w45 |
43. | 4047 2018w46 |
44. | 4606 2018w47 |
45. | 3791 2018w48 |
   |-----------------|
46. | 3596 2018w49 |
47. | 3689 2018w50 |
48. | 3615 2018w51 |
49. | 3687 2018w52 |
50. | 4584 2019w1 |
   |-----------------|
51. | 6102 2019w2 |
52. | 5776 2019w3 |
53. | 4582 2019w4 |
54. | 4408 2019w5 |
55. | 4505 2019w6 |
   |-----------------|
56. | 4259 2019w7 |
57. | 4314 2019w8 |
58. | 4726 2019w9 |
59. | 4979 2019w10 |
60. | 4295 2019w11 |
   |-----------------|
61. | 4690 2019w12 |
62. | 5728 2019w13 |
63. | 4695 2019w14 |
64. | 5253 2019w15 |
65. | 4880 2019w16 |
   |-----------------|
66. | 4260 2019w17 |
67. | 4817 2019w18 |
68. | 5002 2019w19 |
69. | 5596 2019w20 |
70. | 4693 2019w21 |
   |-----------------|
71. | 4342 2019w22 |
72. | 4597 2019w23 |
73. | 5373 2019w24 |
74. | 4629 2019w25 |
75. | 4672 2019w26 |
   |-----------------|
76. | 3882 2019w27 |
77. | 4462 2019w28 |
78. | 4005 2019w29 |
79. | 4377 2019w30 |
80. | 3603 2019w31 |
   |-----------------|
81. | 3346 2019w32 |
82. | 3965 2019w33 |
83. | 3811 2019w34 |
84. | 3579 2019w35 |
85. | 3683 2019w36 |
   |-----------------|
86. | 4005 2019w37 |
87. | 4382 2019w38 |
88. | 4348 2019w39 |
89. | 4209 2019w40 |
90. | 4701 2019w41 |
   |-----------------|
91. | 5160 2019w42 |
92. | 5375 2019w43 |
93. | 4816 2019w44 |
94. | 4753 2019w45 |
95. | 11070 2019w46 |
   |-----------------|
96. | 20397 2019w47 |
97. | 6271 2019w48 |
98. | 4650 2019w49 |
99. | 4832 2019w50 |
100. | 6066 2019w51 |
   |-----------------|
101. | 7058 2019w52 |
102. | 5745 2020w1 |
103. | 5395 2020w2 |
104. | 7247 2020w3 |
105. | 6646 2020w4 |
   |-----------------|
106. | 6756 2020w5 |
107. | 5573 2020w6 |
108. | 6923 2020w7 |
109. | 6314 2020w8 |
110. | 5237 2020w9 |
   |-----------------|
111. | 4622 2020w10 |
112. | 5109 2020w11 |
113. | 5603 2020w12 |
114. | 5392 2020w13 |
115. | 6061 2020w14 |
   |-----------------|
116. | 5094 2020w15 |
117. | 5052 2020w16 |
118. | 4539 2020w17 |
119. | 5699 2020w18 |
120. | 5648 2020w19 |
   |-----------------|
121. | 5802 2020w20 |
122. | 5334 2020w21 |
123. | 4662 2020w22 |
124. | 4676 2020w23 |
125. | 4190 2020w24 |
   |-----------------|
126. | 4366 2020w25 |
127. | 4474 2020w26 |
128. | 4630 2020w27 |
129. | 4673 2020w28 |
130. | 4485 2020w29 |
   |-----------------|
131. | 4518 2020w30 |
132. | 4963 2020w31 |
   +-----------------+

Time series plot

Basic statistics:
- 50% of observed weeks (132 weeks) have total intra-week merits above 4656, whilst the rest 50% of them have total intra-week merits below 4656. 4656 is the median - p50.
- 50% of observed weeks have total intra-week merits fluctuated in the range from 4260 to 5585 (the interquartile range, from p25 to p75, in raw statistics below).
- Min - max: 3186 - 27920.

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 132.0 5471.9 3169.4 4656.0 4259.5 5584.5 3186.0 27920.0
----------------------------------------------------------------------------------------------

Potential outliers:

Code:

. di 5584.5-4259.5
1325

. di 1325*1.5
1987.5

. di 5584.5+1987.5
7572

. di 4259.5-1987.5
2272

It means that potential outliers are weeks that have intra-week merits beyond 2272 or 7572.
How many weeks are potential outliers?

Code:

. count if (merit >= 7572 | merit < 2272) & merit != .
9

9 weeks are outliers, in total.
List of those 9 weeks:

Code:

+-----------------+
   | merit week |
   |-----------------|
  1. | 27920 2018w4 |
  2. | 20930 2018w5 |
  3. | 14042 2018w6 |
  4. | 11901 2018w7 |
  5. | 8879 2018w8 |
   |-----------------|
  6. | 9005 2018w9 |
35. | 9587 2018w38 |
95. | 11070 2019w46 |
96. | 20397 2019w47 |
   +-----------------+

Most of them occured in the year 2018, and there is only 2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 (20397). None of them occured in 2020 so far.

List of weeks in descending weekly merits
The last week (with 4963 merits) stays at the 49^th position, among 132 weeks.

Code:

+------------------------------+
   | weeklyrank merit week |
   |------------------------------|
  1. | 1 27920 2018w4 |
  2. | 2 20930 2018w5 |
  3. | 3 20397 2019w47 |
  4. | 4 14042 2018w6 |
  5. | 5 11901 2018w7 |
   |------------------------------|
  6. | 6 11070 2019w46 |
  7. | 7 9587 2018w38 |
  8. | 8 9005 2018w9 |
  9. | 9 8879 2018w8 |
10. | 10 7340 2018w11 |
   |------------------------------|
11. | 11 7247 2020w3 |
12. | 12 7178 2018w10 |
13. | 13 7138 2018w12 |
14. | 14 7058 2019w52 |
15. | 15 6923 2020w7 |
   |------------------------------|
16. | 16 6756 2020w5 |
17. | 17 6646 2020w4 |
18. | 18 6542 2018w14 |
19. | 19 6392 2018w13 |
20. | 20 6314 2020w8 |
   |------------------------------|
21. | 21 6271 2019w48 |
22. | 22 6102 2019w2 |
23. | 23 6066 2019w51 |
24. | 24 6061 2020w14 |
25. | 25 5946 2018w15 |
   |------------------------------|
26. | 26 5802 2020w20 |
27. | 27 5776 2019w3 |
28. | 28 5745 2020w1 |
29. | 29 5728 2019w13 |
30. | 30 5699 2020w18 |
   |------------------------------|
31. | 31 5648 2020w19 |
32. | 32 5603 2020w12 |
33. | 33 5596 2019w20 |
34. | 34 5573 2020w6 |
35. | 35 5395 2020w2 |
   |------------------------------|
36. | 36 5392 2020w13 |
37. | 37 5375 2019w43 |
38. | 38 5373 2019w24 |
39. | 39 5334 2020w21 |
40. | 40 5253 2019w15 |
   |------------------------------|
41. | 41 5237 2020w9 |
42. | 42 5160 2019w42 |
43. | 43 5109 2020w11 |
44. | 44 5094 2020w15 |
45. | 45 5052 2020w16 |
   |------------------------------|
46. | 46 5043 2018w18 |
47. | 47 5002 2019w19 |
48. | 48 4979 2019w10 |
49. | 49 4963 2020w31 |
50. | 50 4880 2019w16 |
   |------------------------------|
51. | 51 4832 2019w50 |
52. | 52 4820 2018w17 |
53. | 53 4817 2019w18 |
54. | 54 4816 2019w44 |
55. | 55 4753 2019w45 |
   |------------------------------|
56. | 56 4726 2019w9 |
57. | 57 4701 2019w41 |
58. | 58 4695 2019w14 |
59. | 59 4693 2019w21 |
60. | 60 4690 2019w12 |
   |------------------------------|
61. | 61 4685 2018w19 |
62. | 62 4684 2018w26 |
63. | 63 4676 2020w23 |
64. | 64 4673 2020w28 |
65. | 65 4672 2019w26 |
   |------------------------------|
66. | 66 4662 2020w22 |
67. | 67 4650 2019w49 |
68. | 68 4630 2020w27 |
69. | 69 4629 2019w25 |
70. | 70 4622 2020w10 |
   |------------------------------|
71. | 71 4606 2018w47 |
72. | 72 4597 2019w23 |
73. | 73 4584 2019w1 |
74. | 74 4582 2019w4 |
75. | 75 4574 2018w25 |
   |------------------------------|
76. | 76 4539 2020w17 |
77. | 77 4518 2020w30 |
78. | 78 4508 2018w39 |
79. | 79 4505 2019w6 |
80. | 80 4485 2020w29 |
   |------------------------------|
81. | 81 4474 2020w26 |
82. | 82 4473 2018w23 |
83. | 83 4462 2019w28 |
84. | 84 4449 2018w16 |
85. | 85 4431 2018w20 |
   |------------------------------|
86. | 86 4424 2018w42 |
87. | 87 4408 2019w5 |
88. | 88 4386 2018w43 |
89. | 89 4382 2019w38 |
90. | 90 4377 2019w30 |
   |------------------------------|
91. | 91 4367 2018w27 |
92. | 92 4366 2020w25 |
93. | 93 4348 2019w39 |
94. | 94 4342 2019w22 |
95. | 95 4325 2018w40 |
   |------------------------------|
96. | 96 4314 2019w8 |
97. | 97 4295 2019w11 |
98. | 98 4277 2018w29 |
99. | 99 4260 2019w17 |
100. | 100 4259 2019w7 |
   |------------------------------|
101. | 101 4248 2018w22 |
102. | 102 4209 2019w40 |
103. | 103 4199 2018w32 |
104. | 104 4190 2020w24 |
105. | 105 4175 2018w45 |
   |------------------------------|
106. | 106 4109 2018w28 |
107. | 107 4047 2018w46 |
108. | 108 4005 2019w29 |
109. | 109 4005 2019w37 |
110. | 110 3981 2018w41 |
   |------------------------------|
111. | 111 3965 2019w33 |
112. | 112 3953 2018w24 |
113. | 113 3903 2018w21 |
114. | 114 3882 2019w27 |
115. | 115 3811 2019w34 |
   |------------------------------|
116. | 116 3809 2018w30 |
117. | 117 3791 2018w48 |
118. | 118 3767 2018w33 |
119. | 119 3763 2018w34 |
120. | 120 3689 2018w50 |
   |------------------------------|
121. | 121 3687 2018w52 |
122. | 122 3683 2019w36 |
123. | 123 3615 2018w51 |
124. | 124 3603 2019w31 |
125. | 125 3596 2018w49 |
   |------------------------------|
126. | 126 3586 2018w37 |
127. | 127 3579 2019w35 |
128. | 128 3536 2018w36 |
129. | 129 3489 2018w31 |
130. | 130 3346 2019w32 |
   |------------------------------|
131. | 131 3321 2018w44 |
132. | 132 3186 2018w35 |
   +------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Medians and means of intra-day merits over days of weeks ^{GMT time}
Colors:

Green: highest.
Red: Lowest.

- In median, the highest days are Thursday , Tuesday , and Friday at 701, 701, and 700, respectively; whislt the lowest days are Saturday, Sunday, and Monday at 611, 637, and 662, respectively.
- In means, the highest days are Thursday, Friday, and Tuesday at 890, 841, and 797, respectively; whilst the lowest days are Sunday, Saturday, and Monday, at 695, 700, and 774, respectively.

Basic statistics:

Code:

Summary for variables: merit
   by categories of: dofw

   dofw | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
   Sunday | 132.0 694.3 341.4 637.0 512.5 740.0 300.0 3240.0
   Monday | 132.0 773.8 416.3 662.0 582.5 848.0 370.0 3343.0
  Tuesday | 132.0 796.7 455.7 701.0 592.0 830.0 339.0 3826.0
Wednesday | 132.0 776.9 414.0 697.0 605.0 828.0 347.0 4103.0
Thursday | 132.0 890.0 1146.7 700.5 587.5 830.5 411.0 12676.0
   Friday | 132.0 840.9 714.5 699.5 576.5 829.5 373.0 6348.0
Saturday | 132.0 699.4 443.4 611.0 506.0 738.5 375.0 4627.0
----------+--------------------------------------------------------------------------------
   Total | 924.0 781.7 621.5 671.0 565.5 809.5 300.0 12676.0
-------------------------------------------------------------------------------------------

Box plots
Outliers non-displayed.

Details on ranks:
In medians

Code:

+--------------------------------------------------------------------------+
   | rankmedian dofw median mean p25 p75 min max |
   |--------------------------------------------------------------------------|
  1. | 1 Tuesday 701 796.7197 592 830 339 3826 |
  2. | 2 Thursday 700.5 890 587.5 830.5 411 12676 |
  3. | 3 Friday 699.5 840.8636 576.5 829.5 373 6348 |
  4. | 4 Wednesday 697 776.8712 605 828 347 4103 |
  5. | 5 Monday 662 773.8333 582.5 848 370 3343 |
   |--------------------------------------------------------------------------|
  6. | 6 Sunday 637 694.25 512.5 740 300 3240 |
  7. | 7 Saturday 611 699.3788 506 738.5 375 4627 |
   +--------------------------------------------------------------------------+

In means

Code:

+------------------------------------------------------------------------+
   | rankmean dofw mean median p25 p75 min max |
   |------------------------------------------------------------------------|
  1. | 1 Thursday 890 700.5 587.5 830.5 411 12676 |
  2. | 2 Friday 840.8636 699.5 576.5 829.5 373 6348 |
  3. | 3 Tuesday 796.7197 701 592 830 339 3826 |
  4. | 4 Wednesday 776.8712 697 605 828 347 4103 |
  5. | 5 Monday 773.8333 662 582.5 848 370 3343 |
   |------------------------------------------------------------------------|
  6. | 6 Saturday 699.3788 611 506 738.5 375 4627 |
  7. | 7 Sunday 694.25 637 512.5 740 300 3240 |
   +------------------------------------------------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

During the period from 24/1/2018 to 04/8/2020 (last 3 days dropped due to incomplete week, 2020w32 and an incomplete day - dayid = 927), the minimum and maximum of intra-day merit are 300 and 12676, on 04/8/2019 and 25/1/2018, respectively.

List of the top 50-highest day in terms of intra-day merits:

Code:

+-----------------------------------------------------------------------------+
   | rank_max merit dayid date dofw week month year |
   |-----------------------------------------------------------------------------|
  1. | 1 12676 2 25jan2018 Thursday 2018w4 2018m1 2018 |
  2. | 2 6348 3 26jan2018 Friday 2018w4 2018m1 2018 |
  3. | 3 5515 668 22nov2019 Friday 2019w47 2019m11 2019 |
  4. | 4 4889 667 21nov2019 Thursday 2019w47 2019m11 2019 |
  5. | 5 4627 4 27jan2018 Saturday 2018w4 2018m1 2018 |
   |-----------------------------------------------------------------------------|
  6. | 6 4103 8 31jan2018 Wednesday 2018w5 2018m1 2018 |
  7. | 7 3826 665 19nov2019 Tuesday 2019w47 2019m11 2019 |
  8. | 8 3804 7 30jan2018 Tuesday 2018w5 2018m1 2018 |
  9. | 9 3343 6 29jan2018 Monday 2018w5 2018m1 2018 |
10. | 10 3240 5 28jan2018 Sunday 2018w4 2018m1 2018 |
   |-----------------------------------------------------------------------------|
11. | 11 2797 23 15feb2018 Thursday 2018w7 2018m2 2018 |
12. | 12 2793 9 01feb2018 Thursday 2018w5 2018m2 2018 |
13. | 13 2783 664 18nov2019 Monday 2019w46 2019m11 2019 |
14. | 14 2621 10 02feb2018 Friday 2018w5 2018m2 2018 |
15. | 15 2584 666 20nov2019 Wednesday 2019w47 2019m11 2019 |
   |-----------------------------------------------------------------------------|
16. | 16 2553 237 17sep2018 Monday 2018w38 2018m9 2018 |
17. | 17 2476 11 03feb2018 Saturday 2018w5 2018m2 2018 |
18. | 18 2374 661 15nov2019 Friday 2019w46 2019m11 2019 |
19. | 19 2366 15 07feb2018 Wednesday 2018w6 2018m2 2018 |
20. | 20 2263 13 05feb2018 Monday 2018w6 2018m2 2018 |
   |-----------------------------------------------------------------------------|
21. | 21 2223 17 09feb2018 Friday 2018w6 2018m2 2018 |
22. | 22 2059 16 08feb2018 Thursday 2018w6 2018m2 2018 |
23. | 23 2004 14 06feb2018 Tuesday 2018w6 2018m2 2018 |
24. | 24 1807 238 18sep2018 Tuesday 2018w38 2018m9 2018 |
25. | 25 1793 19 11feb2018 Sunday 2018w6 2018m2 2018 |
   |-----------------------------------------------------------------------------|
26. | 26 1790 12 04feb2018 Sunday 2018w5 2018m2 2018 |
27. | 27 1740 24 16feb2018 Friday 2018w7 2018m2 2018 |
28. | 28 1727 39 03mar2018 Saturday 2018w9 2018m3 2018 |
29. | 29 1630 660 14nov2019 Thursday 2019w46 2019m11 2019 |
30. | 30 1590 669 23nov2019 Saturday 2019w47 2019m11 2019 |
   |-----------------------------------------------------------------------------|
31. | 31 1589 26 18feb2018 Sunday 2018w7 2018m2 2018 |
32. | 32 1585 662 16nov2019 Saturday 2019w46 2019m11 2019 |
33. | 33 1580 22 14feb2018 Wednesday 2018w7 2018m2 2018 |
34. | 34 1475 20 12feb2018 Monday 2018w7 2018m2 2018 |
35. | 35 1465 678 02dec2019 Monday 2019w48 2019m12 2019 |
   |-----------------------------------------------------------------------------|
36. | 36 1442 28 20feb2018 Tuesday 2018w8 2018m2 2018 |
37. | 37 1431 25 17feb2018 Saturday 2018w7 2018m2 2018 |
38. | 38 1414 35 27feb2018 Tuesday 2018w9 2018m2 2018 |
39. | 39 1390 57 21mar2018 Wednesday 2018w12 2018m3 2018 |
40. | 40 1377 663 17nov2019 Sunday 2019w46 2019m11 2019 |
   |-----------------------------------------------------------------------------|
41. | 41 1372 33 25feb2018 Sunday 2018w8 2018m2 2018 |
42. | 42 1364 755 17feb2020 Monday 2020w7 2020m2 2020 |
43. | 43 1347 239 19sep2018 Wednesday 2018w38 2018m9 2018 |
44. | 44 1345 38 02mar2018 Friday 2018w9 2018m3 2018 |
45. | 45 1334 18 10feb2018 Saturday 2018w6 2018m2 2018 |
   |-----------------------------------------------------------------------------|
46. | 46 1316 49 13mar2018 Tuesday 2018w11 2018m3 2018 |
47. | 47 1302 36 28feb2018 Wednesday 2018w9 2018m2 2018 |
48. | 48 1289 21 13feb2018 Tuesday 2018w7 2018m2 2018 |
49. | 49 1289 27 19feb2018 Monday 2018w8 2018m2 2018 |
50. | 50 1277 30 22feb2018 Thursday 2018w8 2018m2 2018 |
   +-----------------------------------------------------------------------------+

List of the top 50-lowest days in terms of intra-day merits:

Code:

+-----------------------------------------------------------------------------+
   | rank_min merit dayid date dofw week month year |
   |-----------------------------------------------------------------------------|
  1. | 1 300 558 04aug2019 Sunday 2019w31 2019m8 2019 |
  2. | 2 333 341 30dec2018 Sunday 2018w52 2018m12 2018 |
  3. | 3 339 343 01jan2019 Tuesday 2019w1 2019m1 2019 |
  4. | 4 347 299 18nov2018 Sunday 2018w46 2018m11 2018 |
  5. | 5 347 330 19dec2018 Wednesday 2018w51 2018m12 2018 |
   |-----------------------------------------------------------------------------|
  6. | 6 351 334 23dec2018 Sunday 2018w51 2018m12 2018 |
  7. | 7 366 218 29aug2018 Wednesday 2018w35 2018m8 2018 |
  8. | 8 367 565 11aug2019 Sunday 2019w32 2019m8 2019 |
  9. | 9 370 223 03sep2018 Monday 2018w36 2018m9 2018 |
10. | 10 373 339 28dec2018 Friday 2018w52 2018m12 2018 |
   |-----------------------------------------------------------------------------|
11. | 11 375 340 29dec2018 Saturday 2018w52 2018m12 2018 |
12. | 12 377 600 15sep2019 Sunday 2019w37 2019m9 2019 |
13. | 13 378 567 13aug2019 Tuesday 2019w33 2019m8 2019 |
14. | 14 378 305 24nov2018 Saturday 2018w47 2018m11 2018 |
15. | 15 378 566 12aug2019 Monday 2019w32 2019m8 2019 |
   |-----------------------------------------------------------------------------|
16. | 16 380 192 03aug2018 Friday 2018w31 2018m8 2018 |
17. | 17 381 336 25dec2018 Tuesday 2018w52 2018m12 2018 |
18. | 18 385 215 26aug2018 Sunday 2018w34 2018m8 2018 |
19. | 19 385 327 16dec2018 Sunday 2018w50 2018m12 2018 |
20. | 20 391 221 01sep2018 Saturday 2018w35 2018m9 2018 |
   |-----------------------------------------------------------------------------|
21. | 21 394 188 30jul2018 Monday 2018w31 2018m7 2018 |
22. | 22 395 872 13jun2020 Saturday 2020w24 2020m6 2020 |
23. | 23 399 593 08sep2019 Sunday 2019w36 2019m9 2019 |
24. | 24 401 288 07nov2018 Wednesday 2018w45 2018m11 2018 |
25. | 25 401 557 03aug2019 Saturday 2019w31 2019m8 2019 |
   |-----------------------------------------------------------------------------|
26. | 26 402 263 13oct2018 Saturday 2018w41 2018m10 2018 |
27. | 27 404 229 09sep2018 Sunday 2018w36 2018m9 2018 |
28. | 28 406 277 27oct2018 Saturday 2018w43 2018m10 2018 |
29. | 29 408 530 07jul2019 Sunday 2019w27 2019m7 2019 |
30. | 30 409 123 26may2018 Saturday 2018w21 2018m5 2018 |
   |-----------------------------------------------------------------------------|
31. | 31 409 589 04sep2019 Wednesday 2019w36 2019m9 2019 |
32. | 32 410 279 29oct2018 Monday 2018w44 2018m10 2018 |
33. | 33 411 578 24aug2019 Saturday 2019w34 2019m8 2019 |
34. | 34 411 569 15aug2019 Thursday 2019w33 2019m8 2019 |
35. | 35 414 528 05jul2019 Friday 2019w27 2019m7 2019 |
   |-----------------------------------------------------------------------------|
36. | 36 421 193 04aug2018 Saturday 2018w31 2018m8 2018 |
37. | 37 425 588 03sep2019 Tuesday 2019w36 2019m9 2019 |
38. | 38 426 346 04jan2019 Friday 2019w1 2019m1 2019 |
39. | 39 426 230 10sep2018 Monday 2018w37 2018m9 2018 |
40. | 40 427 141 13jun2018 Wednesday 2018w24 2018m6 2018 |
   |-----------------------------------------------------------------------------|
41. | 41 430 207 18aug2018 Saturday 2018w33 2018m8 2018 |
42. | 42 432 587 02sep2019 Monday 2019w35 2019m9 2019 |
43. | 43 435 522 29jun2019 Saturday 2019w26 2019m6 2019 |
44. | 44 436 419 18mar2019 Monday 2019w11 2019m3 2019 |
45. | 45 439 880 21jun2020 Sunday 2020w25 2020m6 2020 |
   |-----------------------------------------------------------------------------|
46. | 46 440 585 31aug2019 Saturday 2019w35 2019m8 2019 |
47. | 47 440 559 05aug2019 Monday 2019w31 2019m8 2019 |
48. | 48 440 265 15oct2018 Monday 2018w42 2018m10 2018 |
49. | 49 441 404 03mar2019 Sunday 2019w9 2019m3 2019 |
50. | 50 441 319 08dec2018 Saturday 2018w49 2018m12 2018 |
   +-----------------------------------------------------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Time-series plots:
Full dataset:

Truncated dataset:

Basic statistics (for full dataset):
Only drop last 3 days that belong to the 2020w32 (daydi = 925, 926), the incomplete week & incomlete day (dayid = 927).

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 924 781.7024 621.4536 671 565.5 809.5 300 12676
----------------------------------------------------------------------------------------------

Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 198 or 1178.

Code:

. di 810-565
245

. di 245*1.5
367.5

. di 810+367.5
1177.5

. di 565-367.5
197.5

There are 62 outliers (beyond 1178 or 198) in full dataset, in total.

Code:

. count if (merit >= 1178 | merit <= 198) & merit != .
62

Those days are:

Code:

+---------------------------+
| dayid merit date |
|---------------------------|
2. | 2 12676 25jan2018 |
3. | 3 6348 26jan2018 |
4. | 4 4627 27jan2018 |
5. | 5 3240 28jan2018 |
6. | 6 3343 29jan2018 |
7. | 7 3804 30jan2018 |
8. | 8 4103 31jan2018 |
9. | 9 2793 01feb2018 |
10. | 10 2621 02feb2018 |
11. | 11 2476 03feb2018 |
12. | 12 1790 04feb2018 |
13. | 13 2263 05feb2018 |
14. | 14 2004 06feb2018 |
15. | 15 2366 07feb2018 |
16. | 16 2059 08feb2018 |
17. | 17 2223 09feb2018 |
18. | 18 1334 10feb2018 |
19. | 19 1793 11feb2018 |
20. | 20 1475 12feb2018 |
21. | 21 1289 13feb2018 |
22. | 22 1580 14feb2018 |
23. | 23 2797 15feb2018 |
24. | 24 1740 16feb2018 |
25. | 25 1431 17feb2018 |
26. | 26 1589 18feb2018 |
27. | 27 1289 19feb2018 |
28. | 28 1442 20feb2018 |
30. | 30 1277 22feb2018 |
31. | 31 1250 23feb2018 |
33. | 33 1372 25feb2018 |
35. | 35 1414 27feb2018 |
36. | 36 1302 28feb2018 |
38. | 38 1345 02mar2018 |
39. | 39 1727 03mar2018 |
49. | 49 1316 13mar2018 |
51. | 51 1224 15mar2018 |
57. | 57 1390 21mar2018 |
58. | 58 1211 22mar2018 |
69. | 69 1181 02apr2018 |
70. | 70 1186 03apr2018 |
237. | 237 2553 17sep2018 |
238. | 238 1807 18sep2018 |
239. | 239 1347 19sep2018 |
240. | 240 1221 20sep2018 |
|---------------------------|
429. | 429 1247 28mar2019 |
476. | 476 1215 14may2019 |
505. | 505 1227 12jun2019 |
660. | 660 1630 14nov2019 |
661. | 661 2374 15nov2019 |
662. | 662 1585 16nov2019 |
663. | 663 1377 17nov2019 |
664. | 664 2783 18nov2019 |
665. | 665 3826 19nov2019 |
666. | 666 2584 20nov2019 |
667. | 667 4889 21nov2019 |
668. | 668 5515 22nov2019 |
669. | 669 1590 23nov2019 |
678. | 678 1465 02dec2019 |
|---------------------------|
726. | 726 1192 19jan2020 |
755. | 755 1364 17feb2020 |
756. | 756 1195 18feb2020 |
845. | 845 1198 17may2020 |
+---------------------------+

Distributions of outliers over years:

2018: 44 (71.0%)
2019: 14 (22.6%)
2020: 4 (6.4%)

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Converted dataset:

In 2020 ^{at 07aug2020 02:37:50 (GMT time)}
The last one, with dayid = 927 is an incomplete day.

Code:

+-----------------------------------------------------------------+
| dayid date merit dofw week month year |
|-----------------------------------------------------------------|
708. | 708 01jan2020 810 Wednesday 2020w1 2020m1 2020 |
709. | 709 02jan2020 854 Thursday 2020w1 2020m1 2020 |
710. | 710 03jan2020 837 Friday 2020w1 2020m1 2020 |
711. | 711 04jan2020 637 Saturday 2020w1 2020m1 2020 |
712. | 712 05jan2020 777 Sunday 2020w1 2020m1 2020 |
|-----------------------------------------------------------------|
713. | 713 06jan2020 959 Monday 2020w1 2020m1 2020 |
714. | 714 07jan2020 871 Tuesday 2020w1 2020m1 2020 |
715. | 715 08jan2020 860 Wednesday 2020w2 2020m1 2020 |
716. | 716 09jan2020 733 Thursday 2020w2 2020m1 2020 |
717. | 717 10jan2020 745 Friday 2020w2 2020m1 2020 |
|-----------------------------------------------------------------|
718. | 718 11jan2020 743 Saturday 2020w2 2020m1 2020 |
719. | 719 12jan2020 689 Sunday 2020w2 2020m1 2020 |
720. | 720 13jan2020 754 Monday 2020w2 2020m1 2020 |
721. | 721 14jan2020 871 Tuesday 2020w2 2020m1 2020 |
722. | 722 15jan2020 979 Wednesday 2020w3 2020m1 2020 |
|-----------------------------------------------------------------|
723. | 723 16jan2020 972 Thursday 2020w3 2020m1 2020 |
724. | 724 17jan2020 1063 Friday 2020w3 2020m1 2020 |
725. | 725 18jan2020 823 Saturday 2020w3 2020m1 2020 |
726. | 726 19jan2020 1192 Sunday 2020w3 2020m1 2020 |
727. | 727 20jan2020 1136 Monday 2020w3 2020m1 2020 |
|-----------------------------------------------------------------|
728. | 728 21jan2020 1082 Tuesday 2020w3 2020m1 2020 |
729. | 729 22jan2020 863 Wednesday 2020w4 2020m1 2020 |
730. | 730 23jan2020 1050 Thursday 2020w4 2020m1 2020 |
731. | 731 24jan2020 1061 Friday 2020w4 2020m1 2020 |
732. | 732 25jan2020 1043 Saturday 2020w4 2020m1 2020 |
|-----------------------------------------------------------------|
733. | 733 26jan2020 715 Sunday 2020w4 2020m1 2020 |
734. | 734 27jan2020 961 Monday 2020w4 2020m1 2020 |
735. | 735 28jan2020 953 Tuesday 2020w4 2020m1 2020 |
736. | 736 29jan2020 1051 Wednesday 2020w5 2020m1 2020 |
737. | 737 30jan2020 1125 Thursday 2020w5 2020m1 2020 |
|-----------------------------------------------------------------|
738. | 738 31jan2020 1072 Friday 2020w5 2020m1 2020 |
739. | 739 01feb2020 705 Saturday 2020w5 2020m2 2020 |
740. | 740 02feb2020 836 Sunday 2020w5 2020m2 2020 |
741. | 741 03feb2020 908 Monday 2020w5 2020m2 2020 |
742. | 742 04feb2020 1059 Tuesday 2020w5 2020m2 2020 |
|-----------------------------------------------------------------|
743. | 743 05feb2020 873 Wednesday 2020w6 2020m2 2020 |
744. | 744 06feb2020 932 Thursday 2020w6 2020m2 2020 |
745. | 745 07feb2020 800 Friday 2020w6 2020m2 2020 |
746. | 746 08feb2020 763 Saturday 2020w6 2020m2 2020 |
747. | 747 09feb2020 724 Sunday 2020w6 2020m2 2020 |
|-----------------------------------------------------------------|
748. | 748 10feb2020 812 Monday 2020w6 2020m2 2020 |
749. | 749 11feb2020 669 Tuesday 2020w6 2020m2 2020 |
750. | 750 12feb2020 596 Wednesday 2020w7 2020m2 2020 |
751. | 751 13feb2020 1047 Thursday 2020w7 2020m2 2020 |
752. | 752 14feb2020 1041 Friday 2020w7 2020m2 2020 |
|-----------------------------------------------------------------|
753. | 753 15feb2020 890 Saturday 2020w7 2020m2 2020 |
754. | 754 16feb2020 790 Sunday 2020w7 2020m2 2020 |
755. | 755 17feb2020 1364 Monday 2020w7 2020m2 2020 |
756. | 756 18feb2020 1195 Tuesday 2020w7 2020m2 2020 |
757. | 757 19feb2020 1004 Wednesday 2020w8 2020m2 2020 |
|-----------------------------------------------------------------|
758. | 758 20feb2020 782 Thursday 2020w8 2020m2 2020 |
759. | 759 21feb2020 1050 Friday 2020w8 2020m2 2020 |
760. | 760 22feb2020 729 Saturday 2020w8 2020m2 2020 |
761. | 761 23feb2020 724 Sunday 2020w8 2020m2 2020 |
762. | 762 24feb2020 1037 Monday 2020w8 2020m2 2020 |
|-----------------------------------------------------------------|
763. | 763 25feb2020 988 Tuesday 2020w8 2020m2 2020 |
764. | 764 26feb2020 857 Wednesday 2020w9 2020m2 2020 |
765. | 765 27feb2020 960 Thursday 2020w9 2020m2 2020 |
766. | 766 28feb2020 678 Friday 2020w9 2020m2 2020 |
767. | 767 29feb2020 662 Saturday 2020w9 2020m2 2020 |
|-----------------------------------------------------------------|
768. | 768 01mar2020 651 Sunday 2020w9 2020m3 2020 |
769. | 769 02mar2020 755 Monday 2020w9 2020m3 2020 |
770. | 770 03mar2020 674 Tuesday 2020w9 2020m3 2020 |
771. | 771 04mar2020 572 Wednesday 2020w10 2020m3 2020 |
772. | 772 05mar2020 727 Thursday 2020w10 2020m3 2020 |
|-----------------------------------------------------------------|
773. | 773 06mar2020 622 Friday 2020w10 2020m3 2020 |
774. | 774 07mar2020 697 Saturday 2020w10 2020m3 2020 |
775. | 775 08mar2020 670 Sunday 2020w10 2020m3 2020 |
776. | 776 09mar2020 634 Monday 2020w10 2020m3 2020 |
777. | 777 10mar2020 700 Tuesday 2020w10 2020m3 2020 |
|-----------------------------------------------------------------|
778. | 778 11mar2020 800 Wednesday 2020w11 2020m3 2020 |
779. | 779 12mar2020 790 Thursday 2020w11 2020m3 2020 |
780. | 780 13mar2020 748 Friday 2020w11 2020m3 2020 |
781. | 781 14mar2020 562 Saturday 2020w11 2020m3 2020 |
782. | 782 15mar2020 528 Sunday 2020w11 2020m3 2020 |
|-----------------------------------------------------------------|
783. | 783 16mar2020 888 Monday 2020w11 2020m3 2020 |
784. | 784 17mar2020 793 Tuesday 2020w11 2020m3 2020 |
785. | 785 18mar2020 1090 Wednesday 2020w12 2020m3 2020 |
786. | 786 19mar2020 867 Thursday 2020w12 2020m3 2020 |
787. | 787 20mar2020 999 Friday 2020w12 2020m3 2020 |
|-----------------------------------------------------------------|
788. | 788 21mar2020 628 Saturday 2020w12 2020m3 2020 |
789. | 789 22mar2020 549 Sunday 2020w12 2020m3 2020 |
790. | 790 23mar2020 683 Monday 2020w12 2020m3 2020 |
791. | 791 24mar2020 787 Tuesday 2020w12 2020m3 2020 |
792. | 792 25mar2020 786 Wednesday 2020w13 2020m3 2020 |
|-----------------------------------------------------------------|
793. | 793 26mar2020 855 Thursday 2020w13 2020m3 2020 |
794. | 794 27mar2020 934 Friday 2020w13 2020m3 2020 |
795. | 795 28mar2020 658 Saturday 2020w13 2020m3 2020 |
796. | 796 29mar2020 452 Sunday 2020w13 2020m3 2020 |
797. | 797 30mar2020 909 Monday 2020w13 2020m3 2020 |
|-----------------------------------------------------------------|
798. | 798 31mar2020 798 Tuesday 2020w13 2020m3 2020 |
799. | 799 01apr2020 858 Wednesday 2020w14 2020m4 2020 |
800. | 800 02apr2020 1062 Thursday 2020w14 2020m4 2020 |
801. | 801 03apr2020 805 Friday 2020w14 2020m4 2020 |
802. | 802 04apr2020 943 Saturday 2020w14 2020m4 2020 |
|-----------------------------------------------------------------|
803. | 803 05apr2020 661 Sunday 2020w14 2020m4 2020 |
804. | 804 06apr2020 846 Monday 2020w14 2020m4 2020 |
805. | 805 07apr2020 886 Tuesday 2020w14 2020m4 2020 |
806. | 806 08apr2020 875 Wednesday 2020w15 2020m4 2020 |
807. | 807 09apr2020 687 Thursday 2020w15 2020m4 2020 |
|-----------------------------------------------------------------|
808. | 808 10apr2020 758 Friday 2020w15 2020m4 2020 |
809. | 809 11apr2020 615 Saturday 2020w15 2020m4 2020 |
810. | 810 12apr2020 660 Sunday 2020w15 2020m4 2020 |
811. | 811 13apr2020 592 Monday 2020w15 2020m4 2020 |
812. | 812 14apr2020 907 Tuesday 2020w15 2020m4 2020 |
|-----------------------------------------------------------------|
813. | 813 15apr2020 734 Wednesday 2020w16 2020m4 2020 |
814. | 814 16apr2020 763 Thursday 2020w16 2020m4 2020 |
815. | 815 17apr2020 827 Friday 2020w16 2020m4 2020 |
816. | 816 18apr2020 752 Saturday 2020w16 2020m4 2020 |
817. | 817 19apr2020 627 Sunday 2020w16 2020m4 2020 |
|-----------------------------------------------------------------|
818. | 818 20apr2020 626 Monday 2020w16 2020m4 2020 |
819. | 819 21apr2020 723 Tuesday 2020w16 2020m4 2020 |
820. | 820 22apr2020 700 Wednesday 2020w17 2020m4 2020 |
821. | 821 23apr2020 687 Thursday 2020w17 2020m4 2020 |
822. | 822 24apr2020 706 Friday 2020w17 2020m4 2020 |
|-----------------------------------------------------------------|
823. | 823 25apr2020 639 Saturday 2020w17 2020m4 2020 |
824. | 824 26apr2020 663 Sunday 2020w17 2020m4 2020 |
825. | 825 27apr2020 654 Monday 2020w17 2020m4 2020 |
826. | 826 28apr2020 490 Tuesday 2020w17 2020m4 2020 |
827. | 827 29apr2020 795 Wednesday 2020w18 2020m4 2020 |
|-----------------------------------------------------------------|
828. | 828 30apr2020 983 Thursday 2020w18 2020m4 2020 |
829. | 829 01may2020 1099 Friday 2020w18 2020m5 2020 |
830. | 830 02may2020 745 Saturday 2020w18 2020m5 2020 |
831. | 831 03may2020 716 Sunday 2020w18 2020m5 2020 |
832. | 832 04may2020 659 Monday 2020w18 2020m5 2020 |
|-----------------------------------------------------------------|
833. | 833 05may2020 702 Tuesday 2020w18 2020m5 2020 |
834. | 834 06may2020 707 Wednesday 2020w19 2020m5 2020 |
835. | 835 07may2020 852 Thursday 2020w19 2020m5 2020 |
836. | 836 08may2020 734 Friday 2020w19 2020m5 2020 |
837. | 837 09may2020 806 Saturday 2020w19 2020m5 2020 |
|-----------------------------------------------------------------|
838. | 838 10may2020 919 Sunday 2020w19 2020m5 2020 |
839. | 839 11may2020 988 Monday 2020w19 2020m5 2020 |
840. | 840 12may2020 642 Tuesday 2020w19 2020m5 2020 |
841. | 841 13may2020 734 Wednesday 2020w20 2020m5 2020 |
842. | 842 14may2020 929 Thursday 2020w20 2020m5 2020 |
|-----------------------------------------------------------------|
843. | 843 15may2020 681 Friday 2020w20 2020m5 2020 |
844. | 844 16may2020 749 Saturday 2020w20 2020m5 2020 |
845. | 845 17may2020 1198 Sunday 2020w20 2020m5 2020 |
846. | 846 18may2020 728 Monday 2020w20 2020m5 2020 |
847. | 847 19may2020 783 Tuesday 2020w20 2020m5 2020 |
|-----------------------------------------------------------------|
848. | 848 20may2020 759 Wednesday 2020w21 2020m5 2020 |
849. | 849 21may2020 774 Thursday 2020w21 2020m5 2020 |
850. | 850 22may2020 805 Friday 2020w21 2020m5 2020 |
851. | 851 23may2020 731 Saturday 2020w21 2020m5 2020 |
852. | 852 24may2020 598 Sunday 2020w21 2020m5 2020 |
|-----------------------------------------------------------------|
853. | 853 25may2020 937 Monday 2020w21 2020m5 2020 |
854. | 854 26may2020 730 Tuesday 2020w21 2020m5 2020 |
855. | 855 27may2020 698 Wednesday 2020w22 2020m5 2020 |
856. | 856 28may2020 690 Thursday 2020w22 2020m5 2020 |
857. | 857 29may2020 686 Friday 2020w22 2020m5 2020 |
|-----------------------------------------------------------------|
858. | 858 30may2020 565 Saturday 2020w22 2020m5 2020 |
859. | 859 31may2020 530 Sunday 2020w22 2020m5 2020 |
860. | 860 01jun2020 834 Monday 2020w22 2020m6 2020 |
861. | 861 02jun2020 659 Tuesday 2020w22 2020m6 2020 |
862. | 862 03jun2020 488 Wednesday 2020w23 2020m6 2020 |
|-----------------------------------------------------------------|
863. | 863 04jun2020 759 Thursday 2020w23 2020m6 2020 |
864. | 864 05jun2020 640 Friday 2020w23 2020m6 2020 |
865. | 865 06jun2020 589 Saturday 2020w23 2020m6 2020 |
866. | 866 07jun2020 741 Sunday 2020w23 2020m6 2020 |
867. | 867 08jun2020 638 Monday 2020w23 2020m6 2020 |
|-----------------------------------------------------------------|
868. | 868 09jun2020 821 Tuesday 2020w23 2020m6 2020 |
869. | 869 10jun2020 666 Wednesday 2020w24 2020m6 2020 |
870. | 870 11jun2020 623 Thursday 2020w24 2020m6 2020 |
871. | 871 12jun2020 688 Friday 2020w24 2020m6 2020 |
872. | 872 13jun2020 395 Saturday 2020w24 2020m6 2020 |
|-----------------------------------------------------------------|
873. | 873 14jun2020 602 Sunday 2020w24 2020m6 2020 |
874. | 874 15jun2020 682 Monday 2020w24 2020m6 2020 |
875. | 875 16jun2020 534 Tuesday 2020w24 2020m6 2020 |
876. | 876 17jun2020 570 Wednesday 2020w25 2020m6 2020 |
877. | 877 18jun2020 587 Thursday 2020w25 2020m6 2020 |
|-----------------------------------------------------------------|
878. | 878 19jun2020 675 Friday 2020w25 2020m6 2020 |
879. | 879 20jun2020 658 Saturday 2020w25 2020m6 2020 |
880. | 880 21jun2020 439 Sunday 2020w25 2020m6 2020 |
881. | 881 22jun2020 602 Monday 2020w25 2020m6 2020 |
882. | 882 23jun2020 835 Tuesday 2020w25 2020m6 2020 |
|-----------------------------------------------------------------|
883. | 883 24jun2020 700 Wednesday 2020w26 2020m6 2020 |
884. | 884 25jun2020 579 Thursday 2020w26 2020m6 2020 |
885. | 885 26jun2020 679 Friday 2020w26 2020m6 2020 |
886. | 886 27jun2020 481 Saturday 2020w26 2020m6 2020 |
887. | 887 28jun2020 657 Sunday 2020w26 2020m6 2020 |
|-----------------------------------------------------------------|
888. | 888 29jun2020 746 Monday 2020w26 2020m6 2020 |
889. | 889 30jun2020 632 Tuesday 2020w26 2020m6 2020 |
890. | 890 01jul2020 734 Wednesday 2020w27 2020m7 2020 |
891. | 891 02jul2020 531 Thursday 2020w27 2020m7 2020 |
892. | 892 03jul2020 792 Friday 2020w27 2020m7 2020 |
|-----------------------------------------------------------------|
893. | 893 04jul2020 755 Saturday 2020w27 2020m7 2020 |
894. | 894 05jul2020 556 Sunday 2020w27 2020m7 2020 |
895. | 895 06jul2020 581 Monday 2020w27 2020m7 2020 |
896. | 896 07jul2020 681 Tuesday 2020w27 2020m7 2020 |
897. | 897 08jul2020 880 Wednesday 2020w28 2020m7 2020 |
|-----------------------------------------------------------------|
898. | 898 09jul2020 591 Thursday 2020w28 2020m7 2020 |
899. | 899 10jul2020 677 Friday 2020w28 2020m7 2020 |
900. | 900 11jul2020 605 Saturday 2020w28 2020m7 2020 |
901. | 901 12jul2020 681 Sunday 2020w28 2020m7 2020 |
902. | 902 13jul2020 668 Monday 2020w28 2020m7 2020 |
|-----------------------------------------------------------------|
903. | 903 14jul2020 571 Tuesday 2020w28 2020m7 2020 |
904. | 904 15jul2020 593 Wednesday 2020w29 2020m7 2020 |
905. | 905 16jul2020 770 Thursday 2020w29 2020m7 2020 |
906. | 906 17jul2020 642 Friday 2020w29 2020m7 2020 |
907. | 907 18jul2020 484 Saturday 2020w29 2020m7 2020 |
|-----------------------------------------------------------------|
908. | 908 19jul2020 864 Sunday 2020w29 2020m7 2020 |
909. | 909 20jul2020 653 Monday 2020w29 2020m7 2020 |
910. | 910 21jul2020 479 Tuesday 2020w29 2020m7 2020 |
911. | 911 22jul2020 671 Wednesday 2020w30 2020m7 2020 |
912. | 912 23jul2020 679 Thursday 2020w30 2020m7 2020 |
|-----------------------------------------------------------------|
913. | 913 24jul2020 613 Friday 2020w30 2020m7 2020 |
914. | 914 25jul2020 476 Saturday 2020w30 2020m7 2020 |
915. | 915 26jul2020 682 Sunday 2020w30 2020m7 2020 |
916. | 916 27jul2020 816 Monday 2020w30 2020m7 2020 |
917. | 917 28jul2020 581 Tuesday 2020w30 2020m7 2020 |
|-----------------------------------------------------------------|
918. | 918 29jul2020 747 Wednesday 2020w31 2020m7 2020 |
919. | 919 30jul2020 651 Thursday 2020w31 2020m7 2020 |
920. | 920 31jul2020 957 Friday 2020w31 2020m7 2020 |
921. | 921 01aug2020 654 Saturday 2020w31 2020m8 2020 |
922. | 922 02aug2020 738 Sunday 2020w31 2020m8 2020 |
|-----------------------------------------------------------------|
923. | 923 03aug2020 635 Monday 2020w31 2020m8 2020 |
924. | 924 04aug2020 581 Tuesday 2020w31 2020m8 2020 |
925. | 925 05aug2020 592 Wednesday 2020w32 2020m8 2020 |
926. | 926 06aug2020 592 Thursday 2020w32 2020m8 2020 |
927. | 927 07aug2020 41 Friday 2020w32 2020m8 2020 |
+-----------------------------------------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

ABSTRACT ^{2020w30, GMT time}

Data is the full dataset since 24/1/2018, and only dropped last 3 days belong to incomplete week - 2020w31 and an incomplete day (dayid = 920). Details on days dropped, please see above posts.

Intra-day merits:

Total observed days: 917
Potential outliers are days that have intraday total merits beyond 198 or 1178
Median of intraday merits over the period is 671
50% of observed days have their intra-day merits range from 565 to 810 (the interquartile range)
In medians, the highest and lowest days are Thursday and Saturday, respectively; whilst the highest and lowest days in means are Thursday and Sunday, respectively. See here.
There are 62 potential outliers (beyond 198 or 1178) in total.
The distribution of outliers over years are: 44 (71.0%) for 2018, 14 (22.6%) for 2019, and 4 (6.4%) for 2020. (see details)
Minimum and maximum of intraday merits (full dataset) are 300, and 12676, on 04/8/2019 and 25/1/2018, respectively.

Intra-week merits:

Total observed weeks: 131
The median of intra-week merits is 4650
50% of observed weeks (131 weeks in total), have total merits in the range 4259 to 5596 (the interquartile range of intra-week merits).
Minimum and maximum of intra-week merits are 3186 and 27920, in 2018w35, and 2018w4, respectively;
9 potential outliers [beyond 2254 or 7602], only 2 of them occurred in the year 2019, on 2019w46 (11070), and 2019w47 (20397); none of them occured in 2020.
The last week with 4518 merits has its position at 76^th among 131 weeks so far.

Topic: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly) - page 3. (Read 29462 times)