Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly) - page 30.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Thanks LoyceV for another data dump in my topic.

Intraday merits (converted dataset):
For days in 2019:

Code:

. list id merit date day month2 year week month dofw if year == 2019

   +-----------------------------------------------------------------------------+
   | id merit date day month2 year week month dofw |
   |-----------------------------------------------------------------------------|
343. | 343 603 01jan2019 1 1 2019 2019w1 2019m1 Tuesday |
344. | 344 526 02jan2019 2 1 2019 2019w1 2019m1 Wednesday |
345. | 345 394 03jan2019 3 1 2019 2019w1 2019m1 Thursday |
346. | 346 1082 04jan2019 4 1 2019 2019w1 2019m1 Friday |
347. | 347 835 05jan2019 5 1 2019 2019w1 2019m1 Saturday |
   |-----------------------------------------------------------------------------|
348. | 348 783 06jan2019 6 1 2019 2019w1 2019m1 Sunday |
349. | 349 570 07jan2019 7 1 2019 2019w1 2019m1 Monday |
350. | 350 782 08jan2019 8 1 2019 2019w2 2019m1 Tuesday |
351. | 351 1161 09jan2019 9 1 2019 2019w2 2019m1 Wednesday |
352. | 352 987 10jan2019 10 1 2019 2019w2 2019m1 Thursday |
   |-----------------------------------------------------------------------------|
353. | 353 878 11jan2019 11 1 2019 2019w2 2019m1 Friday |
354. | 354 711 12jan2019 12 1 2019 2019w2 2019m1 Saturday |
355. | 355 978 13jan2019 13 1 2019 2019w2 2019m1 Sunday |
356. | 356 1127 14jan2019 14 1 2019 2019w2 2019m1 Monday |
357. | 357 813 15jan2019 15 1 2019 2019w3 2019m1 Tuesday |
   |-----------------------------------------------------------------------------|
358. | 358 880 16jan2019 16 1 2019 2019w3 2019m1 Wednesday |
359. | 359 1018 17jan2019 17 1 2019 2019w3 2019m1 Thursday |
360. | 360 611 18jan2019 18 1 2019 2019w3 2019m1 Friday |
361. | 361 643 19jan2019 19 1 2019 2019w3 2019m1 Saturday |
362. | 362 658 20jan2019 20 1 2019 2019w3 2019m1 Sunday |
   |-----------------------------------------------------------------------------|
363. | 363 683 21jan2019 21 1 2019 2019w3 2019m1 Monday |
364. | 364 618 22jan2019 22 1 2019 2019w4 2019m1 Tuesday |
365. | 365 735 23jan2019 23 1 2019 2019w4 2019m1 Wednesday |
366. | 366 715 24jan2019 24 1 2019 2019w4 2019m1 Thursday |
367. | 367 615 25jan2019 25 1 2019 2019w4 2019m1 Friday |
   |-----------------------------------------------------------------------------|
368. | 368 587 26jan2019 26 1 2019 2019w4 2019m1 Saturday |
369. | 369 655 27jan2019 27 1 2019 2019w4 2019m1 Sunday |
370. | 370 734 28jan2019 28 1 2019 2019w4 2019m1 Monday |
371. | 371 612 29jan2019 29 1 2019 2019w5 2019m1 Tuesday |
372. | 372 510 30jan2019 30 1 2019 2019w5 2019m1 Wednesday |
   +-----------------------------------------------------------------------------+

For days in 2018, please check previous post.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Update:

Per day

Code:

Day 1: 13018 Merit
Day 2: 6761 Merit
Day 3: 4493 Merit
Day 4: 3489 Merit
Day 5: 3188 Merit
Day 6: 3799 Merit
Day 7: 4192 Merit
Day 8: 2820 Merit
Day 9: 2545 Merit
Day 10: 2568 Merit
Day 11: 1867 Merit
Day 12: 2167 Merit
Day 13: 2077 Merit
Day 14: 2308 Merit
Day 15: 2141 Merit
Day 16: 2141 Merit
Day 17: 1448 Merit
Day 18: 1747 Merit
Day 19: 1442 Merit
Day 20: 1331 Merit
Day 21: 1579 Merit
Day 22: 2513 Merit
Day 23: 1991 Merit
Day 24: 1411 Merit
Day 25: 1608 Merit
Day 26: 1289 Merit
Day 27: 1403 Merit
Day 28: 1169 Merit
Day 29: 1266 Merit
Day 30: 1279 Merit
Day 31: 1046 Merit
Day 32: 1409 Merit
Day 33: 1186 Merit
Day 34: 1382 Merit
Day 35: 1326 Merit
Day 36: 991 Merit
Day 37: 1333 Merit
Day 38: 1696 Merit
Day 39: 1089 Merit
Day 40: 989 Merit
Day 41: 1245 Merit
Day 42: 1074 Merit
Day 43: 1109 Merit
Day 44: 922 Merit
Day 45: 789 Merit
Day 46: 1023 Merit
Day 47: 1091 Merit
Day 48: 1354 Merit
Day 49: 994 Merit
Day 50: 1159 Merit
Day 51: 1130 Merit
Day 52: 840 Merit
Day 53: 797 Merit
Day 54: 1035 Merit
Day 55: 992 Merit
Day 56: 1322 Merit
Day 57: 1227 Merit
Day 58: 764 Merit
Day 59: 733 Merit
Day 60: 1045 Merit
Day 61: 858 Merit
Day 62: 808 Merit
Day 63: 879 Merit
Day 64: 848 Merit
Day 65: 1043 Merit
Day 66: 928 Merit
Day 67: 968 Merit
Day 68: 1233 Merit
Day 69: 1146 Merit
Day 70: 1080 Merit
Day 71: 1061 Merit
Day 72: 838 Merit
Day 73: 620 Merit
Day 74: 614 Merit
Day 75: 1056 Merit
Day 76: 884 Merit
Day 77: 768 Merit
Day 78: 963 Merit
Day 79: 917 Merit
Day 80: 682 Merit
Day 81: 681 Merit
Day 82: 592 Merit
Day 83: 609 Merit
Day 84: 628 Merit
Day 85: 681 Merit
Day 86: 848 Merit
Day 87: 563 Merit
Day 88: 522 Merit
Day 89: 880 Merit
Day 90: 709 Merit
Day 91: 626 Merit
Day 92: 687 Merit
Day 93: 675 Merit
Day 94: 583 Merit
Day 95: 623 Merit
Day 96: 682 Merit
Day 97: 822 Merit
Day 98: 741 Merit
Day 99: 759 Merit
Day 100: 747 Merit
Day 101: 597 Merit
Day 102: 688 Merit
Day 103: 599 Merit
Day 104: 898 Merit
Day 105: 618 Merit
Day 106: 761 Merit
Day 107: 475 Merit
Day 108: 867 Merit
Day 109: 415 Merit
Day 110: 719 Merit
Day 111: 674 Merit
Day 112: 700 Merit
Day 113: 652 Merit
Day 114: 574 Merit
Day 115: 542 Merit
Day 116: 587 Merit
Day 117: 617 Merit
Day 118: 626 Merit
Day 119: 639 Merit
Day 120: 531 Merit
Day 121: 554 Merit
Day 122: 370 Merit
Day 123: 575 Merit
Day 124: 559 Merit
Day 125: 589 Merit
Day 126: 638 Merit
Day 127: 599 Merit
Day 128: 687 Merit
Day 129: 698 Merit
Day 130: 461 Merit
Day 131: 511 Merit
Day 132: 773 Merit
Day 133: 731 Merit
Day 134: 504 Merit
Day 135: 506 Merit
Day 136: 766 Merit
Day 137: 672 Merit
Day 138: 575 Merit
Day 139: 519 Merit
Day 140: 422 Merit
Day 141: 786 Merit
Day 142: 528 Merit
Day 143: 445 Merit
Day 144: 654 Merit
Day 145: 464 Merit
Day 146: 601 Merit
Day 147: 662 Merit
Day 148: 707 Merit
Day 149: 705 Merit
Day 150: 774 Merit
Day 151: 643 Merit
Day 152: 829 Merit
Day 153: 1138 Merit
Day 154: 435 Merit
Day 155: 516 Merit
Day 156: 470 Merit
Day 157: 479 Merit
Day 158: 778 Merit
Day 159: 641 Merit
Day 160: 711 Merit
Day 161: 902 Merit
Day 162: 557 Merit
Day 163: 577 Merit
Day 164: 475 Merit
Day 165: 506 Merit
Day 166: 525 Merit
Day 167: 455 Merit
Day 168: 620 Merit
Day 169: 555 Merit
Day 170: 644 Merit
Day 171: 542 Merit
Day 172: 627 Merit
Day 173: 796 Merit
Day 174: 636 Merit
Day 175: 641 Merit
Day 176: 608 Merit
Day 177: 554 Merit
Day 178: 606 Merit
Day 179: 567 Merit
Day 180: 547 Merit
Day 181: 684 Merit
Day 182: 444 Merit
Day 183: 492 Merit
Day 184: 673 Merit
Day 185: 521 Merit
Day 186: 418 Merit
Day 187: 420 Merit
Day 188: 471 Merit
Day 189: 632 Merit
Day 190: 435 Merit
Day 191: 376 Merit
Day 192: 421 Merit
Day 193: 695 Merit
Day 194: 768 Merit
Day 195: 595 Merit
Day 196: 610 Merit
Day 197: 647 Merit
Day 198: 471 Merit
Day 199: 567 Merit
Day 200: 517 Merit
Day 201: 587 Merit
Day 202: 513 Merit
Day 203: 565 Merit
Day 204: 626 Merit
Day 205: 470 Merit
Day 206: 451 Merit
Day 207: 561 Merit
Day 208: 432 Merit
Day 209: 658 Merit
Day 210: 600 Merit
Day 211: 612 Merit
Day 212: 530 Merit
Day 213: 528 Merit
Day 214: 385 Merit
Day 215: 476 Merit
Day 216: 457 Merit
Day 217: 383 Merit
Day 218: 488 Merit
Day 219: 514 Merit
Day 220: 379 Merit
Day 221: 432 Merit
Day 222: 412 Merit
Day 223: 536 Merit
Day 224: 567 Merit
Day 225: 654 Merit
Day 226: 509 Merit
Day 227: 458 Merit
Day 228: 395 Merit
Day 229: 455 Merit
Day 230: 472 Merit
Day 231: 580 Merit
Day 232: 595 Merit
Day 233: 540 Merit
Day 234: 517 Merit
Day 235: 463 Merit
Day 236: 2463 Merit
Day 237: 1862 Merit
Day 238: 1294 Merit
Day 239: 1268 Merit
Day 240: 846 Merit
Day 241: 807 Merit
Day 242: 944 Merit
Day 243: 804 Merit
Day 244: 749 Merit
Day 245: 596 Merit
Day 246: 562 Merit
Day 247: 675 Merit
Day 248: 518 Merit
Day 249: 669 Merit
Day 250: 619 Merit
Day 251: 509 Merit
Day 252: 760 Merit
Day 253: 705 Merit
Day 254: 521 Merit
Day 255: 513 Merit
Day 256: 660 Merit
Day 257: 603 Merit
Day 258: 678 Merit
Day 259: 578 Merit
Day 260: 639 Merit
Day 261: 616 Merit
Day 262: 399 Merit
Day 263: 460 Merit
Day 264: 430 Merit
Day 265: 655 Merit
Day 266: 626 Merit
Day 267: 732 Merit
Day 268: 774 Merit
Day 269: 643 Merit
Day 270: 538 Merit
Day 271: 853 Merit
Day 272: 694 Merit
Day 273: 674 Merit
Day 274: 759 Merit
Day 275: 553 Merit
Day 276: 424 Merit
Day 277: 426 Merit
Day 278: 415 Merit
Day 279: 534 Merit
Day 280: 529 Merit
Day 281: 495 Merit
Day 282: 433 Merit
Day 283: 454 Merit
Day 284: 430 Merit
Day 285: 464 Merit
Day 286: 562 Merit
Day 287: 405 Merit
Day 288: 691 Merit
Day 289: 843 Merit
Day 290: 536 Merit
Day 291: 688 Merit
Day 292: 788 Merit
Day 293: 591 Merit
Day 294: 580 Merit
Day 295: 569 Merit
Day 296: 650 Merit
Day 297: 499 Merit
Day 298: 347 Merit
Day 299: 486 Merit
Day 300: 898 Merit
Day 301: 767 Merit
Day 302: 608 Merit
Day 303: 759 Merit
Day 304: 348 Merit
Day 305: 716 Merit
Day 306: 462 Merit
Day 307: 531 Merit
Day 308: 510 Merit
Day 309: 558 Merit
Day 310: 643 Merit
Day 311: 554 Merit
Day 312: 530 Merit
Day 313: 424 Merit
Day 314: 501 Merit
Day 315: 563 Merit
Day 316: 665 Merit
Day 317: 479 Merit
Day 318: 487 Merit
Day 319: 468 Merit
Day 320: 397 Merit
Day 321: 641 Merit
Day 322: 596 Merit
Day 323: 618 Merit
Day 324: 458 Merit
Day 325: 571 Merit
Day 326: 377 Merit
Day 327: 521 Merit
Day 328: 713 Merit
Day 329: 402 Merit
Day 330: 494 Merit
Day 331: 636 Merit
Day 332: 496 Merit
Day 333: 316 Merit
Day 334: 696 Merit
Day 335: 312 Merit
Day 336: 478 Merit
Day 337: 665 Merit
Day 338: 347 Merit
Day 339: 386 Merit
Day 340: 325 Merit
Day 341: 389 Merit
Day 342: 376 Merit
Day 343: 603 Merit
Day 344: 526 Merit
Day 345: 394 Merit
Day 346: 1082 Merit
Day 347: 835 Merit
Day 348: 783 Merit
Day 349: 570 Merit
Day 350: 782 Merit
Day 351: 1161 Merit
Day 352: 987 Merit
Day 353: 878 Merit
Day 354: 711 Merit
Day 355: 978 Merit
Day 356: 1127 Merit
Day 357: 813 Merit
Day 358: 880 Merit
Day 359: 1018 Merit
Day 360: 611 Merit
Day 361: 643 Merit
Day 362: 658 Merit
Day 363: 683 Merit
Day 364: 618 Merit
Day 365: 735 Merit
Day 366: 715 Merit
Day 367: 615 Merit
Day 368: 587 Merit
Day 369: 655 Merit
Day 370: 734 Merit
Day 371: 612 Merit
Day 372: 510 Merit
Day 373: 59 Merit (incomplete day)

Per week

Code:

Week 1: 38953 Merit
Week 2: 16373 Merit
Week 3: 11836 Merit
Week 4: 11406 Merit
Week 5: 8910 Merit
Week 6: 8434 Merit
Week 7: 7288 Merit
Week 8: 7283 Merit
Week 9: 6324 Merit
Week 10: 7276 Merit
Week 11: 5848 Merit
Week 12: 5082 Merit
Week 13: 4855 Merit
Week 14: 4821 Merit
Week 15: 4919 Merit
Week 16: 4619 Merit
Week 17: 4243 Merit
Week 18: 3825 Merit
Week 19: 4466 Merit
Week 20: 3978 Merit
Week 21: 4156 Merit
Week 22: 5237 Merit
Week 23: 4511 Merit
Week 24: 3733 Merit
Week 25: 4447 Merit
Week 26: 4018 Merit
Week 27: 3682 Merit
Week 28: 3918 Merit
Week 29: 3883 Merit
Week 30: 3811 Merit
Week 31: 3377 Merit
Week 32: 3336 Merit
Week 33: 3536 Merit
Week 34: 7743 Merit
Week 35: 6023 Merit
Week 36: 4318 Merit
Week 37: 4305 Merit
Week 38: 3831 Merit
Week 39: 4916 Merit
Week 40: 3646 Merit
Week 41: 3249 Merit
Week 42: 4728 Merit
Week 43: 4249 Merit
Week 44: 3945 Merit
Week 45: 3783 Merit
Week 46: 3755 Merit
Week 47: 3668 Merit
Week 48: 3472 Merit
Week 49: 3119 Merit
Week 50: 4978 Merit
Week 51: 6666 Merit
Week 52: 5117 Merit
Week 53: 4659 Merit
Week 54: 570 Merit (incomplete week)

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Update:
Intra-week merits:

I> Full dataset
Time series plot

Code:

. 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 |
   +-----------------+

Basic statistics:

Code:

. tabstat merit, s(n mean sd p50 p25 p75 min max)

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 52 5893 4573.549 4485 3799 6022.5 3065 30949
----------------------------------------------------------------------------------------------

Let's identify potential outliers:
IQR = Q3 - Q1 = 6022.5 - 3799 = 2223.5
1.5*IQR = 1.5*223.5 = 3335.25

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
Detail calculations below:

Code:

. di 6022.5-3799
2223.5

. di 2223.5*1.5
3335.25

. di 6022.5+3335.25
9357.75

. di 3799-3335.25
463.75

Now, let's count how many weeks are outliers:

Code:

. 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 dataset
Now, I truncated all these four weeks in order to have a truncated dataset, and start identifying potential outliers for the truncated dataset
Basic statistics:

Code:

. tabstat merit, s(n mean sd p50 p25 p75 min max)

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 48 4802.146 1422.756 4367 3793.5 5129.5 3065 8806
----------------------------------------------------------------------------------------------

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.

Detail calculations:

Code:

. di 5129.5-3793.5
1336

. di 1336*1.5
2004

. di 5129.5+2004
7133.5

. di 3793.5-2004
1789.5

Let's see how many outliers identified:

Code:

. 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:

Code:

. 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.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

There you go, I made it today, Lauda
Tracking the difference of merit circulations with Default Trust Changes

Quote from: Lauda on January 18, 2019, 02:53:25 AM

Could you make a weekly breakdown of the next 2-3 weeks (and compare them to average weekly data)

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

TRUST SYSTEM CHANGE'S IMPACTS ON INTRADAY MERITS

ABSTRACT

(1) Mean and median of the after period (from 09/01/2019 to 21/01/2019 - after the Trust System change) are higher than the figures of before period (from 19/02/2018 to 08/01/2019) at 26.7% and 42.3%, respectively.
(2) There is no potential outliers occured recent days (in the after period) due to effects of Trust System change.
It it very difference from the demotion of Junior Members in September 2018, when outliers occured due to massive absusements. It is just an assumption, but it is likely that the Trust System change has not led to merit abusements (at least till now).

1) Statistics:
It's easily to see that both mean and median of the period after 09/01/2019 are higher than figures of the period before 09/01/2019.
1.1. Before:
- Mean: 677;
- Median: 617.
1.2. After:
- Mean: 858.
- Median: 878

It means that the mean and median of the after period are higher than the before period at 26.7% and 42.3%, respectively.
As always, I would like to look at the median difference between them (42.3%).

Code:

. di (858-677)*100/677
26.735598

. di (878-617)*100/617
42.301459

Details presented below:
- whole: for whole period, from 19/02/2018 to 21/01/2019.

Code:

. tabstat whole before090119 after090119, s(n mean sd p50 p25 p75 min max) format(%9.1f) c(s)

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
whole | 337.0 684.0 262.6 620.0 514.0 774.0 312.0 2463.0
before090119 | 324.0 677.0 263.0 616.5 510.5 766.5 312.0 2463.0
after090119 | 13.0 857.5 187.8 878.0 683.0 987.0 611.0 1161.0
----------------------------------------------------------------------------------------------

2) Box plots:
Outliers displayed

Outliers non-displayed (in order to have clearer view on difference between medians of before and after periods.

Notes for box plots:
- Red circles: potential outliers.
- Medians: horizontal lines inside boxes.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Update:

ABSTRACT
Notes:
- The asbstract describes figures of intraday merits over the period from 19/2/2018 to 21/01/2019 (truncated dataset);
- Days from 24/1/2018 to 18/2/2018 truncated due to highly potential outliers; and days after 21/01/2019 truncated as well due to incomplete week (the fourth week of 2019 -2019w4);
- Statistics presented in the post are for truncated dataset.

(1) Potential outliers are days that have intraday total merits beyond 124 or 1164;
(2) Median of intraday merits over the period is 620, whilst the interquartile range is from 514 to 774;
(3) Friday is the day over weeks has lowest intraday merits in terms of both median and mean, at 617 and 542, respectively.
In contrast, Monday is the day over weeks has highest intraday merits in terms of both median and mean, at 746 and 658, respectively.

1) Time series plot
I used full dataset (only dropped the first two days due to extremely high merits distributed during those days), since 24/1/2018 to 23/1/2019 to draw the below plot

First two days dropped from the plot

2) Basic statistics
- Mean +/- sd: 684 +/-263
- Median (interquartile range): 620 (514 – 774)
- Min - max: 312 - 2463

Let's compared with statistics for the previous report.

From the full dataset, we can easily identify potential outliers via the following formula:
IQR = Q3 – Q1 = 846 – 521 = 325;
1.5*IQR = 1.5*325 = 487.5
Potential outliers:
- Above Q3 +1.5*IQR = 846 + 487.5 = 1333.5;
- Below Q1 – 1.5*IQR = 521 – 487.5 = 33.5
Let's see how many days that have total intraday merits beyond 34 or 1334?

Code:

. count if merit > 1334 | merit < 34 & merit != .
31

In total, 31 days are extremely potential outliers, and none of them occured recent weeks (only days before 18/9/2018).

Code:

. list id date week month merit if merit > 1334 | merit < 34 & merit != .

   +--------------------------------------------+
   | id date week month merit |
   |--------------------------------------------|
  1. | 1 24jan2018 2018w4 2018m1 13018 |
  2. | 2 25jan2018 2018w4 2018m1 6761 |
  3. | 3 26jan2018 2018w4 2018m1 4493 |
  4. | 4 27jan2018 2018w4 2018m1 3489 |
  5. | 5 28jan2018 2018w4 2018m1 3188 |
   |--------------------------------------------|
  6. | 6 29jan2018 2018w5 2018m1 3799 |
  7. | 7 30jan2018 2018w5 2018m1 4192 |
  8. | 8 31jan2018 2018w5 2018m1 2820 |
  9. | 9 01feb2018 2018w5 2018m2 2545 |
10. | 10 02feb2018 2018w5 2018m2 2568 |
   |--------------------------------------------|
11. | 11 03feb2018 2018w5 2018m2 1867 |
12. | 12 04feb2018 2018w5 2018m2 2167 |
13. | 13 05feb2018 2018w6 2018m2 2077 |
14. | 14 06feb2018 2018w6 2018m2 2308 |
15. | 15 07feb2018 2018w6 2018m2 2141 |
   |--------------------------------------------|
16. | 16 08feb2018 2018w6 2018m2 2141 |
17. | 17 09feb2018 2018w6 2018m2 1448 |
18. | 18 10feb2018 2018w6 2018m2 1747 |
19. | 19 11feb2018 2018w6 2018m2 1442 |
21. | 21 13feb2018 2018w7 2018m2 1579 |
   |--------------------------------------------|
22. | 22 14feb2018 2018w7 2018m2 2513 |
23. | 23 15feb2018 2018w7 2018m2 1991 |
24. | 24 16feb2018 2018w7 2018m2 1411 |
25. | 25 17feb2018 2018w7 2018m2 1608 |
27. | 27 19feb2018 2018w8 2018m2 1403 |
   |--------------------------------------------|
32. | 32 24feb2018 2018w8 2018m2 1409 |
34. | 34 26feb2018 2018w9 2018m2 1382 |
38. | 38 02mar2018 2018w9 2018m3 1696 |
48. | 48 12mar2018 2018w11 2018m3 1354 |
236. | 236 16sep2018 2018w37 2018m9 2463 |
   |--------------------------------------------|
237. | 237 17sep2018 2018w38 2018m9 1862 |
   +--------------------------------------------+

Let's identify potential outliers of the truncated dataset (from 19/2/2018 to 21/1/2019):
IQR = Q3 – Q1 = 774 – 514 = 260;
1.5*IQR = 1.5*260 = 390
Potential outliers:
- Above Q3 +1.5*IQR = 774 + 390 = 1164;
- Below Q1 – 1.5*IQR = 514 – 390 = 124.
Potential outliers are days that have intraday merits beyond 124 or 1164.
Let's see how many days that have total intraday merits beyond 124 or 1164 ?

Code:

. count if (merit >= 1164 | merit <= 124) & merit != . & id >26
19

19 outliers in total, and there is no potential outlier day happened in early weeks of 2019.

Code:

. list id merit date if merit >= 1164 | merit <= 124

   +-------------------------+
   | 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 |
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 |
   +-------------------------+

2) The 50 lowest day in terms of daily merits

Code:

. 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 338 27dec2018 Thursday 27 12 2018 2018w52 2018m12 |
  5. | 347 298 17nov2018 Saturday 17 11 2018 2018w46 2018m11 |
   |-------------------------------------------------------------------------------|
  6. | 348 304 23nov2018 Friday 23 11 2018 2018w47 2018m11 |
  7. | 370 122 25may2018 Friday 25 5 2018 2018w21 2018m5 |
  8. | 376 342 31dec2018 Monday 31 12 2018 2018w52 2018m12 |
  9. | 376 191 02aug2018 Thursday 2 8 2018 2018w31 2018m8 |
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 278 28oct2018 Sunday 28 10 2018 2018w43 2018m10 |
24. | 415 109 12may2018 Saturday 12 5 2018 2018w19 2018m5 |
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 276 26oct2018 Friday 26 10 2018 2018w43 2018m10 |
30. | 424 313 02dec2018 Sunday 2 12 2018 2018w48 2018m12 |
   |-------------------------------------------------------------------------------|
31. | 426 277 27oct2018 Saturday 27 10 2018 2018w43 2018m10 |
32. | 430 284 03nov2018 Saturday 3 11 2018 2018w44 2018m11 |
33. | 430 264 14oct2018 Sunday 14 10 2018 2018w41 2018m10 |
34. | 432 208 19aug2018 Sunday 19 8 2018 2018w33 2018m8 |
35. | 432 221 01sep2018 Saturday 1 9 2018 2018w35 2018m9 |
   |-------------------------------------------------------------------------------|
36. | 433 282 01nov2018 Thursday 1 11 2018 2018w44 2018m11 |
37. | 435 190 01aug2018 Wednesday 1 8 2018 2018w31 2018m8 |
38. | 435 154 26jun2018 Tuesday 26 6 2018 2018w26 2018m6 |
39. | 444 182 24jul2018 Tuesday 24 7 2018 2018w30 2018m7 |
40. | 445 143 15jun2018 Friday 15 6 2018 2018w24 2018m6 |
   |-------------------------------------------------------------------------------|
41. | 451 206 17aug2018 Friday 17 8 2018 2018w33 2018m8 |
42. | 454 283 02nov2018 Friday 2 11 2018 2018w44 2018m11 |
43. | 455 229 09sep2018 Sunday 9 9 2018 2018w36 2018m9 |
44. | 455 167 09jul2018 Monday 9 7 2018 2018w28 2018m7 |
45. | 457 216 27aug2018 Monday 27 8 2018 2018w35 2018m8 |
   |-------------------------------------------------------------------------------|
46. | 458 227 07sep2018 Friday 7 9 2018 2018w36 2018m9 |
47. | 458 324 13dec2018 Thursday 13 12 2018 2018w50 2018m12 |
48. | 460 263 13oct2018 Saturday 13 10 2018 2018w41 2018m10 |
49. | 461 130 02jun2018 Saturday 2 6 2018 2018w22 2018m6 |
50. | 462 306 25nov2018 Sunday 25 11 2018 2018w47 2018m11 |

3) The 50 highest day in terms of daily merits

Code:

. 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 542, 601 and 610 respectively.
- In means of intraday merits, and GMT time, lowest days are Friday, Saturday, and Thursday at 617, 623, and 677.
- The highest day in terms of means and medians are both Monday, at 746 and 658, respectively. In contrast,the lowest day in terms of means and medians are both Friday, at 617 and 542, respectively.
More details in the raw results below.

Code:

. 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 | 48.0 703.5 342.5 610.0 470.0 816.5 389.0 2463.0
   Monday | 49.0 745.8 307.9 658.0 536.0 822.0 312.0 1862.0
  Tuesday | 48.0 699.0 236.5 627.0 572.5 767.5 383.0 1326.0
Wednesday | 48.0 722.3 225.5 653.0 560.0 773.5 435.0 1268.0
Thursday | 48.0 676.8 228.0 639.5 511.5 806.0 347.0 1333.0
   Friday | 48.0 616.4 237.0 542.0 469.0 715.5 348.0 1696.0
Saturday | 48.0 622.8 222.4 600.5 460.5 691.5 316.0 1409.0
----------+--------------------------------------------------------------------------------
   Total | 337.0 684.0 262.6 620.0 514.0 774.0 312.0 2463.0
-------------------------------------------------------------------------------------------

Plots:
- Outliers displayed with red circles.

- Outliers non-displayed.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Converted dataset for intraday merits in 2019 (for first part of the full dataset in the year 2018, please check previous posts).

Code:

. list id merit date day month2 year week month dofw if year == 2019

+-----------------------------------------------------------------------------+
| id merit date day month2 year week month dofw |
|-----------------------------------------------------------------------------|
343. | 343 603 01jan2019 1 1 2019 2019w1 2019m1 Tuesday |
344. | 344 526 02jan2019 2 1 2019 2019w1 2019m1 Wednesday |
345. | 345 394 03jan2019 3 1 2019 2019w1 2019m1 Thursday |
346. | 346 1082 04jan2019 4 1 2019 2019w1 2019m1 Friday |
347. | 347 835 05jan2019 5 1 2019 2019w1 2019m1 Saturday |
|-----------------------------------------------------------------------------|
348. | 348 783 06jan2019 6 1 2019 2019w1 2019m1 Sunday |
349. | 349 570 07jan2019 7 1 2019 2019w1 2019m1 Monday |
350. | 350 782 08jan2019 8 1 2019 2019w2 2019m1 Tuesday |
351. | 351 1161 09jan2019 9 1 2019 2019w2 2019m1 Wednesday |
352. | 352 987 10jan2019 10 1 2019 2019w2 2019m1 Thursday |
|-----------------------------------------------------------------------------|
353. | 353 878 11jan2019 11 1 2019 2019w2 2019m1 Friday |
354. | 354 711 12jan2019 12 1 2019 2019w2 2019m1 Saturday |
355. | 355 978 13jan2019 13 1 2019 2019w2 2019m1 Sunday |
356. | 356 1127 14jan2019 14 1 2019 2019w2 2019m1 Monday |
357. | 357 813 15jan2019 15 1 2019 2019w3 2019m1 Tuesday |
|-----------------------------------------------------------------------------|
358. | 358 880 16jan2019 16 1 2019 2019w3 2019m1 Wednesday |
359. | 359 1018 17jan2019 17 1 2019 2019w3 2019m1 Thursday |
360. | 360 611 18jan2019 18 1 2019 2019w3 2019m1 Friday |
361. | 361 643 19jan2019 19 1 2019 2019w3 2019m1 Saturday |
362. | 362 658 20jan2019 20 1 2019 2019w3 2019m1 Sunday |
|-----------------------------------------------------------------------------|
363. | 363 683 21jan2019 21 1 2019 2019w3 2019m1 Monday |
364. | 364 618 22jan2019 22 1 2019 2019w4 2019m1 Tuesday |
365. | 365 735 23jan2019 23 1 2019 2019w4 2019m1 Wednesday |
+-----------------------------------------------------------------------------+

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Update:
Per day

Code:

Day 1: 13018 Merit
Day 2: 6761 Merit
Day 3: 4493 Merit
Day 4: 3489 Merit
Day 5: 3188 Merit
Day 6: 3799 Merit
Day 7: 4192 Merit
Day 8: 2820 Merit
Day 9: 2545 Merit
Day 10: 2568 Merit
Day 11: 1867 Merit
Day 12: 2167 Merit
Day 13: 2077 Merit
Day 14: 2308 Merit
Day 15: 2141 Merit
Day 16: 2141 Merit
Day 17: 1448 Merit
Day 18: 1747 Merit
Day 19: 1442 Merit
Day 20: 1331 Merit
Day 21: 1579 Merit
Day 22: 2513 Merit
Day 23: 1991 Merit
Day 24: 1411 Merit
Day 25: 1608 Merit
Day 26: 1289 Merit
Day 27: 1403 Merit
Day 28: 1169 Merit
Day 29: 1266 Merit
Day 30: 1279 Merit
Day 31: 1046 Merit
Day 32: 1409 Merit
Day 33: 1186 Merit
Day 34: 1382 Merit
Day 35: 1326 Merit
Day 36: 991 Merit
Day 37: 1333 Merit
Day 38: 1696 Merit
Day 39: 1089 Merit
Day 40: 989 Merit
Day 41: 1245 Merit
Day 42: 1074 Merit
Day 43: 1109 Merit
Day 44: 922 Merit
Day 45: 789 Merit
Day 46: 1023 Merit
Day 47: 1091 Merit
Day 48: 1354 Merit
Day 49: 994 Merit
Day 50: 1159 Merit
Day 51: 1130 Merit
Day 52: 840 Merit
Day 53: 797 Merit
Day 54: 1035 Merit
Day 55: 992 Merit
Day 56: 1322 Merit
Day 57: 1227 Merit
Day 58: 764 Merit
Day 59: 733 Merit
Day 60: 1045 Merit
Day 61: 858 Merit
Day 62: 808 Merit
Day 63: 879 Merit
Day 64: 848 Merit
Day 65: 1043 Merit
Day 66: 928 Merit
Day 67: 968 Merit
Day 68: 1233 Merit
Day 69: 1146 Merit
Day 70: 1080 Merit
Day 71: 1061 Merit
Day 72: 838 Merit
Day 73: 620 Merit
Day 74: 614 Merit
Day 75: 1056 Merit
Day 76: 884 Merit
Day 77: 768 Merit
Day 78: 963 Merit
Day 79: 917 Merit
Day 80: 682 Merit
Day 81: 681 Merit
Day 82: 592 Merit
Day 83: 609 Merit
Day 84: 628 Merit
Day 85: 681 Merit
Day 86: 848 Merit
Day 87: 563 Merit
Day 88: 522 Merit
Day 89: 880 Merit
Day 90: 709 Merit
Day 91: 626 Merit
Day 92: 687 Merit
Day 93: 675 Merit
Day 94: 583 Merit
Day 95: 623 Merit
Day 96: 682 Merit
Day 97: 822 Merit
Day 98: 741 Merit
Day 99: 759 Merit
Day 100: 747 Merit
Day 101: 597 Merit
Day 102: 688 Merit
Day 103: 599 Merit
Day 104: 898 Merit
Day 105: 618 Merit
Day 106: 761 Merit
Day 107: 475 Merit
Day 108: 867 Merit
Day 109: 415 Merit
Day 110: 719 Merit
Day 111: 674 Merit
Day 112: 700 Merit
Day 113: 652 Merit
Day 114: 574 Merit
Day 115: 542 Merit
Day 116: 587 Merit
Day 117: 617 Merit
Day 118: 626 Merit
Day 119: 639 Merit
Day 120: 531 Merit
Day 121: 554 Merit
Day 122: 370 Merit
Day 123: 575 Merit
Day 124: 559 Merit
Day 125: 589 Merit
Day 126: 638 Merit
Day 127: 599 Merit
Day 128: 687 Merit
Day 129: 698 Merit
Day 130: 461 Merit
Day 131: 511 Merit
Day 132: 773 Merit
Day 133: 731 Merit
Day 134: 504 Merit
Day 135: 506 Merit
Day 136: 766 Merit
Day 137: 672 Merit
Day 138: 575 Merit
Day 139: 519 Merit
Day 140: 422 Merit
Day 141: 786 Merit
Day 142: 528 Merit
Day 143: 445 Merit
Day 144: 654 Merit
Day 145: 464 Merit
Day 146: 601 Merit
Day 147: 662 Merit
Day 148: 707 Merit
Day 149: 705 Merit
Day 150: 774 Merit
Day 151: 643 Merit
Day 152: 829 Merit
Day 153: 1138 Merit
Day 154: 435 Merit
Day 155: 516 Merit
Day 156: 470 Merit
Day 157: 479 Merit
Day 158: 778 Merit
Day 159: 641 Merit
Day 160: 711 Merit
Day 161: 902 Merit
Day 162: 557 Merit
Day 163: 577 Merit
Day 164: 475 Merit
Day 165: 506 Merit
Day 166: 525 Merit
Day 167: 455 Merit
Day 168: 620 Merit
Day 169: 555 Merit
Day 170: 644 Merit
Day 171: 542 Merit
Day 172: 627 Merit
Day 173: 796 Merit
Day 174: 636 Merit
Day 175: 641 Merit
Day 176: 608 Merit
Day 177: 554 Merit
Day 178: 606 Merit
Day 179: 567 Merit
Day 180: 547 Merit
Day 181: 684 Merit
Day 182: 444 Merit
Day 183: 492 Merit
Day 184: 673 Merit
Day 185: 521 Merit
Day 186: 418 Merit
Day 187: 420 Merit
Day 188: 471 Merit
Day 189: 632 Merit
Day 190: 435 Merit
Day 191: 376 Merit
Day 192: 421 Merit
Day 193: 695 Merit
Day 194: 768 Merit
Day 195: 595 Merit
Day 196: 610 Merit
Day 197: 647 Merit
Day 198: 471 Merit
Day 199: 567 Merit
Day 200: 517 Merit
Day 201: 587 Merit
Day 202: 513 Merit
Day 203: 565 Merit
Day 204: 626 Merit
Day 205: 470 Merit
Day 206: 451 Merit
Day 207: 561 Merit
Day 208: 432 Merit
Day 209: 658 Merit
Day 210: 600 Merit
Day 211: 612 Merit
Day 212: 530 Merit
Day 213: 528 Merit
Day 214: 385 Merit
Day 215: 476 Merit
Day 216: 457 Merit
Day 217: 383 Merit
Day 218: 488 Merit
Day 219: 514 Merit
Day 220: 379 Merit
Day 221: 432 Merit
Day 222: 412 Merit
Day 223: 536 Merit
Day 224: 567 Merit
Day 225: 654 Merit
Day 226: 509 Merit
Day 227: 458 Merit
Day 228: 395 Merit
Day 229: 455 Merit
Day 230: 472 Merit
Day 231: 580 Merit
Day 232: 595 Merit
Day 233: 540 Merit
Day 234: 517 Merit
Day 235: 463 Merit
Day 236: 2463 Merit
Day 237: 1862 Merit
Day 238: 1294 Merit
Day 239: 1268 Merit
Day 240: 846 Merit
Day 241: 807 Merit
Day 242: 944 Merit
Day 243: 804 Merit
Day 244: 749 Merit
Day 245: 596 Merit
Day 246: 562 Merit
Day 247: 675 Merit
Day 248: 518 Merit
Day 249: 669 Merit
Day 250: 619 Merit
Day 251: 509 Merit
Day 252: 760 Merit
Day 253: 705 Merit
Day 254: 521 Merit
Day 255: 513 Merit
Day 256: 660 Merit
Day 257: 603 Merit
Day 258: 678 Merit
Day 259: 578 Merit
Day 260: 639 Merit
Day 261: 616 Merit
Day 262: 399 Merit
Day 263: 460 Merit
Day 264: 430 Merit
Day 265: 655 Merit
Day 266: 626 Merit
Day 267: 732 Merit
Day 268: 774 Merit
Day 269: 643 Merit
Day 270: 538 Merit
Day 271: 853 Merit
Day 272: 694 Merit
Day 273: 674 Merit
Day 274: 759 Merit
Day 275: 553 Merit
Day 276: 424 Merit
Day 277: 426 Merit
Day 278: 415 Merit
Day 279: 534 Merit
Day 280: 529 Merit
Day 281: 495 Merit
Day 282: 433 Merit
Day 283: 454 Merit
Day 284: 430 Merit
Day 285: 464 Merit
Day 286: 562 Merit
Day 287: 405 Merit
Day 288: 691 Merit
Day 289: 843 Merit
Day 290: 536 Merit
Day 291: 688 Merit
Day 292: 788 Merit
Day 293: 591 Merit
Day 294: 580 Merit
Day 295: 569 Merit
Day 296: 650 Merit
Day 297: 499 Merit
Day 298: 347 Merit
Day 299: 486 Merit
Day 300: 898 Merit
Day 301: 767 Merit
Day 302: 608 Merit
Day 303: 759 Merit
Day 304: 348 Merit
Day 305: 716 Merit
Day 306: 462 Merit
Day 307: 531 Merit
Day 308: 510 Merit
Day 309: 558 Merit
Day 310: 643 Merit
Day 311: 554 Merit
Day 312: 530 Merit
Day 313: 424 Merit
Day 314: 501 Merit
Day 315: 563 Merit
Day 316: 665 Merit
Day 317: 479 Merit
Day 318: 487 Merit
Day 319: 468 Merit
Day 320: 397 Merit
Day 321: 641 Merit
Day 322: 596 Merit
Day 323: 618 Merit
Day 324: 458 Merit
Day 325: 571 Merit
Day 326: 377 Merit
Day 327: 521 Merit
Day 328: 713 Merit
Day 329: 402 Merit
Day 330: 494 Merit
Day 331: 636 Merit
Day 332: 496 Merit
Day 333: 316 Merit
Day 334: 696 Merit
Day 335: 312 Merit
Day 336: 478 Merit
Day 337: 665 Merit
Day 338: 347 Merit
Day 339: 386 Merit
Day 340: 325 Merit
Day 341: 389 Merit
Day 342: 376 Merit
Day 343: 603 Merit
Day 344: 526 Merit
Day 345: 394 Merit
Day 346: 1082 Merit
Day 347: 835 Merit
Day 348: 783 Merit
Day 349: 570 Merit
Day 350: 782 Merit
Day 351: 1161 Merit
Day 352: 987 Merit
Day 353: 878 Merit
Day 354: 711 Merit
Day 355: 978 Merit
Day 356: 1127 Merit
Day 357: 813 Merit
Day 358: 880 Merit
Day 359: 1018 Merit
Day 360: 611 Merit
Day 361: 643 Merit
Day 362: 658 Merit
Day 363: 683 Merit
Day 364: 618 Merit
Day 365: 735 Merit
Day 366: 123 Merit (incomplete day)

Per week

Code:

Week 1: 38953 Merit
Week 2: 16373 Merit
Week 3: 11836 Merit
Week 4: 11406 Merit
Week 5: 8910 Merit
Week 6: 8434 Merit
Week 7: 7288 Merit
Week 8: 7283 Merit
Week 9: 6324 Merit
Week 10: 7276 Merit
Week 11: 5848 Merit
Week 12: 5082 Merit
Week 13: 4855 Merit
Week 14: 4821 Merit
Week 15: 4919 Merit
Week 16: 4619 Merit
Week 17: 4243 Merit
Week 18: 3825 Merit
Week 19: 4466 Merit
Week 20: 3978 Merit
Week 21: 4156 Merit
Week 22: 5237 Merit
Week 23: 4511 Merit
Week 24: 3733 Merit
Week 25: 4447 Merit
Week 26: 4018 Merit
Week 27: 3682 Merit
Week 28: 3918 Merit
Week 29: 3883 Merit
Week 30: 3811 Merit
Week 31: 3377 Merit
Week 32: 3336 Merit
Week 33: 3536 Merit
Week 34: 7743 Merit
Week 35: 6023 Merit
Week 36: 4318 Merit
Week 37: 4305 Merit
Week 38: 3831 Merit
Week 39: 4916 Merit
Week 40: 3646 Merit
Week 41: 3249 Merit
Week 42: 4728 Merit
Week 43: 4249 Merit
Week 44: 3945 Merit
Week 45: 3783 Merit
Week 46: 3755 Merit
Week 47: 3668 Merit
Week 48: 3472 Merit
Week 49: 3119 Merit
Week 50: 4978 Merit
Week 51: 6666 Merit
Week 52: 5117 Merit
Week 53: 859 Merit (incomplete week)

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Intra-week merits converted dataset:

Code:

. list week merit

   +-----------------+
   | week merit |
   |-----------------|
  1. | 2018w4 30949 |
  2. | 2018w5 19958 |
  3. | 2018w6 13304 |
  4. | 2018w7 11722 |
  5. | 2018w8 8758 |
   |-----------------|
  6. | 2018w9 8806 |
  7. | 2018w10 7253 |
  8. | 2018w11 7309 |
  9. | 2018w12 6941 |
10. | 2018w13 6707 |
   |-----------------|
11. | 2018w14 6415 |
12. | 2018w15 5487 |
13. | 2018w16 4631 |
14. | 2018w17 4585 |
15. | 2018w18 4953 |
   |-----------------|
16. | 2018w19 4753 |
17. | 2018w20 4346 |
18. | 2018w21 3854 |
19. | 2018w22 4183 |
20. | 2018w23 4527 |
   |-----------------|
21. | 2018w24 3818 |
22. | 2018w25 4921 |
23. | 2018w26 4457 |
24. | 2018w27 4253 |
25. | 2018w28 4239 |
   |-----------------|
26. | 2018w29 4159 |
27. | 2018w30 3652 |
28. | 2018w31 3798 |
29. | 2018w32 3994 |
30. | 2018w33 3618 |
   |-----------------|
31. | 2018w34 3789 |
32. | 2018w35 3065 |
33. | 2018w36 3574 |
34. | 2018w37 5630 |
35. | 2018w38 7825 |
   |-----------------|
36. | 2018w39 4388 |
37. | 2018w40 4271 |
38. | 2018w41 3800 |
39. | 2018w42 4821 |
40. | 2018w43 3945 |
   |-----------------|
41. | 2018w44 3339 |
42. | 2018w45 4513 |
43. | 2018w46 3722 |
44. | 2018w47 4558 |
45. | 2018w48 3750 |
   |-----------------|
46. | 2018w49 3560 |
47. | 2018w50 3782 |
48. | 2018w51 3753 |
49. | 2018w52 3278 |
50. | 2019w1 4793 |
   |-----------------|
51. | 2019w2 6624 |
   +-----------------+

List of intra-week merits in descending order

Code:

. list week merit

   +-----------------+
   | week merit |
   |-----------------|
  1. | 2018w4 30949 |
  2. | 2018w5 19958 |
  3. | 2018w6 13304 |
  4. | 2018w7 11722 |
  5. | 2018w9 8806 |
   |-----------------|
  6. | 2018w8 8758 |
  7. | 2018w38 7825 |
  8. | 2018w11 7309 |
  9. | 2018w10 7253 |
10. | 2018w12 6941 |
   |-----------------|
11. | 2018w13 6707 |
12. | 2019w2 6624 |
13. | 2018w14 6415 |
14. | 2018w37 5630 |
15. | 2018w15 5487 |
   |-----------------|
16. | 2018w18 4953 |
17. | 2018w25 4921 |
18. | 2018w42 4821 |
19. | 2019w1 4793 |
20. | 2018w19 4753 |
   |-----------------|
21. | 2018w16 4631 |
22. | 2018w17 4585 |
23. | 2018w47 4558 |
24. | 2018w23 4527 |
25. | 2018w45 4513 |
   |-----------------|
26. | 2018w26 4457 |
27. | 2018w39 4388 |
28. | 2018w20 4346 |
29. | 2018w40 4271 |
30. | 2018w27 4253 |
   |-----------------|
31. | 2018w28 4239 |
32. | 2018w22 4183 |
33. | 2018w29 4159 |
34. | 2018w32 3994 |
35. | 2018w43 3945 |
   |-----------------|
36. | 2018w21 3854 |
37. | 2018w24 3818 |
38. | 2018w41 3800 |
39. | 2018w31 3798 |
40. | 2018w34 3789 |
   |-----------------|
41. | 2018w50 3782 |
42. | 2018w51 3753 |
43. | 2018w48 3750 |
44. | 2018w46 3722 |
45. | 2018w30 3652 |
   |-----------------|
46. | 2018w33 3618 |
47. | 2018w36 3574 |
48. | 2018w49 3560 |
49. | 2018w44 3339 |
50. | 2018w52 3278 |
   |-----------------|
51. | 2018w35 3065 |
   +-----------------+

List of intra-week merits in ascending order

Code:

. list week merit

   +-----------------+
   | week merit |
   |-----------------|
  1. | 2018w35 3065 |
  2. | 2018w52 3278 |
  3. | 2018w44 3339 |
  4. | 2018w49 3560 |
  5. | 2018w36 3574 |
   |-----------------|
  6. | 2018w33 3618 |
  7. | 2018w30 3652 |
  8. | 2018w46 3722 |
  9. | 2018w48 3750 |
10. | 2018w51 3753 |
   |-----------------|
11. | 2018w50 3782 |
12. | 2018w34 3789 |
13. | 2018w31 3798 |
14. | 2018w41 3800 |
15. | 2018w24 3818 |
   |-----------------|
16. | 2018w21 3854 |
17. | 2018w43 3945 |
18. | 2018w32 3994 |
19. | 2018w29 4159 |
20. | 2018w22 4183 |
   |-----------------|
21. | 2018w28 4239 |
22. | 2018w27 4253 |
23. | 2018w40 4271 |
24. | 2018w20 4346 |
25. | 2018w39 4388 |
   |-----------------|
26. | 2018w26 4457 |
27. | 2018w45 4513 |
28. | 2018w23 4527 |
29. | 2018w47 4558 |
30. | 2018w17 4585 |
   |-----------------|
31. | 2018w16 4631 |
32. | 2018w19 4753 |
33. | 2019w1 4793 |
34. | 2018w42 4821 |
35. | 2018w25 4921 |
   |-----------------|
36. | 2018w18 4953 |
37. | 2018w15 5487 |
38. | 2018w37 5630 |
39. | 2018w14 6415 |
40. | 2019w2 6624 |
   |-----------------|
41. | 2018w13 6707 |
42. | 2018w12 6941 |
43. | 2018w10 7253 |
44. | 2018w11 7309 |
45. | 2018w38 7825 |
   |-----------------|
46. | 2018w8 8758 |
47. | 2018w9 8806 |
48. | 2018w7 11722 |
49. | 2018w6 13304 |
50. | 2018w5 19958 |
   |-----------------|
51. | 2018w4 30949 |
   +-----------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Update:

ABSTRACT
Notes:
- The asbstract describes figures of intraday merits over the period from 19/2/2018 to 14/01/2019 (truncated dataset);
- Days from 24/1/2018 to 18/2/2018 truncated due to highly potential outliers; and days after 14/01/2019 truncated as well due to incomplete week (the third week of 2019 -2019w3);
- Statistics presented in the post are for truncated dataset.

(1) Potential outliers are days that have intraday total merits beyond 123 or 1163;
(2) Median of intraday merits over the period is 619, whilst the interquartile range is from 513 to 773;
(3) Friday is the day over weeks has lowest intraday merits in terms of both median and mean, at 542, and 617, respectively.
In contrast, Monday is the day over weeks has highest intraday merits in terms of both median and mean, at 748 and 657, respectively.

1) Time series plot
I used full dataset (only dropped the first two days due to extremely high merits distributed during those days), since 24/1/2018 to 14/1/2019 to draw the below plot

2) Basic statistics
- Mean +/- sd: 846 +/- 901
- Median (interquartile range): 637 (519 - 845)
- Min - max: 312 - 2463.

Let's compared with statistics for the previous report.

From the full dataset, we can easily identify potential outliers via the following formula:
IQR = Q3 – Q1 = 845 - 519 = 326;
1.5*IQR = 1.5*326 = 489
Potential outliers:
- Above Q3 +1.5*IQR = 845 + 489 = 1334
- Below Q1 – 1.5*IQR = 519 – 489 = 30
Let's see how many days that have total intraday merits beyond 30 or 1334?

Code:

. count if merit > 1334 | merit < 30 & merit != .
31

In total, 31 days are extremely potential outliers, and none of them occured recent weeks (only days before 18/9/2018).

Code:

. list id date merit if merit > 1334 | merit < 30 & merit != .

   +-------------------------+
   | id date merit |
   |-------------------------|
  1. | 1 24jan2018 13018 |
  2. | 2 25jan2018 6761 |
  3. | 3 26jan2018 4493 |
  4. | 4 27jan2018 3489 |
  5. | 5 28jan2018 3188 |
   |-------------------------|
  6. | 6 29jan2018 3799 |
  7. | 7 30jan2018 4192 |
  8. | 8 31jan2018 2820 |
  9. | 9 01feb2018 2545 |
10. | 10 02feb2018 2568 |
   |-------------------------|
11. | 11 03feb2018 1867 |
12. | 12 04feb2018 2167 |
13. | 13 05feb2018 2077 |
14. | 14 06feb2018 2308 |
15. | 15 07feb2018 2141 |
   |-------------------------|
16. | 16 08feb2018 2141 |
17. | 17 09feb2018 1448 |
18. | 18 10feb2018 1747 |
19. | 19 11feb2018 1442 |
21. | 21 13feb2018 1579 |
   |-------------------------|
22. | 22 14feb2018 2513 |
23. | 23 15feb2018 1991 |
24. | 24 16feb2018 1411 |
25. | 25 17feb2018 1608 |
27. | 27 19feb2018 1403 |
   |-------------------------|
32. | 32 24feb2018 1409 |
34. | 34 26feb2018 1382 |
38. | 38 02mar2018 1696 |
48. | 48 12mar2018 1354 |
236. | 236 16sep2018 2463 |
   |-------------------------|
237. | 237 17sep2018 1862 |
   +-------------------------+

Let's identify potential outliers of the truncated dataset (from 19/2/2018 to 14/1/2019):
IQR = Q3 – Q1 = 773 – 513 = 260;
1.5*IQR = 1.5*260 = 390
Potential outliers:
- Above Q3 +1.5*IQR = 773 + 390 = 1163
- Below Q1 – 1.5*IQR = 513 - 390 = 123
Potential outliers are days that have intraday merits beyond 123 or 1163.
Let's see how many days that have total intraday merits beyond 123 or 1163 ?

Code:

. count if (merit >= 1163 | merit <= 123) & merit != . & id >26
19

19 outliers in total, and there is no potential outlier day happened in early weeks of 2019.

Code:

. list id date merit if (merit >= 1163 | merit <= 123) & merit != . & id >26

   +-------------------------+
   | id date merit |
   |-------------------------|
27. | 27 19feb2018 1403 |
28. | 28 20feb2018 1169 |
29. | 29 21feb2018 1266 |
30. | 30 22feb2018 1279 |
32. | 32 24feb2018 1409 |
   |-------------------------|
33. | 33 25feb2018 1186 |
34. | 34 26feb2018 1382 |
35. | 35 27feb2018 1326 |
37. | 37 01mar2018 1333 |
38. | 38 02mar2018 1696 |
   |-------------------------|
41. | 41 05mar2018 1245 |
48. | 48 12mar2018 1354 |
56. | 56 20mar2018 1322 |
57. | 57 21mar2018 1227 |
68. | 68 01apr2018 1233 |
   |-------------------------|
236. | 236 16sep2018 2463 |
237. | 237 17sep2018 1862 |
238. | 238 18sep2018 1294 |
239. | 239 19sep2018 1268 |
   +-------------------------+

2) The 50 lowest day in terms of daily merits

Code:

. 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 338 27dec2018 Thursday 27 12 2018 2018w52 2018m12 |
  5. | 347 298 17nov2018 Saturday 17 11 2018 2018w46 2018m11 |
   |-------------------------------------------------------------------------------|
  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 278 28oct2018 Sunday 28 10 2018 2018w43 2018m10 |
24. | 415 109 12may2018 Saturday 12 5 2018 2018w19 2018m5 |
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 284 03nov2018 Saturday 3 11 2018 2018w44 2018m11 |
33. | 430 264 14oct2018 Sunday 14 10 2018 2018w41 2018m10 |
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. | 451 206 17aug2018 Friday 17 8 2018 2018w33 2018m8 |
42. | 454 283 02nov2018 Friday 2 11 2018 2018w44 2018m11 |
43. | 455 167 09jul2018 Monday 9 7 2018 2018w28 2018m7 |
44. | 455 229 09sep2018 Sunday 9 9 2018 2018w36 2018m9 |
45. | 457 216 27aug2018 Monday 27 8 2018 2018w35 2018m8 |
   |-------------------------------------------------------------------------------|
46. | 458 324 13dec2018 Thursday 13 12 2018 2018w50 2018m12 |
47. | 458 227 07sep2018 Friday 7 9 2018 2018w36 2018m9 |
48. | 460 263 13oct2018 Saturday 13 10 2018 2018w41 2018m10 |
49. | 461 130 02jun2018 Saturday 2 6 2018 2018w22 2018m6 |
50. | 462 306 25nov2018 Sunday 25 11 2018 2018w47 2018m11 |
   |-------------------------------------------------------------------------------|

3) The 50 highest day in terms of daily merits

Code:

. 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 16 08feb2018 Thursday 8 2 2018 2018w6 2018m2 |
   |-------------------------------------------------------------------------------|
16. | 2141 15 07feb2018 Wednesday 7 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 542, 587 and 603 respectively.
- In means of intraday merits, and GMT time, lowest days are Friday, Saturday, and Thursday at 617, 623, and 670.
- The highest day in terms of means and medians are both Monday, at 657 and 748, respectively.
More details in the raw results below.

Code:

. 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 | 47.0 704.4 346.2 603.0 464.0 829.0 389.0 2463.0
   Monday | 48.0 747.1 311.0 656.5 535.0 853.0 312.0 1862.0
  Tuesday | 47.0 696.6 238.4 626.0 567.0 767.0 383.0 1326.0
Wednesday | 47.0 719.0 226.7 652.0 558.0 761.0 435.0 1268.0
Thursday | 47.0 669.5 224.8 636.0 509.0 774.0 347.0 1333.0
   Friday | 47.0 616.6 239.5 542.0 463.0 733.0 348.0 1696.0
Saturday | 47.0 622.3 224.8 587.0 460.0 695.0 316.0 1409.0
----------+--------------------------------------------------------------------------------
   Total | 330.0 682.4 264.4 618.5 513.0 773.0 312.0 2463.0
-------------------------------------------------------------------------------------------

Plots:
- Outliers displayed with red circles.

- Outliers non-displayed.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Update:

Intraday merits

Converted dataset (since 1st Jan. 2019)

Code:

. list id merit date day month2 year week month dofw if year == 2019

   +-----------------------------------------------------------------------------+
   | id merit date day month2 year week month dofw |
   |-----------------------------------------------------------------------------|
343. | 343 603 01jan2019 1 1 2019 2019w1 2019m1 Tuesday |
344. | 344 526 02jan2019 2 1 2019 2019w1 2019m1 Wednesday |
345. | 345 394 03jan2019 3 1 2019 2019w1 2019m1 Thursday |
346. | 346 1082 04jan2019 4 1 2019 2019w1 2019m1 Friday |
347. | 347 835 05jan2019 5 1 2019 2019w1 2019m1 Saturday |
   |-----------------------------------------------------------------------------|
348. | 348 783 06jan2019 6 1 2019 2019w1 2019m1 Sunday |
349. | 349 570 07jan2019 7 1 2019 2019w1 2019m1 Monday |
350. | 350 782 08jan2019 8 1 2019 2019w2 2019m1 Tuesday |
351. | 351 1161 09jan2019 9 1 2019 2019w2 2019m1 Wednesday |
352. | 352 987 10jan2019 10 1 2019 2019w2 2019m1 Thursday |
   |-----------------------------------------------------------------------------|
353. | 353 878 11jan2019 11 1 2019 2019w2 2019m1 Friday |
354. | 354 711 12jan2019 12 1 2019 2019w2 2019m1 Saturday |
355. | 355 978 13jan2019 13 1 2019 2019w2 2019m1 Sunday |
356. | 356 1127 14jan2019 14 1 2019 2019w2 2019m1 Monday |
357. | 357 813 15jan2019 15 1 2019 2019w3 2019m1 Tuesday |
   |-----------------------------------------------------------------------------|
358. | 358 880 16jan2019 16 1 2019 2019w3 2019m1 Wednesday |
   +-----------------------------------------------------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Sure, I will do it later days.
Taking a quick glance at raw data within the recent two weeks, intraday merits have risen considerably.
I guess there are many factors contributed to the new wave of significant rises, including new merit sources added, the re-allocation of sMerits for each merit source, and the new Trust system.
Together, they made total intraday-merits rose.

For median and interquartile range [that I always prefer to use them rather than mean, and standard deviation. Because outliers will be removed when using median and interquartile range statistics], they take at least more than 6 days to retrieve statistics, hence I will show you statistics on before and after period (the day 9th of January will be used as a cut-off day) one or two weeks later.

Quote from: Lauda on January 18, 2019, 02:53:25 AM

Excellent work. Could you make a weekly breakdown of the next 2-3 weeks (and compare them to average weekly data) as I am certain there will be DT shenanigans in the making? Maybe even per section/user outliers if possible.

What did you mean? 'DT shenanigans'?

Quote from: Lauda on January 18, 2019, 02:53:25 AM

DT shenanigans in the making?

Thank you so much again for dumping data for me.

Quote from: LoyceV on January 19, 2019, 03:32:10 AM

Update up to yesterday's data dump:
...

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Update up to yesterday's data dump:
Per day

Code:

Day 1: 13018 Merit
Day 2: 6761 Merit
Day 3: 4493 Merit
Day 4: 3489 Merit
Day 5: 3188 Merit
Day 6: 3799 Merit
Day 7: 4192 Merit
Day 8: 2820 Merit
Day 9: 2545 Merit
Day 10: 2568 Merit
Day 11: 1867 Merit
Day 12: 2167 Merit
Day 13: 2077 Merit
Day 14: 2308 Merit
Day 15: 2141 Merit
Day 16: 2141 Merit
Day 17: 1448 Merit
Day 18: 1747 Merit
Day 19: 1442 Merit
Day 20: 1331 Merit
Day 21: 1579 Merit
Day 22: 2513 Merit
Day 23: 1991 Merit
Day 24: 1411 Merit
Day 25: 1608 Merit
Day 26: 1289 Merit
Day 27: 1403 Merit
Day 28: 1169 Merit
Day 29: 1266 Merit
Day 30: 1279 Merit
Day 31: 1046 Merit
Day 32: 1409 Merit
Day 33: 1186 Merit
Day 34: 1382 Merit
Day 35: 1326 Merit
Day 36: 991 Merit
Day 37: 1333 Merit
Day 38: 1696 Merit
Day 39: 1089 Merit
Day 40: 989 Merit
Day 41: 1245 Merit
Day 42: 1074 Merit
Day 43: 1109 Merit
Day 44: 922 Merit
Day 45: 789 Merit
Day 46: 1023 Merit
Day 47: 1091 Merit
Day 48: 1354 Merit
Day 49: 994 Merit
Day 50: 1159 Merit
Day 51: 1130 Merit
Day 52: 840 Merit
Day 53: 797 Merit
Day 54: 1035 Merit
Day 55: 992 Merit
Day 56: 1322 Merit
Day 57: 1227 Merit
Day 58: 764 Merit
Day 59: 733 Merit
Day 60: 1045 Merit
Day 61: 858 Merit
Day 62: 808 Merit
Day 63: 879 Merit
Day 64: 848 Merit
Day 65: 1043 Merit
Day 66: 928 Merit
Day 67: 968 Merit
Day 68: 1233 Merit
Day 69: 1146 Merit
Day 70: 1080 Merit
Day 71: 1061 Merit
Day 72: 838 Merit
Day 73: 620 Merit
Day 74: 614 Merit
Day 75: 1056 Merit
Day 76: 884 Merit
Day 77: 768 Merit
Day 78: 963 Merit
Day 79: 917 Merit
Day 80: 682 Merit
Day 81: 681 Merit
Day 82: 592 Merit
Day 83: 609 Merit
Day 84: 628 Merit
Day 85: 681 Merit
Day 86: 848 Merit
Day 87: 563 Merit
Day 88: 522 Merit
Day 89: 880 Merit
Day 90: 709 Merit
Day 91: 626 Merit
Day 92: 687 Merit
Day 93: 675 Merit
Day 94: 583 Merit
Day 95: 623 Merit
Day 96: 682 Merit
Day 97: 822 Merit
Day 98: 741 Merit
Day 99: 759 Merit
Day 100: 747 Merit
Day 101: 597 Merit
Day 102: 688 Merit
Day 103: 599 Merit
Day 104: 898 Merit
Day 105: 618 Merit
Day 106: 761 Merit
Day 107: 475 Merit
Day 108: 867 Merit
Day 109: 415 Merit
Day 110: 719 Merit
Day 111: 674 Merit
Day 112: 700 Merit
Day 113: 652 Merit
Day 114: 574 Merit
Day 115: 542 Merit
Day 116: 587 Merit
Day 117: 617 Merit
Day 118: 626 Merit
Day 119: 639 Merit
Day 120: 531 Merit
Day 121: 554 Merit
Day 122: 370 Merit
Day 123: 575 Merit
Day 124: 559 Merit
Day 125: 589 Merit
Day 126: 638 Merit
Day 127: 599 Merit
Day 128: 687 Merit
Day 129: 698 Merit
Day 130: 461 Merit
Day 131: 511 Merit
Day 132: 773 Merit
Day 133: 731 Merit
Day 134: 504 Merit
Day 135: 506 Merit
Day 136: 766 Merit
Day 137: 672 Merit
Day 138: 575 Merit
Day 139: 519 Merit
Day 140: 422 Merit
Day 141: 786 Merit
Day 142: 528 Merit
Day 143: 445 Merit
Day 144: 654 Merit
Day 145: 464 Merit
Day 146: 601 Merit
Day 147: 662 Merit
Day 148: 707 Merit
Day 149: 705 Merit
Day 150: 774 Merit
Day 151: 643 Merit
Day 152: 829 Merit
Day 153: 1138 Merit
Day 154: 435 Merit
Day 155: 516 Merit
Day 156: 470 Merit
Day 157: 479 Merit
Day 158: 778 Merit
Day 159: 641 Merit
Day 160: 711 Merit
Day 161: 902 Merit
Day 162: 557 Merit
Day 163: 577 Merit
Day 164: 475 Merit
Day 165: 506 Merit
Day 166: 525 Merit
Day 167: 455 Merit
Day 168: 620 Merit
Day 169: 555 Merit
Day 170: 644 Merit
Day 171: 542 Merit
Day 172: 627 Merit
Day 173: 796 Merit
Day 174: 636 Merit
Day 175: 641 Merit
Day 176: 608 Merit
Day 177: 554 Merit
Day 178: 606 Merit
Day 179: 567 Merit
Day 180: 547 Merit
Day 181: 684 Merit
Day 182: 444 Merit
Day 183: 492 Merit
Day 184: 673 Merit
Day 185: 521 Merit
Day 186: 418 Merit
Day 187: 420 Merit
Day 188: 471 Merit
Day 189: 632 Merit
Day 190: 435 Merit
Day 191: 376 Merit
Day 192: 421 Merit
Day 193: 695 Merit
Day 194: 768 Merit
Day 195: 595 Merit
Day 196: 610 Merit
Day 197: 647 Merit
Day 198: 471 Merit
Day 199: 567 Merit
Day 200: 517 Merit
Day 201: 587 Merit
Day 202: 513 Merit
Day 203: 565 Merit
Day 204: 626 Merit
Day 205: 470 Merit
Day 206: 451 Merit
Day 207: 561 Merit
Day 208: 432 Merit
Day 209: 658 Merit
Day 210: 600 Merit
Day 211: 612 Merit
Day 212: 530 Merit
Day 213: 528 Merit
Day 214: 385 Merit
Day 215: 476 Merit
Day 216: 457 Merit
Day 217: 383 Merit
Day 218: 488 Merit
Day 219: 514 Merit
Day 220: 379 Merit
Day 221: 432 Merit
Day 222: 412 Merit
Day 223: 536 Merit
Day 224: 567 Merit
Day 225: 654 Merit
Day 226: 509 Merit
Day 227: 458 Merit
Day 228: 395 Merit
Day 229: 455 Merit
Day 230: 472 Merit
Day 231: 580 Merit
Day 232: 595 Merit
Day 233: 540 Merit
Day 234: 517 Merit
Day 235: 463 Merit
Day 236: 2463 Merit
Day 237: 1862 Merit
Day 238: 1294 Merit
Day 239: 1268 Merit
Day 240: 846 Merit
Day 241: 807 Merit
Day 242: 944 Merit
Day 243: 804 Merit
Day 244: 749 Merit
Day 245: 596 Merit
Day 246: 562 Merit
Day 247: 675 Merit
Day 248: 518 Merit
Day 249: 669 Merit
Day 250: 619 Merit
Day 251: 509 Merit
Day 252: 760 Merit
Day 253: 705 Merit
Day 254: 521 Merit
Day 255: 513 Merit
Day 256: 660 Merit
Day 257: 603 Merit
Day 258: 678 Merit
Day 259: 578 Merit
Day 260: 639 Merit
Day 261: 616 Merit
Day 262: 399 Merit
Day 263: 460 Merit
Day 264: 430 Merit
Day 265: 655 Merit
Day 266: 626 Merit
Day 267: 732 Merit
Day 268: 774 Merit
Day 269: 643 Merit
Day 270: 538 Merit
Day 271: 853 Merit
Day 272: 694 Merit
Day 273: 674 Merit
Day 274: 759 Merit
Day 275: 553 Merit
Day 276: 424 Merit
Day 277: 426 Merit
Day 278: 415 Merit
Day 279: 534 Merit
Day 280: 529 Merit
Day 281: 495 Merit
Day 282: 433 Merit
Day 283: 454 Merit
Day 284: 430 Merit
Day 285: 464 Merit
Day 286: 562 Merit
Day 287: 405 Merit
Day 288: 691 Merit
Day 289: 843 Merit
Day 290: 536 Merit
Day 291: 688 Merit
Day 292: 788 Merit
Day 293: 591 Merit
Day 294: 580 Merit
Day 295: 569 Merit
Day 296: 650 Merit
Day 297: 499 Merit
Day 298: 347 Merit
Day 299: 486 Merit
Day 300: 898 Merit
Day 301: 767 Merit
Day 302: 608 Merit
Day 303: 759 Merit
Day 304: 348 Merit
Day 305: 716 Merit
Day 306: 462 Merit
Day 307: 531 Merit
Day 308: 510 Merit
Day 309: 558 Merit
Day 310: 643 Merit
Day 311: 554 Merit
Day 312: 530 Merit
Day 313: 424 Merit
Day 314: 501 Merit
Day 315: 563 Merit
Day 316: 665 Merit
Day 317: 479 Merit
Day 318: 487 Merit
Day 319: 468 Merit
Day 320: 397 Merit
Day 321: 641 Merit
Day 322: 596 Merit
Day 323: 618 Merit
Day 324: 458 Merit
Day 325: 571 Merit
Day 326: 377 Merit
Day 327: 521 Merit
Day 328: 713 Merit
Day 329: 402 Merit
Day 330: 494 Merit
Day 331: 636 Merit
Day 332: 496 Merit
Day 333: 316 Merit
Day 334: 696 Merit
Day 335: 312 Merit
Day 336: 478 Merit
Day 337: 665 Merit
Day 338: 347 Merit
Day 339: 386 Merit
Day 340: 325 Merit
Day 341: 389 Merit
Day 342: 376 Merit
Day 343: 603 Merit
Day 344: 526 Merit
Day 345: 394 Merit
Day 346: 1082 Merit
Day 347: 835 Merit
Day 348: 783 Merit
Day 349: 570 Merit
Day 350: 782 Merit
Day 351: 1161 Merit
Day 352: 987 Merit
Day 353: 878 Merit
Day 354: 711 Merit
Day 355: 978 Merit
Day 356: 1127 Merit
Day 357: 813 Merit
Day 358: 880 Merit
Day 359: 141 Merit (incomplete day)

Per week

Code:

Week 1: 38953 Merit
Week 2: 16373 Merit
Week 3: 11836 Merit
Week 4: 11406 Merit
Week 5: 8910 Merit
Week 6: 8434 Merit
Week 7: 7288 Merit
Week 8: 7283 Merit
Week 9: 6324 Merit
Week 10: 7276 Merit
Week 11: 5848 Merit
Week 12: 5082 Merit
Week 13: 4855 Merit
Week 14: 4821 Merit
Week 15: 4919 Merit
Week 16: 4619 Merit
Week 17: 4243 Merit
Week 18: 3825 Merit
Week 19: 4466 Merit
Week 20: 3978 Merit
Week 21: 4156 Merit
Week 22: 5237 Merit
Week 23: 4511 Merit
Week 24: 3733 Merit
Week 25: 4447 Merit
Week 26: 4018 Merit
Week 27: 3682 Merit
Week 28: 3918 Merit
Week 29: 3883 Merit
Week 30: 3811 Merit
Week 31: 3377 Merit
Week 32: 3336 Merit
Week 33: 3536 Merit
Week 34: 7743 Merit
Week 35: 6023 Merit
Week 36: 4318 Merit
Week 37: 4305 Merit
Week 38: 3831 Merit
Week 39: 4916 Merit
Week 40: 3646 Merit
Week 41: 3249 Merit
Week 42: 4728 Merit
Week 43: 4249 Merit
Week 44: 3945 Merit
Week 45: 3783 Merit
Week 46: 3755 Merit
Week 47: 3668 Merit
Week 48: 3472 Merit
Week 49: 3119 Merit
Week 50: 4978 Merit
Week 51: 6666 Merit
Week 52: 1022 Merit (incomplete week)

Lauda

legendary

Activity: 2674

Merit: 3000

Terminated.

Excellent work. Could you make a weekly breakdown of the next 2-3 weeks (and compare them to average weekly data) as I am certain there will be DT shenanigans in the making? Maybe even per section/user outliers if possible.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Quarterly merits

ABSTRACT
(1) The highest and lowest quarter are 2018q1 (first quarter of 2018) and 2018q4 (fourth quarter of 2018), at 120474 and 51092 merits, respectively.
(2) The total merits in the incomplete first quarter of 2019 is 6736 (from 01/1/2019 to 09/1/2019).
(3) The figure of 2018q1 has almost two-times higher than the figures of rest three quarters.

- The 'assumed' calendar time is in GMT.

Quote from: LoyceV on January 04, 2019, 11:10:19 AM

To take away all doubt: the first Merit was this one:

Code:

1516831941 1 2818066.msg28853325 35 877396

Use EpochConverter to convert 1516831941 (Unix Time) to GMT: Wednesday 24 January 2018 22:12:21.

1) Truncated dataset:
Notes:
- The first quarter of 2018 (2018q1) is incomplete one, but I used it due to extremely high merits sent around during the period.
- Early days of 2019 dropped due to incomplete quarter.

Code:

. list merit quarter

   +------------------+
   | merit quarter |
   |------------------|
  1. | 120474 2018q1 |
  2. | 61522 2018q2 |
  3. | 56625 2018q3 |
  4. | 51092 2018q4 |
   +------------------+

2) Full dataset

Code:

. list merit quarter

   +------------------+
   | merit quarter |
   |------------------|
  1. | 120474 2018q1 |
  2. | 61522 2018q2 |
  3. | 56625 2018q3 |
  4. | 51092 2018q4 |
  5. | 6736 2019q1 |
   +------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Monthly merits's update:

ABSTRACT

- 50% of observed months have intra-month merits above 19175 or below 19175, that is the median of intra-month merits;
- 50% of observed months have intra-month merits ranged in the range from 17709 to 27629, that is the interquartile range of intra-month merits.
- Minimum and maximum are 15327 and 46630, respectively. The minimum and maximum found in December of 2018 and February of 2018, respectively.
The January of 2018 has still been the highest one even the figure for the month is for incomplete month.

1) Monthly merits time series plot

2) Basic statistics
- Mean +/- sd: 24143 +/- 10394;
- Median (interquartile range): 19175 (17709 - 27629).
- Min - max: 15327 - 46630.

Note:
The first week of 2019 dropped due to incomplete month.

Code:

. list merit month

   +-----------------+
   | merit month |
   |-----------------|
  1. | 41760 2018m1 |
  2. | 46630 2018m2 |
  3. | 32084 2018m3 |
  4. | 23173 2018m4 |
  5. | 19597 2018m5 |
   |-----------------|
  6. | 18752 2018m6 |
  7. | 18047 2018m7 |
  8. | 16317 2018m8 |
  9. | 22261 2018m9 |
10. | 18395 2018m10 |
   |-----------------|
11. | 17370 2018m11 |
12. | 15327 2018m12 |
13. | 6736 2019m1 |
   +-----------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Weekly merits update:

ABSTRACT

(1) The all-time-low and all-time-high of weekly merits so far are 3065 and 30949, respectively (full dataset); whist the ATL and ATH of truncated dataset are 3065 and 8806, respectively;
(2) 50% of observed weeks (truncated dataset) have total intra-week merits below 4309 or above 4309 (median is 4309);
(3) 50% of observed weeks (truncatated dataset) have total intra-week merits in the range from 3789 to 4921 (the interquartile range);
(4)There is no potential outlier found recent weeks (beyond 2091 or 6619).
(5) Total merit of the newest week (2019w1) has nearly 46% higher than the figure of previous week.

1) Weekly merits' time series plot

2) Basic statistics

Weekly merits' median of the truncated dataset (from 19/2/2018 to 07/1/2019) has increased a little bit than figures of dataset within the period from 19/2/2018 to 31/12/2018.
The median rose from 4271 to 4309, whilst the mean remained around 4752.

Potential outliers
IQR = | Q1 - Q3 | = | 4921 - 3789 | = 1132.
1.5*IQR = 1132 * 1.5 = 1698
Q1 - 1.5 IQR = 3789 - 1698 = 2091
Q3 + 1.5 IQR = 4921 + 1698 = 6619

In short, potential outliers are weeks that have total intra-week merits beyond 2091 or 6619.

Now, let's see how many weeks are potential outliers.
weeks are potential outliers in total (results shown below), and none of them occured in the recent weeks. Grin

Code:

. list merit week if merit > = 6619 | merit <= 2091

   +-----------------+
   | merit week |
   |-----------------|
  1. | 8758 2018w8 |
  2. | 8806 2018w9 |
  3. | 7253 2018w10 |
  4. | 7309 2018w11 |
  5. | 6941 2018w12 |
   |-----------------|
  6. | 6707 2018w13 |
31. | 7825 2018w38 |
   +-----------------+

3) Weeks in ascending order of intra-week merits

Code:

. list merit week

   +-----------------+
   | merit week |
   |-----------------|
  1. | 3065 2018w35 |
  2. | 3278 2018w52 |
  3. | 3339 2018w44 |
  4. | 3560 2018w49 |
  5. | 3574 2018w36 |
   |-----------------|
  6. | 3618 2018w33 |
  7. | 3652 2018w30 |
  8. | 3722 2018w46 |
  9. | 3750 2018w48 |
10. | 3753 2018w51 |
   |-----------------|
11. | 3782 2018w50 |
12. | 3789 2018w34 |
13. | 3798 2018w31 |
14. | 3800 2018w41 |
15. | 3818 2018w24 |
   |-----------------|
16. | 3854 2018w21 |
17. | 3945 2018w43 |
18. | 3994 2018w32 |
19. | 4159 2018w29 |
20. | 4183 2018w22 |
   |-----------------|
21. | 4239 2018w28 |
22. | 4253 2018w27 |
23. | 4271 2018w40 |
24. | 4346 2018w20 |
25. | 4388 2018w39 |
   |-----------------|
26. | 4457 2018w26 |
27. | 4513 2018w45 |
28. | 4527 2018w23 |
29. | 4558 2018w47 |
30. | 4585 2018w17 |
   |-----------------|
31. | 4631 2018w16 |
32. | 4753 2018w19 |
33. | 4793 2019w1 |
34. | 4821 2018w42 |
35. | 4921 2018w25 |
   |-----------------|
36. | 4953 2018w18 |
37. | 5487 2018w15 |
38. | 5630 2018w37 |
39. | 6415 2018w14 |
40. | 6707 2018w13 |
   |-----------------|
41. | 6941 2018w12 |
42. | 7253 2018w10 |
43. | 7309 2018w11 |
44. | 7825 2018w38 |
45. | 8758 2018w8 |
   |-----------------|
46. | 8806 2018w9 |
47. | 11722 2018w7 |
48. | 13304 2018w6 |
49. | 19958 2018w5 |
50. | 30949 2018w4 |
   +-----------------+

4) Weeks in descending order of intra-week merits

Code:

. list merit week

   +-----------------+
   | merit week |
   |-----------------|
  1. | 30949 2018w4 |
  2. | 19958 2018w5 |
  3. | 13304 2018w6 |
  4. | 11722 2018w7 |
  5. | 8806 2018w9 |
   |-----------------|
  6. | 8758 2018w8 |
  7. | 7825 2018w38 |
  8. | 7309 2018w11 |
  9. | 7253 2018w10 |
10. | 6941 2018w12 |
   |-----------------|
11. | 6707 2018w13 |
12. | 6415 2018w14 |
13. | 5630 2018w37 |
14. | 5487 2018w15 |
15. | 4953 2018w18 |
   |-----------------|
16. | 4921 2018w25 |
17. | 4821 2018w42 |
18. | 4793 2019w1 |
19. | 4753 2018w19 |
20. | 4631 2018w16 |
   |-----------------|
21. | 4585 2018w17 |
22. | 4558 2018w47 |
23. | 4527 2018w23 |
24. | 4513 2018w45 |
25. | 4457 2018w26 |
   |-----------------|
26. | 4388 2018w39 |
27. | 4346 2018w20 |
28. | 4271 2018w40 |
29. | 4253 2018w27 |
30. | 4239 2018w28 |
   |-----------------|
31. | 4183 2018w22 |
32. | 4159 2018w29 |
33. | 3994 2018w32 |
34. | 3945 2018w43 |
35. | 3854 2018w21 |
   |-----------------|
36. | 3818 2018w24 |
37. | 3800 2018w41 |
38. | 3798 2018w31 |
39. | 3789 2018w34 |
40. | 3782 2018w50 |
   |-----------------|
41. | 3753 2018w51 |
42. | 3750 2018w48 |
43. | 3722 2018w46 |
44. | 3652 2018w30 |
45. | 3618 2018w33 |
   |-----------------|
46. | 3574 2018w36 |
47. | 3560 2018w49 |
48. | 3339 2018w44 |
49. | 3278 2018w52 |
50. | 3065 2018w35 |
   +-----------------+

5) Weeks in chronological order

Code:

. 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 |
   +-----------------+

The newest week (in data dump) has total intra-week merits nearly 46% higher than of the previous week (4793 compared to 3278).

Code:

. di 4793-3278
1515

. di 1515/3278*100
46.217206

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Update:

ABSTRACT
Notes:
- The asbstract describes figures of intraday merits over the period from 19/2/2018 to 07/01/2019 (truncated dataset);
- Days from 24/1/2018 to 18/2/2018 truncated due to highly potential outliers; and days after 07/01/2019 truncated as well due to incomplete week (the second week of 2019);
- Statistics presented in the post are for truncated dataset.

(1) Potential outliers are days that have intraday total merits beyond 126 or 1150;
(2) Mean of intraday merits over the period is 616, whilst the interquartile range is from 510 to 766;
(3) Friday is the day over weeks has lowest intraday merits in terms of both median and mean, at 539, and 611, respectively.

1) Daily merits' time series plot
I used full dataset (only dropped the first two days due to extremely high merits distributed during those days), since 24/1/2018 to 9/1/2019 to draw the below plot

2) Basic statistics
- Mean +/- sd: 677 +/- 264
- Median (interquartile range): 616 (510 - 766)
- Min - max: 312 - 2463.

From the full dataset, we can easily identify potential outliers via the following formula:
IQR = Q3 – Q1 = 835 – 517 = 350;
1.5*IQR = 1.5*318 = 477
Potential outliers:
- Above Q3 +1.5*IQR = 835 + 477 = 1312
- Below Q1 – 1.5*IQR = 517 – 477 = 40
Let's see how many days that have total intraday merits beyond 40 or 1312?

Code:

. count if merit >= 1312 | merit <= 40
35

In total, 35 days are extremely potential outliers, and none of them occured recent weeks (only days before 18/9/2018).

Code:

. list id merit date if merit >= 1312 | merit <= 40

   +-------------------------+
   | id merit date |
   |-------------------------|
  1. | 1 13018 24jan2018 |
  2. | 2 6761 25jan2018 |
  3. | 3 4493 26jan2018 |
  4. | 4 3489 27jan2018 |
  5. | 5 3188 28jan2018 |
   |-------------------------|
  6. | 6 3799 29jan2018 |
  7. | 7 4192 30jan2018 |
  8. | 8 2820 31jan2018 |
  9. | 9 2545 01feb2018 |
10. | 10 2568 02feb2018 |
   |-------------------------|
11. | 11 1867 03feb2018 |
12. | 12 2167 04feb2018 |
13. | 13 2077 05feb2018 |
14. | 14 2308 06feb2018 |
15. | 15 2141 07feb2018 |
   |-------------------------|
16. | 16 2141 08feb2018 |
17. | 17 1448 09feb2018 |
18. | 18 1747 10feb2018 |
19. | 19 1442 11feb2018 |
20. | 20 1331 12feb2018 |
   |-------------------------|
21. | 21 1579 13feb2018 |
22. | 22 2513 14feb2018 |
23. | 23 1991 15feb2018 |
24. | 24 1411 16feb2018 |
25. | 25 1608 17feb2018 |
   |-------------------------|
27. | 27 1403 19feb2018 |
32. | 32 1409 24feb2018 |
34. | 34 1382 26feb2018 |
35. | 35 1326 27feb2018 |
37. | 37 1333 01mar2018 |
   |-------------------------|
38. | 38 1696 02mar2018 |
48. | 48 1354 12mar2018 |
56. | 56 1322 20mar2018 |
236. | 236 2463 16sep2018 |
237. | 237 1862 17sep2018 |
   +-------------------------+

Let's identify potential outliers of the truncated dataset (from 19/2/2018 to 07/1/2019):
IQR = Q3 – Q1 = 766 – 510 = 256;
1.5*IQR = 1.5*256 = 384
Potential outliers:
- Above Q3 +1.5*IQR = 766 + 384 = 1150
- Below Q1 – 1.5*IQR = 510 – 384 = 126
Potential outliers are days that have intraday merits beyond 126 or 1150.
Let's see how many days that have total intraday merits beyond 126 or 1150 ?
There is no potential outlier day happened in early weeks of 2019.
In fact, the day with id # 351 (in LoyceV's dataset) on 09/1/2019 is an outlier with 1161 intraday merits, but I skipped it for now because the day belong to next week (which has still incompleted).

2) The 50 lowest day in terms of daily merits

Code:

. 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 338 27dec2018 Thursday 27 12 2018 2018w52 2018m12 |
  5. | 347 298 17nov2018 Saturday 17 11 2018 2018w46 2018m11 |
   |-------------------------------------------------------------------------------|
  6. | 348 304 23nov2018 Friday 23 11 2018 2018w47 2018m11 |
  7. | 370 122 25may2018 Friday 25 5 2018 2018w21 2018m5 |
  8. | 376 342 31dec2018 Monday 31 12 2018 2018w52 2018m12 |
  9. | 376 191 02aug2018 Thursday 2 8 2018 2018w31 2018m8 |
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 278 28oct2018 Sunday 28 10 2018 2018w43 2018m10 |
24. | 415 109 12may2018 Saturday 12 5 2018 2018w19 2018m5 |
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 276 26oct2018 Friday 26 10 2018 2018w43 2018m10 |
30. | 424 313 02dec2018 Sunday 2 12 2018 2018w48 2018m12 |
   |-------------------------------------------------------------------------------|
31. | 426 277 27oct2018 Saturday 27 10 2018 2018w43 2018m10 |
32. | 430 284 03nov2018 Saturday 3 11 2018 2018w44 2018m11 |
33. | 430 264 14oct2018 Sunday 14 10 2018 2018w41 2018m10 |
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 190 01aug2018 Wednesday 1 8 2018 2018w31 2018m8 |
38. | 435 154 26jun2018 Tuesday 26 6 2018 2018w26 2018m6 |
39. | 444 182 24jul2018 Tuesday 24 7 2018 2018w30 2018m7 |
40. | 445 143 15jun2018 Friday 15 6 2018 2018w24 2018m6 |
   |-------------------------------------------------------------------------------|
41. | 451 206 17aug2018 Friday 17 8 2018 2018w33 2018m8 |
42. | 454 283 02nov2018 Friday 2 11 2018 2018w44 2018m11 |
43. | 455 167 09jul2018 Monday 9 7 2018 2018w28 2018m7 |
44. | 455 229 09sep2018 Sunday 9 9 2018 2018w36 2018m9 |
45. | 457 216 27aug2018 Monday 27 8 2018 2018w35 2018m8 |
   |-------------------------------------------------------------------------------|
46. | 458 227 07sep2018 Friday 7 9 2018 2018w36 2018m9 |
47. | 458 324 13dec2018 Thursday 13 12 2018 2018w50 2018m12 |
48. | 460 263 13oct2018 Saturday 13 10 2018 2018w41 2018m10 |
49. | 461 130 02jun2018 Saturday 2 6 2018 2018w22 2018m6 |
50. | 462 306 25nov2018 Sunday 25 11 2018 2018w47 2018m11 |
   |-------------------------------------------------------------------------------|

3) The 50 highest day in terms of daily merits

Code:

. 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 539, 581 and 601 respectively.
- In means of intraday merits, and GMT time, lowest days are Friday, Saturday, and Thursday at 611, 621, and 663.
- The highest day in terms of means and medians are both Monday, at 655 and 739, respectively.
More details in the raw results below.

Code:

. 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 | 46.0 698.5 347.5 601.0 464.0 804.0 389.0 2463.0
   Monday | 47.0 739.1 309.2 655.0 534.0 822.0 312.0 1862.0
  Tuesday | 46.0 694.7 240.7 626.0 567.0 760.0 383.0 1326.0
Wednesday | 46.0 709.3 219.3 649.5 558.0 759.0 435.0 1268.0
Thursday | 46.0 662.6 222.2 626.0 509.0 764.0 347.0 1333.0
   Friday | 46.0 610.9 238.9 539.0 463.0 698.0 348.0 1696.0
Saturday | 46.0 620.4 226.9 581.0 460.0 688.0 316.0 1409.0
----------+--------------------------------------------------------------------------------
   Total | 323.0 676.7 263.4 616.0 510.0 766.0 312.0 2463.0
-------------------------------------------------------------------------------------------

Plots:
- Outliers displayed with red circles.

- Outliers non-displayed.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Daily converted dataset's update:

I only posted the part of converted dataset since the start of 2019, for part of dataset for previous days in the year 2018, please get it on previous posts.

Code:

. list id merit date day month2 year week month dofw if year == 2019

   +-----------------------------------------------------------------------------+
   | id merit date day month2 year week month dofw |
   |-----------------------------------------------------------------------------|
343. | 343 603 01jan2019 1 1 2019 2019w1 2019m1 Tuesday |
344. | 344 526 02jan2019 2 1 2019 2019w1 2019m1 Wednesday |
345. | 345 394 03jan2019 3 1 2019 2019w1 2019m1 Thursday |
346. | 346 1082 04jan2019 4 1 2019 2019w1 2019m1 Friday |
347. | 347 835 05jan2019 5 1 2019 2019w1 2019m1 Saturday |
   |-----------------------------------------------------------------------------|
348. | 348 783 06jan2019 6 1 2019 2019w1 2019m1 Sunday |
349. | 349 570 07jan2019 7 1 2019 2019w1 2019m1 Monday |
350. | 350 782 08jan2019 8 1 2019 2019w2 2019m1 Tuesday |
351. | 351 1161 09jan2019 9 1 2019 2019w2 2019m1 Wednesday |
   +-----------------------------------------------------------------------------+

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Thank you for your data dump, LoyceV.

It's normal to see the considerable increases of total merits distributed last week.
It happened in September with new rules on rank requirements and a wave of demoted Junior member. During that period, so many merits sent around from merit abusers.

This time, it is probably that the merits distributed last week almost true, correct ones dedicated to qualitied, deserved threads/ posts.
I read somewhere in the forum so many topics (newly published) after the rebuilt of trust system.
Those topics and posts inside received so many merits.

Additionally, 3 new merit sources added last week.

I guess all these two factors boosted merit distribution last week.

In general, merit distributions in the forum tend to increase with new systems/ adjusted ones.

I will come back with more statistics.

Topic: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly) - page 30. (Read 29484 times)