Intra-week merits (from 24/1/2018 to 01/9/2020)Last 3 days dropped due to incomplete week (2020w36) and an incomplete day (dayid = 955)Converted dataset: +-----------------+
| merit week |
|-----------------|
1. | 27920 2018w4 |
2. | 20930 2018w5 |
3. | 14042 2018w6 |
4. | 11901 2018w7 |
5. | 8879 2018w8 |
|-----------------|
6. | 9005 2018w9 |
7. | 7178 2018w10 |
8. | 7340 2018w11 |
9. | 7138 2018w12 |
10. | 6392 2018w13 |
|-----------------|
11. | 6542 2018w14 |
12. | 5946 2018w15 |
13. | 4449 2018w16 |
14. | 4820 2018w17 |
15. | 5043 2018w18 |
|-----------------|
16. | 4685 2018w19 |
17. | 4431 2018w20 |
18. | 3903 2018w21 |
19. | 4248 2018w22 |
20. | 4473 2018w23 |
|-----------------|
21. | 3953 2018w24 |
22. | 4574 2018w25 |
23. | 4684 2018w26 |
24. | 4367 2018w27 |
25. | 4109 2018w28 |
|-----------------|
26. | 4277 2018w29 |
27. | 3809 2018w30 |
28. | 3489 2018w31 |
29. | 4199 2018w32 |
30. | 3767 2018w33 |
|-----------------|
31. | 3763 2018w34 |
32. | 3186 2018w35 |
33. | 3536 2018w36 |
34. | 3586 2018w37 |
35. | 9587 2018w38 |
|-----------------|
36. | 4508 2018w39 |
37. | 4325 2018w40 |
38. | 3981 2018w41 |
39. | 4424 2018w42 |
40. | 4386 2018w43 |
|-----------------|
41. | 3321 2018w44 |
42. | 4175 2018w45 |
43. | 4047 2018w46 |
44. | 4606 2018w47 |
45. | 3791 2018w48 |
|-----------------|
46. | 3596 2018w49 |
47. | 3689 2018w50 |
48. | 3615 2018w51 |
49. | 3687 2018w52 |
50. | 4584 2019w1 |
|-----------------|
51. | 6102 2019w2 |
52. | 5776 2019w3 |
53. | 4582 2019w4 |
54. | 4408 2019w5 |
55. | 4505 2019w6 |
|-----------------|
56. | 4259 2019w7 |
57. | 4314 2019w8 |
58. | 4726 2019w9 |
59. | 4979 2019w10 |
60. | 4295 2019w11 |
|-----------------|
61. | 4690 2019w12 |
62. | 5728 2019w13 |
63. | 4695 2019w14 |
64. | 5253 2019w15 |
65. | 4880 2019w16 |
|-----------------|
66. | 4260 2019w17 |
67. | 4817 2019w18 |
68. | 5002 2019w19 |
69. | 5596 2019w20 |
70. | 4693 2019w21 |
|-----------------|
71. | 4342 2019w22 |
72. | 4597 2019w23 |
73. | 5373 2019w24 |
74. | 4629 2019w25 |
75. | 4672 2019w26 |
|-----------------|
76. | 3882 2019w27 |
77. | 4462 2019w28 |
78. | 4005 2019w29 |
79. | 4377 2019w30 |
80. | 3603 2019w31 |
|-----------------|
81. | 3346 2019w32 |
82. | 3965 2019w33 |
83. | 3811 2019w34 |
84. | 3579 2019w35 |
85. | 3683 2019w36 |
|-----------------|
86. | 4005 2019w37 |
87. | 4382 2019w38 |
88. | 4348 2019w39 |
89. | 4209 2019w40 |
90. | 4701 2019w41 |
|-----------------|
91. | 5160 2019w42 |
92. | 5375 2019w43 |
93. | 4816 2019w44 |
94. | 4753 2019w45 |
95. | 11070 2019w46 |
|-----------------|
96. | 20397 2019w47 |
97. | 6271 2019w48 |
98. | 4650 2019w49 |
99. | 4832 2019w50 |
100. | 6066 2019w51 |
|-----------------|
101. | 7058 2019w52 |
102. | 5745 2020w1 |
103. | 5395 2020w2 |
104. | 7247 2020w3 |
105. | 6646 2020w4 |
|-----------------|
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 |
135. | 5330 2020w34 |
|-----------------|
136. | 5974 2020w35 |
+-----------------+
Time series plotBasic statistics:- 50% of observed weeks (
136 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 4254 to 5585 (the interquartile range, from p25 to p75, in raw statistics below).
- Min - max: 3186 - 27920.
variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 136.0 5453.4 3127.3 4656.0 4253.5 5584.5 3186.0 27920.0
----------------------------------------------------------------------------------------------
Potential outliers:. di 5584.5-4253.5
1331
. di 1331*1.5
1996.5
. di 5584.5+1996.5
7581
. di 4253.5-1996.5
2257
It means that potential outliers are weeks that have intra-week merits beyond
2257 or
7581.
How many weeks are potential outliers?
. count if (merit >= 7581 | merit < 2257) & merit != .
9
9 weeks are outliers, in total.
List of those
9 weeks:
+-----------------+
| merit week |
|-----------------|
1. | 27920 2018w4 |
2. | 20930 2018w5 |
3. | 14042 2018w6 |
4. | 11901 2018w7 |
5. | 8879 2018w8 |
|-----------------|
6. | 9005 2018w9 |
35. | 9587 2018w38 |
95. | 11070 2019w46 |
96. | 20397 2019w47 |
+-----------------+
Most of them occured in the year 2018, and there is only
2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 (20397). None of them occured in 2020 so far.
List of weeks in descending weekly meritsThe last week (with 5974 merits) stays at the
25th position, among 136 weeks.
+------------------------------+
| weeklyrank merit week |
|------------------------------|
1. | 1 27920 2018w4 |
2. | 2 20930 2018w5 |
3. | 3 20397 2019w47 |
4. | 4 14042 2018w6 |
5. | 5 11901 2018w7 |
|------------------------------|
6. | 6 11070 2019w46 |
7. | 7 9587 2018w38 |
8. | 8 9005 2018w9 |
9. | 9 8879 2018w8 |
10. | 10 7340 2018w11 |
|------------------------------|
11. | 11 7247 2020w3 |
12. | 12 7178 2018w10 |
13. | 13 7138 2018w12 |
14. | 14 7058 2019w52 |
15. | 15 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 5974 2020w35 |
|------------------------------|
26. | 26 5946 2018w15 |
27. | 27 5802 2020w20 |
28. | 28 5776 2019w3 |
29. | 29 5745 2020w1 |
30. | 30 5728 2019w13 |
|------------------------------|
31. | 31 5699 2020w18 |
32. | 32 5648 2020w19 |
33. | 33 5603 2020w12 |
34. | 34 5596 2019w20 |
35. | 35 5573 2020w6 |
|------------------------------|
36. | 36 5395 2020w2 |
37. | 37 5392 2020w13 |
38. | 38 5375 2019w43 |
39. | 39 5373 2019w24 |
40. | 40 5334 2020w21 |
|------------------------------|
41. | 41 5330 2020w34 |
42. | 42 5253 2019w15 |
43. | 43 5237 2020w9 |
44. | 44 5160 2019w42 |
45. | 45 5109 2020w11 |
|------------------------------|
46. | 46 5094 2020w15 |
47. | 47 5052 2020w16 |
48. | 48 5043 2018w18 |
49. | 49 5002 2019w19 |
50. | 50 4979 2019w10 |
|------------------------------|
51. | 51 4963 2020w31 |
52. | 52 4880 2019w16 |
53. | 53 4832 2019w50 |
54. | 54 4820 2018w17 |
55. | 55 4817 2019w18 |
|------------------------------|
56. | 56 4816 2019w44 |
57. | 57 4753 2019w45 |
58. | 58 4726 2019w9 |
59. | 59 4701 2019w41 |
60. | 60 4695 2019w14 |
|------------------------------|
61. | 61 4693 2019w21 |
62. | 62 4690 2019w12 |
63. | 63 4685 2018w19 |
64. | 64 4684 2018w26 |
65. | 65 4676 2020w23 |
|------------------------------|
66. | 66 4673 2020w28 |
67. | 67 4672 2019w26 |
68. | 68 4662 2020w22 |
69. | 69 4650 2019w49 |
70. | 70 4630 2020w27 |
|------------------------------|
71. | 71 4629 2019w25 |
72. | 72 4622 2020w10 |
73. | 73 4606 2018w47 |
74. | 74 4597 2019w23 |
75. | 75 4584 2019w1 |
|------------------------------|
76. | 76 4582 2019w4 |
77. | 77 4574 2018w25 |
78. | 78 4539 2020w17 |
79. | 79 4518 2020w30 |
80. | 80 4508 2018w39 |
|------------------------------|
81. | 81 4505 2019w6 |
82. | 82 4485 2020w29 |
83. | 83 4474 2020w26 |
84. | 84 4473 2018w23 |
85. | 85 4462 2019w28 |
|------------------------------|
86. | 86 4449 2018w16 |
87. | 87 4431 2018w20 |
88. | 88 4424 2018w42 |
89. | 89 4408 2019w5 |
90. | 90 4386 2018w43 |
|------------------------------|
91. | 91 4382 2019w38 |
92. | 92 4377 2019w30 |
93. | 93 4367 2018w27 |
94. | 94 4366 2020w25 |
95. | 95 4348 2019w39 |
|------------------------------|
96. | 96 4342 2019w22 |
97. | 97 4325 2018w40 |
98. | 98 4314 2019w8 |
99. | 99 4295 2019w11 |
100. | 100 4277 2018w29 |
|------------------------------|
101. | 101 4260 2019w17 |
102. | 102 4259 2019w7 |
103. | 103 4248 2018w22 |
104. | 104 4209 2019w40 |
105. | 105 4199 2018w32 |
|------------------------------|
106. | 106 4190 2020w24 |
107. | 107 4175 2018w45 |
108. | 108 4109 2018w28 |
109. | 109 4074 2020w32 |
110. | 110 4047 2018w46 |
|------------------------------|
111. | 111 4005 2019w29 |
112. | 112 4005 2019w37 |
113. | 113 3986 2020w33 |
114. | 114 3981 2018w41 |
115. | 115 3965 2019w33 |
|------------------------------|
116. | 116 3953 2018w24 |
117. | 117 3903 2018w21 |
118. | 118 3882 2019w27 |
119. | 119 3811 2019w34 |
120. | 120 3809 2018w30 |
|------------------------------|
121. | 121 3791 2018w48 |
122. | 122 3767 2018w33 |
123. | 123 3763 2018w34 |
124. | 124 3689 2018w50 |
125. | 125 3687 2018w52 |
|------------------------------|
126. | 126 3683 2019w36 |
127. | 127 3615 2018w51 |
128. | 128 3603 2019w31 |
129. | 129 3596 2018w49 |
130. | 130 3586 2018w37 |
|------------------------------|
131. | 131 3579 2019w35 |
132. | 132 3536 2018w36 |
133. | 133 3489 2018w31 |
134. | 134 3346 2019w32 |
135. | 135 3321 2018w44 |
|------------------------------|
136. | 136 3186 2018w35 |
+------------------------------+