Converted dataset:
. list merit week
+-----------------+
| merit week |
|-----------------|
1. | 30949 2018w4 |
2. | 19958 2018w5 |
3. | 13304 2018w6 |
4. | 11722 2018w7 |
5. | 8758 2018w8 |
|-----------------|
6. | 8806 2018w9 |
7. | 7253 2018w10 |
8. | 7309 2018w11 |
9. | 6941 2018w12 |
10. | 6707 2018w13 |
|-----------------|
11. | 6415 2018w14 |
12. | 5487 2018w15 |
13. | 4631 2018w16 |
14. | 4585 2018w17 |
15. | 4953 2018w18 |
|-----------------|
16. | 4753 2018w19 |
17. | 4346 2018w20 |
18. | 3854 2018w21 |
19. | 4183 2018w22 |
20. | 4527 2018w23 |
|-----------------|
21. | 3818 2018w24 |
22. | 4921 2018w25 |
23. | 4457 2018w26 |
24. | 4253 2018w27 |
25. | 4239 2018w28 |
|-----------------|
26. | 4159 2018w29 |
27. | 3652 2018w30 |
28. | 3798 2018w31 |
29. | 3994 2018w32 |
30. | 3618 2018w33 |
|-----------------|
31. | 3789 2018w34 |
32. | 3065 2018w35 |
33. | 3574 2018w36 |
34. | 5630 2018w37 |
35. | 7825 2018w38 |
|-----------------|
36. | 4388 2018w39 |
37. | 4271 2018w40 |
38. | 3800 2018w41 |
39. | 4821 2018w42 |
40. | 3945 2018w43 |
|-----------------|
41. | 3339 2018w44 |
42. | 4513 2018w45 |
43. | 3722 2018w46 |
44. | 4558 2018w47 |
45. | 3750 2018w48 |
|-----------------|
46. | 3560 2018w49 |
47. | 3782 2018w50 |
48. | 3753 2018w51 |
49. | 3278 2018w52 |
50. | 4793 2019w1 |
|-----------------|
51. | 6624 2019w2 |
52. | 5306 2019w3 |
53. | 4659 2019w4 |
54. | 4474 2019w5 |
55. | 4318 2019w6 |
|-----------------|
56. | 4207 2019w7 |
57. | 4507 2019w8 |
58. | 4625 2019w9 |
59. | 4901 2019w10 |
60. | 4318 2019w11 |
|-----------------|
61. | 4598 2019w12 |
62. | 6120 2019w13 |
63. | 4418 2019w14 |
64. | 5259 2019w15 |
65. | 4680 2019w16 |
|-----------------|
66. | 4450 2019w17 |
67. | 4756 2019w18 |
68. | 5434 2019w19 |
69. | 5202 2019w20 |
70. | 4571 2019w21 |
|-----------------|
71. | 4336 2019w22 |
72. | 4678 2019w23 |
73. | 5294 2019w24 |
74. | 4710 2019w25 |
75. | 4356 2019w26 |
+-----------------+
Time series plot
Basic statistics:
- 50% of observed weeks (75 weeks) have total intra-week merits above 4558, whilst the rest 50% of them have total intra-week merits below 4558. 4558is the median - p50.
- 50% of observed weeks have total intra-week merits fluctuated in the range from 4159 to 5294 (the interquartile range, from p25 to p75, in raw statistics below).
- Min - max: 3065 - 30949.
. tabstat merit, s(n mean sd p50 p25 p75 min max)
variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 75 5537.427 3842.798 4558 4159 5294 3065 30949
----------------------------------------------------------------------------------------------
Potential outliers:
. di 5294-4159
1135
. di 1135*1.5
1702.5
. di 5294+1702.5
6996.5
. di 4159-1702.5
2456.5
How many weeks are potential outliers?
. count if (merit >= 6997 | merit < 2457) & merit != .
9
List of those nine weeks:
. list merit week if merit >=6997 | merit <= 2457
+-----------------+
| merit week |
|-----------------|
1. | 30949 2018w4 |
2. | 19958 2018w5 |
3. | 13304 2018w6 |
4. | 11722 2018w7 |
5. | 8758 2018w8 |
|-----------------|
6. | 8806 2018w9 |
7. | 7253 2018w10 |
8. | 7309 2018w11 |
35. | 7825 2018w38 |
+-----------------+