Last 3 days dropped due to incomplete week (2020w31) and an incomplete day (dayid = 920)
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 |
+-----------------+
Time series plot
Basic statistics:
- 50% of observed weeks (131 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 5596 (the interquartile range, from p25 to p75, in raw statistics below).
- Min - max: 3186 - 27920.
-------------+--------------------------------------------------------------------------------
merit | 131.0 5475.8 3181.2 4650.0 4259.0 5596.0 3186.0 27920.0
----------------------------------------------------------------------------------------------
Potential outliers:
1337
. di 1337*1.5
2005.5
. di 5596+2005.5
7601.5
. di 4259-2005.5
2253.5
How many weeks are potential outliers?
9
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 |
+-----------------+
List of weeks in descending weekly merits
The last week (with 4518 merits) stays at the 76th position, among 131 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 4673 2020w28 |
64. | 64 4672 2019w26 |
65. | 65 4662 2020w22 |
|------------------------------|
66. | 66 4650 2019w49 |
67. | 67 4630 2020w27 |
68. | 68 4629 2019w25 |
69. | 69 4622 2020w10 |
70. | 70 4606 2018w47 |
|------------------------------|
71. | 71 4597 2019w23 |
72. | 72 4584 2019w1 |
73. | 73 4582 2019w4 |
74. | 74 4574 2018w25 |
75. | 75 4539 2020w17 |
|------------------------------|
76. | 76 4518 2020w30 |
77. | 77 4508 2018w39 |
78. | 78 4505 2019w6 |
79. | 79 4485 2020w29 |
80. | 80 4474 2020w26 |
|------------------------------|
81. | 81 4473 2018w23 |
82. | 82 4462 2019w28 |
83. | 83 4449 2018w16 |
84. | 84 4431 2018w20 |
85. | 85 4424 2018w42 |
|------------------------------|
86. | 86 4408 2019w5 |
87. | 87 4386 2018w43 |
88. | 88 4382 2019w38 |
89. | 89 4377 2019w30 |
90. | 90 4367 2018w27 |
|------------------------------|
91. | 91 4366 2020w25 |
92. | 92 4348 2019w39 |
93. | 93 4342 2019w22 |
94. | 94 4325 2018w40 |
95. | 95 4314 2019w8 |
|------------------------------|
96. | 96 4295 2019w11 |
97. | 97 4277 2018w29 |
98. | 98 4260 2019w17 |
99. | 99 4259 2019w7 |
100. | 100 4248 2018w22 |
|------------------------------|
101. | 101 4209 2019w40 |
102. | 102 4199 2018w32 |
103. | 103 4190 2020w24 |
104. | 104 4175 2018w45 |
105. | 105 4109 2018w28 |
|------------------------------|
106. | 106 4047 2018w46 |
107. | 107 4005 2019w37 |
108. | 108 4005 2019w29 |
109. | 109 3981 2018w41 |
110. | 110 3965 2019w33 |
|------------------------------|
111. | 111 3953 2018w24 |
112. | 112 3903 2018w21 |
113. | 113 3882 2019w27 |
114. | 114 3811 2019w34 |
115. | 115 3809 2018w30 |
|------------------------------|
116. | 116 3791 2018w48 |
117. | 117 3767 2018w33 |
118. | 118 3763 2018w34 |
119. | 119 3689 2018w50 |
120. | 120 3687 2018w52 |
|------------------------------|
121. | 121 3683 2019w36 |
122. | 122 3615 2018w51 |
123. | 123 3603 2019w31 |
124. | 124 3596 2018w49 |
125. | 125 3586 2018w37 |
|------------------------------|
126. | 126 3579 2019w35 |
127. | 127 3536 2018w36 |
128. | 128 3489 2018w31 |
129. | 129 3346 2019w32 |
130. | 130 3321 2018w44 |
|------------------------------|
131. | 131 3186 2018w35 |
+------------------------------+