Intra-week merits (from 24/1/2018 to 29/9/2020)Last 3 days dropped due to incomplete week (2020w40) and an incomplete day (dayid = 983)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 |
137. | 4667 2020w36 |
138. | 4290 2020w37 |
139. | 4983 2020w38 |
140. | 4227 2020w39 |
+-----------------+
Time series plotBasic statistics:- 50% of observed weeks (
140 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 5484 (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 | 140.0 5427.3 3086.2 4656.0 4253.5 5484.0 3186.0 27920.0
----------------------------------------------------------------------------------------------
Potential outliers:. di 5484-4254
1230
. di 1230*1.5
1845
. di 5484+1845
7329
. di 4254-1845
2409
It means that potential outliers are weeks that have intra-week merits beyond
2409 or
7329.
How many weeks are potential outliers?
. count if (merit >= 7329 | merit < 2409) & merit != .
10
10 weeks are outliers, in total.
List of those
10 weeks:
+-----------------+
| merit week |
|-----------------|
1. | 27920 2018w4 |
2. | 20930 2018w5 |
3. | 14042 2018w6 |
4. | 11901 2018w7 |
5. | 8879 2018w8 |
|-----------------|
6. | 9005 2018w9 |
8. | 7340 2018w11 |
35. | 9587 2018w38 |
95. | 11070 2019w46 |
96. | 20397 2019w47 |
+-----------------+
Most of them occured in the year 2018, and there is only
2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 (20397). None of them occured in 2020 so far.
List of weeks in descending weekly meritsThe last week (with 4227 merits) stays at the
107th position, among 140 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 4983 2020w38 |
|------------------------------|
51. | 51 4979 2019w10 |
52. | 52 4963 2020w31 |
53. | 53 4880 2019w16 |
54. | 54 4832 2019w50 |
55. | 55 4820 2018w17 |
|------------------------------|
56. | 56 4817 2019w18 |
57. | 57 4816 2019w44 |
58. | 58 4753 2019w45 |
59. | 59 4726 2019w9 |
60. | 60 4701 2019w41 |
|------------------------------|
61. | 61 4695 2019w14 |
62. | 62 4693 2019w21 |
63. | 63 4690 2019w12 |
64. | 64 4685 2018w19 |
65. | 65 4684 2018w26 |
|------------------------------|
66. | 66 4676 2020w23 |
67. | 67 4673 2020w28 |
68. | 68 4672 2019w26 |
69. | 69 4667 2020w36 |
70. | 70 4662 2020w22 |
|------------------------------|
71. | 71 4650 2019w49 |
72. | 72 4630 2020w27 |
73. | 73 4629 2019w25 |
74. | 74 4622 2020w10 |
75. | 75 4606 2018w47 |
|------------------------------|
76. | 76 4597 2019w23 |
77. | 77 4584 2019w1 |
78. | 78 4582 2019w4 |
79. | 79 4574 2018w25 |
80. | 80 4539 2020w17 |
|------------------------------|
81. | 81 4518 2020w30 |
82. | 82 4508 2018w39 |
83. | 83 4505 2019w6 |
84. | 84 4485 2020w29 |
85. | 85 4474 2020w26 |
|------------------------------|
86. | 86 4473 2018w23 |
87. | 87 4462 2019w28 |
88. | 88 4449 2018w16 |
89. | 89 4431 2018w20 |
90. | 90 4424 2018w42 |
|------------------------------|
91. | 91 4408 2019w5 |
92. | 92 4386 2018w43 |
93. | 93 4382 2019w38 |
94. | 94 4377 2019w30 |
95. | 95 4367 2018w27 |
|------------------------------|
96. | 96 4366 2020w25 |
97. | 97 4348 2019w39 |
98. | 98 4342 2019w22 |
99. | 99 4325 2018w40 |
100. | 100 4314 2019w8 |
|------------------------------|
101. | 101 4295 2019w11 |
102. | 102 4290 2020w37 |
103. | 103 4277 2018w29 |
104. | 104 4260 2019w17 |
105. | 105 4259 2019w7 |
|------------------------------|
106. | 106 4248 2018w22 |
107. | 107 4227 2020w39 |
108. | 108 4209 2019w40 |
109. | 109 4199 2018w32 |
110. | 110 4190 2020w24 |
|------------------------------|
111. | 111 4175 2018w45 |
112. | 112 4109 2018w28 |
113. | 113 4074 2020w32 |
114. | 114 4047 2018w46 |
115. | 115 4005 2019w29 |
|------------------------------|
116. | 116 4005 2019w37 |
117. | 117 3986 2020w33 |
118. | 118 3981 2018w41 |
119. | 119 3965 2019w33 |
120. | 120 3953 2018w24 |
|------------------------------|
121. | 121 3903 2018w21 |
122. | 122 3882 2019w27 |
123. | 123 3811 2019w34 |
124. | 124 3809 2018w30 |
125. | 125 3791 2018w48 |
|------------------------------|
126. | 126 3767 2018w33 |
127. | 127 3763 2018w34 |
128. | 128 3689 2018w50 |
129. | 129 3687 2018w52 |
130. | 130 3683 2019w36 |
|------------------------------|
131. | 131 3615 2018w51 |
132. | 132 3603 2019w31 |
133. | 133 3596 2018w49 |
134. | 134 3586 2018w37 |
135. | 135 3579 2019w35 |
|------------------------------|
136. | 136 3536 2018w36 |
137. | 137 3489 2018w31 |
138. | 138 3346 2019w32 |
139. | 139 3321 2018w44 |
140. | 140 3186 2018w35 |
+------------------------------+