Update:
ABSTRACTNotes:
- The asbstract describes figures of intraday merits over the period from 19/2/2018 to 04/02/2019 (truncated dataset);
- Days from 24/1/2018 to 18/2/2018 truncated due to highly potential outliers; and days after 04/02/2019 truncated as well due to incomplete week (the sixth week of 2019, 2019w6);
- Statistics presented in the post are for truncated dataset.
(1) Potential outliers are days that have intraday total merits beyond 131 or 1159;
(2) Median of intraday merits over the period is 620, whilst the interquartile range is from 516 to 773;
(3) Friday [in GTM time] is the day over weeks has lowest intraday merits in terms of both median and mean, at 548, and 618, respectively.
(4) Monday [in GMT time] is the day over weeks has highest intraday merits in terms of both median and mean, at 674, and 747, respectively.
(5) There are 21 potential outliers in total, and there is only one potential outlier day happened in early weeks of 2019, on 09 Jan. 2019, at 1161.
1) Daily merits' time series plotFull dataset:I used full dataset, since 24/1/2018 to 06/02/2019 to draw the below plot
Truncated dataset:2) Basic statistics* For full dataset (only first 2 days dropped due to extremely high merits distributed during those days)
- Mean +/- sd: 789 +/- 528
- Median (interquartile range): 638 (521 – 835)
- Min - max: 312 - 4493.
From the full dataset, we can easily identify potential outliers via the following formula:
IQR = Q3 – Q1 = 835 – 521 = 314;
1.5*IQR = 1.5*314 = 471
Potential outliers:
- Above Q3 +1.5*IQR = 835 + 471 = 1306
- Below Q1 – 1.5*IQR = 521 – 471 = 50
Let's see how many days that have total intraday merits beyond 50 or 1306?
. count if (merit >= 1306 | merit <= 50) & merit != .
33
In total,
33 days are extremely potential outliers, and none of them occured recent weeks (only days before 18/9/2018).
. list id merit date if (merit >= 1306 | merit <= 50) & merit != .
+-------------------------+
| id merit date |
|-------------------------|
1. | 3 4493 26jan2018 |
2. | 4 3489 27jan2018 |
3. | 5 3188 28jan2018 |
4. | 6 3799 29jan2018 |
5. | 7 4192 30jan2018 |
|-------------------------|
6. | 8 2820 31jan2018 |
7. | 9 2545 01feb2018 |
8. | 10 2568 02feb2018 |
9. | 11 1867 03feb2018 |
10. | 12 2167 04feb2018 |
|-------------------------|
11. | 13 2077 05feb2018 |
12. | 14 2308 06feb2018 |
13. | 15 2141 07feb2018 |
14. | 16 2141 08feb2018 |
15. | 17 1448 09feb2018 |
|-------------------------|
16. | 18 1747 10feb2018 |
17. | 19 1442 11feb2018 |
18. | 20 1331 12feb2018 |
19. | 21 1579 13feb2018 |
20. | 22 2513 14feb2018 |
|-------------------------|
21. | 23 1991 15feb2018 |
22. | 24 1411 16feb2018 |
23. | 25 1608 17feb2018 |
25. | 27 1403 19feb2018 |
30. | 32 1409 24feb2018 |
|-------------------------|
32. | 34 1382 26feb2018 |
33. | 35 1326 27feb2018 |
35. | 37 1333 01mar2018 |
36. | 38 1696 02mar2018 |
46. | 48 1354 12mar2018 |
|-------------------------|
54. | 56 1322 20mar2018 |
234. | 236 2463 16sep2018 |
235. | 237 1862 17sep2018 |
+-------------------------+
Let's identify potential outliers of the truncated dataset (from 19/2/2018 to 04/02/2019):
- Mean +/- sd: 683 +/- 259
- Median (interquartile range): 620 (516 – 773)
- Min - max: 312 - 2463.
IQR = Q3 – Q1 = 773 – 516 = 257
1.5*IQR = 1.5*257 = 385.5
Potential outliers:
- Above Q3 +1.5*IQR = 773 + 385.5 = 1158.5 ~ 1159
- Below Q1 – 1.5*IQR = 516 – 385.5 = 130.5 ~ 131
Potential outliers are days that have intraday merits beyond 131 or 1159
Let's see how many days that have total intraday merits beyond 131 or 1159
. count if (merit >= 1159 | merit <= 131) & merit != .
21
There are 21 days in total, and there is only one potential outlier day happened in early weeks of 2019, on 09 Jan. 2019, at 1161.
. list id merit date if (merit >= 1159 | merit <= 131) & merit != .
+-------------------------+
| id merit date |
|-------------------------|
1. | 27 1403 19feb2018 |
2. | 28 1169 20feb2018 |
3. | 29 1266 21feb2018 |
4. | 30 1279 22feb2018 |
6. | 32 1409 24feb2018 |
|-------------------------|
7. | 33 1186 25feb2018 |
8. | 34 1382 26feb2018 |
9. | 35 1326 27feb2018 |
11. | 37 1333 01mar2018 |
12. | 38 1696 02mar2018 |
|-------------------------|
15. | 41 1245 05mar2018 |
22. | 48 1354 12mar2018 |
24. | 50 1159 14mar2018 |
30. | 56 1322 20mar2018 |
31. | 57 1227 21mar2018 |
|-------------------------|
42. | 68 1233 01apr2018 |
210. | 236 2463 16sep2018 |
211. | 237 1862 17sep2018 |
212. | 238 1294 18sep2018 |
213. | 239 1268 19sep2018 |
|-------------------------|
325. | 351 1161 09jan2019 |
+-------------------------+
2) The 50 lowest day in terms of daily merits . list merit id date dofw day month2 year week month
+-------------------------------------------------------------------------------+
| merit id date dofw day month2 year week month |
|-------------------------------------------------------------------------------|
1. | 312 335 24dec2018 Monday 24 12 2018 2018w52 2018m12 |
2. | 316 333 22dec2018 Saturday 22 12 2018 2018w51 2018m12 |
3. | 325 340 29dec2018 Saturday 29 12 2018 2018w52 2018m12 |
4. | 347 298 17nov2018 Saturday 17 11 2018 2018w46 2018m11 |
5. | 347 338 27dec2018 Thursday 27 12 2018 2018w52 2018m12 |
|-------------------------------------------------------------------------------|
6. | 348 304 23nov2018 Friday 23 11 2018 2018w47 2018m11 |
7. | 370 122 25may2018 Friday 25 5 2018 2018w21 2018m5 |
8. | 376 191 02aug2018 Thursday 2 8 2018 2018w31 2018m8 |
9. | 376 342 31dec2018 Monday 31 12 2018 2018w52 2018m12 |
10. | 377 326 15dec2018 Saturday 15 12 2018 2018w50 2018m12 |
|-------------------------------------------------------------------------------|
11. | 379 220 31aug2018 Friday 31 8 2018 2018w35 2018m8 |
12. | 383 217 28aug2018 Tuesday 28 8 2018 2018w35 2018m8 |
13. | 385 214 25aug2018 Saturday 25 8 2018 2018w34 2018m8 |
14. | 386 339 28dec2018 Friday 28 12 2018 2018w52 2018m12 |
15. | 389 341 30dec2018 Sunday 30 12 2018 2018w52 2018m12 |
|-------------------------------------------------------------------------------|
16. | 394 345 03jan2019 Thursday 3 1 2019 2019w1 2019m1 |
17. | 395 228 08sep2018 Saturday 8 9 2018 2018w36 2018m9 |
18. | 397 320 09dec2018 Sunday 9 12 2018 2018w49 2018m12 |
19. | 399 262 12oct2018 Friday 12 10 2018 2018w41 2018m10 |
20. | 402 329 18dec2018 Tuesday 18 12 2018 2018w51 2018m12 |
|-------------------------------------------------------------------------------|
21. | 405 287 06nov2018 Tuesday 6 11 2018 2018w45 2018m11 |
22. | 412 222 02sep2018 Sunday 2 9 2018 2018w35 2018m9 |
23. | 415 109 12may2018 Saturday 12 5 2018 2018w19 2018m5 |
24. | 415 278 28oct2018 Sunday 28 10 2018 2018w43 2018m10 |
25. | 418 186 28jul2018 Saturday 28 7 2018 2018w30 2018m7 |
|-------------------------------------------------------------------------------|
26. | 420 187 29jul2018 Sunday 29 7 2018 2018w30 2018m7 |
27. | 421 192 03aug2018 Friday 3 8 2018 2018w31 2018m8 |
28. | 422 140 12jun2018 Tuesday 12 6 2018 2018w24 2018m6 |
29. | 424 313 02dec2018 Sunday 2 12 2018 2018w48 2018m12 |
30. | 424 276 26oct2018 Friday 26 10 2018 2018w43 2018m10 |
|-------------------------------------------------------------------------------|
31. | 426 277 27oct2018 Saturday 27 10 2018 2018w43 2018m10 |
32. | 430 264 14oct2018 Sunday 14 10 2018 2018w41 2018m10 |
33. | 430 284 03nov2018 Saturday 3 11 2018 2018w44 2018m11 |
34. | 432 221 01sep2018 Saturday 1 9 2018 2018w35 2018m9 |
35. | 432 208 19aug2018 Sunday 19 8 2018 2018w33 2018m8 |
|-------------------------------------------------------------------------------|
36. | 433 282 01nov2018 Thursday 1 11 2018 2018w44 2018m11 |
37. | 435 154 26jun2018 Tuesday 26 6 2018 2018w26 2018m6 |
38. | 435 190 01aug2018 Wednesday 1 8 2018 2018w31 2018m8 |
39. | 444 182 24jul2018 Tuesday 24 7 2018 2018w30 2018m7 |
40. | 445 143 15jun2018 Friday 15 6 2018 2018w24 2018m6 |
|-------------------------------------------------------------------------------|
41. | 450 373 31jan2019 Thursday 31 1 2019 2019w5 2019m1 |
42. | 451 206 17aug2018 Friday 17 8 2018 2018w33 2018m8 |
43. | 454 283 02nov2018 Friday 2 11 2018 2018w44 2018m11 |
44. | 455 167 09jul2018 Monday 9 7 2018 2018w28 2018m7 |
45. | 455 229 09sep2018 Sunday 9 9 2018 2018w36 2018m9 |
|-------------------------------------------------------------------------------|
46. | 457 216 27aug2018 Monday 27 8 2018 2018w35 2018m8 |
47. | 458 324 13dec2018 Thursday 13 12 2018 2018w50 2018m12 |
48. | 458 227 07sep2018 Friday 7 9 2018 2018w36 2018m9 |
49. | 460 263 13oct2018 Saturday 13 10 2018 2018w41 2018m10 |
50. | 461 130 02jun2018 Saturday 2 6 2018 2018w22 2018m6 |
|-------------------------------------------------------------------------------|
3) The 50 highest day in terms of daily merits . list merit id date dofw day month2 year week month
+-------------------------------------------------------------------------------+
| merit id date dofw day month2 year week month |
|-------------------------------------------------------------------------------|
1. | 13018 1 24jan2018 Wednesday 24 1 2018 2018w4 2018m1 |
2. | 6761 2 25jan2018 Thursday 25 1 2018 2018w4 2018m1 |
3. | 4493 3 26jan2018 Friday 26 1 2018 2018w4 2018m1 |
4. | 4192 7 30jan2018 Tuesday 30 1 2018 2018w5 2018m1 |
5. | 3799 6 29jan2018 Monday 29 1 2018 2018w5 2018m1 |
|-------------------------------------------------------------------------------|
6. | 3489 4 27jan2018 Saturday 27 1 2018 2018w4 2018m1 |
7. | 3188 5 28jan2018 Sunday 28 1 2018 2018w4 2018m1 |
8. | 2820 8 31jan2018 Wednesday 31 1 2018 2018w5 2018m1 |
9. | 2568 10 02feb2018 Friday 2 2 2018 2018w5 2018m2 |
10. | 2545 9 01feb2018 Thursday 1 2 2018 2018w5 2018m2 |
|-------------------------------------------------------------------------------|
11. | 2513 22 14feb2018 Wednesday 14 2 2018 2018w7 2018m2 |
12. | 2463 236 16sep2018 Sunday 16 9 2018 2018w37 2018m9 |
13. | 2308 14 06feb2018 Tuesday 6 2 2018 2018w6 2018m2 |
14. | 2167 12 04feb2018 Sunday 4 2 2018 2018w5 2018m2 |
15. | 2141 15 07feb2018 Wednesday 7 2 2018 2018w6 2018m2 |
|-------------------------------------------------------------------------------|
16. | 2141 16 08feb2018 Thursday 8 2 2018 2018w6 2018m2 |
17. | 2077 13 05feb2018 Monday 5 2 2018 2018w6 2018m2 |
18. | 1991 23 15feb2018 Thursday 15 2 2018 2018w7 2018m2 |
19. | 1867 11 03feb2018 Saturday 3 2 2018 2018w5 2018m2 |
20. | 1862 237 17sep2018 Monday 17 9 2018 2018w38 2018m9 |
|-------------------------------------------------------------------------------|
21. | 1747 18 10feb2018 Saturday 10 2 2018 2018w6 2018m2 |
22. | 1696 38 02mar2018 Friday 2 3 2018 2018w9 2018m3 |
23. | 1608 25 17feb2018 Saturday 17 2 2018 2018w7 2018m2 |
24. | 1579 21 13feb2018 Tuesday 13 2 2018 2018w7 2018m2 |
25. | 1448 17 09feb2018 Friday 9 2 2018 2018w6 2018m2 |
|-------------------------------------------------------------------------------|
26. | 1442 19 11feb2018 Sunday 11 2 2018 2018w6 2018m2 |
27. | 1411 24 16feb2018 Friday 16 2 2018 2018w7 2018m2 |
28. | 1409 32 24feb2018 Saturday 24 2 2018 2018w8 2018m2 |
29. | 1403 27 19feb2018 Monday 19 2 2018 2018w8 2018m2 |
30. | 1382 34 26feb2018 Monday 26 2 2018 2018w9 2018m2 |
|-------------------------------------------------------------------------------|
31. | 1354 48 12mar2018 Monday 12 3 2018 2018w11 2018m3 |
32. | 1333 37 01mar2018 Thursday 1 3 2018 2018w9 2018m3 |
33. | 1331 20 12feb2018 Monday 12 2 2018 2018w7 2018m2 |
34. | 1326 35 27feb2018 Tuesday 27 2 2018 2018w9 2018m2 |
35. | 1322 56 20mar2018 Tuesday 20 3 2018 2018w12 2018m3 |
|-------------------------------------------------------------------------------|
36. | 1294 238 18sep2018 Tuesday 18 9 2018 2018w38 2018m9 |
37. | 1289 26 18feb2018 Sunday 18 2 2018 2018w7 2018m2 |
38. | 1279 30 22feb2018 Thursday 22 2 2018 2018w8 2018m2 |
39. | 1268 239 19sep2018 Wednesday 19 9 2018 2018w38 2018m9 |
40. | 1266 29 21feb2018 Wednesday 21 2 2018 2018w8 2018m2 |
|-------------------------------------------------------------------------------|
41. | 1245 41 05mar2018 Monday 5 3 2018 2018w10 2018m3 |
42. | 1233 68 01apr2018 Sunday 1 4 2018 2018w13 2018m4 |
43. | 1227 57 21mar2018 Wednesday 21 3 2018 2018w12 2018m3 |
44. | 1186 33 25feb2018 Sunday 25 2 2018 2018w8 2018m2 |
45. | 1169 28 20feb2018 Tuesday 20 2 2018 2018w8 2018m2 |
|-------------------------------------------------------------------------------|
46. | 1161 351 09jan2019 Wednesday 9 1 2019 2019w2 2019m1 |
47. | 1159 50 14mar2018 Wednesday 14 3 2018 2018w11 2018m3 |
48. | 1146 69 02apr2018 Monday 2 4 2018 2018w14 2018m4 |
49. | 1138 153 25jun2018 Monday 25 6 2018 2018w26 2018m6 |
50. | 1130 51 15mar2018 Thursday 15 3 2018 2018w11 2018m3 |
|-------------------------------------------------------------------------------|
4) Intraday merits over days of week-
In medians of intraday merits, and GMT time,
lowest days are
Friday, Saturday and Sunday, at
548, 601 and 610, respectively.
-
In means of intraday merits, and GMT time,
lowest days are
Friday, Saturday, and Thursday at
616, 629, and 673.
- The
highest day in terms of medians and means re both
Monday, at 674 and 747, respectively.
More details in the raw results below.
. tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f) by(dofw)
Summary for variables: merit
by categories of: dofw
dofw | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
Sunday | 50.0 699.9 336.0 610.0 476.0 804.0 389.0 2463.0
Monday | 51.0 746.6 301.8 674.0 536.0 822.0 312.0 1862.0
Tuesday | 50.0 695.6 232.2 626.0 578.0 767.0 383.0 1326.0
Wednesday | 50.0 718.3 222.8 653.0 558.0 761.0 435.0 1268.0
Thursday | 50.0 673.0 225.7 639.5 509.0 774.0 347.0 1333.0
Friday | 50.0 616.0 232.1 548.0 475.0 698.0 348.0 1696.0
Saturday | 50.0 628.4 222.5 600.5 461.0 695.0 316.0 1409.0
----------+--------------------------------------------------------------------------------
Total | 351.0 682.7 258.5 620.0 516.0 773.0 312.0 2463.0
-------------------------------------------------------------------------------------------
Plots:- Outliers displayed with red circles.
- Outliers non-displayed.