Intra-week merits (from 24/1/2018 to 30/6/2020)Last 3 days dropped due to incomplete week (2020w27) and an incomplete day (dayid = 892)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 |
+-----------------+
Time series plotBasic statistics:- 50% of observed weeks (
127 weeks) have total intra-week merits above 4662, whilst the rest 50% of them have total intra-week merits below 4662. 4662 is the median - p50.
- 50% of observed weeks have total intra-week merits fluctuated in the range from 4248 to 5603 (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 | 127.0 5504.1 3227.2 4662.0 4248.0 5603.0 3186.0 27920.0
----------------------------------------------------------------------------------------------
Potential outliers:. di 5603-4248
1355
. di 1355*1.5
2032.5
. di 5603+2032.5
7635.5
. di 4248-2032.5
2215.5
It means that potential outliers are weeks that have intra-week merits beyond
2216 or
7636.
How many weeks are potential outliers?
. count if (merit >= 7636 | merit < 2216) & 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 4474 merits) stays at the
76th position, among 127 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 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 4880 2019w16 |
50. | 50 4832 2019w50 |
|------------------------------|
51. | 51 4820 2018w17 |
52. | 52 4817 2019w18 |
53. | 53 4816 2019w44 |
54. | 54 4753 2019w45 |
55. | 55 4726 2019w9 |
|------------------------------|
56. | 56 4701 2019w41 |
57. | 57 4695 2019w14 |
58. | 58 4693 2019w21 |
59. | 59 4690 2019w12 |
60. | 60 4685 2018w19 |
|------------------------------|
61. | 61 4684 2018w26 |
62. | 62 4676 2020w23 |
63. | 63 4672 2019w26 |
64. | 64 4662 2020w22 |
65. | 65 4650 2019w49 |
|------------------------------|
66. | 66 4629 2019w25 |
67. | 67 4622 2020w10 |
68. | 68 4606 2018w47 |
69. | 69 4597 2019w23 |
70. | 70 4584 2019w1 |
|------------------------------|
71. | 71 4582 2019w4 |
72. | 72 4574 2018w25 |
73. | 73 4539 2020w17 |
74. | 74 4508 2018w39 |
75. | 75 4505 2019w6 |
|------------------------------|
76. | 76 4474 2020w26 |
77. | 77 4473 2018w23 |
78. | 78 4462 2019w28 |
79. | 79 4449 2018w16 |
80. | 80 4431 2018w20 |
|------------------------------|
81. | 81 4424 2018w42 |
82. | 82 4408 2019w5 |
83. | 83 4386 2018w43 |
84. | 84 4382 2019w38 |
85. | 85 4377 2019w30 |
|------------------------------|
86. | 86 4367 2018w27 |
87. | 87 4366 2020w25 |
88. | 88 4348 2019w39 |
89. | 89 4342 2019w22 |
90. | 90 4325 2018w40 |
|------------------------------|
91. | 91 4314 2019w8 |
92. | 92 4295 2019w11 |
93. | 93 4277 2018w29 |
94. | 94 4260 2019w17 |
95. | 95 4259 2019w7 |
|------------------------------|
96. | 96 4248 2018w22 |
97. | 97 4209 2019w40 |
98. | 98 4199 2018w32 |
99. | 99 4190 2020w24 |
100. | 100 4175 2018w45 |
|------------------------------|
101. | 101 4109 2018w28 |
102. | 102 4047 2018w46 |
103. | 103 4005 2019w37 |
104. | 104 4005 2019w29 |
105. | 105 3981 2018w41 |
|------------------------------|
106. | 106 3965 2019w33 |
107. | 107 3953 2018w24 |
108. | 108 3903 2018w21 |
109. | 109 3882 2019w27 |
110. | 110 3811 2019w34 |
|------------------------------|
111. | 111 3809 2018w30 |
112. | 112 3791 2018w48 |
113. | 113 3767 2018w33 |
114. | 114 3763 2018w34 |
115. | 115 3689 2018w50 |
|------------------------------|
116. | 116 3687 2018w52 |
117. | 117 3683 2019w36 |
118. | 118 3615 2018w51 |
119. | 119 3603 2019w31 |
120. | 120 3596 2018w49 |
|------------------------------|
121. | 121 3586 2018w37 |
122. | 122 3579 2019w35 |
123. | 123 3536 2018w36 |
124. | 124 3489 2018w31 |
125. | 125 3346 2019w32 |
|------------------------------|
126. | 126 3321 2018w44 |
127. | 127 3186 2018w35 |
+------------------------------+