tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 31, 2019, 05:59:26 AM |
|
Medians and means of intra-day merits over days of weeks.Colors: - Green: highest.- Red: Lowest.- In median, the highest days are Monday, Wednesday, and Thursday at 658, 654, and 644, respectively; whislt the lowest days are Friday, Sunday, and Saturday, at 567, 607, and 614, respectively. - In means, the highest days are Monday, Wednesday, and Sunday at 738, 711, and 692, respectively; whilst the lowest days are Friday, Saturday, and Thursday at 614, 622, and 672, respectively. - In both mean and median, Monday is the highest day, whilst Friday is the lowest day. Calendar day is in GMT time.To take away all doubt: the first Merit was this one: 1516831941 1 2818066.msg28853325 35 877396 Use EpochConverter to convert 1516831941 (Unix Time) to GMT: Wednesday 24 January 2018 22:12:21. Basic statistics:. 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 | 57.0 692.0 320.3 607.0 486.0 796.0 389.0 2463.0 Monday | 58.0 737.2 286.1 657.5 565.0 808.0 312.0 1862.0 Tuesday | 57.0 695.3 218.4 632.0 580.0 760.0 383.0 1326.0 Wednesday | 57.0 710.9 211.1 654.0 559.0 759.0 435.0 1268.0 Thursday | 57.0 671.8 213.9 644.0 514.0 764.0 347.0 1333.0 Friday | 57.0 614.0 218.6 567.0 487.0 682.0 348.0 1696.0 Saturday | 57.0 622.2 211.8 614.0 463.0 688.0 316.0 1409.0 ----------+-------------------------------------------------------------------------------- Total | 400.0 677.8 245.4 625.5 521.0 759.5 312.0 2463.0 -------------------------------------------------------------------------------------------
Box plotsOutliers displayed as red circles. Outliers non-displayed.
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 31, 2019, 06:20:04 AM |
|
Update on intra-week merits (from 24/1/2018 to 25/3/2019)Converted dataset:. list merit week
+-----------------+ | merit week | |-----------------| 1. | 30949 2018w4 | 2. | 19958 2018w5 | 3. | 13304 2018w6 | 4. | 11722 2018w7 | 5. | 8758 2018w8 | |-----------------| 6. | 8806 2018w9 | 7. | 7253 2018w10 | 8. | 7309 2018w11 | 9. | 6941 2018w12 | 10. | 6707 2018w13 | |-----------------| 11. | 6415 2018w14 | 12. | 5487 2018w15 | 13. | 4631 2018w16 | 14. | 4585 2018w17 | 15. | 4953 2018w18 | |-----------------| 16. | 4753 2018w19 | 17. | 4346 2018w20 | 18. | 3854 2018w21 | 19. | 4183 2018w22 | 20. | 4527 2018w23 | |-----------------| 21. | 3818 2018w24 | 22. | 4921 2018w25 | 23. | 4457 2018w26 | 24. | 4253 2018w27 | 25. | 4239 2018w28 | |-----------------| 26. | 4159 2018w29 | 27. | 3652 2018w30 | 28. | 3798 2018w31 | 29. | 3994 2018w32 | 30. | 3618 2018w33 | |-----------------| 31. | 3789 2018w34 | 32. | 3065 2018w35 | 33. | 3574 2018w36 | 34. | 5630 2018w37 | 35. | 7825 2018w38 | |-----------------| 36. | 4388 2018w39 | 37. | 4271 2018w40 | 38. | 3800 2018w41 | 39. | 4821 2018w42 | 40. | 3945 2018w43 | |-----------------| 41. | 3339 2018w44 | 42. | 4513 2018w45 | 43. | 3722 2018w46 | 44. | 4558 2018w47 | 45. | 3750 2018w48 | |-----------------| 46. | 3560 2018w49 | 47. | 3782 2018w50 | 48. | 3753 2018w51 | 49. | 3278 2018w52 | 50. | 4793 2019w1 | |-----------------| 51. | 6624 2019w2 | 52. | 5306 2019w3 | 53. | 4659 2019w4 | 54. | 4474 2019w5 | 55. | 4318 2019w6 | |-----------------| 56. | 4207 2019w7 | 57. | 4507 2019w8 | 58. | 4625 2019w9 | 59. | 4901 2019w10 | 60. | 4318 2019w11 | |-----------------| 61. | 4598 2019w12 | +-----------------+
Time series plotBasic statistics:- 50% of observed weeks have total intra-week merits above 4507, whilst the rest 50% of them have total intra-week merits below 4507. 4507 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 3854 to 5306 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3065 - 30949. . tabstat merit, s(n mean sd p50 p25 p75 min max)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 61 5689.23 4246.139 4507 3854 5306 3065 30949 ----------------------------------------------------------------------------------------------
Potential outliers: . di 5306-3854 1452
. di 1452*1.5 2178
. di 5306+2178 7484
. di 3854-2178 1676
It means that potential outliers are weeks that have intra-week merits beyond 1676 or 7484? How many weeks are potential outliers? . count if (merit >= 7484 | merit < 1676) & merit != . 7
7 weeks are outliers, in total. List of those seven weeks: . list merit week if merit >=7484 | merit <= 1676
+-----------------+ | merit week | |-----------------| 1. | 30949 2018w4 | 2. | 19958 2018w5 | 3. | 13304 2018w6 | 4. | 11722 2018w7 | 5. | 8758 2018w8 | |-----------------| 6. | 8806 2018w9 | 35. | 7825 2018w38 | +-----------------+
All of them occured in the year 2018. ![Grin](https://bitcointalk.org/Smileys/default/grin.gif)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 31, 2019, 06:26:24 AM |
|
ABSTRACT
Intra-day merits: Notes: - The part of the asbstract describes figures of intraday merits over the period from 19/2/2018 to 25/3/2019 (truncated dataset); - Days from 24/1/2018 to 18/2/2018 truncated due to highly potential outliers; and days after 25/3/2019 truncated as well due to incomplete week (the 2019w13); - Statistics presented in the post are for truncated dataset
(1) Potential outliers are days that have intraday total merits beyond 164 or 1118; (2) Median of intraday merits over the period is 626; (3) 50% of observed days have their intra-day merits range from 521 to 760 (the interquartile range); (4) Friday [in GTM time] is the day over weeks has lowest intraday merits in terms of both median and mean, at 567, and 614, respectively. (5) Monday [in GTM time] is the day over weeks has highest intraday merits in terms of both median and mean, at 658, and 738, respectively. (6) There are 25 potential outliers in total, and there is only two potential outlier days happened in early weeks of 2019, on 09 Jan. 2019 and 14 Jan. 2019, at 1161, and 1127, respectively. (7) Minimum and maximum of intraday merits (full dataset) are 312 and 13018, on 11/2/2019 and 24/1/2018 respectively.
Intra-week merits: Notes: The part of the abstract use full dataset, only dropped last two days due to incomple week (2019w10).
(1) The median of intra-week merits is 4507; (2) 50% of observed weeks (61 weeeks in total), have total merits in the range from 3854 to 5306 (the interquaritle range of intra-week merits); (3) Minimum and maximum of intraweek merits are 3065 and 30949, in 2018w35, and 2018w4, respectively; (4) Seven potential outliers [beyond 1676 or 7484], all of them occurred in the year 2018.
|
|
|
|
LoyceV
Legendary
Offline
Activity: 3416
Merit: 17265
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 06, 2019, 08:11:25 AM |
|
Update: Per dayDay 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: 450 Merit Day 374: 595 Merit Day 375: 940 Merit Day 376: 571 Merit Day 377: 796 Merit Day 378: 776 Merit Day 379: 559 Merit Day 380: 548 Merit Day 381: 611 Merit Day 382: 623 Merit Day 383: 559 Merit Day 384: 642 Merit Day 385: 585 Merit Day 386: 671 Merit Day 387: 649 Merit Day 388: 607 Merit Day 389: 523 Merit Day 390: 607 Merit Day 391: 565 Merit Day 392: 637 Merit Day 393: 696 Merit Day 394: 504 Merit Day 395: 509 Merit Day 396: 657 Merit Day 397: 608 Merit Day 398: 896 Merit Day 399: 736 Merit Day 400: 553 Merit Day 401: 707 Merit Day 402: 508 Merit Day 403: 412 Merit Day 404: 1001 Merit Day 405: 708 Merit Day 406: 677 Merit Day 407: 787 Merit Day 408: 711 Merit Day 409: 712 Merit Day 410: 723 Merit Day 411: 656 Merit Day 412: 635 Merit Day 413: 680 Merit Day 414: 687 Merit Day 415: 804 Merit Day 416: 580 Merit Day 417: 482 Merit Day 418: 428 Merit Day 419: 657 Merit Day 420: 758 Merit Day 421: 651 Merit Day 422: 720 Merit Day 423: 674 Merit Day 424: 625 Merit Day 425: 594 Merit Day 426: 576 Merit Day 427: 726 Merit Day 428: 1249 Merit Day 429: 927 Merit Day 430: 725 Merit Day 431: 655 Merit Day 432: 851 Merit Day 433: 987 Merit Day 434: 700 Merit Day 435: 616 Merit Day 436: 66 Merit (incomplete day) Per weekWeek 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: 4657 Merit Week 55: 4137 Merit Week 56: 4269 Merit Week 57: 4618 Merit Week 58: 4581 Merit Week 59: 4912 Merit Week 60: 4402 Merit Week 61: 4576 Merit Week 62: 6103 Merit Week 63: 683 Merit (incomplete week)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 06, 2019, 11:29:46 AM |
|
Update:Converted intra-day merits for days in 2019. . 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 | |------------------------------------------------------------------------------| 373. | 373 450 31jan2019 31 1 2019 2019w5 2019m1 Thursday | 374. | 374 595 01feb2019 1 2 2019 2019w5 2019m2 Friday | 375. | 375 940 02feb2019 2 2 2019 2019w5 2019m2 Saturday | 376. | 376 571 03feb2019 3 2 2019 2019w5 2019m2 Sunday | 377. | 377 796 04feb2019 4 2 2019 2019w5 2019m2 Monday | |------------------------------------------------------------------------------| 378. | 378 776 05feb2019 5 2 2019 2019w6 2019m2 Tuesday | 379. | 379 559 06feb2019 6 2 2019 2019w6 2019m2 Wednesday | 380. | 380 548 07feb2019 7 2 2019 2019w6 2019m2 Thursday | 381. | 381 611 08feb2019 8 2 2019 2019w6 2019m2 Friday | 382. | 382 623 09feb2019 9 2 2019 2019w6 2019m2 Saturday | |------------------------------------------------------------------------------| 383. | 383 559 10feb2019 10 2 2019 2019w6 2019m2 Sunday | 384. | 384 642 11feb2019 11 2 2019 2019w6 2019m2 Monday | 385. | 385 585 12feb2019 12 2 2019 2019w7 2019m2 Tuesday | 386. | 386 671 13feb2019 13 2 2019 2019w7 2019m2 Wednesday | 387. | 387 649 14feb2019 14 2 2019 2019w7 2019m2 Thursday | |------------------------------------------------------------------------------| 388. | 388 607 15feb2019 15 2 2019 2019w7 2019m2 Friday | 389. | 389 523 16feb2019 16 2 2019 2019w7 2019m2 Saturday | 390. | 390 607 17feb2019 17 2 2019 2019w7 2019m2 Sunday | 391. | 391 565 18feb2019 18 2 2019 2019w7 2019m2 Monday | 392. | 392 637 19feb2019 19 2 2019 2019w8 2019m2 Tuesday | |------------------------------------------------------------------------------| 393. | 393 696 20feb2019 20 2 2019 2019w8 2019m2 Wednesday | 394. | 394 504 21feb2019 21 2 2019 2019w8 2019m2 Thursday | 395. | 395 509 22feb2019 22 2 2019 2019w8 2019m2 Friday | 396. | 396 657 23feb2019 23 2 2019 2019w8 2019m2 Saturday | 397. | 397 608 24feb2019 24 2 2019 2019w8 2019m2 Sunday | |------------------------------------------------------------------------------| 398. | 398 896 25feb2019 25 2 2019 2019w8 2019m2 Monday | 399. | 399 736 26feb2019 26 2 2019 2019w9 2019m2 Tuesday | 400. | 400 553 27feb2019 27 2 2019 2019w9 2019m2 Wednesday | 401. | 401 707 28feb2019 28 2 2019 2019w9 2019m2 Thursday | 402. | 402 508 01mar2019 1 3 2019 2019w9 2019m3 Friday | |------------------------------------------------------------------------------| 403. | 403 412 02mar2019 2 3 2019 2019w9 2019m3 Saturday | 404. | 404 1001 03mar2019 3 3 2019 2019w9 2019m3 Sunday | 405. | 405 708 04mar2019 4 3 2019 2019w9 2019m3 Monday | 406. | 406 677 05mar2019 5 3 2019 2019w10 2019m3 Tuesday | 407. | 407 787 06mar2019 6 3 2019 2019w10 2019m3 Wednesday | |------------------------------------------------------------------------------| 408. | 408 711 07mar2019 7 3 2019 2019w10 2019m3 Thursday | 409. | 409 712 08mar2019 8 3 2019 2019w10 2019m3 Friday | 410. | 410 723 09mar2019 9 3 2019 2019w10 2019m3 Saturday | 411. | 411 656 10mar2019 10 3 2019 2019w10 2019m3 Sunday | 412. | 412 635 11mar2019 11 3 2019 2019w10 2019m3 Monday | |------------------------------------------------------------------------------| 413. | 413 680 12mar2019 12 3 2019 2019w11 2019m3 Tuesday | 414. | 414 687 13mar2019 13 3 2019 2019w11 2019m3 Wednesday | 415. | 415 804 14mar2019 14 3 2019 2019w11 2019m3 Thursday | 416. | 416 580 15mar2019 15 3 2019 2019w11 2019m3 Friday | 417. | 417 482 16mar2019 16 3 2019 2019w11 2019m3 Saturday | |------------------------------------------------------------------------------| 418. | 418 428 17mar2019 17 3 2019 2019w11 2019m3 Sunday | 419. | 419 657 18mar2019 18 3 2019 2019w11 2019m3 Monday | 420. | 420 758 19mar2019 19 3 2019 2019w12 2019m3 Tuesday | 421. | 421 651 20mar2019 20 3 2019 2019w12 2019m3 Wednesday | 422. | 422 720 21mar2019 21 3 2019 2019w12 2019m3 Thursday | |------------------------------------------------------------------------------| 423. | 423 674 22mar2019 22 3 2019 2019w12 2019m3 Friday | 424. | 424 625 23mar2019 23 3 2019 2019w12 2019m3 Saturday | 425. | 425 594 24mar2019 24 3 2019 2019w12 2019m3 Sunday | 426. | 426 576 25mar2019 25 3 2019 2019w12 2019m3 Monday | 427. | 427 726 26mar2019 26 3 2019 2019w13 2019m3 Tuesday | |------------------------------------------------------------------------------| 428. | 428 1249 27mar2019 27 3 2019 2019w13 2019m3 Wednesday | 429. | 429 927 28mar2019 28 3 2019 2019w13 2019m3 Thursday | 430. | 430 725 29mar2019 29 3 2019 2019w13 2019m3 Friday | 431. | 431 655 30mar2019 30 3 2019 2019w13 2019m3 Saturday | 432. | 432 851 31mar2019 31 3 2019 2019w13 2019m3 Sunday | |------------------------------------------------------------------------------| 433. | 433 987 01apr2019 1 4 2019 2019w13 2019m4 Monday | 434. | 434 700 02apr2019 2 4 2019 2019w14 2019m4 Tuesday | 435. | 435 616 03apr2019 3 4 2019 2019w14 2019m4 Wednesday | +------------------------------------------------------------------------------+
For days in 2018, please get it there
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 07, 2019, 09:14:43 AM Last edit: April 07, 2019, 09:44:34 AM by tranthidung |
|
Time-series plots:Full dataset:Truncated dataset: Basic statistics:Full dataset:. tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 431.0 773.5 496.6 641.0 529.0 797.0 312.0 4493.0 ----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 127 or 1199 . di 797-529 268
. di 268*1.5 402
. di 797+402 1199
. di 529-402 127
There are 42 outliers in full dataset, in total. Those days are: . count if (merit >= 1199 | merit <= 127) & merit != . 42
. list id merit date if (merit >= 1199 | merit <= 127) & merit != .
+-------------------------+ | id merit date | |-------------------------| 1. | 3 4493 26jan2018 | 2. | 4 3489 27jan2018 | 3. | 5 3188 28jan2018 | 4. | 6 3799 29jan2018 | 5. | 7 4192 30jan2018 | |-------------------------| 6. | 8 2820 31jan2018 | 7. | 9 2545 01feb2018 | 8. | 10 2568 02feb2018 | 9. | 11 1867 03feb2018 | 10. | 12 2167 04feb2018 | |-------------------------| 11. | 13 2077 05feb2018 | 12. | 14 2308 06feb2018 | 13. | 15 2141 07feb2018 | 14. | 16 2141 08feb2018 | 15. | 17 1448 09feb2018 | |-------------------------| 16. | 18 1747 10feb2018 | 17. | 19 1442 11feb2018 | 18. | 20 1331 12feb2018 | 19. | 21 1579 13feb2018 | 20. | 22 2513 14feb2018 | |-------------------------| 21. | 23 1991 15feb2018 | 22. | 24 1411 16feb2018 | 23. | 25 1608 17feb2018 | 24. | 26 1289 18feb2018 | 25. | 27 1403 19feb2018 | |-------------------------| 27. | 29 1266 21feb2018 | 28. | 30 1279 22feb2018 | 30. | 32 1409 24feb2018 | 32. | 34 1382 26feb2018 | 33. | 35 1326 27feb2018 | |-------------------------| 35. | 37 1333 01mar2018 | 36. | 38 1696 02mar2018 | 39. | 41 1245 05mar2018 | 46. | 48 1354 12mar2018 | 54. | 56 1322 20mar2018 | |-------------------------| 55. | 57 1227 21mar2018 | 66. | 68 1233 01apr2018 | 234. | 236 2463 16sep2018 | 235. | 237 1862 17sep2018 | 236. | 238 1294 18sep2018 | |-------------------------| 237. | 239 1268 19sep2018 | 426. | 428 1249 27mar2019 | +-------------------------+
Only one of them occured in 2019, on 27/3/2019, at 1249 merits circulated in total. Truncated dataset:. tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 407.0 681.2 245.9 626.0 522.0 764.0 312.0 2463.0 ----------------------------------------------------------------------------------------------
Applied same formulas I used in earlier analyses, potential outliers are days have intra-day merits beyond 159 or 1127. . di 764-522 242
. di 242*1.5 363
. di 764+363 1127
. di 522-363 159
There are 26 outliers in total, only three of them occured in 2019, on 09/1/2019, 14/01/2019, and 27/3/2019, at 1161, 1127, and 1249, respectively. . count if (merit >= 1127 | merit <= 159) & merit != . 26
. list id merit date if (merit >= 1127 | merit <= 159) & merit != .
+-------------------------+ | id merit date | |-------------------------| 1. | 27 1403 19feb2018 | 2. | 28 1169 20feb2018 | 3. | 29 1266 21feb2018 | 4. | 30 1279 22feb2018 | 6. | 32 1409 24feb2018 | |-------------------------| 7. | 33 1186 25feb2018 | 8. | 34 1382 26feb2018 | 9. | 35 1326 27feb2018 | 11. | 37 1333 01mar2018 | 12. | 38 1696 02mar2018 | |-------------------------| 15. | 41 1245 05mar2018 | 22. | 48 1354 12mar2018 | 24. | 50 1159 14mar2018 | 25. | 51 1130 15mar2018 | 30. | 56 1322 20mar2018 | |-------------------------| 31. | 57 1227 21mar2018 | 42. | 68 1233 01apr2018 | 43. | 69 1146 02apr2018 | 127. | 153 1138 25jun2018 | 210. | 236 2463 16sep2018 | |-------------------------| 211. | 237 1862 17sep2018 | 212. | 238 1294 18sep2018 | 213. | 239 1268 19sep2018 | 325. | 351 1161 09jan2019 | 330. | 356 1127 14jan2019 | |-------------------------| 402. | 428 1249 27mar2019 | +-------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 07, 2019, 09:19:04 AM |
|
List of the top 50-highest day in terms of intra-day merits: . list merit id date dofw day month2 year week month
+-------------------------------------------------------------------------------+ | merit id date dofw day month2 year week month | |-------------------------------------------------------------------------------| 1. | 13018 1 24jan2018 Wednesday 24 1 2018 2018w4 2018m1 | 2. | 6761 2 25jan2018 Thursday 25 1 2018 2018w4 2018m1 | 3. | 4493 3 26jan2018 Friday 26 1 2018 2018w4 2018m1 | 4. | 4192 7 30jan2018 Tuesday 30 1 2018 2018w5 2018m1 | 5. | 3799 6 29jan2018 Monday 29 1 2018 2018w5 2018m1 | |-------------------------------------------------------------------------------| 6. | 3489 4 27jan2018 Saturday 27 1 2018 2018w4 2018m1 | 7. | 3188 5 28jan2018 Sunday 28 1 2018 2018w4 2018m1 | 8. | 2820 8 31jan2018 Wednesday 31 1 2018 2018w5 2018m1 | 9. | 2568 10 02feb2018 Friday 2 2 2018 2018w5 2018m2 | 10. | 2545 9 01feb2018 Thursday 1 2 2018 2018w5 2018m2 | |-------------------------------------------------------------------------------| 11. | 2513 22 14feb2018 Wednesday 14 2 2018 2018w7 2018m2 | 12. | 2463 236 16sep2018 Sunday 16 9 2018 2018w37 2018m9 | 13. | 2308 14 06feb2018 Tuesday 6 2 2018 2018w6 2018m2 | 14. | 2167 12 04feb2018 Sunday 4 2 2018 2018w5 2018m2 | 15. | 2141 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. | 1249 428 27mar2019 Wednesday 27 3 2019 2019w13 2019m3 | 42. | 1245 41 05mar2018 Monday 5 3 2018 2018w10 2018m3 | 43. | 1233 68 01apr2018 Sunday 1 4 2018 2018w13 2018m4 | 44. | 1227 57 21mar2018 Wednesday 21 3 2018 2018w12 2018m3 | 45. | 1186 33 25feb2018 Sunday 25 2 2018 2018w8 2018m2 | |-------------------------------------------------------------------------------| 46. | 1169 28 20feb2018 Tuesday 20 2 2018 2018w8 2018m2 | 47. | 1161 351 09jan2019 Wednesday 9 1 2019 2019w2 2019m1 | 48. | 1159 50 14mar2018 Wednesday 14 3 2018 2018w11 2018m3 | 49. | 1146 69 02apr2018 Monday 2 4 2018 2018w14 2018m4 | 50. | 1138 153 25jun2018 Monday 25 6 2018 2018w26 2018m6 | |-------------------------------------------------------------------------------|
List of the top 50-lowest days in terms of intra-day merits: . list merit id date dofw day month2 year week month
+-------------------------------------------------------------------------------+ | merit id date dofw day month2 year week month | |-------------------------------------------------------------------------------| 1. | 312 335 24dec2018 Monday 24 12 2018 2018w52 2018m12 | 2. | 316 333 22dec2018 Saturday 22 12 2018 2018w51 2018m12 | 3. | 325 340 29dec2018 Saturday 29 12 2018 2018w52 2018m12 | 4. | 347 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 403 02mar2019 Saturday 2 3 2019 2019w9 2019m3 | 23. | 412 222 02sep2018 Sunday 2 9 2018 2018w35 2018m9 | 24. | 415 109 12may2018 Saturday 12 5 2018 2018w19 2018m5 | 25. | 415 278 28oct2018 Sunday 28 10 2018 2018w43 2018m10 | |-------------------------------------------------------------------------------| 26. | 418 186 28jul2018 Saturday 28 7 2018 2018w30 2018m7 | 27. | 420 187 29jul2018 Sunday 29 7 2018 2018w30 2018m7 | 28. | 421 192 03aug2018 Friday 3 8 2018 2018w31 2018m8 | 29. | 422 140 12jun2018 Tuesday 12 6 2018 2018w24 2018m6 | 30. | 424 276 26oct2018 Friday 26 10 2018 2018w43 2018m10 | |-------------------------------------------------------------------------------| 31. | 424 313 02dec2018 Sunday 2 12 2018 2018w48 2018m12 | 32. | 426 277 27oct2018 Saturday 27 10 2018 2018w43 2018m10 | 33. | 428 418 17mar2019 Sunday 17 3 2019 2019w11 2019m3 | 34. | 430 284 03nov2018 Saturday 3 11 2018 2018w44 2018m11 | 35. | 430 264 14oct2018 Sunday 14 10 2018 2018w41 2018m10 | |-------------------------------------------------------------------------------| 36. | 432 208 19aug2018 Sunday 19 8 2018 2018w33 2018m8 | 37. | 432 221 01sep2018 Saturday 1 9 2018 2018w35 2018m9 | 38. | 433 282 01nov2018 Thursday 1 11 2018 2018w44 2018m11 | 39. | 435 154 26jun2018 Tuesday 26 6 2018 2018w26 2018m6 | 40. | 435 190 01aug2018 Wednesday 1 8 2018 2018w31 2018m8 | |-------------------------------------------------------------------------------| 41. | 444 182 24jul2018 Tuesday 24 7 2018 2018w30 2018m7 | 42. | 445 143 15jun2018 Friday 15 6 2018 2018w24 2018m6 | 43. | 450 373 31jan2019 Thursday 31 1 2019 2019w5 2019m1 | 44. | 451 206 17aug2018 Friday 17 8 2018 2018w33 2018m8 | 45. | 454 283 02nov2018 Friday 2 11 2018 2018w44 2018m11 | |-------------------------------------------------------------------------------| 46. | 455 167 09jul2018 Monday 9 7 2018 2018w28 2018m7 | 47. | 455 229 09sep2018 Sunday 9 9 2018 2018w36 2018m9 | 48. | 457 216 27aug2018 Monday 27 8 2018 2018w35 2018m8 | 49. | 458 324 13dec2018 Thursday 13 12 2018 2018w50 2018m12 | 50. | 458 227 07sep2018 Friday 7 9 2018 2018w36 2018m9 | |-------------------------------------------------------------------------------|
During the period from 24/1/2018 to 01/4/2019, the minimum and maximum of intra-day merits are 312 and 13018 , on 24/12/2018 and 24/1/2018, respectively.
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 07, 2019, 09:29:53 AM |
|
Medians and means of intra-day merits over days of weeks.Colors: - Green: highest.- Red: Lowest.- In median, the highest days are Wednesday, Monday, and Thursday at 660, 658, and 649, respectively; whislt the lowest days are Friday, Sunday, and Saturday, at 569, 608, and 619, respectively. - In means, the highest days are Monday, Wednesday, and Sunday at 742, 721, and 695, respectively; whilst the lowest days are Friday, Saturday, and Thursday at 616, 623, and 677, respectively. - There was a flippening in highest median intraday merits last week, between Wednesday and Monday, but the gap between them are small, only 2 merit points. So, in general, Monday has still been the highest day in terms of median intra-day merits over weeks. Calendar day is in GMT time.To take away all doubt: the first Merit was this one: 1516831941 1 2818066.msg28853325 35 877396 Use EpochConverter to convert 1516831941 (Unix Time) to GMT: Wednesday 24 January 2018 22:12:21. Basic statistics:. 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 | 58.0 694.8 318.1 607.5 486.0 804.0 389.0 2463.0 Monday | 59.0 741.4 285.5 658.0 565.0 822.0 312.0 1862.0 Tuesday | 58.0 695.8 216.5 634.5 580.0 760.0 383.0 1326.0 Wednesday | 58.0 720.2 220.9 659.5 559.0 761.0 435.0 1268.0 Thursday | 58.0 676.2 214.7 646.5 514.0 774.0 347.0 1333.0 Friday | 58.0 615.9 217.2 569.0 487.0 698.0 348.0 1696.0 Saturday | 58.0 622.8 210.0 618.5 463.0 688.0 316.0 1409.0 ----------+-------------------------------------------------------------------------------- Total | 407.0 681.2 245.9 626.0 522.0 764.0 312.0 2463.0 -------------------------------------------------------------------------------------------
Box plotsOutliers displayed as red circles. Outliers non-displayed.
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 07, 2019, 09:36:08 AM Last edit: April 13, 2019, 02:12:41 PM by tranthidung |
|
Update on intra-week merits (from 24/1/2018 to 01/4/2019)Converted dataset:. list merit week
+-----------------+ | merit week | |-----------------| 1. | 30949 2018w4 | 2. | 19958 2018w5 | 3. | 13304 2018w6 | 4. | 11722 2018w7 | 5. | 8758 2018w8 | |-----------------| 6. | 8806 2018w9 | 7. | 7253 2018w10 | 8. | 7309 2018w11 | 9. | 6941 2018w12 | 10. | 6707 2018w13 | |-----------------| 11. | 6415 2018w14 | 12. | 5487 2018w15 | 13. | 4631 2018w16 | 14. | 4585 2018w17 | 15. | 4953 2018w18 | |-----------------| 16. | 4753 2018w19 | 17. | 4346 2018w20 | 18. | 3854 2018w21 | 19. | 4183 2018w22 | 20. | 4527 2018w23 | |-----------------| 21. | 3818 2018w24 | 22. | 4921 2018w25 | 23. | 4457 2018w26 | 24. | 4253 2018w27 | 25. | 4239 2018w28 | |-----------------| 26. | 4159 2018w29 | 27. | 3652 2018w30 | 28. | 3798 2018w31 | 29. | 3994 2018w32 | 30. | 3618 2018w33 | |-----------------| 31. | 3789 2018w34 | 32. | 3065 2018w35 | 33. | 3574 2018w36 | 34. | 5630 2018w37 | 35. | 7825 2018w38 | |-----------------| 36. | 4388 2018w39 | 37. | 4271 2018w40 | 38. | 3800 2018w41 | 39. | 4821 2018w42 | 40. | 3945 2018w43 | |-----------------| 41. | 3339 2018w44 | 42. | 4513 2018w45 | 43. | 3722 2018w46 | 44. | 4558 2018w47 | 45. | 3750 2018w48 | |-----------------| 46. | 3560 2018w49 | 47. | 3782 2018w50 | 48. | 3753 2018w51 | 49. | 3278 2018w52 | 50. | 4793 2019w1 | |-----------------| 51. | 6624 2019w2 | 52. | 5306 2019w3 | 53. | 4659 2019w4 | 54. | 4474 2019w5 | 55. | 4318 2019w6 | |-----------------| 56. | 4207 2019w7 | 57. | 4507 2019w8 | 58. | 4625 2019w9 | 59. | 4901 2019w10 | 60. | 4318 2019w11 | |-----------------| 61. | 4598 2019w12 | 62. | 6120 2019w13 | +-----------------+
Time series plotBasic statistics:- 50% of observed weeks (62 weeks) have total intra-week merits above 4510, whilst the rest 50% of them have total intra-week merits below 4510. 4510 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 3854 to 5487 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3065 - 30949. . tabstat merit, s(n mean sd p50 p25 p75 min max)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 62 5696.177 4211.547 4510 3854 5487 3065 30949 ----------------------------------------------------------------------------------------------
Potential outliers: . di 5487-3854 1633
. di 1633*1.5 2449.5
. di 5487+2449.5 7936.5
. di 3854-2449.5 1404.5
It means that potential outliers are weeks that have intra-week merits beyond 1405 or 7937. How many weeks are potential outliers? . count if (merit >= 7937 | merit < 1405) & merit != . 6
7 weeks are outliers, in total. List of those seven weeks: . list merit week if merit >=7937 | merit <= 1405
+----------------+ | merit week | |----------------| 1. | 30949 2018w4 | 2. | 19958 2018w5 | 3. | 13304 2018w6 | 4. | 11722 2018w7 | 5. | 8758 2018w8 | |----------------| 6. | 8806 2018w9 | +----------------+
All of them occured in the year 2018. ![Grin](https://bitcointalk.org/Smileys/default/grin.gif)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 07, 2019, 09:43:25 AM Last edit: April 13, 2019, 02:25:22 PM by tranthidung |
|
ABSTRACT
Intra-day merits: Notes: - The part of the asbstract describes figures of intraday merits over the period from 19/2/2018 to 01/4/2019 (truncated dataset); - Days from 24/1/2018 to 18/2/2018 truncated due to highly potential outliers; and days after 01/4/2019 truncated as well due to incomplete week (the 2019w14); - Statistics presented in the post are for truncated dataset
(1) Potential outliers are days that have intraday total merits beyond 159 or 1127; (2) Median of intraday merits over the period is 626; (3) 50% of observed days have their intra-day merits range from 522 to 764 (the interquartile range); (4) Friday [in GTM time] is the day over weeks has lowest intraday merits in terms of both median and mean, at 569, and 616, respectively. (5) Monday [in GTM time] is the day over weeks has highest intraday merits in terms of mean, at 742. (6) There is a flippening between Wednesday and Monday in terms of highest intra-day merits, with figures for Wednesday and Monday are 660 and 658, respectively; (7) There are 26 potential outliers in total, and there is only three potential outlier days happened in early weeks of 2019, on 09/01/2019, 14/01/2019, and 27/3/2019, at 1161, 1127, and 1249, respectively. <8> Minimum and maximum of intraday merits (full dataset) are 312 and 13018, on 11/2/2019 and 24/1/2018 respectively.
Intra-week merits: Notes: The part of the abstract use full dataset, only dropped last two days due to incomple week (2019w13).
(1) The median of intra-week merits is 4510; (2) 50% of observed weeks (62 weeeks in total), have total merits in the range from 3854 to 5487 (the interquaritle range of intra-week merits); (3) Minimum and maximum of intraweek merits are 3065 and 30949, in 2018w35, and 2018w4, respectively; (4) Seven potential outliers [beyond 1405 or 7937], all of them occurred in the year 2018.
|
|
|
|
LoyceV
Legendary
Offline
Activity: 3416
Merit: 17265
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 13, 2019, 09:01:33 AM |
|
UpdatePer dayDay 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: 450 Merit Day 374: 595 Merit Day 375: 940 Merit Day 376: 571 Merit Day 377: 796 Merit Day 378: 776 Merit Day 379: 559 Merit Day 380: 548 Merit Day 381: 611 Merit Day 382: 623 Merit Day 383: 559 Merit Day 384: 642 Merit Day 385: 585 Merit Day 386: 671 Merit Day 387: 649 Merit Day 388: 607 Merit Day 389: 523 Merit Day 390: 607 Merit Day 391: 565 Merit Day 392: 637 Merit Day 393: 696 Merit Day 394: 504 Merit Day 395: 509 Merit Day 396: 657 Merit Day 397: 608 Merit Day 398: 896 Merit Day 399: 736 Merit Day 400: 553 Merit Day 401: 707 Merit Day 402: 508 Merit Day 403: 412 Merit Day 404: 1001 Merit Day 405: 708 Merit Day 406: 677 Merit Day 407: 787 Merit Day 408: 711 Merit Day 409: 712 Merit Day 410: 723 Merit Day 411: 656 Merit Day 412: 635 Merit Day 413: 680 Merit Day 414: 687 Merit Day 415: 804 Merit Day 416: 580 Merit Day 417: 482 Merit Day 418: 428 Merit Day 419: 657 Merit Day 420: 758 Merit Day 421: 651 Merit Day 422: 720 Merit Day 423: 674 Merit Day 424: 625 Merit Day 425: 594 Merit Day 426: 576 Merit Day 427: 726 Merit Day 428: 1249 Merit Day 429: 927 Merit Day 430: 725 Merit Day 431: 655 Merit Day 432: 851 Merit Day 433: 987 Merit Day 434: 700 Merit Day 435: 616 Merit Day 436: 532 Merit Day 437: 516 Merit Day 438: 618 Merit Day 439: 728 Merit Day 440: 708 Merit Day 441: 707 Merit Day 442: 741 Merit Day 443: 111 Merit (incomplete day) Per weekWeek 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: 4657 Merit Week 55: 4137 Merit Week 56: 4269 Merit Week 57: 4618 Merit Week 58: 4581 Merit Week 59: 4912 Merit Week 60: 4402 Merit Week 61: 4576 Merit Week 62: 6103 Merit Week 63: 4432 Merit Week 64: 854 Merit (incomplete week)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 13, 2019, 10:46:02 AM |
|
Update:Converted intra-day merits for days in 2019. . 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 | |------------------------------------------------------------------------------| 373. | 373 450 31jan2019 31 1 2019 2019w5 2019m1 Thursday | 374. | 374 595 01feb2019 1 2 2019 2019w5 2019m2 Friday | 375. | 375 940 02feb2019 2 2 2019 2019w5 2019m2 Saturday | 376. | 376 571 03feb2019 3 2 2019 2019w5 2019m2 Sunday | 377. | 377 796 04feb2019 4 2 2019 2019w5 2019m2 Monday | |------------------------------------------------------------------------------| 378. | 378 776 05feb2019 5 2 2019 2019w6 2019m2 Tuesday | 379. | 379 559 06feb2019 6 2 2019 2019w6 2019m2 Wednesday | 380. | 380 548 07feb2019 7 2 2019 2019w6 2019m2 Thursday | 381. | 381 611 08feb2019 8 2 2019 2019w6 2019m2 Friday | 382. | 382 623 09feb2019 9 2 2019 2019w6 2019m2 Saturday | |------------------------------------------------------------------------------| 383. | 383 559 10feb2019 10 2 2019 2019w6 2019m2 Sunday | 384. | 384 642 11feb2019 11 2 2019 2019w6 2019m2 Monday | 385. | 385 585 12feb2019 12 2 2019 2019w7 2019m2 Tuesday | 386. | 386 671 13feb2019 13 2 2019 2019w7 2019m2 Wednesday | 387. | 387 649 14feb2019 14 2 2019 2019w7 2019m2 Thursday | |------------------------------------------------------------------------------| 388. | 388 607 15feb2019 15 2 2019 2019w7 2019m2 Friday | 389. | 389 523 16feb2019 16 2 2019 2019w7 2019m2 Saturday | 390. | 390 607 17feb2019 17 2 2019 2019w7 2019m2 Sunday | 391. | 391 565 18feb2019 18 2 2019 2019w7 2019m2 Monday | 392. | 392 637 19feb2019 19 2 2019 2019w8 2019m2 Tuesday | |------------------------------------------------------------------------------| 393. | 393 696 20feb2019 20 2 2019 2019w8 2019m2 Wednesday | 394. | 394 504 21feb2019 21 2 2019 2019w8 2019m2 Thursday | 395. | 395 509 22feb2019 22 2 2019 2019w8 2019m2 Friday | 396. | 396 657 23feb2019 23 2 2019 2019w8 2019m2 Saturday | 397. | 397 608 24feb2019 24 2 2019 2019w8 2019m2 Sunday | |------------------------------------------------------------------------------| 398. | 398 896 25feb2019 25 2 2019 2019w8 2019m2 Monday | 399. | 399 736 26feb2019 26 2 2019 2019w9 2019m2 Tuesday | 400. | 400 553 27feb2019 27 2 2019 2019w9 2019m2 Wednesday | 401. | 401 707 28feb2019 28 2 2019 2019w9 2019m2 Thursday | 402. | 402 508 01mar2019 1 3 2019 2019w9 2019m3 Friday | |------------------------------------------------------------------------------| 403. | 403 412 02mar2019 2 3 2019 2019w9 2019m3 Saturday | 404. | 404 1001 03mar2019 3 3 2019 2019w9 2019m3 Sunday | 405. | 405 708 04mar2019 4 3 2019 2019w9 2019m3 Monday | 406. | 406 677 05mar2019 5 3 2019 2019w10 2019m3 Tuesday | 407. | 407 787 06mar2019 6 3 2019 2019w10 2019m3 Wednesday | |------------------------------------------------------------------------------| 408. | 408 711 07mar2019 7 3 2019 2019w10 2019m3 Thursday | 409. | 409 712 08mar2019 8 3 2019 2019w10 2019m3 Friday | 410. | 410 723 09mar2019 9 3 2019 2019w10 2019m3 Saturday | 411. | 411 656 10mar2019 10 3 2019 2019w10 2019m3 Sunday | 412. | 412 635 11mar2019 11 3 2019 2019w10 2019m3 Monday | |------------------------------------------------------------------------------| 413. | 413 680 12mar2019 12 3 2019 2019w11 2019m3 Tuesday | 414. | 414 687 13mar2019 13 3 2019 2019w11 2019m3 Wednesday | 415. | 415 804 14mar2019 14 3 2019 2019w11 2019m3 Thursday | 416. | 416 580 15mar2019 15 3 2019 2019w11 2019m3 Friday | 417. | 417 482 16mar2019 16 3 2019 2019w11 2019m3 Saturday | |------------------------------------------------------------------------------| 418. | 418 428 17mar2019 17 3 2019 2019w11 2019m3 Sunday | 419. | 419 657 18mar2019 18 3 2019 2019w11 2019m3 Monday | 420. | 420 758 19mar2019 19 3 2019 2019w12 2019m3 Tuesday | 421. | 421 651 20mar2019 20 3 2019 2019w12 2019m3 Wednesday | 422. | 422 720 21mar2019 21 3 2019 2019w12 2019m3 Thursday | |------------------------------------------------------------------------------| 423. | 423 674 22mar2019 22 3 2019 2019w12 2019m3 Friday | 424. | 424 625 23mar2019 23 3 2019 2019w12 2019m3 Saturday | 425. | 425 594 24mar2019 24 3 2019 2019w12 2019m3 Sunday | 426. | 426 576 25mar2019 25 3 2019 2019w12 2019m3 Monday | 427. | 427 726 26mar2019 26 3 2019 2019w13 2019m3 Tuesday | |------------------------------------------------------------------------------| 428. | 428 1249 27mar2019 27 3 2019 2019w13 2019m3 Wednesday | 429. | 429 927 28mar2019 28 3 2019 2019w13 2019m3 Thursday | 430. | 430 725 29mar2019 29 3 2019 2019w13 2019m3 Friday | 431. | 431 655 30mar2019 30 3 2019 2019w13 2019m3 Saturday | 432. | 432 851 31mar2019 31 3 2019 2019w13 2019m3 Sunday | |------------------------------------------------------------------------------| 433. | 433 987 01apr2019 1 4 2019 2019w13 2019m4 Monday | 434. | 434 700 02apr2019 2 4 2019 2019w14 2019m4 Tuesday | 435. | 435 616 03apr2019 3 4 2019 2019w14 2019m4 Wednesday | 436. | 436 532 04apr2019 4 4 2019 2019w14 2019m4 Thursday | 437. | 437 516 05apr2019 5 4 2019 2019w14 2019m4 Friday | |------------------------------------------------------------------------------| 438. | 438 618 06apr2019 6 4 2019 2019w14 2019m4 Saturday | 439. | 439 728 07apr2019 7 4 2019 2019w14 2019m4 Sunday | 440. | 440 708 08apr2019 8 4 2019 2019w14 2019m4 Monday | 441. | 441 707 09apr2019 9 4 2019 2019w15 2019m4 Tuesday | 442. | 442 741 10apr2019 10 4 2019 2019w15 2019m4 Wednesday | +------------------------------------------------------------------------------+
For days in 2018, please get it there
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 13, 2019, 10:53:15 AM |
|
Time-series plots:Full dataset:Truncated dataset: Basic statistics:Full dataset:. tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 438.0 771.2 493.1 641.0 530.0 796.0 312.0 4493.0 ----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 131 or 1195 . di 796-530 266
. di 266*1.5 399
. di 796+399 1195
. di 530-399 131
There are 42 outliers in full dataset, in total. Those days are: . count if (merit >= 1195 | merit <= 131) & merit != . 42
. list id merit date if (merit >= 1195 | merit <= 131) & merit != .
+-------------------------+ | id merit date | |-------------------------| 1. | 3 4493 26jan2018 | 2. | 4 3489 27jan2018 | 3. | 5 3188 28jan2018 | 4. | 6 3799 29jan2018 | 5. | 7 4192 30jan2018 | |-------------------------| 6. | 8 2820 31jan2018 | 7. | 9 2545 01feb2018 | 8. | 10 2568 02feb2018 | 9. | 11 1867 03feb2018 | 10. | 12 2167 04feb2018 | |-------------------------| 11. | 13 2077 05feb2018 | 12. | 14 2308 06feb2018 | 13. | 15 2141 07feb2018 | 14. | 16 2141 08feb2018 | 15. | 17 1448 09feb2018 | |-------------------------| 16. | 18 1747 10feb2018 | 17. | 19 1442 11feb2018 | 18. | 20 1331 12feb2018 | 19. | 21 1579 13feb2018 | 20. | 22 2513 14feb2018 | |-------------------------| 21. | 23 1991 15feb2018 | 22. | 24 1411 16feb2018 | 23. | 25 1608 17feb2018 | 24. | 26 1289 18feb2018 | 25. | 27 1403 19feb2018 | |-------------------------| 27. | 29 1266 21feb2018 | 28. | 30 1279 22feb2018 | 30. | 32 1409 24feb2018 | 32. | 34 1382 26feb2018 | 33. | 35 1326 27feb2018 | |-------------------------| 35. | 37 1333 01mar2018 | 36. | 38 1696 02mar2018 | 39. | 41 1245 05mar2018 | 46. | 48 1354 12mar2018 | 54. | 56 1322 20mar2018 | |-------------------------| 55. | 57 1227 21mar2018 | 66. | 68 1233 01apr2018 | 234. | 236 2463 16sep2018 | 235. | 237 1862 17sep2018 | 236. | 238 1294 18sep2018 | |-------------------------| 237. | 239 1268 19sep2018 | 426. | 428 1249 27mar2019 | +-------------------------+
Only one of them occured in 2019, on 27/3/2019, at 1249 merits circulated in total. Truncated dataset:. tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 414.0 680.3 244.1 626.0 523.0 760.0 312.0 2463.0 ----------------------------------------------------------------------------------------------
Applied same formulas I used in earlier analyses, potential outliers are days have intra-day merits beyond 168 or 1116. . di 760-523 237
. di 237*1.5 355.5
. di 760+355.5 1115.5
. di 523-355.5 167.5
There are 26 outliers in total, only three of them occured in 2019, on 09/1/2019, 14/01/2019, and 27/3/2019, at 1161, 1127, and 1249, respectively. . count if (merit >= 1116 | merit <= 168) & merit != . 26
. list id merit date if (merit >= 1116 | merit <= 168) & merit != .
+-------------------------+ | id merit date | |-------------------------| 1. | 27 1403 19feb2018 | 2. | 28 1169 20feb2018 | 3. | 29 1266 21feb2018 | 4. | 30 1279 22feb2018 | 6. | 32 1409 24feb2018 | |-------------------------| 7. | 33 1186 25feb2018 | 8. | 34 1382 26feb2018 | 9. | 35 1326 27feb2018 | 11. | 37 1333 01mar2018 | 12. | 38 1696 02mar2018 | |-------------------------| 15. | 41 1245 05mar2018 | 22. | 48 1354 12mar2018 | 24. | 50 1159 14mar2018 | 25. | 51 1130 15mar2018 | 30. | 56 1322 20mar2018 | |-------------------------| 31. | 57 1227 21mar2018 | 42. | 68 1233 01apr2018 | 43. | 69 1146 02apr2018 | 127. | 153 1138 25jun2018 | 210. | 236 2463 16sep2018 | |-------------------------| 211. | 237 1862 17sep2018 | 212. | 238 1294 18sep2018 | 213. | 239 1268 19sep2018 | 325. | 351 1161 09jan2019 | 330. | 356 1127 14jan2019 | |-------------------------| 402. | 428 1249 27mar2019 | +-------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 13, 2019, 10:57:59 AM |
|
List of the top 50-highest day in terms of intra-day merits: . list merit id date dofw day month2 year week month
+-------------------------------------------------------------------------------+ | merit id date dofw day month2 year week month | |-------------------------------------------------------------------------------| 1. | 13018 1 24jan2018 Wednesday 24 1 2018 2018w4 2018m1 | 2. | 6761 2 25jan2018 Thursday 25 1 2018 2018w4 2018m1 | 3. | 4493 3 26jan2018 Friday 26 1 2018 2018w4 2018m1 | 4. | 4192 7 30jan2018 Tuesday 30 1 2018 2018w5 2018m1 | 5. | 3799 6 29jan2018 Monday 29 1 2018 2018w5 2018m1 | |-------------------------------------------------------------------------------| 6. | 3489 4 27jan2018 Saturday 27 1 2018 2018w4 2018m1 | 7. | 3188 5 28jan2018 Sunday 28 1 2018 2018w4 2018m1 | 8. | 2820 8 31jan2018 Wednesday 31 1 2018 2018w5 2018m1 | 9. | 2568 10 02feb2018 Friday 2 2 2018 2018w5 2018m2 | 10. | 2545 9 01feb2018 Thursday 1 2 2018 2018w5 2018m2 | |-------------------------------------------------------------------------------| 11. | 2513 22 14feb2018 Wednesday 14 2 2018 2018w7 2018m2 | 12. | 2463 236 16sep2018 Sunday 16 9 2018 2018w37 2018m9 | 13. | 2308 14 06feb2018 Tuesday 6 2 2018 2018w6 2018m2 | 14. | 2167 12 04feb2018 Sunday 4 2 2018 2018w5 2018m2 | 15. | 2141 15 07feb2018 Wednesday 7 2 2018 2018w6 2018m2 | |-------------------------------------------------------------------------------| 16. | 2141 16 08feb2018 Thursday 8 2 2018 2018w6 2018m2 | 17. | 2077 13 05feb2018 Monday 5 2 2018 2018w6 2018m2 | 18. | 1991 23 15feb2018 Thursday 15 2 2018 2018w7 2018m2 | 19. | 1867 11 03feb2018 Saturday 3 2 2018 2018w5 2018m2 | 20. | 1862 237 17sep2018 Monday 17 9 2018 2018w38 2018m9 | |-------------------------------------------------------------------------------| 21. | 1747 18 10feb2018 Saturday 10 2 2018 2018w6 2018m2 | 22. | 1696 38 02mar2018 Friday 2 3 2018 2018w9 2018m3 | 23. | 1608 25 17feb2018 Saturday 17 2 2018 2018w7 2018m2 | 24. | 1579 21 13feb2018 Tuesday 13 2 2018 2018w7 2018m2 | 25. | 1448 17 09feb2018 Friday 9 2 2018 2018w6 2018m2 | |-------------------------------------------------------------------------------| 26. | 1442 19 11feb2018 Sunday 11 2 2018 2018w6 2018m2 | 27. | 1411 24 16feb2018 Friday 16 2 2018 2018w7 2018m2 | 28. | 1409 32 24feb2018 Saturday 24 2 2018 2018w8 2018m2 | 29. | 1403 27 19feb2018 Monday 19 2 2018 2018w8 2018m2 | 30. | 1382 34 26feb2018 Monday 26 2 2018 2018w9 2018m2 | |-------------------------------------------------------------------------------| 31. | 1354 48 12mar2018 Monday 12 3 2018 2018w11 2018m3 | 32. | 1333 37 01mar2018 Thursday 1 3 2018 2018w9 2018m3 | 33. | 1331 20 12feb2018 Monday 12 2 2018 2018w7 2018m2 | 34. | 1326 35 27feb2018 Tuesday 27 2 2018 2018w9 2018m2 | 35. | 1322 56 20mar2018 Tuesday 20 3 2018 2018w12 2018m3 | |-------------------------------------------------------------------------------| 36. | 1294 238 18sep2018 Tuesday 18 9 2018 2018w38 2018m9 | 37. | 1289 26 18feb2018 Sunday 18 2 2018 2018w7 2018m2 | 38. | 1279 30 22feb2018 Thursday 22 2 2018 2018w8 2018m2 | 39. | 1268 239 19sep2018 Wednesday 19 9 2018 2018w38 2018m9 | 40. | 1266 29 21feb2018 Wednesday 21 2 2018 2018w8 2018m2 | |-------------------------------------------------------------------------------| 41. | 1249 428 27mar2019 Wednesday 27 3 2019 2019w13 2019m3 | 42. | 1245 41 05mar2018 Monday 5 3 2018 2018w10 2018m3 | 43. | 1233 68 01apr2018 Sunday 1 4 2018 2018w13 2018m4 | 44. | 1227 57 21mar2018 Wednesday 21 3 2018 2018w12 2018m3 | 45. | 1186 33 25feb2018 Sunday 25 2 2018 2018w8 2018m2 | |-------------------------------------------------------------------------------| 46. | 1169 28 20feb2018 Tuesday 20 2 2018 2018w8 2018m2 | 47. | 1161 351 09jan2019 Wednesday 9 1 2019 2019w2 2019m1 | 48. | 1159 50 14mar2018 Wednesday 14 3 2018 2018w11 2018m3 | 49. | 1146 69 02apr2018 Monday 2 4 2018 2018w14 2018m4 | 50. | 1138 153 25jun2018 Monday 25 6 2018 2018w26 2018m6 | |-------------------------------------------------------------------------------|
List of the top 50-lowest days in terms of intra-day merits: . list merit id date dofw day month2 year week month
+-------------------------------------------------------------------------------+ | merit id date dofw day month2 year week month | |-------------------------------------------------------------------------------| 1. | 312 335 24dec2018 Monday 24 12 2018 2018w52 2018m12 | 2. | 316 333 22dec2018 Saturday 22 12 2018 2018w51 2018m12 | 3. | 325 340 29dec2018 Saturday 29 12 2018 2018w52 2018m12 | 4. | 347 298 17nov2018 Saturday 17 11 2018 2018w46 2018m11 | 5. | 347 338 27dec2018 Thursday 27 12 2018 2018w52 2018m12 | |-------------------------------------------------------------------------------| 6. | 348 304 23nov2018 Friday 23 11 2018 2018w47 2018m11 | 7. | 370 122 25may2018 Friday 25 5 2018 2018w21 2018m5 | 8. | 376 191 02aug2018 Thursday 2 8 2018 2018w31 2018m8 | 9. | 376 342 31dec2018 Monday 31 12 2018 2018w52 2018m12 | 10. | 377 326 15dec2018 Saturday 15 12 2018 2018w50 2018m12 | |-------------------------------------------------------------------------------| 11. | 379 220 31aug2018 Friday 31 8 2018 2018w35 2018m8 | 12. | 383 217 28aug2018 Tuesday 28 8 2018 2018w35 2018m8 | 13. | 385 214 25aug2018 Saturday 25 8 2018 2018w34 2018m8 | 14. | 386 339 28dec2018 Friday 28 12 2018 2018w52 2018m12 | 15. | 389 341 30dec2018 Sunday 30 12 2018 2018w52 2018m12 | |-------------------------------------------------------------------------------| 16. | 394 345 03jan2019 Thursday 3 1 2019 2019w1 2019m1 | 17. | 395 228 08sep2018 Saturday 8 9 2018 2018w36 2018m9 | 18. | 397 320 09dec2018 Sunday 9 12 2018 2018w49 2018m12 | 19. | 399 262 12oct2018 Friday 12 10 2018 2018w41 2018m10 | 20. | 402 329 18dec2018 Tuesday 18 12 2018 2018w51 2018m12 | |-------------------------------------------------------------------------------| 21. | 405 287 06nov2018 Tuesday 6 11 2018 2018w45 2018m11 | 22. | 412 403 02mar2019 Saturday 2 3 2019 2019w9 2019m3 | 23. | 412 222 02sep2018 Sunday 2 9 2018 2018w35 2018m9 | 24. | 415 278 28oct2018 Sunday 28 10 2018 2018w43 2018m10 | 25. | 415 109 12may2018 Saturday 12 5 2018 2018w19 2018m5 | |-------------------------------------------------------------------------------| 26. | 418 186 28jul2018 Saturday 28 7 2018 2018w30 2018m7 | 27. | 420 187 29jul2018 Sunday 29 7 2018 2018w30 2018m7 | 28. | 421 192 03aug2018 Friday 3 8 2018 2018w31 2018m8 | 29. | 422 140 12jun2018 Tuesday 12 6 2018 2018w24 2018m6 | 30. | 424 276 26oct2018 Friday 26 10 2018 2018w43 2018m10 | |-------------------------------------------------------------------------------| 31. | 424 313 02dec2018 Sunday 2 12 2018 2018w48 2018m12 | 32. | 426 277 27oct2018 Saturday 27 10 2018 2018w43 2018m10 | 33. | 428 418 17mar2019 Sunday 17 3 2019 2019w11 2019m3 | 34. | 430 284 03nov2018 Saturday 3 11 2018 2018w44 2018m11 | 35. | 430 264 14oct2018 Sunday 14 10 2018 2018w41 2018m10 | |-------------------------------------------------------------------------------| 36. | 432 221 01sep2018 Saturday 1 9 2018 2018w35 2018m9 | 37. | 432 208 19aug2018 Sunday 19 8 2018 2018w33 2018m8 | 38. | 433 282 01nov2018 Thursday 1 11 2018 2018w44 2018m11 | 39. | 435 190 01aug2018 Wednesday 1 8 2018 2018w31 2018m8 | 40. | 435 154 26jun2018 Tuesday 26 6 2018 2018w26 2018m6 | |-------------------------------------------------------------------------------| 41. | 444 182 24jul2018 Tuesday 24 7 2018 2018w30 2018m7 | 42. | 445 143 15jun2018 Friday 15 6 2018 2018w24 2018m6 | 43. | 450 373 31jan2019 Thursday 31 1 2019 2019w5 2019m1 | 44. | 451 206 17aug2018 Friday 17 8 2018 2018w33 2018m8 | 45. | 454 283 02nov2018 Friday 2 11 2018 2018w44 2018m11 | |-------------------------------------------------------------------------------| 46. | 455 167 09jul2018 Monday 9 7 2018 2018w28 2018m7 | 47. | 455 229 09sep2018 Sunday 9 9 2018 2018w36 2018m9 | 48. | 457 216 27aug2018 Monday 27 8 2018 2018w35 2018m8 | 49. | 458 227 07sep2018 Friday 7 9 2018 2018w36 2018m9 | 50. | 458 324 13dec2018 Thursday 13 12 2018 2018w50 2018m12 | |-------------------------------------------------------------------------------|
During the period from 24/1/2018 to 08/4/2019, the minimum and maximum of intra-day merits are 312 and 13018 , on 24/12/2018 and 24/1/2018, respectively.
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 13, 2019, 02:08:50 PM |
|
Medians and means of intra-day merits over days of weeks.Colors: - Green: highest.- Red: Lowest.- In median, the highest days are Monday, Wednesday, and Thursday at 666, 654, and 644, respectively; whislt the lowest days are Friday, Sunday, and Saturday, at 567, 608, and 618, respectively. - In means, the highest days are Monday, Wednesday, Sunday, and Tuesday at 740, 719, and 696 (the last twos), respectively; whilst the lowest days are Friday, Saturday, and Thursday at 615, 623, and 674, respectively. - Monday has still been the highest day in terms of median and mean of intra-day merits over weeks, in contrast Friday is the lowest days in terms of median, and mean of intra-day merits over weeks. Calendar day is in GMT time.To take away all doubt: the first Merit was this one: 1516831941 1 2818066.msg28853325 35 877396 Use EpochConverter to convert 1516831941 (Unix Time) to GMT: Wednesday 24 January 2018 22:12:21. Basic statistics:. 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 | 59.0 695.3 315.4 608.0 486.0 804.0 389.0 2463.0 Monday | 60.0 740.8 283.1 666.0 567.5 815.0 312.0 1862.0 Tuesday | 59.0 695.9 214.6 637.0 580.0 760.0 383.0 1326.0 Wednesday | 59.0 718.4 219.4 654.0 559.0 761.0 435.0 1268.0 Thursday | 59.0 673.8 213.6 644.0 514.0 774.0 347.0 1333.0 Friday | 59.0 614.3 215.7 567.0 487.0 698.0 348.0 1696.0 Saturday | 59.0 622.7 208.2 618.0 463.0 688.0 316.0 1409.0 ----------+-------------------------------------------------------------------------------- Total | 414.0 680.3 244.1 626.0 523.0 760.0 312.0 2463.0 -------------------------------------------------------------------------------------------
Box plotsOutliers displayed as red circles. Outliers non-displayed.
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 13, 2019, 02:19:06 PM |
|
Update on intra-week merits (from 24/1/2018 to 08/4/2019)Converted dataset:. list merit week
+-----------------+ | merit week | |-----------------| 1. | 30949 2018w4 | 2. | 19958 2018w5 | 3. | 13304 2018w6 | 4. | 11722 2018w7 | 5. | 8758 2018w8 | |-----------------| 6. | 8806 2018w9 | 7. | 7253 2018w10 | 8. | 7309 2018w11 | 9. | 6941 2018w12 | 10. | 6707 2018w13 | |-----------------| 11. | 6415 2018w14 | 12. | 5487 2018w15 | 13. | 4631 2018w16 | 14. | 4585 2018w17 | 15. | 4953 2018w18 | |-----------------| 16. | 4753 2018w19 | 17. | 4346 2018w20 | 18. | 3854 2018w21 | 19. | 4183 2018w22 | 20. | 4527 2018w23 | |-----------------| 21. | 3818 2018w24 | 22. | 4921 2018w25 | 23. | 4457 2018w26 | 24. | 4253 2018w27 | 25. | 4239 2018w28 | |-----------------| 26. | 4159 2018w29 | 27. | 3652 2018w30 | 28. | 3798 2018w31 | 29. | 3994 2018w32 | 30. | 3618 2018w33 | |-----------------| 31. | 3789 2018w34 | 32. | 3065 2018w35 | 33. | 3574 2018w36 | 34. | 5630 2018w37 | 35. | 7825 2018w38 | |-----------------| 36. | 4388 2018w39 | 37. | 4271 2018w40 | 38. | 3800 2018w41 | 39. | 4821 2018w42 | 40. | 3945 2018w43 | |-----------------| 41. | 3339 2018w44 | 42. | 4513 2018w45 | 43. | 3722 2018w46 | 44. | 4558 2018w47 | 45. | 3750 2018w48 | |-----------------| 46. | 3560 2018w49 | 47. | 3782 2018w50 | 48. | 3753 2018w51 | 49. | 3278 2018w52 | 50. | 4793 2019w1 | |-----------------| 51. | 6624 2019w2 | 52. | 5306 2019w3 | 53. | 4659 2019w4 | 54. | 4474 2019w5 | 55. | 4318 2019w6 | |-----------------| 56. | 4207 2019w7 | 57. | 4507 2019w8 | 58. | 4625 2019w9 | 59. | 4901 2019w10 | 60. | 4318 2019w11 | |-----------------| 61. | 4598 2019w12 | 62. | 6120 2019w13 | 63. | 4418 2019w14 | +-----------------+
Time series plotBasic statistics:- 50% of observed weeks (63 weeks) have total intra-week merits above 4507, whilst the rest 50% of them have total intra-week merits below 4507. 4507 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 3854 to 5487 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3065 - 30949. . tabstat merit, s(n mean sd p50 p25 p75 min max)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 63 5675.889 4180.547 4507 3854 5487 3065 30949 ----------------------------------------------------------------------------------------------
The part of analysis below contains some information as of the last week (because the interquartile range is the same, from 3854 to 5487).Potential outliers: It means that potential outliers are weeks that have intra-week merits beyond 1405 or 7937. How many weeks are potential outliers? . count if (merit >= 7937 | merit < 1405) & merit != . 6
7 weeks are outliers, in total. List of those seven weeks: . list merit week if merit >=7937 | merit <= 1405
All of them occured in the year 2018. ![Grin](https://bitcointalk.org/Smileys/default/grin.gif)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 13, 2019, 02:24:32 PM |
|
ABSTRACT
Intra-day merits: Notes: - The part of the asbstract describes figures of intraday merits over the period from 19/2/2018 to 08/4/2019 (truncated dataset); - Days from 24/1/2018 to 18/2/2018 truncated due to highly potential outliers; and days after 08/4/2019 truncated as well due to incomplete week (the 2019w15); - Statistics presented in the post are for truncated dataset
(1) Potential outliers are days that have intraday total merits beyond 168 or 1116; (2) Median of intraday merits over the period is 626; (3) 50% of observed days have their intra-day merits range from 523 to 760 (the interquartile range); (4) Friday [in GTM time] is the day over weeks has lowest intraday merits in terms of both median and mean, at 567, and 615, respectively. (5) Monday [in GTM time] is the day over weeks has highest intraday merits in terms of median and mean, at 666, and 740. (6) There are 26 potential outliers in total, and there is only three potential outlier days happened in early weeks of 2019, on 09/01/2019, 14/01/2019, and 27/3/2019, at 1161, 1127, and 1249, respectively. (7) Minimum and maximum of intraday merits (full dataset) are 312 and 13018, on 11/2/2019 and 24/1/2018 respectively.
Intra-week merits: Notes: The part of the abstract use full dataset, only dropped last two days due to incomple week (2019w14).
(1) The median of intra-week merits is 4507; (2) 50% of observed weeks (63 weeeks in total), have total merits in the range from 3854 to 5487 (the interquaritle range of intra-week merits); (3) Minimum and maximum of intraweek merits are 3065 and 30949, in 2018w35, and 2018w4, respectively; (4) Seven potential outliers [beyond 1405 or 7937], all of them occurred in the year 2018.
|
|
|
|
LoyceV
Legendary
Offline
Activity: 3416
Merit: 17265
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 20, 2019, 06:13:19 AM |
|
Update: Per dayDay 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: 450 Merit Day 374: 595 Merit Day 375: 940 Merit Day 376: 571 Merit Day 377: 796 Merit Day 378: 776 Merit Day 379: 559 Merit Day 380: 548 Merit Day 381: 611 Merit Day 382: 623 Merit Day 383: 559 Merit Day 384: 642 Merit Day 385: 585 Merit Day 386: 671 Merit Day 387: 649 Merit Day 388: 607 Merit Day 389: 523 Merit Day 390: 607 Merit Day 391: 565 Merit Day 392: 637 Merit Day 393: 696 Merit Day 394: 504 Merit Day 395: 509 Merit Day 396: 657 Merit Day 397: 608 Merit Day 398: 896 Merit Day 399: 736 Merit Day 400: 553 Merit Day 401: 707 Merit Day 402: 508 Merit Day 403: 412 Merit Day 404: 1001 Merit Day 405: 708 Merit Day 406: 677 Merit Day 407: 787 Merit Day 408: 711 Merit Day 409: 712 Merit Day 410: 723 Merit Day 411: 656 Merit Day 412: 635 Merit Day 413: 680 Merit Day 414: 687 Merit Day 415: 804 Merit Day 416: 580 Merit Day 417: 482 Merit Day 418: 428 Merit Day 419: 657 Merit Day 420: 758 Merit Day 421: 651 Merit Day 422: 720 Merit Day 423: 674 Merit Day 424: 625 Merit Day 425: 594 Merit Day 426: 576 Merit Day 427: 726 Merit Day 428: 1249 Merit Day 429: 927 Merit Day 430: 725 Merit Day 431: 655 Merit Day 432: 851 Merit Day 433: 987 Merit Day 434: 700 Merit Day 435: 616 Merit Day 436: 532 Merit Day 437: 516 Merit Day 438: 618 Merit Day 439: 728 Merit Day 440: 708 Merit Day 441: 707 Merit Day 442: 741 Merit Day 443: 907 Merit Day 444: 612 Merit Day 445: 787 Merit Day 446: 768 Merit Day 447: 737 Merit Day 448: 677 Merit Day 449: 628 Merit Day 450: 79 Merit (incomplete day) Per weekWeek 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: 4657 Merit Week 55: 4137 Merit Week 56: 4269 Merit Week 57: 4618 Merit Week 58: 4581 Merit Week 59: 4912 Merit Week 60: 4402 Merit Week 61: 4576 Merit Week 62: 6103 Merit Week 63: 4432 Merit Week 64: 5240 Merit Week 65: 708 Merit (incomplete week)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 20, 2019, 10:33:09 AM |
|
Update:Converted intra-day merits for days in 2019. . 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 | |------------------------------------------------------------------------------| 373. | 373 450 31jan2019 31 1 2019 2019w5 2019m1 Thursday | 374. | 374 595 01feb2019 1 2 2019 2019w5 2019m2 Friday | 375. | 375 940 02feb2019 2 2 2019 2019w5 2019m2 Saturday | 376. | 376 571 03feb2019 3 2 2019 2019w5 2019m2 Sunday | 377. | 377 796 04feb2019 4 2 2019 2019w5 2019m2 Monday | |------------------------------------------------------------------------------| 378. | 378 776 05feb2019 5 2 2019 2019w6 2019m2 Tuesday | 379. | 379 559 06feb2019 6 2 2019 2019w6 2019m2 Wednesday | 380. | 380 548 07feb2019 7 2 2019 2019w6 2019m2 Thursday | 381. | 381 611 08feb2019 8 2 2019 2019w6 2019m2 Friday | 382. | 382 623 09feb2019 9 2 2019 2019w6 2019m2 Saturday | |------------------------------------------------------------------------------| 383. | 383 559 10feb2019 10 2 2019 2019w6 2019m2 Sunday | 384. | 384 642 11feb2019 11 2 2019 2019w6 2019m2 Monday | 385. | 385 585 12feb2019 12 2 2019 2019w7 2019m2 Tuesday | 386. | 386 671 13feb2019 13 2 2019 2019w7 2019m2 Wednesday | 387. | 387 649 14feb2019 14 2 2019 2019w7 2019m2 Thursday | |------------------------------------------------------------------------------| 388. | 388 607 15feb2019 15 2 2019 2019w7 2019m2 Friday | 389. | 389 523 16feb2019 16 2 2019 2019w7 2019m2 Saturday | 390. | 390 607 17feb2019 17 2 2019 2019w7 2019m2 Sunday | 391. | 391 565 18feb2019 18 2 2019 2019w7 2019m2 Monday | 392. | 392 637 19feb2019 19 2 2019 2019w8 2019m2 Tuesday | |------------------------------------------------------------------------------| 393. | 393 696 20feb2019 20 2 2019 2019w8 2019m2 Wednesday | 394. | 394 504 21feb2019 21 2 2019 2019w8 2019m2 Thursday | 395. | 395 509 22feb2019 22 2 2019 2019w8 2019m2 Friday | 396. | 396 657 23feb2019 23 2 2019 2019w8 2019m2 Saturday | 397. | 397 608 24feb2019 24 2 2019 2019w8 2019m2 Sunday | |------------------------------------------------------------------------------| 398. | 398 896 25feb2019 25 2 2019 2019w8 2019m2 Monday | 399. | 399 736 26feb2019 26 2 2019 2019w9 2019m2 Tuesday | 400. | 400 553 27feb2019 27 2 2019 2019w9 2019m2 Wednesday | 401. | 401 707 28feb2019 28 2 2019 2019w9 2019m2 Thursday | 402. | 402 508 01mar2019 1 3 2019 2019w9 2019m3 Friday | |------------------------------------------------------------------------------| 403. | 403 412 02mar2019 2 3 2019 2019w9 2019m3 Saturday | 404. | 404 1001 03mar2019 3 3 2019 2019w9 2019m3 Sunday | 405. | 405 708 04mar2019 4 3 2019 2019w9 2019m3 Monday | 406. | 406 677 05mar2019 5 3 2019 2019w10 2019m3 Tuesday | 407. | 407 787 06mar2019 6 3 2019 2019w10 2019m3 Wednesday | |------------------------------------------------------------------------------| 408. | 408 711 07mar2019 7 3 2019 2019w10 2019m3 Thursday | 409. | 409 712 08mar2019 8 3 2019 2019w10 2019m3 Friday | 410. | 410 723 09mar2019 9 3 2019 2019w10 2019m3 Saturday | 411. | 411 656 10mar2019 10 3 2019 2019w10 2019m3 Sunday | 412. | 412 635 11mar2019 11 3 2019 2019w10 2019m3 Monday | |------------------------------------------------------------------------------| 413. | 413 680 12mar2019 12 3 2019 2019w11 2019m3 Tuesday | 414. | 414 687 13mar2019 13 3 2019 2019w11 2019m3 Wednesday | 415. | 415 804 14mar2019 14 3 2019 2019w11 2019m3 Thursday | 416. | 416 580 15mar2019 15 3 2019 2019w11 2019m3 Friday | 417. | 417 482 16mar2019 16 3 2019 2019w11 2019m3 Saturday | |------------------------------------------------------------------------------| 418. | 418 428 17mar2019 17 3 2019 2019w11 2019m3 Sunday | 419. | 419 657 18mar2019 18 3 2019 2019w11 2019m3 Monday | 420. | 420 758 19mar2019 19 3 2019 2019w12 2019m3 Tuesday | 421. | 421 651 20mar2019 20 3 2019 2019w12 2019m3 Wednesday | 422. | 422 720 21mar2019 21 3 2019 2019w12 2019m3 Thursday | |------------------------------------------------------------------------------| 423. | 423 674 22mar2019 22 3 2019 2019w12 2019m3 Friday | 424. | 424 625 23mar2019 23 3 2019 2019w12 2019m3 Saturday | 425. | 425 594 24mar2019 24 3 2019 2019w12 2019m3 Sunday | 426. | 426 576 25mar2019 25 3 2019 2019w12 2019m3 Monday | 427. | 427 726 26mar2019 26 3 2019 2019w13 2019m3 Tuesday | |------------------------------------------------------------------------------| 428. | 428 1249 27mar2019 27 3 2019 2019w13 2019m3 Wednesday | 429. | 429 927 28mar2019 28 3 2019 2019w13 2019m3 Thursday | 430. | 430 725 29mar2019 29 3 2019 2019w13 2019m3 Friday | 431. | 431 655 30mar2019 30 3 2019 2019w13 2019m3 Saturday | 432. | 432 851 31mar2019 31 3 2019 2019w13 2019m3 Sunday | |------------------------------------------------------------------------------| 433. | 433 987 01apr2019 1 4 2019 2019w13 2019m4 Monday | 434. | 434 700 02apr2019 2 4 2019 2019w14 2019m4 Tuesday | 435. | 435 616 03apr2019 3 4 2019 2019w14 2019m4 Wednesday | 436. | 436 532 04apr2019 4 4 2019 2019w14 2019m4 Thursday | 437. | 437 516 05apr2019 5 4 2019 2019w14 2019m4 Friday | |------------------------------------------------------------------------------| 438. | 438 618 06apr2019 6 4 2019 2019w14 2019m4 Saturday | 439. | 439 728 07apr2019 7 4 2019 2019w14 2019m4 Sunday | 440. | 440 708 08apr2019 8 4 2019 2019w14 2019m4 Monday | 441. | 441 707 09apr2019 9 4 2019 2019w15 2019m4 Tuesday | 442. | 442 741 10apr2019 10 4 2019 2019w15 2019m4 Wednesday | |------------------------------------------------------------------------------| 443. | 443 907 11apr2019 11 4 2019 2019w15 2019m4 Thursday | 444. | 444 612 12apr2019 12 4 2019 2019w15 2019m4 Friday | 445. | 445 787 13apr2019 13 4 2019 2019w15 2019m4 Saturday | 446. | 446 768 14apr2019 14 4 2019 2019w15 2019m4 Sunday | 447. | 447 737 15apr2019 15 4 2019 2019w15 2019m4 Monday | |------------------------------------------------------------------------------| 448. | 448 677 16apr2019 16 4 2019 2019w16 2019m4 Tuesday | 449. | 449 628 17apr2019 17 4 2019 2019w16 2019m4 Wednesday | +------------------------------------------------------------------------------+
For days in 2018, please get it there
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2380
Merit: 4183
Farewell o_e_l_e_o
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
April 20, 2019, 10:53:37 AM |
|
Time-series plots:Full dataset:Truncated dataset: Basic statistics:Full dataset:. tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 445.0 770.9 489.3 642.0 531.0 789.0 312.0 4493.0 ----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 144 or 1176. . di 789-531 258
. di 258*1.5 387
. di 789+387 1176
. di 531-387 144
There are 43 outliers in full dataset, in total. . count if (merit >= 1176 | merit <= 144) & merit != . 43
Those days are: . list id merit date if (merit >= 1176 | merit <= 144) & merit != .
+-------------------------+ | id merit date | |-------------------------| 1. | 3 4493 26jan2018 | 2. | 4 3489 27jan2018 | 3. | 5 3188 28jan2018 | 4. | 6 3799 29jan2018 | 5. | 7 4192 30jan2018 | |-------------------------| 6. | 8 2820 31jan2018 | 7. | 9 2545 01feb2018 | 8. | 10 2568 02feb2018 | 9. | 11 1867 03feb2018 | 10. | 12 2167 04feb2018 | |-------------------------| 11. | 13 2077 05feb2018 | 12. | 14 2308 06feb2018 | 13. | 15 2141 07feb2018 | 14. | 16 2141 08feb2018 | 15. | 17 1448 09feb2018 | |-------------------------| 16. | 18 1747 10feb2018 | 17. | 19 1442 11feb2018 | 18. | 20 1331 12feb2018 | 19. | 21 1579 13feb2018 | 20. | 22 2513 14feb2018 | |-------------------------| 21. | 23 1991 15feb2018 | 22. | 24 1411 16feb2018 | 23. | 25 1608 17feb2018 | 24. | 26 1289 18feb2018 | 25. | 27 1403 19feb2018 | |-------------------------| 27. | 29 1266 21feb2018 | 28. | 30 1279 22feb2018 | 30. | 32 1409 24feb2018 | 31. | 33 1186 25feb2018 | 32. | 34 1382 26feb2018 | |-------------------------| 33. | 35 1326 27feb2018 | 35. | 37 1333 01mar2018 | 36. | 38 1696 02mar2018 | 39. | 41 1245 05mar2018 | 46. | 48 1354 12mar2018 | |-------------------------| 54. | 56 1322 20mar2018 | 55. | 57 1227 21mar2018 | 66. | 68 1233 01apr2018 | 234. | 236 2463 16sep2018 | 235. | 237 1862 17sep2018 | |-------------------------| 236. | 238 1294 18sep2018 | 237. | 239 1268 19sep2018 | 426. | 428 1249 27mar2019 | +-------------------------+
Only one of them occured in 2019, on 27/3/2019, at 1249 merits circulated in total. Truncated dataset: . tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f)
variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 421.0 681.5 242.5 628.0 526.0 761.0 312.0 2463.0 ----------------------------------------------------------------------------------------------
Applied same formulas I used in earlier analyses, potential outliers are days have intra-day merits beyond 174 or 1114. . di 761-526 235
. di 235*1.5 352.5
. di 761+352.5 1113.5
. di 526-352.5 173.5
There are 26 outliers in total, only three of them occured in 2019, on 09/1/2019, 14/01/2019, and 27/3/2019, at 1161, 1127, and 1249, respectively. . count if (merit >= 1114 | merit <=174) & merit != . 26
. list id merit date if (merit >= 1114 | merit <= 174) & merit != .
+-------------------------+ | id merit date | |-------------------------| 1. | 27 1403 19feb2018 | 2. | 28 1169 20feb2018 | 3. | 29 1266 21feb2018 | 4. | 30 1279 22feb2018 | 6. | 32 1409 24feb2018 | |-------------------------| 7. | 33 1186 25feb2018 | 8. | 34 1382 26feb2018 | 9. | 35 1326 27feb2018 | 11. | 37 1333 01mar2018 | 12. | 38 1696 02mar2018 | |-------------------------| 15. | 41 1245 05mar2018 | 22. | 48 1354 12mar2018 | 24. | 50 1159 14mar2018 | 25. | 51 1130 15mar2018 | 30. | 56 1322 20mar2018 | |-------------------------| 31. | 57 1227 21mar2018 | 42. | 68 1233 01apr2018 | 43. | 69 1146 02apr2018 | 127. | 153 1138 25jun2018 | 210. | 236 2463 16sep2018 | |-------------------------| 211. | 237 1862 17sep2018 | 212. | 238 1294 18sep2018 | 213. | 239 1268 19sep2018 | 325. | 351 1161 09jan2019 | 330. | 356 1127 14jan2019 | |-------------------------| 402. | 428 1249 27mar2019 | +-------------------------+
|
|
|
|
|