I don't agree.
In my analysis on intra-week merits, there is no outlier week occured in first three weeks of 2019!
< ... >
In short, my analysis presented there:
< ... >
I> Full dataset< ... >
Potential outliers are weeks that have total merits beyond these two threshold
1) Q3 + 1.5*IQR = 6022.5 + 3335.25 = 9357.75 ~ 9358
2) Q1 - 1.5*IQR = 3799 - 3335.25 = 463.75 ~ 464
< ... >
Now, let's count how many weeks are outliers:
. list merit week if merit >=9358 | merit <=464
+----------------+
| merit week |
|----------------|
1. | 30949 2018w4 |
2. | 19958 2018w5 |
3. | 13304 2018w6 |
4. | 11722 2018w7 |
+----------------+
There are only
four outlier weeks, and all of them occured within the first four weeks after the start of merit system.
II> Truncated datasetNow, I truncated all these four weeks in order to have a truncated dataset, and start identifying potential outliers for the truncated dataset
< ... >
Potential outliers:- IQR = Q3 - Q1 = 1336
- 1.5*IQR = 1336*1.5 = 2004
- Q3 + 1.5*IQR = 5129.5 + 2004 = 7133.5 ~ 7134.
- Q1 - 1.5*IQR = 3793.5 - 2004 = 1789.5 ~ 1790
Potential outliers for truncated dataset are weeks that have total intraweek merits beyond 1790 or 7134.
< ... >
Let's see how many outliers identified:
. list merit week if merit >=7134 | merit <=1790
+-----------------+
| merit week |
|-----------------|
1. | 8758 2018w8 |
2. | 8806 2018w9 |
3. | 7253 2018w10 |
4. | 7309 2018w11 |
31. | 7825 2018w38 |
+-----------------+
Five weeks in total, and
none of them occured in the year 2019.
The week #2018w18 described below:
. list id merit date dofw day month2 year week month if id >=237 & id < 244
+------------------------------------------------------------------------------+
| id merit date dofw day month2 year week month |
|------------------------------------------------------------------------------|
237. | 237 1862 17sep2018 Monday 17 9 2018 2018w38 2018m9 |
238. | 238 1294 18sep2018 Tuesday 18 9 2018 2018w38 2018m9 |
239. | 239 1268 19sep2018 Wednesday 19 9 2018 2018w38 2018m9 |
240. | 240 846 20sep2018 Thursday 20 9 2018 2018w38 2018m9 |
241. | 241 807 21sep2018 Friday 21 9 2018 2018w38 2018m9 |
|------------------------------------------------------------------------------|
242. | 242 944 22sep2018 Saturday 22 9 2018 2018w38 2018m9 |
243. | 243 804 23sep2018 Sunday 23 9 2018 2018w38 2018m9 |
+------------------------------------------------------------------------------+
As we all known, the sudden rises of merits
in September mainly come from abusements due to demotion of Junior Members.
For fully analysis, please visit the original post.