Intra-week merits (from 24/1/2018 to 17/3/2020)Last 3 days dropped due to incomplete week (2020w12) and an incomplete day (dayid = 787)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 |
+-----------------+
Time series plotBasic statistics:- 50% of observed weeks (
112 weeks) have total intra-week merits above 4614, whilst the rest 50% of them have total intra-week merits below 4614. 4614 is the median - p50.
- 50% of observed weeks have total intra-week merits fluctuated in the range from 4187 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 | 112.0 5557.4 3428.4 4614.0 4187.0 5584.5 3186.0 27920.0
----------------------------------------------------------------------------------------------
Potential outliers:. di 5584.5-4187
1397.5
. di 1397.5*1.5
2096.25
. di 5584.5+2096.25
7680.75
. di 4187-2096.25
2090.75
It means that potential outliers are weeks that have intra-week merits beyond
2091 or
7681.
How many weeks are potential outliers?
. count if (merit >= 7681 | merit < 2091) & 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).
List of weeks in descending weekly meritsThe last week (with 5109 merits) stays at the
36th position, among 112 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 5946 2018w15 |
25. | 25 5776 2019w3 |
|------------------------------|
26. | 26 5745 2020w1 |
27. | 27 5728 2019w13 |
28. | 28 5596 2019w20 |
29. | 29 5573 2020w6 |
30. | 30 5395 2020w2 |
|------------------------------|
31. | 31 5375 2019w43 |
32. | 32 5373 2019w24 |
33. | 33 5253 2019w15 |
34. | 34 5237 2020w9 |
35. | 35 5160 2019w42 |
|------------------------------|
36. | 36 5109 2020w11 |
37. | 37 5043 2018w18 |
38. | 38 5002 2019w19 |
39. | 39 4979 2019w10 |
40. | 40 4880 2019w16 |
|------------------------------|
41. | 41 4832 2019w50 |
42. | 42 4820 2018w17 |
43. | 43 4817 2019w18 |
44. | 44 4816 2019w44 |
45. | 45 4753 2019w45 |
|------------------------------|
46. | 46 4726 2019w9 |
47. | 47 4701 2019w41 |
48. | 48 4695 2019w14 |
49. | 49 4693 2019w21 |
50. | 50 4690 2019w12 |
|------------------------------|
51. | 51 4685 2018w19 |
52. | 52 4684 2018w26 |
53. | 53 4672 2019w26 |
54. | 54 4650 2019w49 |
55. | 55 4629 2019w25 |
|------------------------------|
56. | 56 4622 2020w10 |
57. | 57 4606 2018w47 |
58. | 58 4597 2019w23 |
59. | 59 4584 2019w1 |
60. | 60 4582 2019w4 |
|------------------------------|
61. | 61 4574 2018w25 |
62. | 62 4508 2018w39 |
63. | 63 4505 2019w6 |
64. | 64 4473 2018w23 |
65. | 65 4462 2019w28 |
|------------------------------|
66. | 66 4449 2018w16 |
67. | 67 4431 2018w20 |
68. | 68 4424 2018w42 |
69. | 69 4408 2019w5 |
70. | 70 4386 2018w43 |
|------------------------------|
71. | 71 4382 2019w38 |
72. | 72 4377 2019w30 |
73. | 73 4367 2018w27 |
74. | 74 4348 2019w39 |
75. | 75 4342 2019w22 |
|------------------------------|
76. | 76 4325 2018w40 |
77. | 77 4314 2019w8 |
78. | 78 4295 2019w11 |
79. | 79 4277 2018w29 |
80. | 80 4260 2019w17 |
|------------------------------|
81. | 81 4259 2019w7 |
82. | 82 4248 2018w22 |
83. | 83 4209 2019w40 |
84. | 84 4199 2018w32 |
85. | 85 4175 2018w45 |
|------------------------------|
86. | 86 4109 2018w28 |
87. | 87 4047 2018w46 |
88. | 88 4005 2019w29 |
89. | 89 4005 2019w37 |
90. | 90 3981 2018w41 |
|------------------------------|
91. | 91 3965 2019w33 |
92. | 92 3953 2018w24 |
93. | 93 3903 2018w21 |
94. | 94 3882 2019w27 |
95. | 95 3811 2019w34 |
|------------------------------|
96. | 96 3809 2018w30 |
97. | 97 3791 2018w48 |
98. | 98 3767 2018w33 |
99. | 99 3763 2018w34 |
100. | 100 3689 2018w50 |
|------------------------------|
101. | 101 3687 2018w52 |
102. | 102 3683 2019w36 |
103. | 103 3615 2018w51 |
104. | 104 3603 2019w31 |
105. | 105 3596 2018w49 |
|------------------------------|
106. | 106 3586 2018w37 |
107. | 107 3579 2019w35 |
108. | 108 3536 2018w36 |
109. | 109 3489 2018w31 |
110. | 110 3346 2019w32 |
|------------------------------|
111. | 111 3321 2018w44 |
112. | 112 3186 2018w35 |
+------------------------------+