tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 07, 2020, 07:37:59 AM Last edit: March 07, 2020, 03:31:55 PM by tranthidung |
|
Intra-week merits (from 24/1/2018 to 03/3/2020)Last 3 days dropped due to incomplete week (2020w10) and an incomplete day (dayid = 773)Converted dataset: +-----------------+ | merit week | |-----------------| 1. | 27920 2018w4 | 2. | 20930 2018w5 | 3. | 14042 2018w6 | 4. | 11901 2018w7 | 5. | 8879 2018w8 | |-----------------| 6. | 9005 2018w9 | 7. | 7178 2018w10 | 8. | 7340 2018w11 | 9. | 7138 2018w12 | 10. | 6392 2018w13 | |-----------------| 11. | 6542 2018w14 | 12. | 5946 2018w15 | 13. | 4449 2018w16 | 14. | 4820 2018w17 | 15. | 5043 2018w18 | |-----------------| 16. | 4685 2018w19 | 17. | 4431 2018w20 | 18. | 3903 2018w21 | 19. | 4248 2018w22 | 20. | 4473 2018w23 | |-----------------| 21. | 3953 2018w24 | 22. | 4574 2018w25 | 23. | 4684 2018w26 | 24. | 4367 2018w27 | 25. | 4109 2018w28 | |-----------------| 26. | 4277 2018w29 | 27. | 3809 2018w30 | 28. | 3489 2018w31 | 29. | 4199 2018w32 | 30. | 3767 2018w33 | |-----------------| 31. | 3763 2018w34 | 32. | 3186 2018w35 | 33. | 3536 2018w36 | 34. | 3586 2018w37 | 35. | 9587 2018w38 | |-----------------| 36. | 4508 2018w39 | 37. | 4325 2018w40 | 38. | 3981 2018w41 | 39. | 4424 2018w42 | 40. | 4386 2018w43 | |-----------------| 41. | 3321 2018w44 | 42. | 4175 2018w45 | 43. | 4047 2018w46 | 44. | 4606 2018w47 | 45. | 3791 2018w48 | |-----------------| 46. | 3596 2018w49 | 47. | 3689 2018w50 | 48. | 3615 2018w51 | 49. | 3687 2018w52 | 50. | 4584 2019w1 | |-----------------| 51. | 6102 2019w2 | 52. | 5776 2019w3 | 53. | 4582 2019w4 | 54. | 4408 2019w5 | 55. | 4505 2019w6 | |-----------------| 56. | 4259 2019w7 | 57. | 4314 2019w8 | 58. | 4726 2019w9 | 59. | 4979 2019w10 | 60. | 4295 2019w11 | |-----------------| 61. | 4690 2019w12 | 62. | 5728 2019w13 | 63. | 4695 2019w14 | 64. | 5253 2019w15 | 65. | 4880 2019w16 | |-----------------| 66. | 4260 2019w17 | 67. | 4817 2019w18 | 68. | 5002 2019w19 | 69. | 5596 2019w20 | 70. | 4693 2019w21 | |-----------------| 71. | 4342 2019w22 | 72. | 4597 2019w23 | 73. | 5373 2019w24 | 74. | 4629 2019w25 | 75. | 4672 2019w26 | |-----------------| 76. | 3882 2019w27 | 77. | 4462 2019w28 | 78. | 4005 2019w29 | 79. | 4377 2019w30 | 80. | 3603 2019w31 | |-----------------| 81. | 3346 2019w32 | 82. | 3965 2019w33 | 83. | 3811 2019w34 | 84. | 3579 2019w35 | 85. | 3683 2019w36 | |-----------------| 86. | 4005 2019w37 | 87. | 4382 2019w38 | 88. | 4348 2019w39 | 89. | 4209 2019w40 | 90. | 4701 2019w41 | |-----------------| 91. | 5160 2019w42 | 92. | 5375 2019w43 | 93. | 4816 2019w44 | 94. | 4753 2019w45 | 95. | 11070 2019w46 | |-----------------| 96. | 20397 2019w47 | 97. | 6271 2019w48 | 98. | 4650 2019w49 | 99. | 4832 2019w50 | 100. | 6066 2019w51 | |-----------------| 101. | 7058 2019w52 | 102. | 5745 2020w1 | 103. | 5395 2020w2 | 104. | 7247 2020w3 | 105. | 6646 2020w4 | |-----------------| 106. | 6756 2020w5 | 107. | 5573 2020w6 | 108. | 6923 2020w7 | 109. | 6314 2020w8 | 110. | 5237 2020w9 | +-----------------+
Time series plotBasic statistics:- 50% of observed weeks ( 110 weeks) have total intra-week merits above 4602, whilst the rest 50% of them have total intra-week merits below 4602. 4602 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 4175 to 5596 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3186 - 27920. variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 110.0 5570.0 3458.2 4601.5 4175.0 5596.0 3186.0 27920.0 ----------------------------------------------------------------------------------------------
Potential outliers:. di 5596-4175 1421
. di 1421*1.5 2131.5
. di 5596+2131.5 7727.5
. di 4175-2131.5 2043.5
It means that potential outliers are weeks that have intra-week merits beyond 2044 or 7728. How many weeks are potential outliers? . count if (merit >= 7728 | merit < 2044) & merit != . 9
9 weeks are outliers, in total. List of those 9 weeks: +-----------------+ | merit week | |-----------------| 1. | 27920 2018w4 | 2. | 20930 2018w5 | 3. | 14042 2018w6 | 4. | 11901 2018w7 | 5. | 8879 2018w8 | |-----------------| 6. | 9005 2018w9 | 35. | 9587 2018w38 | 95. | 11070 2019w46 | 96. | 20397 2019w47 | +-----------------+
Most of them occured in the year 2018, and there is only 2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 ( 20397). List of weeks in descending weekly meritsThe last week (with 5237 merits) stays at the 34th position, among 110 weeks. +------------------------------+ | weeklyrank merit week | |------------------------------| 1. | 1 27920 2018w4 | 2. | 2 20930 2018w5 | 3. | 3 20397 2019w47 | 4. | 4 14042 2018w6 | 5. | 5 11901 2018w7 | |------------------------------| 6. | 6 11070 2019w46 | 7. | 7 9587 2018w38 | 8. | 8 9005 2018w9 | 9. | 9 8879 2018w8 | 10. | 10 7340 2018w11 | |------------------------------| 11. | 11 7247 2020w3 | 12. | 12 7178 2018w10 | 13. | 13 7138 2018w12 | 14. | 14 7058 2019w52 | 15. | 15 6923 2020w7 | |------------------------------| 16. | 16 6756 2020w5 | 17. | 17 6646 2020w4 | 18. | 18 6542 2018w14 | 19. | 19 6392 2018w13 | 20. | 20 6314 2020w8 | |------------------------------| 21. | 21 6271 2019w48 | 22. | 22 6102 2019w2 | 23. | 23 6066 2019w51 | 24. | 24 5946 2018w15 | 25. | 25 5776 2019w3 | |------------------------------| 26. | 26 5745 2020w1 | 27. | 27 5728 2019w13 | 28. | 28 5596 2019w20 | 29. | 29 5573 2020w6 | 30. | 30 5395 2020w2 | |------------------------------| 31. | 31 5375 2019w43 | 32. | 32 5373 2019w24 | 33. | 33 5253 2019w15 | 34. | 34 5237 2020w9 | 35. | 35 5160 2019w42 | |------------------------------| 36. | 36 5043 2018w18 | 37. | 37 5002 2019w19 | 38. | 38 4979 2019w10 | 39. | 39 4880 2019w16 | 40. | 40 4832 2019w50 | |------------------------------| 41. | 41 4820 2018w17 | 42. | 42 4817 2019w18 | 43. | 43 4816 2019w44 | 44. | 44 4753 2019w45 | 45. | 45 4726 2019w9 | |------------------------------| 46. | 46 4701 2019w41 | 47. | 47 4695 2019w14 | 48. | 48 4693 2019w21 | 49. | 49 4690 2019w12 | 50. | 50 4685 2018w19 | |------------------------------| 51. | 51 4684 2018w26 | 52. | 52 4672 2019w26 | 53. | 53 4650 2019w49 | 54. | 54 4629 2019w25 | 55. | 55 4606 2018w47 | |------------------------------| 56. | 56 4597 2019w23 | 57. | 57 4584 2019w1 | 58. | 58 4582 2019w4 | 59. | 59 4574 2018w25 | 60. | 60 4508 2018w39 | |------------------------------| 61. | 61 4505 2019w6 | 62. | 62 4473 2018w23 | 63. | 63 4462 2019w28 | 64. | 64 4449 2018w16 | 65. | 65 4431 2018w20 | |------------------------------| 66. | 66 4424 2018w42 | 67. | 67 4408 2019w5 | 68. | 68 4386 2018w43 | 69. | 69 4382 2019w38 | 70. | 70 4377 2019w30 | |------------------------------| 71. | 71 4367 2018w27 | 72. | 72 4348 2019w39 | 73. | 73 4342 2019w22 | 74. | 74 4325 2018w40 | 75. | 75 4314 2019w8 | |------------------------------| 76. | 76 4295 2019w11 | 77. | 77 4277 2018w29 | 78. | 78 4260 2019w17 | 79. | 79 4259 2019w7 | 80. | 80 4248 2018w22 | |------------------------------| 81. | 81 4209 2019w40 | 82. | 82 4199 2018w32 | 83. | 83 4175 2018w45 | 84. | 84 4109 2018w28 | 85. | 85 4047 2018w46 | |------------------------------| 86. | 86 4005 2019w37 | 87. | 87 4005 2019w29 | 88. | 88 3981 2018w41 | 89. | 89 3965 2019w33 | 90. | 90 3953 2018w24 | |------------------------------| 91. | 91 3903 2018w21 | 92. | 92 3882 2019w27 | 93. | 93 3811 2019w34 | 94. | 94 3809 2018w30 | 95. | 95 3791 2018w48 | |------------------------------| 96. | 96 3767 2018w33 | 97. | 97 3763 2018w34 | 98. | 98 3689 2018w50 | 99. | 99 3687 2018w52 | 100. | 100 3683 2019w36 | |------------------------------| 101. | 101 3615 2018w51 | 102. | 102 3603 2019w31 | 103. | 103 3596 2018w49 | 104. | 104 3586 2018w37 | 105. | 105 3579 2019w35 | |------------------------------| 106. | 106 3536 2018w36 | 107. | 107 3489 2018w31 | 108. | 108 3346 2019w32 | 109. | 109 3321 2018w44 | 110. | 110 3186 2018w35 | +------------------------------+
|
|
|
|
|
|
|
|
Each block is stacked on top of the previous one. Adding another block to the top makes all lower blocks more difficult to remove: there is more "weight" above each block. A transaction in a block 6 blocks deep (6 confirmations) will be very difficult to remove.
|
|
|
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 07, 2020, 07:45:32 AM |
|
ABSTRACT 2020w9, GMT timeData is the full dataset since 24/1/2018, and only dropped last 3 days belong to incomplete week - 2020w10 and an incomplete day (dayid = 773). Details on days dropped, please see above posts. Intra-day merits:- Total observed days: 770
- Potential outliers are days that have intraday total merits beyond 151 or 1227
- Median of intraday merits over the period is 663
- 50% of observed days have their intra-day merits range from 554 to 823 (the interquartile range)
- In medians, the highest and lowest days are Tuesday and Saturday, respectively; whilst the highest and lowest days in means are Thursday and Sunday, respectively. See here.
- There are 53 potential outliers (beyond 151 or 1227) in total.
- The distribution of outliers over years are: 39 (73.6%) for 2018, 13 (24.5%) for 2019, and 1 (1.9%) for 2020. (see details)
- Minimum and maximum of intraday merits (full dataset) are 300, and 12676, on 04/8/2019 and 25/1/2018, respectively.
Intra-week merits:- Total observed weeks: 110
- The median of intra-week merits is 4602
- 50% of observed weeks (110 weeks in total), have total merits in the range from 4175 to 5596 (the interquartile range of intra-week merits).
- Minimum and maximum of intra-week merits are 3186 and 27920, in 2018w35, and 2018w4, respectively;
- 9 potential outliers [beyond 2044 or 7728], only 2 of them occurred in the year 2019, on 2019w46 (11070), and 2019w47 (20397).
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 20, 2020, 05:17:36 AM |
|
Once again, I am sorry for the lack of update last week. Today, I came back to do it but unfortunately theymos already dumped merit dataset for a new week. Hence, I skipped the previous week (2020w11) and below is update for the new week (2020w12). Converted dataset: - In 2020 at 20mar2020 02:50:12 (GMT time)
- The last one, with dayid = 787 is an incomplete day.
+-----------------------------------------------------------------+ | dayid date merit dofw week month year | |-----------------------------------------------------------------| 708. | 708 01jan2020 810 Wednesday 2020w1 2020m1 2020 | 709. | 709 02jan2020 854 Thursday 2020w1 2020m1 2020 | 710. | 710 03jan2020 837 Friday 2020w1 2020m1 2020 | 711. | 711 04jan2020 637 Saturday 2020w1 2020m1 2020 | 712. | 712 05jan2020 777 Sunday 2020w1 2020m1 2020 | |-----------------------------------------------------------------| 713. | 713 06jan2020 959 Monday 2020w1 2020m1 2020 | 714. | 714 07jan2020 871 Tuesday 2020w1 2020m1 2020 | 715. | 715 08jan2020 860 Wednesday 2020w2 2020m1 2020 | 716. | 716 09jan2020 733 Thursday 2020w2 2020m1 2020 | 717. | 717 10jan2020 745 Friday 2020w2 2020m1 2020 | |-----------------------------------------------------------------| 718. | 718 11jan2020 743 Saturday 2020w2 2020m1 2020 | 719. | 719 12jan2020 689 Sunday 2020w2 2020m1 2020 | 720. | 720 13jan2020 754 Monday 2020w2 2020m1 2020 | 721. | 721 14jan2020 871 Tuesday 2020w2 2020m1 2020 | 722. | 722 15jan2020 979 Wednesday 2020w3 2020m1 2020 | |-----------------------------------------------------------------| 723. | 723 16jan2020 972 Thursday 2020w3 2020m1 2020 | 724. | 724 17jan2020 1063 Friday 2020w3 2020m1 2020 | 725. | 725 18jan2020 823 Saturday 2020w3 2020m1 2020 | 726. | 726 19jan2020 1192 Sunday 2020w3 2020m1 2020 | 727. | 727 20jan2020 1136 Monday 2020w3 2020m1 2020 | |-----------------------------------------------------------------| 728. | 728 21jan2020 1082 Tuesday 2020w3 2020m1 2020 | 729. | 729 22jan2020 863 Wednesday 2020w4 2020m1 2020 | 730. | 730 23jan2020 1050 Thursday 2020w4 2020m1 2020 | 731. | 731 24jan2020 1061 Friday 2020w4 2020m1 2020 | 732. | 732 25jan2020 1043 Saturday 2020w4 2020m1 2020 | |-----------------------------------------------------------------| 733. | 733 26jan2020 715 Sunday 2020w4 2020m1 2020 | 734. | 734 27jan2020 961 Monday 2020w4 2020m1 2020 | 735. | 735 28jan2020 953 Tuesday 2020w4 2020m1 2020 | 736. | 736 29jan2020 1051 Wednesday 2020w5 2020m1 2020 | 737. | 737 30jan2020 1125 Thursday 2020w5 2020m1 2020 | |-----------------------------------------------------------------| 738. | 738 31jan2020 1072 Friday 2020w5 2020m1 2020 | 739. | 739 01feb2020 705 Saturday 2020w5 2020m2 2020 | 740. | 740 02feb2020 836 Sunday 2020w5 2020m2 2020 | 741. | 741 03feb2020 908 Monday 2020w5 2020m2 2020 | 742. | 742 04feb2020 1059 Tuesday 2020w5 2020m2 2020 | |-----------------------------------------------------------------| 743. | 743 05feb2020 873 Wednesday 2020w6 2020m2 2020 | 744. | 744 06feb2020 932 Thursday 2020w6 2020m2 2020 | 745. | 745 07feb2020 800 Friday 2020w6 2020m2 2020 | 746. | 746 08feb2020 763 Saturday 2020w6 2020m2 2020 | 747. | 747 09feb2020 724 Sunday 2020w6 2020m2 2020 | |-----------------------------------------------------------------| 748. | 748 10feb2020 812 Monday 2020w6 2020m2 2020 | 749. | 749 11feb2020 669 Tuesday 2020w6 2020m2 2020 | 750. | 750 12feb2020 596 Wednesday 2020w7 2020m2 2020 | 751. | 751 13feb2020 1047 Thursday 2020w7 2020m2 2020 | 752. | 752 14feb2020 1041 Friday 2020w7 2020m2 2020 | |-----------------------------------------------------------------| 753. | 753 15feb2020 890 Saturday 2020w7 2020m2 2020 | 754. | 754 16feb2020 790 Sunday 2020w7 2020m2 2020 | 755. | 755 17feb2020 1364 Monday 2020w7 2020m2 2020 | 756. | 756 18feb2020 1195 Tuesday 2020w7 2020m2 2020 | 757. | 757 19feb2020 1004 Wednesday 2020w8 2020m2 2020 | |-----------------------------------------------------------------| 758. | 758 20feb2020 782 Thursday 2020w8 2020m2 2020 | 759. | 759 21feb2020 1050 Friday 2020w8 2020m2 2020 | 760. | 760 22feb2020 729 Saturday 2020w8 2020m2 2020 | 761. | 761 23feb2020 724 Sunday 2020w8 2020m2 2020 | 762. | 762 24feb2020 1037 Monday 2020w8 2020m2 2020 | |-----------------------------------------------------------------| 763. | 763 25feb2020 988 Tuesday 2020w8 2020m2 2020 | 764. | 764 26feb2020 857 Wednesday 2020w9 2020m2 2020 | 765. | 765 27feb2020 960 Thursday 2020w9 2020m2 2020 | 766. | 766 28feb2020 678 Friday 2020w9 2020m2 2020 | 767. | 767 29feb2020 662 Saturday 2020w9 2020m2 2020 | |-----------------------------------------------------------------| 768. | 768 01mar2020 651 Sunday 2020w9 2020m3 2020 | 769. | 769 02mar2020 755 Monday 2020w9 2020m3 2020 | 770. | 770 03mar2020 674 Tuesday 2020w9 2020m3 2020 | 771. | 771 04mar2020 572 Wednesday 2020w10 2020m3 2020 | 772. | 772 05mar2020 727 Thursday 2020w10 2020m3 2020 | |-----------------------------------------------------------------| 773. | 773 06mar2020 622 Friday 2020w10 2020m3 2020 | 774. | 774 07mar2020 697 Saturday 2020w10 2020m3 2020 | 775. | 775 08mar2020 670 Sunday 2020w10 2020m3 2020 | 776. | 776 09mar2020 634 Monday 2020w10 2020m3 2020 | 777. | 777 10mar2020 700 Tuesday 2020w10 2020m3 2020 | |-----------------------------------------------------------------| 778. | 778 11mar2020 800 Wednesday 2020w11 2020m3 2020 | 779. | 779 12mar2020 790 Thursday 2020w11 2020m3 2020 | 780. | 780 13mar2020 748 Friday 2020w11 2020m3 2020 | 781. | 781 14mar2020 562 Saturday 2020w11 2020m3 2020 | 782. | 782 15mar2020 528 Sunday 2020w11 2020m3 2020 | |-----------------------------------------------------------------| 783. | 783 16mar2020 888 Monday 2020w11 2020m3 2020 | 784. | 784 17mar2020 793 Tuesday 2020w11 2020m3 2020 | 785. | 785 18mar2020 1090 Wednesday 2020w12 2020m3 2020 | 786. | 786 19mar2020 867 Thursday 2020w12 2020m3 2020 | 787. | 787 20mar2020 62 Friday 2020w12 2020m3 2020 | +-----------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 20, 2020, 05:23:53 AM Last edit: March 20, 2020, 06:01:46 AM by tranthidung |
|
Time-series plots:Full dataset:Truncated dataset: Basic statistics (for full dataset): Only drop last 3 days that belong to the 2020w12 (daydi = 785, 786), the incomplete week & incomlete day (dayid = 787). variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 784 793.9184 671.4041 663.5 555.5 818 300 12676 ----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 162 or 1212. . di 818-555.5 262.5
. di 262.5*1.5 393.75
. di 818+393.75 1211.75
. di 555.5-393.75 161.75
There are 56 outliers (beyond 1212 or 162) in full dataset, in total. . count if (merit >= 1212 | merit <= 162) & merit != . 56
Those days are: +---------------------------+ | dayid merit date | |---------------------------| 2. | 2 12676 25jan2018 | 3. | 3 6348 26jan2018 | 4. | 4 4627 27jan2018 | 5. | 5 3240 28jan2018 | 6. | 6 3343 29jan2018 | 7. | 7 3804 30jan2018 | 8. | 8 4103 31jan2018 | 9. | 9 2793 01feb2018 | 10. | 10 2621 02feb2018 | 11. | 11 2476 03feb2018 | 12. | 12 1790 04feb2018 | 13. | 13 2263 05feb2018 | 14. | 14 2003 06feb2018 | 15. | 15 2367 07feb2018 | 16. | 16 2059 08feb2018 | 17. | 17 2223 09feb2018 | 18. | 18 1334 10feb2018 | 19. | 19 1793 11feb2018 | 20. | 20 1475 12feb2018 | 21. | 21 1289 13feb2018 | 22. | 22 1580 14feb2018 | 23. | 23 2797 15feb2018 | 24. | 24 1740 16feb2018 | 25. | 25 1431 17feb2018 | 26. | 26 1589 18feb2018 | 27. | 27 1289 19feb2018 | 28. | 28 1442 20feb2018 | 30. | 30 1277 22feb2018 | 31. | 31 1249 23feb2018 | 33. | 33 1372 25feb2018 | 35. | 35 1414 27feb2018 | 36. | 36 1302 28feb2018 | 38. | 38 1345 02mar2018 | 39. | 39 1727 03mar2018 | 49. | 49 1316 13mar2018 | 51. | 51 1224 15mar2018 | 57. | 57 1390 21mar2018 | 237. | 237 2553 17sep2018 | 238. | 238 1807 18sep2018 | 239. | 239 1347 19sep2018 | 240. | 240 1221 20sep2018 | |---------------------------| 429. | 429 1247 28mar2019 | 476. | 476 1215 14may2019 | 505. | 505 1227 12jun2019 | 660. | 660 1630 14nov2019 | 661. | 661 2374 15nov2019 | 662. | 662 1585 16nov2019 | 663. | 663 1377 17nov2019 | 664. | 664 2783 18nov2019 | 665. | 665 3826 19nov2019 | 666. | 666 2584 20nov2019 | 667. | 667 4889 21nov2019 | 668. | 668 5515 22nov2019 | 669. | 669 1590 23nov2019 | 678. | 678 1465 02dec2019 | |---------------------------| 755. | 755 1364 17feb2020 | +---------------------------+
Distributions of outliers over years:- 2018: 41 (73.2%)
- 2019: 14 (25%)
- 2020: 1 (1.8%)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 20, 2020, 05:25:55 AM |
|
During the period from 24/1/2018 to 17/3/2020 (last 3 days dropped due to incomplete week, 2020w12 and an incomplete day - dayid = 787), the minimum and maximum of intra-day merit are 300 and 12676, on 04/8/2019 and 25/1/2018, respectively. List of the top 50-highest day in terms of intra-day merits: +-----------------------------------------------------------------------------+ | rank_max merit dayid date dofw week month year | |-----------------------------------------------------------------------------| 1. | 1 12676 2 25jan2018 Thursday 2018w4 2018m1 2018 | 2. | 2 6348 3 26jan2018 Friday 2018w4 2018m1 2018 | 3. | 3 5515 668 22nov2019 Friday 2019w47 2019m11 2019 | 4. | 4 4889 667 21nov2019 Thursday 2019w47 2019m11 2019 | 5. | 5 4627 4 27jan2018 Saturday 2018w4 2018m1 2018 | |-----------------------------------------------------------------------------| 6. | 6 4103 8 31jan2018 Wednesday 2018w5 2018m1 2018 | 7. | 7 3826 665 19nov2019 Tuesday 2019w47 2019m11 2019 | 8. | 8 3804 7 30jan2018 Tuesday 2018w5 2018m1 2018 | 9. | 9 3343 6 29jan2018 Monday 2018w5 2018m1 2018 | 10. | 10 3240 5 28jan2018 Sunday 2018w4 2018m1 2018 | |-----------------------------------------------------------------------------| 11. | 11 2797 23 15feb2018 Thursday 2018w7 2018m2 2018 | 12. | 12 2793 9 01feb2018 Thursday 2018w5 2018m2 2018 | 13. | 13 2783 664 18nov2019 Monday 2019w46 2019m11 2019 | 14. | 14 2621 10 02feb2018 Friday 2018w5 2018m2 2018 | 15. | 15 2584 666 20nov2019 Wednesday 2019w47 2019m11 2019 | |-----------------------------------------------------------------------------| 16. | 16 2553 237 17sep2018 Monday 2018w38 2018m9 2018 | 17. | 17 2476 11 03feb2018 Saturday 2018w5 2018m2 2018 | 18. | 18 2374 661 15nov2019 Friday 2019w46 2019m11 2019 | 19. | 19 2367 15 07feb2018 Wednesday 2018w6 2018m2 2018 | 20. | 20 2263 13 05feb2018 Monday 2018w6 2018m2 2018 | |-----------------------------------------------------------------------------| 21. | 21 2223 17 09feb2018 Friday 2018w6 2018m2 2018 | 22. | 22 2059 16 08feb2018 Thursday 2018w6 2018m2 2018 | 23. | 23 2003 14 06feb2018 Tuesday 2018w6 2018m2 2018 | 24. | 24 1807 238 18sep2018 Tuesday 2018w38 2018m9 2018 | 25. | 25 1793 19 11feb2018 Sunday 2018w6 2018m2 2018 | |-----------------------------------------------------------------------------| 26. | 26 1790 12 04feb2018 Sunday 2018w5 2018m2 2018 | 27. | 27 1740 24 16feb2018 Friday 2018w7 2018m2 2018 | 28. | 28 1727 39 03mar2018 Saturday 2018w9 2018m3 2018 | 29. | 29 1630 660 14nov2019 Thursday 2019w46 2019m11 2019 | 30. | 30 1590 669 23nov2019 Saturday 2019w47 2019m11 2019 | |-----------------------------------------------------------------------------| 31. | 31 1589 26 18feb2018 Sunday 2018w7 2018m2 2018 | 32. | 32 1585 662 16nov2019 Saturday 2019w46 2019m11 2019 | 33. | 33 1580 22 14feb2018 Wednesday 2018w7 2018m2 2018 | 34. | 34 1475 20 12feb2018 Monday 2018w7 2018m2 2018 | 35. | 35 1465 678 02dec2019 Monday 2019w48 2019m12 2019 | |-----------------------------------------------------------------------------| 36. | 36 1442 28 20feb2018 Tuesday 2018w8 2018m2 2018 | 37. | 37 1431 25 17feb2018 Saturday 2018w7 2018m2 2018 | 38. | 38 1414 35 27feb2018 Tuesday 2018w9 2018m2 2018 | 39. | 39 1390 57 21mar2018 Wednesday 2018w12 2018m3 2018 | 40. | 40 1377 663 17nov2019 Sunday 2019w46 2019m11 2019 | |-----------------------------------------------------------------------------| 41. | 41 1372 33 25feb2018 Sunday 2018w8 2018m2 2018 | 42. | 42 1364 755 17feb2020 Monday 2020w7 2020m2 2020 | 43. | 43 1347 239 19sep2018 Wednesday 2018w38 2018m9 2018 | 44. | 44 1345 38 02mar2018 Friday 2018w9 2018m3 2018 | 45. | 45 1334 18 10feb2018 Saturday 2018w6 2018m2 2018 | |-----------------------------------------------------------------------------| 46. | 46 1316 49 13mar2018 Tuesday 2018w11 2018m3 2018 | 47. | 47 1302 36 28feb2018 Wednesday 2018w9 2018m2 2018 | 48. | 48 1289 21 13feb2018 Tuesday 2018w7 2018m2 2018 | 49. | 49 1289 27 19feb2018 Monday 2018w8 2018m2 2018 | 50. | 50 1277 30 22feb2018 Thursday 2018w8 2018m2 2018 | +-----------------------------------------------------------------------------+
List of the top 50-lowest days in terms of intra-day merits: +-----------------------------------------------------------------------------+ | rank_min merit dayid date dofw week month year | |-----------------------------------------------------------------------------| 1. | 1 300 558 04aug2019 Sunday 2019w31 2019m8 2019 | 2. | 2 333 341 30dec2018 Sunday 2018w52 2018m12 2018 | 3. | 3 339 343 01jan2019 Tuesday 2019w1 2019m1 2019 | 4. | 4 347 299 18nov2018 Sunday 2018w46 2018m11 2018 | 5. | 5 347 330 19dec2018 Wednesday 2018w51 2018m12 2018 | |-----------------------------------------------------------------------------| 6. | 6 351 334 23dec2018 Sunday 2018w51 2018m12 2018 | 7. | 7 366 218 29aug2018 Wednesday 2018w35 2018m8 2018 | 8. | 8 367 565 11aug2019 Sunday 2019w32 2019m8 2019 | 9. | 9 370 223 03sep2018 Monday 2018w36 2018m9 2018 | 10. | 10 373 339 28dec2018 Friday 2018w52 2018m12 2018 | |-----------------------------------------------------------------------------| 11. | 11 375 340 29dec2018 Saturday 2018w52 2018m12 2018 | 12. | 12 377 600 15sep2019 Sunday 2019w37 2019m9 2019 | 13. | 13 378 305 24nov2018 Saturday 2018w47 2018m11 2018 | 14. | 14 378 567 13aug2019 Tuesday 2019w33 2019m8 2019 | 15. | 15 378 566 12aug2019 Monday 2019w32 2019m8 2019 | |-----------------------------------------------------------------------------| 16. | 16 380 192 03aug2018 Friday 2018w31 2018m8 2018 | 17. | 17 381 336 25dec2018 Tuesday 2018w52 2018m12 2018 | 18. | 18 385 215 26aug2018 Sunday 2018w34 2018m8 2018 | 19. | 19 385 327 16dec2018 Sunday 2018w50 2018m12 2018 | 20. | 20 391 221 01sep2018 Saturday 2018w35 2018m9 2018 | |-----------------------------------------------------------------------------| 21. | 21 394 188 30jul2018 Monday 2018w31 2018m7 2018 | 22. | 22 399 593 08sep2019 Sunday 2019w36 2019m9 2019 | 23. | 23 401 557 03aug2019 Saturday 2019w31 2019m8 2019 | 24. | 24 401 288 07nov2018 Wednesday 2018w45 2018m11 2018 | 25. | 25 402 263 13oct2018 Saturday 2018w41 2018m10 2018 | |-----------------------------------------------------------------------------| 26. | 26 404 229 09sep2018 Sunday 2018w36 2018m9 2018 | 27. | 27 406 277 27oct2018 Saturday 2018w43 2018m10 2018 | 28. | 28 408 530 07jul2019 Sunday 2019w27 2019m7 2019 | 29. | 29 409 589 04sep2019 Wednesday 2019w36 2019m9 2019 | 30. | 30 409 123 26may2018 Saturday 2018w21 2018m5 2018 | |-----------------------------------------------------------------------------| 31. | 31 410 279 29oct2018 Monday 2018w44 2018m10 2018 | 32. | 32 411 569 15aug2019 Thursday 2019w33 2019m8 2019 | 33. | 33 411 578 24aug2019 Saturday 2019w34 2019m8 2019 | 34. | 34 414 528 05jul2019 Friday 2019w27 2019m7 2019 | 35. | 35 421 193 04aug2018 Saturday 2018w31 2018m8 2018 | |-----------------------------------------------------------------------------| 36. | 36 425 588 03sep2019 Tuesday 2019w36 2019m9 2019 | 37. | 37 426 346 04jan2019 Friday 2019w1 2019m1 2019 | 38. | 38 426 230 10sep2018 Monday 2018w37 2018m9 2018 | 39. | 39 427 141 13jun2018 Wednesday 2018w24 2018m6 2018 | 40. | 40 430 207 18aug2018 Saturday 2018w33 2018m8 2018 | |-----------------------------------------------------------------------------| 41. | 41 432 587 02sep2019 Monday 2019w35 2019m9 2019 | 42. | 42 435 522 29jun2019 Saturday 2019w26 2019m6 2019 | 43. | 43 436 419 18mar2019 Monday 2019w11 2019m3 2019 | 44. | 44 440 559 05aug2019 Monday 2019w31 2019m8 2019 | 45. | 45 440 265 15oct2018 Monday 2018w42 2018m10 2018 | |-----------------------------------------------------------------------------| 46. | 46 440 585 31aug2019 Saturday 2019w35 2019m8 2019 | 47. | 47 441 404 03mar2019 Sunday 2019w9 2019m3 2019 | 48. | 48 441 319 08dec2018 Saturday 2018w49 2018m12 2018 | 49. | 49 442 342 31dec2018 Monday 2018w52 2018m12 2018 | 50. | 50 442 278 28oct2018 Sunday 2018w43 2018m10 2018 | +-----------------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 20, 2020, 05:30:51 AM Last edit: March 20, 2020, 06:01:17 AM by tranthidung |
|
Medians and means of intra-day merits over days of weeks GMT timeColors: - Green: highest.
- Red: Lowest.
- In median, the highest days are Tuesday, Thursday , and Friday at 702, 701, and 696, respectively; whislt the lowest days are Saturday, Sunday, and Monday at 600, 622, and 661, respectively. - In means, the highest days are Thursday, Friday, and Tuesday at 916, 854, and 816, respectively; whilst the lowest days are Sunday, Saturday, and Monday, at 698, 709, and 783, respectively. Basic statistics:Summary for variables: merit by categories of: dofw
dofw | N mean sd p50 p25 p75 min max ----------+-------------------------------------------------------------------------------- Sunday | 112 697.4286 364.0684 621.5 499 755.5 300 3240 Monday | 112 782.7589 448.8148 660.5 557.5 867.5 370 3343 Tuesday | 112 815.5714 489.82 702 593 871 339 3826 Wednesday | 112 783.5982 446.3148 661.5 597.5 834 347 4103 Thursday | 112 915.7232 1242.537 700.5 580 820.5 411 12676 Friday | 112 853.5357 773.5219 696 562.5 834 373 6348 Saturday | 112 708.8125 478.0683 599.5 502 732.5 375 4627 ----------+-------------------------------------------------------------------------------- Total | 784 793.9184 671.4041 663.5 555.5 818 300 12676 -------------------------------------------------------------------------------------------
Box plotsOutliers displayed as red circles. Outliers non-displayed. Details on ranks:In medians +--------------------------------------------------------------------------+ | rankmedian dofw median mean p25 p75 min max | |--------------------------------------------------------------------------| 1. | 1 Tuesday 702 815.5714 593 871 339 3826 | 2. | 2 Thursday 700.5 915.7232 580 820.5 411 12676 | 3. | 3 Friday 696 853.5357 562.5 834 373 6348 | 4. | 4 Wednesday 661.5 783.5982 597.5 834 347 4103 | 5. | 5 Monday 660.5 782.7589 557.5 867.5 370 3343 | |--------------------------------------------------------------------------| 6. | 6 Sunday 621.5 697.4286 499 755.5 300 3240 | 7. | 7 Saturday 599.5 708.8125 502 732.5 375 4627 | +--------------------------------------------------------------------------+
In means +------------------------------------------------------------------------+ | rankmean dofw mean median p25 p75 min max | |------------------------------------------------------------------------| 1. | 1 Thursday 915.7232 700.5 580 820.5 411 12676 | 2. | 2 Friday 853.5357 696 562.5 834 373 6348 | 3. | 3 Tuesday 815.5714 702 593 871 339 3826 | 4. | 4 Wednesday 783.5982 661.5 597.5 834 347 4103 | 5. | 5 Monday 782.7589 660.5 557.5 867.5 370 3343 | |------------------------------------------------------------------------| 6. | 6 Saturday 708.8125 599.5 502 732.5 375 4627 | 7. | 7 Sunday 697.4286 621.5 499 755.5 300 3240 | +------------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 20, 2020, 05:37:43 AM Last edit: March 20, 2020, 06:00:47 AM by tranthidung |
|
Intra-week merits (from 24/1/2018 to 17/3/2020)Last 3 days dropped due to incomplete week (2020w12) and an incomplete day (dayid = 787)Converted dataset: +-----------------+ | merit week | |-----------------| 1. | 27920 2018w4 | 2. | 20930 2018w5 | 3. | 14042 2018w6 | 4. | 11901 2018w7 | 5. | 8879 2018w8 | |-----------------| 6. | 9005 2018w9 | 7. | 7178 2018w10 | 8. | 7340 2018w11 | 9. | 7138 2018w12 | 10. | 6392 2018w13 | |-----------------| 11. | 6542 2018w14 | 12. | 5946 2018w15 | 13. | 4449 2018w16 | 14. | 4820 2018w17 | 15. | 5043 2018w18 | |-----------------| 16. | 4685 2018w19 | 17. | 4431 2018w20 | 18. | 3903 2018w21 | 19. | 4248 2018w22 | 20. | 4473 2018w23 | |-----------------| 21. | 3953 2018w24 | 22. | 4574 2018w25 | 23. | 4684 2018w26 | 24. | 4367 2018w27 | 25. | 4109 2018w28 | |-----------------| 26. | 4277 2018w29 | 27. | 3809 2018w30 | 28. | 3489 2018w31 | 29. | 4199 2018w32 | 30. | 3767 2018w33 | |-----------------| 31. | 3763 2018w34 | 32. | 3186 2018w35 | 33. | 3536 2018w36 | 34. | 3586 2018w37 | 35. | 9587 2018w38 | |-----------------| 36. | 4508 2018w39 | 37. | 4325 2018w40 | 38. | 3981 2018w41 | 39. | 4424 2018w42 | 40. | 4386 2018w43 | |-----------------| 41. | 3321 2018w44 | 42. | 4175 2018w45 | 43. | 4047 2018w46 | 44. | 4606 2018w47 | 45. | 3791 2018w48 | |-----------------| 46. | 3596 2018w49 | 47. | 3689 2018w50 | 48. | 3615 2018w51 | 49. | 3687 2018w52 | 50. | 4584 2019w1 | |-----------------| 51. | 6102 2019w2 | 52. | 5776 2019w3 | 53. | 4582 2019w4 | 54. | 4408 2019w5 | 55. | 4505 2019w6 | |-----------------| 56. | 4259 2019w7 | 57. | 4314 2019w8 | 58. | 4726 2019w9 | 59. | 4979 2019w10 | 60. | 4295 2019w11 | |-----------------| 61. | 4690 2019w12 | 62. | 5728 2019w13 | 63. | 4695 2019w14 | 64. | 5253 2019w15 | 65. | 4880 2019w16 | |-----------------| 66. | 4260 2019w17 | 67. | 4817 2019w18 | 68. | 5002 2019w19 | 69. | 5596 2019w20 | 70. | 4693 2019w21 | |-----------------| 71. | 4342 2019w22 | 72. | 4597 2019w23 | 73. | 5373 2019w24 | 74. | 4629 2019w25 | 75. | 4672 2019w26 | |-----------------| 76. | 3882 2019w27 | 77. | 4462 2019w28 | 78. | 4005 2019w29 | 79. | 4377 2019w30 | 80. | 3603 2019w31 | |-----------------| 81. | 3346 2019w32 | 82. | 3965 2019w33 | 83. | 3811 2019w34 | 84. | 3579 2019w35 | 85. | 3683 2019w36 | |-----------------| 86. | 4005 2019w37 | 87. | 4382 2019w38 | 88. | 4348 2019w39 | 89. | 4209 2019w40 | 90. | 4701 2019w41 | |-----------------| 91. | 5160 2019w42 | 92. | 5375 2019w43 | 93. | 4816 2019w44 | 94. | 4753 2019w45 | 95. | 11070 2019w46 | |-----------------| 96. | 20397 2019w47 | 97. | 6271 2019w48 | 98. | 4650 2019w49 | 99. | 4832 2019w50 | 100. | 6066 2019w51 | |-----------------| 101. | 7058 2019w52 | 102. | 5745 2020w1 | 103. | 5395 2020w2 | 104. | 7247 2020w3 | 105. | 6646 2020w4 | |-----------------| 106. | 6756 2020w5 | 107. | 5573 2020w6 | 108. | 6923 2020w7 | 109. | 6314 2020w8 | 110. | 5237 2020w9 | |-----------------| 111. | 4622 2020w10 | 112. | 5109 2020w11 | +-----------------+
Time series plotBasic statistics:- 50% of observed weeks ( 112 weeks) have total intra-week merits above 4614, whilst the rest 50% of them have total intra-week merits below 4614. 4614 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 4187 to 5585 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3186 - 27920. variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 112.0 5557.4 3428.4 4614.0 4187.0 5584.5 3186.0 27920.0 ----------------------------------------------------------------------------------------------
Potential outliers:. di 5584.5-4187 1397.5
. di 1397.5*1.5 2096.25
. di 5584.5+2096.25 7680.75
. di 4187-2096.25 2090.75
It means that potential outliers are weeks that have intra-week merits beyond 2091 or 7681. How many weeks are potential outliers? . count if (merit >= 7681 | merit < 2091) & merit != . 9
9 weeks are outliers, in total. List of those 9 weeks: +-----------------+ | merit week | |-----------------| 1. | 27920 2018w4 | 2. | 20930 2018w5 | 3. | 14042 2018w6 | 4. | 11901 2018w7 | 5. | 8879 2018w8 | |-----------------| 6. | 9005 2018w9 | 35. | 9587 2018w38 | 95. | 11070 2019w46 | 96. | 20397 2019w47 | +-----------------+
Most of them occured in the year 2018, and there is only 2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 ( 20397). List of weeks in descending weekly meritsThe last week (with 5109 merits) stays at the 36th position, among 112 weeks. +------------------------------+ | weeklyrank merit week | |------------------------------| 1. | 1 27920 2018w4 | 2. | 2 20930 2018w5 | 3. | 3 20397 2019w47 | 4. | 4 14042 2018w6 | 5. | 5 11901 2018w7 | |------------------------------| 6. | 6 11070 2019w46 | 7. | 7 9587 2018w38 | 8. | 8 9005 2018w9 | 9. | 9 8879 2018w8 | 10. | 10 7340 2018w11 | |------------------------------| 11. | 11 7247 2020w3 | 12. | 12 7178 2018w10 | 13. | 13 7138 2018w12 | 14. | 14 7058 2019w52 | 15. | 15 6923 2020w7 | |------------------------------| 16. | 16 6756 2020w5 | 17. | 17 6646 2020w4 | 18. | 18 6542 2018w14 | 19. | 19 6392 2018w13 | 20. | 20 6314 2020w8 | |------------------------------| 21. | 21 6271 2019w48 | 22. | 22 6102 2019w2 | 23. | 23 6066 2019w51 | 24. | 24 5946 2018w15 | 25. | 25 5776 2019w3 | |------------------------------| 26. | 26 5745 2020w1 | 27. | 27 5728 2019w13 | 28. | 28 5596 2019w20 | 29. | 29 5573 2020w6 | 30. | 30 5395 2020w2 | |------------------------------| 31. | 31 5375 2019w43 | 32. | 32 5373 2019w24 | 33. | 33 5253 2019w15 | 34. | 34 5237 2020w9 | 35. | 35 5160 2019w42 | |------------------------------| 36. | 36 5109 2020w11 | 37. | 37 5043 2018w18 | 38. | 38 5002 2019w19 | 39. | 39 4979 2019w10 | 40. | 40 4880 2019w16 | |------------------------------| 41. | 41 4832 2019w50 | 42. | 42 4820 2018w17 | 43. | 43 4817 2019w18 | 44. | 44 4816 2019w44 | 45. | 45 4753 2019w45 | |------------------------------| 46. | 46 4726 2019w9 | 47. | 47 4701 2019w41 | 48. | 48 4695 2019w14 | 49. | 49 4693 2019w21 | 50. | 50 4690 2019w12 | |------------------------------| 51. | 51 4685 2018w19 | 52. | 52 4684 2018w26 | 53. | 53 4672 2019w26 | 54. | 54 4650 2019w49 | 55. | 55 4629 2019w25 | |------------------------------| 56. | 56 4622 2020w10 | 57. | 57 4606 2018w47 | 58. | 58 4597 2019w23 | 59. | 59 4584 2019w1 | 60. | 60 4582 2019w4 | |------------------------------| 61. | 61 4574 2018w25 | 62. | 62 4508 2018w39 | 63. | 63 4505 2019w6 | 64. | 64 4473 2018w23 | 65. | 65 4462 2019w28 | |------------------------------| 66. | 66 4449 2018w16 | 67. | 67 4431 2018w20 | 68. | 68 4424 2018w42 | 69. | 69 4408 2019w5 | 70. | 70 4386 2018w43 | |------------------------------| 71. | 71 4382 2019w38 | 72. | 72 4377 2019w30 | 73. | 73 4367 2018w27 | 74. | 74 4348 2019w39 | 75. | 75 4342 2019w22 | |------------------------------| 76. | 76 4325 2018w40 | 77. | 77 4314 2019w8 | 78. | 78 4295 2019w11 | 79. | 79 4277 2018w29 | 80. | 80 4260 2019w17 | |------------------------------| 81. | 81 4259 2019w7 | 82. | 82 4248 2018w22 | 83. | 83 4209 2019w40 | 84. | 84 4199 2018w32 | 85. | 85 4175 2018w45 | |------------------------------| 86. | 86 4109 2018w28 | 87. | 87 4047 2018w46 | 88. | 88 4005 2019w29 | 89. | 89 4005 2019w37 | 90. | 90 3981 2018w41 | |------------------------------| 91. | 91 3965 2019w33 | 92. | 92 3953 2018w24 | 93. | 93 3903 2018w21 | 94. | 94 3882 2019w27 | 95. | 95 3811 2019w34 | |------------------------------| 96. | 96 3809 2018w30 | 97. | 97 3791 2018w48 | 98. | 98 3767 2018w33 | 99. | 99 3763 2018w34 | 100. | 100 3689 2018w50 | |------------------------------| 101. | 101 3687 2018w52 | 102. | 102 3683 2019w36 | 103. | 103 3615 2018w51 | 104. | 104 3603 2019w31 | 105. | 105 3596 2018w49 | |------------------------------| 106. | 106 3586 2018w37 | 107. | 107 3579 2019w35 | 108. | 108 3536 2018w36 | 109. | 109 3489 2018w31 | 110. | 110 3346 2019w32 | |------------------------------| 111. | 111 3321 2018w44 | 112. | 112 3186 2018w35 | +------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 20, 2020, 05:43:39 AM Last edit: March 28, 2020, 04:47:23 AM by tranthidung |
|
ABSTRACT 2020w11, GMT timeData is the full dataset since 24/1/2018, and only dropped last 3 days belong to incomplete week - 2020w12 and an incomplete day (dayid = 787). Details on days dropped, please see above posts. Intra-day merits:- Total observed days: 784
- Potential outliers are days that have intraday total merits beyond 162 or 1212
- Median of intraday merits over the period is 664
- 50% of observed days have their intra-day merits range from 556 to 818 (the interquartile range)
- In medians, the highest and lowest days are Tuesday and Saturday, respectively; whilst the highest and lowest days in means are Thursday and Sunday, respectively. See here.
- There are 56 potential outliers (beyond 162 or 1212) in total.
- The distribution of outliers over years are: 41 (73.2%) for 2018, 14 (25%) for 2019, and 1 (1.8%) for 2020. (see details)
- Minimum and maximum of intraday merits (full dataset) are 300, and 12676, on 04/8/2019 and 25/1/2018, respectively.
Intra-week merits:- Total observed weeks: 112
- The median of intra-week merits is 4614
- 50% of observed weeks (110 weeks in total), have total merits in the range from 4187 to 5585 (the interquartile range of intra-week merits).
- Minimum and maximum of intra-week merits are 3186 and 27920, in 2018w35, and 2018w4, respectively;
- 9 potential outliers [beyond 2044 or 7728], only 2 of them occurred in the year 2019, on 2019w46 (11070), and 2019w47 (20397).
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 28, 2020, 04:37:12 AM |
|
Converted dataset: - In 2020 at 27mar2020 01:34:34 (GMT time)
- The last one, with dayid = 794 is an incomplete day.
+-----------------------------------------------------------------+ | dayid date merit dofw week month year | |-----------------------------------------------------------------| 708. | 708 01jan2020 810 Wednesday 2020w1 2020m1 2020 | 709. | 709 02jan2020 854 Thursday 2020w1 2020m1 2020 | 710. | 710 03jan2020 837 Friday 2020w1 2020m1 2020 | 711. | 711 04jan2020 637 Saturday 2020w1 2020m1 2020 | 712. | 712 05jan2020 777 Sunday 2020w1 2020m1 2020 | |-----------------------------------------------------------------| 713. | 713 06jan2020 959 Monday 2020w1 2020m1 2020 | 714. | 714 07jan2020 871 Tuesday 2020w1 2020m1 2020 | 715. | 715 08jan2020 860 Wednesday 2020w2 2020m1 2020 | 716. | 716 09jan2020 733 Thursday 2020w2 2020m1 2020 | 717. | 717 10jan2020 745 Friday 2020w2 2020m1 2020 | |-----------------------------------------------------------------| 718. | 718 11jan2020 743 Saturday 2020w2 2020m1 2020 | 719. | 719 12jan2020 689 Sunday 2020w2 2020m1 2020 | 720. | 720 13jan2020 754 Monday 2020w2 2020m1 2020 | 721. | 721 14jan2020 871 Tuesday 2020w2 2020m1 2020 | 722. | 722 15jan2020 979 Wednesday 2020w3 2020m1 2020 | |-----------------------------------------------------------------| 723. | 723 16jan2020 972 Thursday 2020w3 2020m1 2020 | 724. | 724 17jan2020 1063 Friday 2020w3 2020m1 2020 | 725. | 725 18jan2020 823 Saturday 2020w3 2020m1 2020 | 726. | 726 19jan2020 1192 Sunday 2020w3 2020m1 2020 | 727. | 727 20jan2020 1136 Monday 2020w3 2020m1 2020 | |-----------------------------------------------------------------| 728. | 728 21jan2020 1082 Tuesday 2020w3 2020m1 2020 | 729. | 729 22jan2020 863 Wednesday 2020w4 2020m1 2020 | 730. | 730 23jan2020 1050 Thursday 2020w4 2020m1 2020 | 731. | 731 24jan2020 1061 Friday 2020w4 2020m1 2020 | 732. | 732 25jan2020 1043 Saturday 2020w4 2020m1 2020 | |-----------------------------------------------------------------| 733. | 733 26jan2020 715 Sunday 2020w4 2020m1 2020 | 734. | 734 27jan2020 961 Monday 2020w4 2020m1 2020 | 735. | 735 28jan2020 953 Tuesday 2020w4 2020m1 2020 | 736. | 736 29jan2020 1051 Wednesday 2020w5 2020m1 2020 | 737. | 737 30jan2020 1125 Thursday 2020w5 2020m1 2020 | |-----------------------------------------------------------------| 738. | 738 31jan2020 1072 Friday 2020w5 2020m1 2020 | 739. | 739 01feb2020 705 Saturday 2020w5 2020m2 2020 | 740. | 740 02feb2020 836 Sunday 2020w5 2020m2 2020 | 741. | 741 03feb2020 908 Monday 2020w5 2020m2 2020 | 742. | 742 04feb2020 1059 Tuesday 2020w5 2020m2 2020 | |-----------------------------------------------------------------| 743. | 743 05feb2020 873 Wednesday 2020w6 2020m2 2020 | 744. | 744 06feb2020 932 Thursday 2020w6 2020m2 2020 | 745. | 745 07feb2020 800 Friday 2020w6 2020m2 2020 | 746. | 746 08feb2020 763 Saturday 2020w6 2020m2 2020 | 747. | 747 09feb2020 724 Sunday 2020w6 2020m2 2020 | |-----------------------------------------------------------------| 748. | 748 10feb2020 812 Monday 2020w6 2020m2 2020 | 749. | 749 11feb2020 669 Tuesday 2020w6 2020m2 2020 | 750. | 750 12feb2020 596 Wednesday 2020w7 2020m2 2020 | 751. | 751 13feb2020 1047 Thursday 2020w7 2020m2 2020 | 752. | 752 14feb2020 1041 Friday 2020w7 2020m2 2020 | |-----------------------------------------------------------------| 753. | 753 15feb2020 890 Saturday 2020w7 2020m2 2020 | 754. | 754 16feb2020 790 Sunday 2020w7 2020m2 2020 | 755. | 755 17feb2020 1364 Monday 2020w7 2020m2 2020 | 756. | 756 18feb2020 1195 Tuesday 2020w7 2020m2 2020 | 757. | 757 19feb2020 1004 Wednesday 2020w8 2020m2 2020 | |-----------------------------------------------------------------| 758. | 758 20feb2020 782 Thursday 2020w8 2020m2 2020 | 759. | 759 21feb2020 1050 Friday 2020w8 2020m2 2020 | 760. | 760 22feb2020 729 Saturday 2020w8 2020m2 2020 | 761. | 761 23feb2020 724 Sunday 2020w8 2020m2 2020 | 762. | 762 24feb2020 1037 Monday 2020w8 2020m2 2020 | |-----------------------------------------------------------------| 763. | 763 25feb2020 988 Tuesday 2020w8 2020m2 2020 | 764. | 764 26feb2020 857 Wednesday 2020w9 2020m2 2020 | 765. | 765 27feb2020 960 Thursday 2020w9 2020m2 2020 | 766. | 766 28feb2020 678 Friday 2020w9 2020m2 2020 | 767. | 767 29feb2020 662 Saturday 2020w9 2020m2 2020 | |-----------------------------------------------------------------| 768. | 768 01mar2020 651 Sunday 2020w9 2020m3 2020 | 769. | 769 02mar2020 755 Monday 2020w9 2020m3 2020 | 770. | 770 03mar2020 674 Tuesday 2020w9 2020m3 2020 | 771. | 771 04mar2020 572 Wednesday 2020w10 2020m3 2020 | 772. | 772 05mar2020 727 Thursday 2020w10 2020m3 2020 | |-----------------------------------------------------------------| 773. | 773 06mar2020 622 Friday 2020w10 2020m3 2020 | 774. | 774 07mar2020 697 Saturday 2020w10 2020m3 2020 | 775. | 775 08mar2020 670 Sunday 2020w10 2020m3 2020 | 776. | 776 09mar2020 634 Monday 2020w10 2020m3 2020 | 777. | 777 10mar2020 700 Tuesday 2020w10 2020m3 2020 | |-----------------------------------------------------------------| 778. | 778 11mar2020 800 Wednesday 2020w11 2020m3 2020 | 779. | 779 12mar2020 790 Thursday 2020w11 2020m3 2020 | 780. | 780 13mar2020 748 Friday 2020w11 2020m3 2020 | 781. | 781 14mar2020 562 Saturday 2020w11 2020m3 2020 | 782. | 782 15mar2020 528 Sunday 2020w11 2020m3 2020 | |-----------------------------------------------------------------| 783. | 783 16mar2020 888 Monday 2020w11 2020m3 2020 | 784. | 784 17mar2020 793 Tuesday 2020w11 2020m3 2020 | 785. | 785 18mar2020 1090 Wednesday 2020w12 2020m3 2020 | 786. | 786 19mar2020 867 Thursday 2020w12 2020m3 2020 | 787. | 787 20mar2020 999 Friday 2020w12 2020m3 2020 | |-----------------------------------------------------------------| 788. | 788 21mar2020 628 Saturday 2020w12 2020m3 2020 | 789. | 789 22mar2020 549 Sunday 2020w12 2020m3 2020 | 790. | 790 23mar2020 683 Monday 2020w12 2020m3 2020 | 791. | 791 24mar2020 787 Tuesday 2020w12 2020m3 2020 | 792. | 792 25mar2020 786 Wednesday 2020w13 2020m3 2020 | |-----------------------------------------------------------------| 793. | 793 26mar2020 855 Thursday 2020w13 2020m3 2020 | 794. | 794 27mar2020 60 Friday 2020w13 2020m3 2020 | +-----------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 28, 2020, 04:40:28 AM Last edit: March 28, 2020, 05:22:33 AM by tranthidung |
|
Time-series plots:Full dataset:Truncated dataset: Basic statistics (for full dataset): Only drop last 3 days that belong to the 2020w13 (daydi = 792, 793), the incomplete week & incomlete day (dayid = 794). variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 791 793.976 668.6453 666 556 819 300 12676 ----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 162 or 1214. . di 819-556 263
. di 263*1.5 394.5
. di 819+394.5 1213.5
. di 556-394.5 161.5
There are 56 outliers (beyond 1214 or 162) in full dataset, in total. . count if (merit >= 1212 | merit <= 162) & merit != . 56
Those days are: +---------------------------+ | dayid merit date | |---------------------------| 2. | 2 12676 25jan2018 | 3. | 3 6348 26jan2018 | 4. | 4 4627 27jan2018 | 5. | 5 3240 28jan2018 | 6. | 6 3343 29jan2018 | 7. | 7 3804 30jan2018 | 8. | 8 4103 31jan2018 | 9. | 9 2793 01feb2018 | 10. | 10 2621 02feb2018 | 11. | 11 2476 03feb2018 | 12. | 12 1790 04feb2018 | 13. | 13 2263 05feb2018 | 14. | 14 2003 06feb2018 | 15. | 15 2367 07feb2018 | 16. | 16 2059 08feb2018 | 17. | 17 2223 09feb2018 | 18. | 18 1334 10feb2018 | 19. | 19 1793 11feb2018 | 20. | 20 1475 12feb2018 | 21. | 21 1289 13feb2018 | 22. | 22 1580 14feb2018 | 23. | 23 2797 15feb2018 | 24. | 24 1740 16feb2018 | 25. | 25 1431 17feb2018 | 26. | 26 1589 18feb2018 | 27. | 27 1289 19feb2018 | 28. | 28 1442 20feb2018 | 30. | 30 1277 22feb2018 | 31. | 31 1249 23feb2018 | 33. | 33 1372 25feb2018 | 35. | 35 1414 27feb2018 | 36. | 36 1302 28feb2018 | 38. | 38 1345 02mar2018 | 39. | 39 1727 03mar2018 | 49. | 49 1316 13mar2018 | 51. | 51 1224 15mar2018 | 57. | 57 1390 21mar2018 | 237. | 237 2553 17sep2018 | 238. | 238 1807 18sep2018 | 239. | 239 1347 19sep2018 | 240. | 240 1221 20sep2018 | |---------------------------| 429. | 429 1247 28mar2019 | 476. | 476 1215 14may2019 | 505. | 505 1227 12jun2019 | 660. | 660 1630 14nov2019 | 661. | 661 2374 15nov2019 | 662. | 662 1585 16nov2019 | 663. | 663 1377 17nov2019 | 664. | 664 2783 18nov2019 | 665. | 665 3826 19nov2019 | 666. | 666 2584 20nov2019 | 667. | 667 4889 21nov2019 | 668. | 668 5515 22nov2019 | 669. | 669 1590 23nov2019 | 678. | 678 1465 02dec2019 | |---------------------------| 755. | 755 1364 17feb2020 | +---------------------------+
Distributions of outliers over years:- 2018: 41 (73.2%)
- 2019: 14 (25%)
- 2020: 1 (1.8%)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 28, 2020, 04:42:16 AM |
|
During the period from 24/1/2018 to 24/3/2020 (last 3 days dropped due to incomplete week, 2020w13 and an incomplete day - dayid = 794), the minimum and maximum of intra-day merit are 300 and 12676, on 04/8/2019 and 25/1/2018, respectively. List of the top 50-highest day in terms of intra-day merits: +-----------------------------------------------------------------------------+ | rank_max merit dayid date dofw week month year | |-----------------------------------------------------------------------------| 1. | 1 12676 2 25jan2018 Thursday 2018w4 2018m1 2018 | 2. | 2 6348 3 26jan2018 Friday 2018w4 2018m1 2018 | 3. | 3 5515 668 22nov2019 Friday 2019w47 2019m11 2019 | 4. | 4 4889 667 21nov2019 Thursday 2019w47 2019m11 2019 | 5. | 5 4627 4 27jan2018 Saturday 2018w4 2018m1 2018 | |-----------------------------------------------------------------------------| 6. | 6 4103 8 31jan2018 Wednesday 2018w5 2018m1 2018 | 7. | 7 3826 665 19nov2019 Tuesday 2019w47 2019m11 2019 | 8. | 8 3804 7 30jan2018 Tuesday 2018w5 2018m1 2018 | 9. | 9 3343 6 29jan2018 Monday 2018w5 2018m1 2018 | 10. | 10 3240 5 28jan2018 Sunday 2018w4 2018m1 2018 | |-----------------------------------------------------------------------------| 11. | 11 2797 23 15feb2018 Thursday 2018w7 2018m2 2018 | 12. | 12 2793 9 01feb2018 Thursday 2018w5 2018m2 2018 | 13. | 13 2783 664 18nov2019 Monday 2019w46 2019m11 2019 | 14. | 14 2621 10 02feb2018 Friday 2018w5 2018m2 2018 | 15. | 15 2584 666 20nov2019 Wednesday 2019w47 2019m11 2019 | |-----------------------------------------------------------------------------| 16. | 16 2553 237 17sep2018 Monday 2018w38 2018m9 2018 | 17. | 17 2476 11 03feb2018 Saturday 2018w5 2018m2 2018 | 18. | 18 2374 661 15nov2019 Friday 2019w46 2019m11 2019 | 19. | 19 2367 15 07feb2018 Wednesday 2018w6 2018m2 2018 | 20. | 20 2263 13 05feb2018 Monday 2018w6 2018m2 2018 | |-----------------------------------------------------------------------------| 21. | 21 2223 17 09feb2018 Friday 2018w6 2018m2 2018 | 22. | 22 2059 16 08feb2018 Thursday 2018w6 2018m2 2018 | 23. | 23 2003 14 06feb2018 Tuesday 2018w6 2018m2 2018 | 24. | 24 1807 238 18sep2018 Tuesday 2018w38 2018m9 2018 | 25. | 25 1793 19 11feb2018 Sunday 2018w6 2018m2 2018 | |-----------------------------------------------------------------------------| 26. | 26 1790 12 04feb2018 Sunday 2018w5 2018m2 2018 | 27. | 27 1740 24 16feb2018 Friday 2018w7 2018m2 2018 | 28. | 28 1727 39 03mar2018 Saturday 2018w9 2018m3 2018 | 29. | 29 1630 660 14nov2019 Thursday 2019w46 2019m11 2019 | 30. | 30 1590 669 23nov2019 Saturday 2019w47 2019m11 2019 | |-----------------------------------------------------------------------------| 31. | 31 1589 26 18feb2018 Sunday 2018w7 2018m2 2018 | 32. | 32 1585 662 16nov2019 Saturday 2019w46 2019m11 2019 | 33. | 33 1580 22 14feb2018 Wednesday 2018w7 2018m2 2018 | 34. | 34 1475 20 12feb2018 Monday 2018w7 2018m2 2018 | 35. | 35 1465 678 02dec2019 Monday 2019w48 2019m12 2019 | |-----------------------------------------------------------------------------| 36. | 36 1442 28 20feb2018 Tuesday 2018w8 2018m2 2018 | 37. | 37 1431 25 17feb2018 Saturday 2018w7 2018m2 2018 | 38. | 38 1414 35 27feb2018 Tuesday 2018w9 2018m2 2018 | 39. | 39 1390 57 21mar2018 Wednesday 2018w12 2018m3 2018 | 40. | 40 1377 663 17nov2019 Sunday 2019w46 2019m11 2019 | |-----------------------------------------------------------------------------| 41. | 41 1372 33 25feb2018 Sunday 2018w8 2018m2 2018 | 42. | 42 1364 755 17feb2020 Monday 2020w7 2020m2 2020 | 43. | 43 1347 239 19sep2018 Wednesday 2018w38 2018m9 2018 | 44. | 44 1345 38 02mar2018 Friday 2018w9 2018m3 2018 | 45. | 45 1334 18 10feb2018 Saturday 2018w6 2018m2 2018 | |-----------------------------------------------------------------------------| 46. | 46 1316 49 13mar2018 Tuesday 2018w11 2018m3 2018 | 47. | 47 1302 36 28feb2018 Wednesday 2018w9 2018m2 2018 | 48. | 48 1289 21 13feb2018 Tuesday 2018w7 2018m2 2018 | 49. | 49 1289 27 19feb2018 Monday 2018w8 2018m2 2018 | 50. | 50 1277 30 22feb2018 Thursday 2018w8 2018m2 2018 | +-----------------------------------------------------------------------------+
List of the top 50-lowest days in terms of intra-day merits: +-----------------------------------------------------------------------------+ | rank_min merit dayid date dofw week month year | |-----------------------------------------------------------------------------| 1. | 1 300 558 04aug2019 Sunday 2019w31 2019m8 2019 | 2. | 2 333 341 30dec2018 Sunday 2018w52 2018m12 2018 | 3. | 3 339 343 01jan2019 Tuesday 2019w1 2019m1 2019 | 4. | 4 347 299 18nov2018 Sunday 2018w46 2018m11 2018 | 5. | 5 347 330 19dec2018 Wednesday 2018w51 2018m12 2018 | |-----------------------------------------------------------------------------| 6. | 6 351 334 23dec2018 Sunday 2018w51 2018m12 2018 | 7. | 7 366 218 29aug2018 Wednesday 2018w35 2018m8 2018 | 8. | 8 367 565 11aug2019 Sunday 2019w32 2019m8 2019 | 9. | 9 370 223 03sep2018 Monday 2018w36 2018m9 2018 | 10. | 10 373 339 28dec2018 Friday 2018w52 2018m12 2018 | |-----------------------------------------------------------------------------| 11. | 11 375 340 29dec2018 Saturday 2018w52 2018m12 2018 | 12. | 12 377 600 15sep2019 Sunday 2019w37 2019m9 2019 | 13. | 13 378 566 12aug2019 Monday 2019w32 2019m8 2019 | 14. | 14 378 567 13aug2019 Tuesday 2019w33 2019m8 2019 | 15. | 15 378 305 24nov2018 Saturday 2018w47 2018m11 2018 | |-----------------------------------------------------------------------------| 16. | 16 380 192 03aug2018 Friday 2018w31 2018m8 2018 | 17. | 17 381 336 25dec2018 Tuesday 2018w52 2018m12 2018 | 18. | 18 385 327 16dec2018 Sunday 2018w50 2018m12 2018 | 19. | 19 385 215 26aug2018 Sunday 2018w34 2018m8 2018 | 20. | 20 391 221 01sep2018 Saturday 2018w35 2018m9 2018 | |-----------------------------------------------------------------------------| 21. | 21 394 188 30jul2018 Monday 2018w31 2018m7 2018 | 22. | 22 399 593 08sep2019 Sunday 2019w36 2019m9 2019 | 23. | 23 401 288 07nov2018 Wednesday 2018w45 2018m11 2018 | 24. | 24 401 557 03aug2019 Saturday 2019w31 2019m8 2019 | 25. | 25 402 263 13oct2018 Saturday 2018w41 2018m10 2018 | |-----------------------------------------------------------------------------| 26. | 26 404 229 09sep2018 Sunday 2018w36 2018m9 2018 | 27. | 27 406 277 27oct2018 Saturday 2018w43 2018m10 2018 | 28. | 28 408 530 07jul2019 Sunday 2019w27 2019m7 2019 | 29. | 29 409 123 26may2018 Saturday 2018w21 2018m5 2018 | 30. | 30 409 589 04sep2019 Wednesday 2019w36 2019m9 2019 | |-----------------------------------------------------------------------------| 31. | 31 410 279 29oct2018 Monday 2018w44 2018m10 2018 | 32. | 32 411 578 24aug2019 Saturday 2019w34 2019m8 2019 | 33. | 33 411 569 15aug2019 Thursday 2019w33 2019m8 2019 | 34. | 34 414 528 05jul2019 Friday 2019w27 2019m7 2019 | 35. | 35 421 193 04aug2018 Saturday 2018w31 2018m8 2018 | |-----------------------------------------------------------------------------| 36. | 36 425 588 03sep2019 Tuesday 2019w36 2019m9 2019 | 37. | 37 426 230 10sep2018 Monday 2018w37 2018m9 2018 | 38. | 38 426 346 04jan2019 Friday 2019w1 2019m1 2019 | 39. | 39 427 141 13jun2018 Wednesday 2018w24 2018m6 2018 | 40. | 40 430 207 18aug2018 Saturday 2018w33 2018m8 2018 | |-----------------------------------------------------------------------------| 41. | 41 432 587 02sep2019 Monday 2019w35 2019m9 2019 | 42. | 42 435 522 29jun2019 Saturday 2019w26 2019m6 2019 | 43. | 43 436 419 18mar2019 Monday 2019w11 2019m3 2019 | 44. | 44 440 559 05aug2019 Monday 2019w31 2019m8 2019 | 45. | 45 440 265 15oct2018 Monday 2018w42 2018m10 2018 | |-----------------------------------------------------------------------------| 46. | 46 440 585 31aug2019 Saturday 2019w35 2019m8 2019 | 47. | 47 441 319 08dec2018 Saturday 2018w49 2018m12 2018 | 48. | 48 441 404 03mar2019 Sunday 2019w9 2019m3 2019 | 49. | 49 442 342 31dec2018 Monday 2018w52 2018m12 2018 | 50. | 50 442 278 28oct2018 Sunday 2018w43 2018m10 2018 | +-----------------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 28, 2020, 04:46:05 AM Last edit: March 28, 2020, 05:23:11 AM by tranthidung |
|
Medians and means of intra-day merits over days of weeks GMT timeColors: - Green: highest.
- Red: Lowest.
- In median, the highest days are Tuesday, Thursday , and Friday at 704, 704, and 697, respectively; whislt the lowest days are Saturday, Sunday, and Monday at 601, 616, and 662, respectively. - In means, the highest days are Thursday, Friday, and Tuesday at 916, 855, and 816, respectively; whilst the lowest days are Sunday, Saturday, and Monday, at 697, 708, and 782, respectively. Basic statistics:Summary for variables: merit by categories of: dofw
dofw | N mean sd p50 p25 p75 min max ----------+-------------------------------------------------------------------------------- Sunday | 113 696.115 362.7083 616 503 747 300 3240 Monday | 113 781.8761 446.9052 662 558 859 370 3343 Tuesday | 113 815.3186 487.6358 704 594 871 339 3826 Wednesday | 113 786.3097 445.2518 667 599 836 347 4103 Thursday | 113 915.292 1236.986 704 584 824 411 12676 Friday | 113 854.823 770.1825 697 564 837 373 6348 Saturday | 113 708.0973 475.99 601 503 729 375 4627 ----------+-------------------------------------------------------------------------------- Total | 791 793.976 668.6453 666 556 819 300 12676 -------------------------------------------------------------------------------------------
Box plotsOutliers displayed as red circles. Outliers non-displayed. Details on ranks:In medians +----------------------------------------------------------------------+ | rankmedian dofw median mean p25 p75 min max | |----------------------------------------------------------------------| 1. | 1 Tuesday 704 815.3186 594 871 339 3826 | 2. | 2 Thursday 704 915.2921 584 824 411 12676 | 3. | 3 Friday 697 854.823 564 837 373 6348 | 4. | 4 Wednesday 667 786.3098 599 836 347 4103 | 5. | 5 Monday 662 781.8761 558 859 370 3343 | |----------------------------------------------------------------------| 6. | 6 Sunday 616 696.1151 503 747 300 3240 | 7. | 7 Saturday 601 708.0974 503 729 375 4627 | +----------------------------------------------------------------------+
In means +--------------------------------------------------------------------+ | rankmean dofw mean median p25 p75 min max | |--------------------------------------------------------------------| 1. | 1 Thursday 915.2921 704 584 824 411 12676 | 2. | 2 Friday 854.823 697 564 837 373 6348 | 3. | 3 Tuesday 815.3186 704 594 871 339 3826 | 4. | 4 Wednesday 786.3098 667 599 836 347 4103 | 5. | 5 Monday 781.8761 662 558 859 370 3343 | |--------------------------------------------------------------------| 6. | 6 Saturday 708.0974 601 503 729 375 4627 | 7. | 7 Sunday 696.1151 616 503 747 300 3240 | +--------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 28, 2020, 04:52:59 AM Last edit: March 28, 2020, 05:23:34 AM by tranthidung |
|
Intra-week merits (from 24/1/2018 to 24/3/2020)Last 3 days dropped due to incomplete week (2020w13) and an incomplete day (dayid = 794)Converted dataset: +-----------------+ | merit week | |-----------------| 1. | 27920 2018w4 | 2. | 20930 2018w5 | 3. | 14042 2018w6 | 4. | 11901 2018w7 | 5. | 8879 2018w8 | |-----------------| 6. | 9005 2018w9 | 7. | 7178 2018w10 | 8. | 7340 2018w11 | 9. | 7138 2018w12 | 10. | 6392 2018w13 | |-----------------| 11. | 6542 2018w14 | 12. | 5946 2018w15 | 13. | 4449 2018w16 | 14. | 4820 2018w17 | 15. | 5043 2018w18 | |-----------------| 16. | 4685 2018w19 | 17. | 4431 2018w20 | 18. | 3903 2018w21 | 19. | 4248 2018w22 | 20. | 4473 2018w23 | |-----------------| 21. | 3953 2018w24 | 22. | 4574 2018w25 | 23. | 4684 2018w26 | 24. | 4367 2018w27 | 25. | 4109 2018w28 | |-----------------| 26. | 4277 2018w29 | 27. | 3809 2018w30 | 28. | 3489 2018w31 | 29. | 4199 2018w32 | 30. | 3767 2018w33 | |-----------------| 31. | 3763 2018w34 | 32. | 3186 2018w35 | 33. | 3536 2018w36 | 34. | 3586 2018w37 | 35. | 9587 2018w38 | |-----------------| 36. | 4508 2018w39 | 37. | 4325 2018w40 | 38. | 3981 2018w41 | 39. | 4424 2018w42 | 40. | 4386 2018w43 | |-----------------| 41. | 3321 2018w44 | 42. | 4175 2018w45 | 43. | 4047 2018w46 | 44. | 4606 2018w47 | 45. | 3791 2018w48 | |-----------------| 46. | 3596 2018w49 | 47. | 3689 2018w50 | 48. | 3615 2018w51 | 49. | 3687 2018w52 | 50. | 4584 2019w1 | |-----------------| 51. | 6102 2019w2 | 52. | 5776 2019w3 | 53. | 4582 2019w4 | 54. | 4408 2019w5 | 55. | 4505 2019w6 | |-----------------| 56. | 4259 2019w7 | 57. | 4314 2019w8 | 58. | 4726 2019w9 | 59. | 4979 2019w10 | 60. | 4295 2019w11 | |-----------------| 61. | 4690 2019w12 | 62. | 5728 2019w13 | 63. | 4695 2019w14 | 64. | 5253 2019w15 | 65. | 4880 2019w16 | |-----------------| 66. | 4260 2019w17 | 67. | 4817 2019w18 | 68. | 5002 2019w19 | 69. | 5596 2019w20 | 70. | 4693 2019w21 | |-----------------| 71. | 4342 2019w22 | 72. | 4597 2019w23 | 73. | 5373 2019w24 | 74. | 4629 2019w25 | 75. | 4672 2019w26 | |-----------------| 76. | 3882 2019w27 | 77. | 4462 2019w28 | 78. | 4005 2019w29 | 79. | 4377 2019w30 | 80. | 3603 2019w31 | |-----------------| 81. | 3346 2019w32 | 82. | 3965 2019w33 | 83. | 3811 2019w34 | 84. | 3579 2019w35 | 85. | 3683 2019w36 | |-----------------| 86. | 4005 2019w37 | 87. | 4382 2019w38 | 88. | 4348 2019w39 | 89. | 4209 2019w40 | 90. | 4701 2019w41 | |-----------------| 91. | 5160 2019w42 | 92. | 5375 2019w43 | 93. | 4816 2019w44 | 94. | 4753 2019w45 | 95. | 11070 2019w46 | |-----------------| 96. | 20397 2019w47 | 97. | 6271 2019w48 | 98. | 4650 2019w49 | 99. | 4832 2019w50 | 100. | 6066 2019w51 | |-----------------| 101. | 7058 2019w52 | 102. | 5745 2020w1 | 103. | 5395 2020w2 | 104. | 7247 2020w3 | 105. | 6646 2020w4 | |-----------------| 106. | 6756 2020w5 | 107. | 5573 2020w6 | 108. | 6923 2020w7 | 109. | 6314 2020w8 | 110. | 5237 2020w9 | |-----------------| 111. | 4622 2020w10 | 112. | 5109 2020w11 | 113. | 5603 2020w12 | +-----------------+
Time series plotBasic statistics:- 50% of observed weeks ( 113 weeks) have total intra-week merits above 4622, whilst the rest 50% of them have total intra-week merits below 4622. 4622 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 4199 to 5596 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3186 - 27920. variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 113.0 5557.8 3413.0 4622.0 4199.0 5596.0 3186.0 27920.0 ----------------------------------------------------------------------------------------------
Potential outliers:. di 5596-4199 1397
. di 1397*1.5 2095.5
. di 5596+2095.5 7691.5
. di 4199-2095.5 2103.5
It means that potential outliers are weeks that have intra-week merits beyond 2104 or 7692. How many weeks are potential outliers? . count if (merit >= 7692 | merit < 2096) & merit != . 9
9 weeks are outliers, in total. List of those 9 weeks: +-----------------+ | merit week | |-----------------| 1. | 27920 2018w4 | 2. | 20930 2018w5 | 3. | 14042 2018w6 | 4. | 11901 2018w7 | 5. | 8879 2018w8 | |-----------------| 6. | 9005 2018w9 | 35. | 9587 2018w38 | 95. | 11070 2019w46 | 96. | 20397 2019w47 | +-----------------+
Most of them occured in the year 2018, and there is only 2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 ( 20397). List of weeks in descending weekly meritsThe last week (with 5603 merits) stays at the 28th position, among 113 weeks. +------------------------------+ | weeklyrank merit week | |------------------------------| 1. | 1 27920 2018w4 | 2. | 2 20930 2018w5 | 3. | 3 20397 2019w47 | 4. | 4 14042 2018w6 | 5. | 5 11901 2018w7 | |------------------------------| 6. | 6 11070 2019w46 | 7. | 7 9587 2018w38 | 8. | 8 9005 2018w9 | 9. | 9 8879 2018w8 | 10. | 10 7340 2018w11 | |------------------------------| 11. | 11 7247 2020w3 | 12. | 12 7178 2018w10 | 13. | 13 7138 2018w12 | 14. | 14 7058 2019w52 | 15. | 15 6923 2020w7 | |------------------------------| 16. | 16 6756 2020w5 | 17. | 17 6646 2020w4 | 18. | 18 6542 2018w14 | 19. | 19 6392 2018w13 | 20. | 20 6314 2020w8 | |------------------------------| 21. | 21 6271 2019w48 | 22. | 22 6102 2019w2 | 23. | 23 6066 2019w51 | 24. | 24 5946 2018w15 | 25. | 25 5776 2019w3 | |------------------------------| 26. | 26 5745 2020w1 | 27. | 27 5728 2019w13 | 28. | 28 5603 2020w12 | 29. | 29 5596 2019w20 | 30. | 30 5573 2020w6 | |------------------------------| 31. | 31 5395 2020w2 | 32. | 32 5375 2019w43 | 33. | 33 5373 2019w24 | 34. | 34 5253 2019w15 | 35. | 35 5237 2020w9 | |------------------------------| 36. | 36 5160 2019w42 | 37. | 37 5109 2020w11 | 38. | 38 5043 2018w18 | 39. | 39 5002 2019w19 | 40. | 40 4979 2019w10 | |------------------------------| 41. | 41 4880 2019w16 | 42. | 42 4832 2019w50 | 43. | 43 4820 2018w17 | 44. | 44 4817 2019w18 | 45. | 45 4816 2019w44 | |------------------------------| 46. | 46 4753 2019w45 | 47. | 47 4726 2019w9 | 48. | 48 4701 2019w41 | 49. | 49 4695 2019w14 | 50. | 50 4693 2019w21 | |------------------------------| 51. | 51 4690 2019w12 | 52. | 52 4685 2018w19 | 53. | 53 4684 2018w26 | 54. | 54 4672 2019w26 | 55. | 55 4650 2019w49 | |------------------------------| 56. | 56 4629 2019w25 | 57. | 57 4622 2020w10 | 58. | 58 4606 2018w47 | 59. | 59 4597 2019w23 | 60. | 60 4584 2019w1 | |------------------------------| 61. | 61 4582 2019w4 | 62. | 62 4574 2018w25 | 63. | 63 4508 2018w39 | 64. | 64 4505 2019w6 | 65. | 65 4473 2018w23 | |------------------------------| 66. | 66 4462 2019w28 | 67. | 67 4449 2018w16 | 68. | 68 4431 2018w20 | 69. | 69 4424 2018w42 | 70. | 70 4408 2019w5 | |------------------------------| 71. | 71 4386 2018w43 | 72. | 72 4382 2019w38 | 73. | 73 4377 2019w30 | 74. | 74 4367 2018w27 | 75. | 75 4348 2019w39 | |------------------------------| 76. | 76 4342 2019w22 | 77. | 77 4325 2018w40 | 78. | 78 4314 2019w8 | 79. | 79 4295 2019w11 | 80. | 80 4277 2018w29 | |------------------------------| 81. | 81 4260 2019w17 | 82. | 82 4259 2019w7 | 83. | 83 4248 2018w22 | 84. | 84 4209 2019w40 | 85. | 85 4199 2018w32 | |------------------------------| 86. | 86 4175 2018w45 | 87. | 87 4109 2018w28 | 88. | 88 4047 2018w46 | 89. | 89 4005 2019w29 | 90. | 90 4005 2019w37 | |------------------------------| 91. | 91 3981 2018w41 | 92. | 92 3965 2019w33 | 93. | 93 3953 2018w24 | 94. | 94 3903 2018w21 | 95. | 95 3882 2019w27 | |------------------------------| 96. | 96 3811 2019w34 | 97. | 97 3809 2018w30 | 98. | 98 3791 2018w48 | 99. | 99 3767 2018w33 | 100. | 100 3763 2018w34 | |------------------------------| 101. | 101 3689 2018w50 | 102. | 102 3687 2018w52 | 103. | 103 3683 2019w36 | 104. | 104 3615 2018w51 | 105. | 105 3603 2019w31 | |------------------------------| 106. | 106 3596 2018w49 | 107. | 107 3586 2018w37 | 108. | 108 3579 2019w35 | 109. | 109 3536 2018w36 | 110. | 110 3489 2018w31 | |------------------------------| 111. | 111 3346 2019w32 | 112. | 112 3321 2018w44 | 113. | 113 3186 2018w35 | +------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
March 28, 2020, 04:56:57 AM Last edit: March 28, 2020, 05:24:05 AM by tranthidung |
|
ABSTRACT 2020w12, GMT timeData is the full dataset since 24/1/2018, and only dropped last 3 days belong to incomplete week - 2020w12 and an incomplete day (dayid = 797). Details on days dropped, please see above posts. Intra-day merits:- Total observed days: 791
- Potential outliers are days that have intraday total merits beyond 162 or 1214
- Median of intraday merits over the period is 666
- 50% of observed days have their intra-day merits range from 556 to 819 (the interquartile range)
- In medians, the highest and lowest days are Tuesday and Saturday, respectively; whilst the highest and lowest days in means are Thursday and Sunday, respectively. See here.
- There are 56 potential outliers (beyond 162 or 1214) in total.
- The distribution of outliers over years are: 41 (73.2%) for 2018, 14 (25%) for 2019, and 1 (1.8%) for 2020. (see details)
- Minimum and maximum of intraday merits (full dataset) are 300, and 12676, on 04/8/2019 and 25/1/2018, respectively.
Intra-week merits:- Total observed weeks: 113
- The median of intra-week merits is 4622
- 50% of observed weeks (113 weeks in total), have total merits in the range from 4199 to 5596 (the interquartile range of intra-week merits).
- Minimum and maximum of intra-week merits are 3186 and 27920, in 2018w35, and 2018w4, respectively;
- 9 potential outliers [beyond 2104 or 7692], only 2 of them occurred in the year 2019, on 2019w46 (11070), and 2019w47 (20397).
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
April 04, 2020, 12:30:17 AM |
|
Converted dataset: - In 2020 at 03apr2020 00:12:30 (GMT time)
- The last one, with dayid = 801 is an incomplete day.
+-----------------------------------------------------------------+ | dayid date merit dofw week month year | |-----------------------------------------------------------------| 708. | 708 01jan2020 810 Wednesday 2020w1 2020m1 2020 | 709. | 709 02jan2020 854 Thursday 2020w1 2020m1 2020 | 710. | 710 03jan2020 837 Friday 2020w1 2020m1 2020 | 711. | 711 04jan2020 637 Saturday 2020w1 2020m1 2020 | 712. | 712 05jan2020 777 Sunday 2020w1 2020m1 2020 | |-----------------------------------------------------------------| 713. | 713 06jan2020 959 Monday 2020w1 2020m1 2020 | 714. | 714 07jan2020 871 Tuesday 2020w1 2020m1 2020 | 715. | 715 08jan2020 860 Wednesday 2020w2 2020m1 2020 | 716. | 716 09jan2020 733 Thursday 2020w2 2020m1 2020 | 717. | 717 10jan2020 745 Friday 2020w2 2020m1 2020 | |-----------------------------------------------------------------| 718. | 718 11jan2020 743 Saturday 2020w2 2020m1 2020 | 719. | 719 12jan2020 689 Sunday 2020w2 2020m1 2020 | 720. | 720 13jan2020 754 Monday 2020w2 2020m1 2020 | 721. | 721 14jan2020 871 Tuesday 2020w2 2020m1 2020 | 722. | 722 15jan2020 979 Wednesday 2020w3 2020m1 2020 | |-----------------------------------------------------------------| 723. | 723 16jan2020 972 Thursday 2020w3 2020m1 2020 | 724. | 724 17jan2020 1063 Friday 2020w3 2020m1 2020 | 725. | 725 18jan2020 823 Saturday 2020w3 2020m1 2020 | 726. | 726 19jan2020 1192 Sunday 2020w3 2020m1 2020 | 727. | 727 20jan2020 1136 Monday 2020w3 2020m1 2020 | |-----------------------------------------------------------------| 728. | 728 21jan2020 1082 Tuesday 2020w3 2020m1 2020 | 729. | 729 22jan2020 863 Wednesday 2020w4 2020m1 2020 | 730. | 730 23jan2020 1050 Thursday 2020w4 2020m1 2020 | 731. | 731 24jan2020 1061 Friday 2020w4 2020m1 2020 | 732. | 732 25jan2020 1043 Saturday 2020w4 2020m1 2020 | |-----------------------------------------------------------------| 733. | 733 26jan2020 715 Sunday 2020w4 2020m1 2020 | 734. | 734 27jan2020 961 Monday 2020w4 2020m1 2020 | 735. | 735 28jan2020 953 Tuesday 2020w4 2020m1 2020 | 736. | 736 29jan2020 1051 Wednesday 2020w5 2020m1 2020 | 737. | 737 30jan2020 1125 Thursday 2020w5 2020m1 2020 | |-----------------------------------------------------------------| 738. | 738 31jan2020 1072 Friday 2020w5 2020m1 2020 | 739. | 739 01feb2020 705 Saturday 2020w5 2020m2 2020 | 740. | 740 02feb2020 836 Sunday 2020w5 2020m2 2020 | 741. | 741 03feb2020 908 Monday 2020w5 2020m2 2020 | 742. | 742 04feb2020 1059 Tuesday 2020w5 2020m2 2020 | |-----------------------------------------------------------------| 743. | 743 05feb2020 873 Wednesday 2020w6 2020m2 2020 | 744. | 744 06feb2020 932 Thursday 2020w6 2020m2 2020 | 745. | 745 07feb2020 800 Friday 2020w6 2020m2 2020 | 746. | 746 08feb2020 763 Saturday 2020w6 2020m2 2020 | 747. | 747 09feb2020 724 Sunday 2020w6 2020m2 2020 | |-----------------------------------------------------------------| 748. | 748 10feb2020 812 Monday 2020w6 2020m2 2020 | 749. | 749 11feb2020 669 Tuesday 2020w6 2020m2 2020 | 750. | 750 12feb2020 596 Wednesday 2020w7 2020m2 2020 | 751. | 751 13feb2020 1047 Thursday 2020w7 2020m2 2020 | 752. | 752 14feb2020 1041 Friday 2020w7 2020m2 2020 | |-----------------------------------------------------------------| 753. | 753 15feb2020 890 Saturday 2020w7 2020m2 2020 | 754. | 754 16feb2020 790 Sunday 2020w7 2020m2 2020 | 755. | 755 17feb2020 1364 Monday 2020w7 2020m2 2020 | 756. | 756 18feb2020 1195 Tuesday 2020w7 2020m2 2020 | 757. | 757 19feb2020 1004 Wednesday 2020w8 2020m2 2020 | |-----------------------------------------------------------------| 758. | 758 20feb2020 782 Thursday 2020w8 2020m2 2020 | 759. | 759 21feb2020 1050 Friday 2020w8 2020m2 2020 | 760. | 760 22feb2020 729 Saturday 2020w8 2020m2 2020 | 761. | 761 23feb2020 724 Sunday 2020w8 2020m2 2020 | 762. | 762 24feb2020 1037 Monday 2020w8 2020m2 2020 | |-----------------------------------------------------------------| 763. | 763 25feb2020 988 Tuesday 2020w8 2020m2 2020 | 764. | 764 26feb2020 857 Wednesday 2020w9 2020m2 2020 | 765. | 765 27feb2020 960 Thursday 2020w9 2020m2 2020 | 766. | 766 28feb2020 678 Friday 2020w9 2020m2 2020 | 767. | 767 29feb2020 662 Saturday 2020w9 2020m2 2020 | |-----------------------------------------------------------------| 768. | 768 01mar2020 651 Sunday 2020w9 2020m3 2020 | 769. | 769 02mar2020 755 Monday 2020w9 2020m3 2020 | 770. | 770 03mar2020 674 Tuesday 2020w9 2020m3 2020 | 771. | 771 04mar2020 572 Wednesday 2020w10 2020m3 2020 | 772. | 772 05mar2020 727 Thursday 2020w10 2020m3 2020 | |-----------------------------------------------------------------| 773. | 773 06mar2020 622 Friday 2020w10 2020m3 2020 | 774. | 774 07mar2020 697 Saturday 2020w10 2020m3 2020 | 775. | 775 08mar2020 670 Sunday 2020w10 2020m3 2020 | 776. | 776 09mar2020 634 Monday 2020w10 2020m3 2020 | 777. | 777 10mar2020 700 Tuesday 2020w10 2020m3 2020 | |-----------------------------------------------------------------| 778. | 778 11mar2020 800 Wednesday 2020w11 2020m3 2020 | 779. | 779 12mar2020 790 Thursday 2020w11 2020m3 2020 | 780. | 780 13mar2020 748 Friday 2020w11 2020m3 2020 | 781. | 781 14mar2020 562 Saturday 2020w11 2020m3 2020 | 782. | 782 15mar2020 528 Sunday 2020w11 2020m3 2020 | |-----------------------------------------------------------------| 783. | 783 16mar2020 888 Monday 2020w11 2020m3 2020 | 784. | 784 17mar2020 793 Tuesday 2020w11 2020m3 2020 | 785. | 785 18mar2020 1090 Wednesday 2020w12 2020m3 2020 | 786. | 786 19mar2020 867 Thursday 2020w12 2020m3 2020 | 787. | 787 20mar2020 999 Friday 2020w12 2020m3 2020 | |-----------------------------------------------------------------| 788. | 788 21mar2020 628 Saturday 2020w12 2020m3 2020 | 789. | 789 22mar2020 549 Sunday 2020w12 2020m3 2020 | 790. | 790 23mar2020 683 Monday 2020w12 2020m3 2020 | 791. | 791 24mar2020 787 Tuesday 2020w12 2020m3 2020 | 792. | 792 25mar2020 786 Wednesday 2020w13 2020m3 2020 | |-----------------------------------------------------------------| 793. | 793 26mar2020 855 Thursday 2020w13 2020m3 2020 | 794. | 794 27mar2020 934 Friday 2020w13 2020m3 2020 | 795. | 795 28mar2020 658 Saturday 2020w13 2020m3 2020 | 796. | 796 29mar2020 452 Sunday 2020w13 2020m3 2020 | 797. | 797 30mar2020 909 Monday 2020w13 2020m3 2020 | |-----------------------------------------------------------------| 798. | 798 31mar2020 798 Tuesday 2020w13 2020m3 2020 | 799. | 799 01apr2020 858 Wednesday 2020w14 2020m4 2020 | 800. | 800 02apr2020 1062 Thursday 2020w14 2020m4 2020 | 801. | 801 03apr2020 33 Friday 2020w14 2020m4 2020 | +-----------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
April 04, 2020, 12:47:00 AM Last edit: April 04, 2020, 01:12:58 AM by tranthidung |
|
Time-series plots:Full dataset:Truncated dataset: Basic statistics (for full dataset): Only drop last 3 days that belong to the 2020w14 (daydi = 799, 800), the incomplete week & incomlete day (dayid = 801). variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 798 793.7682 665.8646 667 557 823 300 12676 ----------------------------------------------------------------------------------------------
Applied formulas in previous weeks, potential outliers are days have intra-day merits beyond 158 or 1222. . di 823-557 266
. di 266*1.5 399
. di 823+399 1222
. di 557-399 158
There are 54 outliers (beyond 1222 or 158) in full dataset, in total. . count if (merit >= 1222 | merit <= 158) & merit != . 54
Those days are: +---------------------------+ | dayid merit date | |---------------------------| 2. | 2 12676 25jan2018 | 3. | 3 6348 26jan2018 | 4. | 4 4627 27jan2018 | 5. | 5 3240 28jan2018 | 6. | 6 3343 29jan2018 | 7. | 7 3804 30jan2018 | 8. | 8 4103 31jan2018 | 9. | 9 2793 01feb2018 | 10. | 10 2621 02feb2018 | 11. | 11 2476 03feb2018 | 12. | 12 1790 04feb2018 | 13. | 13 2263 05feb2018 | 14. | 14 2003 06feb2018 | 15. | 15 2367 07feb2018 | 16. | 16 2059 08feb2018 | 17. | 17 2223 09feb2018 | 18. | 18 1334 10feb2018 | 19. | 19 1793 11feb2018 | 20. | 20 1475 12feb2018 | 21. | 21 1289 13feb2018 | 22. | 22 1580 14feb2018 | 23. | 23 2797 15feb2018 | 24. | 24 1740 16feb2018 | 25. | 25 1431 17feb2018 | 26. | 26 1589 18feb2018 | 27. | 27 1289 19feb2018 | 28. | 28 1442 20feb2018 | 30. | 30 1277 22feb2018 | 31. | 31 1249 23feb2018 | 33. | 33 1372 25feb2018 | 35. | 35 1414 27feb2018 | 36. | 36 1302 28feb2018 | 38. | 38 1345 02mar2018 | 39. | 39 1727 03mar2018 | 49. | 49 1316 13mar2018 | 51. | 51 1224 15mar2018 | 57. | 57 1390 21mar2018 | 237. | 237 2553 17sep2018 | 238. | 238 1807 18sep2018 | 239. | 239 1347 19sep2018 | |---------------------------| 429. | 429 1247 28mar2019 | 505. | 505 1227 12jun2019 | 660. | 660 1630 14nov2019 | 661. | 661 2374 15nov2019 | 662. | 662 1585 16nov2019 | 663. | 663 1377 17nov2019 | 664. | 664 2783 18nov2019 | 665. | 665 3826 19nov2019 | 666. | 666 2584 20nov2019 | 667. | 667 4889 21nov2019 | 668. | 668 5515 22nov2019 | 669. | 669 1590 23nov2019 | 678. | 678 1465 02dec2019 | |---------------------------| 755. | 755 1364 17feb2020 | +---------------------------+
Distributions of outliers over years:- 2018: 40 (74.1%)
- 2019: 13 (24.1%)
- 2020: 1 (1.8%)
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
April 04, 2020, 12:48:32 AM |
|
During the period from 24/1/2018 to 31/3/2020 (last 3 days dropped due to incomplete week, 2020w14 and an incomplete day - dayid = 801), the minimum and maximum of intra-day merit are 300 and 12676, on 04/8/2019 and 25/1/2018, respectively. List of the top 50-highest day in terms of intra-day merits: +-----------------------------------------------------------------------------+ | rank_max merit dayid date dofw week month year | |-----------------------------------------------------------------------------| 1. | 1 12676 2 25jan2018 Thursday 2018w4 2018m1 2018 | 2. | 2 6348 3 26jan2018 Friday 2018w4 2018m1 2018 | 3. | 3 5515 668 22nov2019 Friday 2019w47 2019m11 2019 | 4. | 4 4889 667 21nov2019 Thursday 2019w47 2019m11 2019 | 5. | 5 4627 4 27jan2018 Saturday 2018w4 2018m1 2018 | |-----------------------------------------------------------------------------| 6. | 6 4103 8 31jan2018 Wednesday 2018w5 2018m1 2018 | 7. | 7 3826 665 19nov2019 Tuesday 2019w47 2019m11 2019 | 8. | 8 3804 7 30jan2018 Tuesday 2018w5 2018m1 2018 | 9. | 9 3343 6 29jan2018 Monday 2018w5 2018m1 2018 | 10. | 10 3240 5 28jan2018 Sunday 2018w4 2018m1 2018 | |-----------------------------------------------------------------------------| 11. | 11 2797 23 15feb2018 Thursday 2018w7 2018m2 2018 | 12. | 12 2793 9 01feb2018 Thursday 2018w5 2018m2 2018 | 13. | 13 2783 664 18nov2019 Monday 2019w46 2019m11 2019 | 14. | 14 2621 10 02feb2018 Friday 2018w5 2018m2 2018 | 15. | 15 2584 666 20nov2019 Wednesday 2019w47 2019m11 2019 | |-----------------------------------------------------------------------------| 16. | 16 2553 237 17sep2018 Monday 2018w38 2018m9 2018 | 17. | 17 2476 11 03feb2018 Saturday 2018w5 2018m2 2018 | 18. | 18 2374 661 15nov2019 Friday 2019w46 2019m11 2019 | 19. | 19 2367 15 07feb2018 Wednesday 2018w6 2018m2 2018 | 20. | 20 2263 13 05feb2018 Monday 2018w6 2018m2 2018 | |-----------------------------------------------------------------------------| 21. | 21 2223 17 09feb2018 Friday 2018w6 2018m2 2018 | 22. | 22 2059 16 08feb2018 Thursday 2018w6 2018m2 2018 | 23. | 23 2003 14 06feb2018 Tuesday 2018w6 2018m2 2018 | 24. | 24 1807 238 18sep2018 Tuesday 2018w38 2018m9 2018 | 25. | 25 1793 19 11feb2018 Sunday 2018w6 2018m2 2018 | |-----------------------------------------------------------------------------| 26. | 26 1790 12 04feb2018 Sunday 2018w5 2018m2 2018 | 27. | 27 1740 24 16feb2018 Friday 2018w7 2018m2 2018 | 28. | 28 1727 39 03mar2018 Saturday 2018w9 2018m3 2018 | 29. | 29 1630 660 14nov2019 Thursday 2019w46 2019m11 2019 | 30. | 30 1590 669 23nov2019 Saturday 2019w47 2019m11 2019 | |-----------------------------------------------------------------------------| 31. | 31 1589 26 18feb2018 Sunday 2018w7 2018m2 2018 | 32. | 32 1585 662 16nov2019 Saturday 2019w46 2019m11 2019 | 33. | 33 1580 22 14feb2018 Wednesday 2018w7 2018m2 2018 | 34. | 34 1475 20 12feb2018 Monday 2018w7 2018m2 2018 | 35. | 35 1465 678 02dec2019 Monday 2019w48 2019m12 2019 | |-----------------------------------------------------------------------------| 36. | 36 1442 28 20feb2018 Tuesday 2018w8 2018m2 2018 | 37. | 37 1431 25 17feb2018 Saturday 2018w7 2018m2 2018 | 38. | 38 1414 35 27feb2018 Tuesday 2018w9 2018m2 2018 | 39. | 39 1390 57 21mar2018 Wednesday 2018w12 2018m3 2018 | 40. | 40 1377 663 17nov2019 Sunday 2019w46 2019m11 2019 | |-----------------------------------------------------------------------------| 41. | 41 1372 33 25feb2018 Sunday 2018w8 2018m2 2018 | 42. | 42 1364 755 17feb2020 Monday 2020w7 2020m2 2020 | 43. | 43 1347 239 19sep2018 Wednesday 2018w38 2018m9 2018 | 44. | 44 1345 38 02mar2018 Friday 2018w9 2018m3 2018 | 45. | 45 1334 18 10feb2018 Saturday 2018w6 2018m2 2018 | |-----------------------------------------------------------------------------| 46. | 46 1316 49 13mar2018 Tuesday 2018w11 2018m3 2018 | 47. | 47 1302 36 28feb2018 Wednesday 2018w9 2018m2 2018 | 48. | 48 1289 27 19feb2018 Monday 2018w8 2018m2 2018 | 49. | 49 1289 21 13feb2018 Tuesday 2018w7 2018m2 2018 | 50. | 50 1277 30 22feb2018 Thursday 2018w8 2018m2 2018 | +-----------------------------------------------------------------------------+
List of the top 50-lowest days in terms of intra-day merits: +-----------------------------------------------------------------------------+ | rank_min merit dayid date dofw week month year | |-----------------------------------------------------------------------------| 1. | 1 300 558 04aug2019 Sunday 2019w31 2019m8 2019 | 2. | 2 333 341 30dec2018 Sunday 2018w52 2018m12 2018 | 3. | 3 339 343 01jan2019 Tuesday 2019w1 2019m1 2019 | 4. | 4 347 330 19dec2018 Wednesday 2018w51 2018m12 2018 | 5. | 5 347 299 18nov2018 Sunday 2018w46 2018m11 2018 | |-----------------------------------------------------------------------------| 6. | 6 351 334 23dec2018 Sunday 2018w51 2018m12 2018 | 7. | 7 366 218 29aug2018 Wednesday 2018w35 2018m8 2018 | 8. | 8 367 565 11aug2019 Sunday 2019w32 2019m8 2019 | 9. | 9 370 223 03sep2018 Monday 2018w36 2018m9 2018 | 10. | 10 373 339 28dec2018 Friday 2018w52 2018m12 2018 | |-----------------------------------------------------------------------------| 11. | 11 375 340 29dec2018 Saturday 2018w52 2018m12 2018 | 12. | 12 377 600 15sep2019 Sunday 2019w37 2019m9 2019 | 13. | 13 378 566 12aug2019 Monday 2019w32 2019m8 2019 | 14. | 14 378 305 24nov2018 Saturday 2018w47 2018m11 2018 | 15. | 15 378 567 13aug2019 Tuesday 2019w33 2019m8 2019 | |-----------------------------------------------------------------------------| 16. | 16 380 192 03aug2018 Friday 2018w31 2018m8 2018 | 17. | 17 381 336 25dec2018 Tuesday 2018w52 2018m12 2018 | 18. | 18 385 215 26aug2018 Sunday 2018w34 2018m8 2018 | 19. | 19 385 327 16dec2018 Sunday 2018w50 2018m12 2018 | 20. | 20 391 221 01sep2018 Saturday 2018w35 2018m9 2018 | |-----------------------------------------------------------------------------| 21. | 21 394 188 30jul2018 Monday 2018w31 2018m7 2018 | 22. | 22 399 593 08sep2019 Sunday 2019w36 2019m9 2019 | 23. | 23 401 557 03aug2019 Saturday 2019w31 2019m8 2019 | 24. | 24 401 288 07nov2018 Wednesday 2018w45 2018m11 2018 | 25. | 25 402 263 13oct2018 Saturday 2018w41 2018m10 2018 | |-----------------------------------------------------------------------------| 26. | 26 404 229 09sep2018 Sunday 2018w36 2018m9 2018 | 27. | 27 406 277 27oct2018 Saturday 2018w43 2018m10 2018 | 28. | 28 408 530 07jul2019 Sunday 2019w27 2019m7 2019 | 29. | 29 409 123 26may2018 Saturday 2018w21 2018m5 2018 | 30. | 30 409 589 04sep2019 Wednesday 2019w36 2019m9 2019 | |-----------------------------------------------------------------------------| 31. | 31 410 279 29oct2018 Monday 2018w44 2018m10 2018 | 32. | 32 411 578 24aug2019 Saturday 2019w34 2019m8 2019 | 33. | 33 411 569 15aug2019 Thursday 2019w33 2019m8 2019 | 34. | 34 414 528 05jul2019 Friday 2019w27 2019m7 2019 | 35. | 35 421 193 04aug2018 Saturday 2018w31 2018m8 2018 | |-----------------------------------------------------------------------------| 36. | 36 425 588 03sep2019 Tuesday 2019w36 2019m9 2019 | 37. | 37 426 230 10sep2018 Monday 2018w37 2018m9 2018 | 38. | 38 426 346 04jan2019 Friday 2019w1 2019m1 2019 | 39. | 39 427 141 13jun2018 Wednesday 2018w24 2018m6 2018 | 40. | 40 430 207 18aug2018 Saturday 2018w33 2018m8 2018 | |-----------------------------------------------------------------------------| 41. | 41 432 587 02sep2019 Monday 2019w35 2019m9 2019 | 42. | 42 435 522 29jun2019 Saturday 2019w26 2019m6 2019 | 43. | 43 436 419 18mar2019 Monday 2019w11 2019m3 2019 | 44. | 44 440 585 31aug2019 Saturday 2019w35 2019m8 2019 | 45. | 45 440 559 05aug2019 Monday 2019w31 2019m8 2019 | |-----------------------------------------------------------------------------| 46. | 46 440 265 15oct2018 Monday 2018w42 2018m10 2018 | 47. | 47 441 319 08dec2018 Saturday 2018w49 2018m12 2018 | 48. | 48 441 404 03mar2019 Sunday 2019w9 2019m3 2019 | 49. | 49 442 278 28oct2018 Sunday 2018w43 2018m10 2018 | 50. | 50 442 342 31dec2018 Monday 2018w52 2018m12 2018 | +-----------------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
April 04, 2020, 12:52:17 AM Last edit: April 04, 2020, 01:12:25 AM by tranthidung |
|
Medians and means of intra-day merits over days of weeks GMT timeColors: - Green: highest.
- Red: Lowest.
- In median, the highest days are Thursday , Tuesday, and Friday at 706, 705, and 700, respectively; whislt the lowest days are Saturday, Sunday, and Monday at 603, 615, and 662, respectively. - In means, the highest days are Thursday, Friday, and Tuesday at 915, 856, and 816, respectively; whilst the lowest days are Sunday, Saturday, and Monday, at 694, 708, and 783, respectively. Basic statistics:Summary for variables: merit by categories of: dofw
dofw | N mean sd p50 p25 p75 min max ----------+-------------------------------------------------------------------------------- Sunday | 114.0 694.0 361.8 614.5 495.0 747.0 300.0 3240.0 Monday | 114.0 783.0 445.1 662.0 558.0 876.0 370.0 3343.0 Tuesday | 114.0 815.2 485.5 704.5 594.0 871.0 339.0 3826.0 Wednesday | 114.0 786.3 443.3 669.5 599.0 836.0 347.0 4103.0 Thursday | 114.0 914.8 1231.5 706.0 584.0 837.0 411.0 12676.0 Friday | 114.0 855.5 766.8 699.5 564.0 858.0 373.0 6348.0 Saturday | 114.0 707.7 473.9 603.0 503.0 729.0 375.0 4627.0 ----------+-------------------------------------------------------------------------------- Total | 798.0 793.8 665.9 667.0 557.0 823.0 300.0 12676.0 -------------------------------------------------------------------------------------------
Box plotsOutliers displayed as red circles. Outliers non-displayed. Details on ranks:In medians +----------------------------------------------------------------------+ | rankmedian dofw median mean p25 p75 min max | |----------------------------------------------------------------------| 1. | 1 Thursday 706 914.7632 584 837 411 12676 | 2. | 2 Tuesday 704.5 815.1667 594 871 339 3826 | 3. | 3 Friday 699.5 855.5175 564 858 373 6348 | 4. | 4 Wednesday 669.5 786.307 599 836 347 4103 | 5. | 5 Monday 662 782.9912 558 876 370 3343 | |----------------------------------------------------------------------| 6. | 6 Sunday 614.5 693.9737 495 747 300 3240 | 7. | 7 Saturday 603 707.6579 503 729 375 4627 | +----------------------------------------------------------------------+
In means +--------------------------------------------------------------------+ | rankmean dofw mean median p25 p75 min max | |--------------------------------------------------------------------| 1. | 1 Thursday 914.7632 706 584 837 411 12676 | 2. | 2 Friday 855.5175 699.5 564 858 373 6348 | 3. | 3 Tuesday 815.1667 704.5 594 871 339 3826 | 4. | 4 Wednesday 786.307 669.5 599 836 347 4103 | 5. | 5 Monday 782.9912 662 558 876 370 3343 | |--------------------------------------------------------------------| 6. | 6 Saturday 707.6579 603 503 729 375 4627 | 7. | 7 Sunday 693.9737 614.5 495 747 300 3240 | +--------------------------------------------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
April 04, 2020, 12:58:35 AM Last edit: April 04, 2020, 01:11:43 AM by tranthidung |
|
Intra-week merits (from 24/1/2018 to 31/3/2020)Last 3 days dropped due to incomplete week (2020w14) and an incomplete day (dayid = 801)Converted dataset: +-----------------+ | merit week | |-----------------| 1. | 27920 2018w4 | 2. | 20930 2018w5 | 3. | 14042 2018w6 | 4. | 11901 2018w7 | 5. | 8879 2018w8 | |-----------------| 6. | 9005 2018w9 | 7. | 7178 2018w10 | 8. | 7340 2018w11 | 9. | 7138 2018w12 | 10. | 6392 2018w13 | |-----------------| 11. | 6542 2018w14 | 12. | 5946 2018w15 | 13. | 4449 2018w16 | 14. | 4820 2018w17 | 15. | 5043 2018w18 | |-----------------| 16. | 4685 2018w19 | 17. | 4431 2018w20 | 18. | 3903 2018w21 | 19. | 4248 2018w22 | 20. | 4473 2018w23 | |-----------------| 21. | 3953 2018w24 | 22. | 4574 2018w25 | 23. | 4684 2018w26 | 24. | 4367 2018w27 | 25. | 4109 2018w28 | |-----------------| 26. | 4277 2018w29 | 27. | 3809 2018w30 | 28. | 3489 2018w31 | 29. | 4199 2018w32 | 30. | 3767 2018w33 | |-----------------| 31. | 3763 2018w34 | 32. | 3186 2018w35 | 33. | 3536 2018w36 | 34. | 3586 2018w37 | 35. | 9587 2018w38 | |-----------------| 36. | 4508 2018w39 | 37. | 4325 2018w40 | 38. | 3981 2018w41 | 39. | 4424 2018w42 | 40. | 4386 2018w43 | |-----------------| 41. | 3321 2018w44 | 42. | 4175 2018w45 | 43. | 4047 2018w46 | 44. | 4606 2018w47 | 45. | 3791 2018w48 | |-----------------| 46. | 3596 2018w49 | 47. | 3689 2018w50 | 48. | 3615 2018w51 | 49. | 3687 2018w52 | 50. | 4584 2019w1 | |-----------------| 51. | 6102 2019w2 | 52. | 5776 2019w3 | 53. | 4582 2019w4 | 54. | 4408 2019w5 | 55. | 4505 2019w6 | |-----------------| 56. | 4259 2019w7 | 57. | 4314 2019w8 | 58. | 4726 2019w9 | 59. | 4979 2019w10 | 60. | 4295 2019w11 | |-----------------| 61. | 4690 2019w12 | 62. | 5728 2019w13 | 63. | 4695 2019w14 | 64. | 5253 2019w15 | 65. | 4880 2019w16 | |-----------------| 66. | 4260 2019w17 | 67. | 4817 2019w18 | 68. | 5002 2019w19 | 69. | 5596 2019w20 | 70. | 4693 2019w21 | |-----------------| 71. | 4342 2019w22 | 72. | 4597 2019w23 | 73. | 5373 2019w24 | 74. | 4629 2019w25 | 75. | 4672 2019w26 | |-----------------| 76. | 3882 2019w27 | 77. | 4462 2019w28 | 78. | 4005 2019w29 | 79. | 4377 2019w30 | 80. | 3603 2019w31 | |-----------------| 81. | 3346 2019w32 | 82. | 3965 2019w33 | 83. | 3811 2019w34 | 84. | 3579 2019w35 | 85. | 3683 2019w36 | |-----------------| 86. | 4005 2019w37 | 87. | 4382 2019w38 | 88. | 4348 2019w39 | 89. | 4209 2019w40 | 90. | 4701 2019w41 | |-----------------| 91. | 5160 2019w42 | 92. | 5375 2019w43 | 93. | 4816 2019w44 | 94. | 4753 2019w45 | 95. | 11070 2019w46 | |-----------------| 96. | 20397 2019w47 | 97. | 6271 2019w48 | 98. | 4650 2019w49 | 99. | 4832 2019w50 | 100. | 6066 2019w51 | |-----------------| 101. | 7058 2019w52 | 102. | 5745 2020w1 | 103. | 5395 2020w2 | 104. | 7247 2020w3 | 105. | 6646 2020w4 | |-----------------| 106. | 6756 2020w5 | 107. | 5573 2020w6 | 108. | 6923 2020w7 | 109. | 6314 2020w8 | 110. | 5237 2020w9 | |-----------------| 111. | 4622 2020w10 | 112. | 5109 2020w11 | 113. | 5603 2020w12 | 114. | 5392 2020w13 | +-----------------+
Time series plotBasic statistics:- 50% of observed weeks ( 114 weeks) have total intra-week merits above 4626, whilst the rest 50% of them have total intra-week merits below 4626. 4626 is the median - p50. - 50% of observed weeks have total intra-week merits fluctuated in the range from 4199 to 5596 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 3186 - 27920. variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 114.0 5556.4 3397.9 4625.5 4199.0 5596.0 3186.0 27920.0 ----------------------------------------------------------------------------------------------
Potential outliers:It means that potential outliers are weeks that have intra-week merits beyond 2104 or 7692. How many weeks are potential outliers? . count if (merit >= 7692 | merit < 2104) & merit != . 9
9 weeks are outliers, in total. List of those 9 weeks: +-----------------+ | merit week | |-----------------| 1. | 27920 2018w4 | 2. | 20930 2018w5 | 3. | 14042 2018w6 | 4. | 11901 2018w7 | 5. | 8879 2018w8 | |-----------------| 6. | 9005 2018w9 | 35. | 9587 2018w38 | 95. | 11070 2019w46 | 96. | 20397 2019w47 | +-----------------+
Most of them occured in the year 2018, and there is only 2 outliers week occured in 2019, in 2019w46 (11070), 2019w47 ( 20397). List of weeks in descending weekly meritsThe last week (with 5392 merits) stays at the 32th position, among 114 weeks. +------------------------------+ | weeklyrank merit week | |------------------------------| 1. | 1 27920 2018w4 | 2. | 2 20930 2018w5 | 3. | 3 20397 2019w47 | 4. | 4 14042 2018w6 | 5. | 5 11901 2018w7 | |------------------------------| 6. | 6 11070 2019w46 | 7. | 7 9587 2018w38 | 8. | 8 9005 2018w9 | 9. | 9 8879 2018w8 | 10. | 10 7340 2018w11 | |------------------------------| 11. | 11 7247 2020w3 | 12. | 12 7178 2018w10 | 13. | 13 7138 2018w12 | 14. | 14 7058 2019w52 | 15. | 15 6923 2020w7 | |------------------------------| 16. | 16 6756 2020w5 | 17. | 17 6646 2020w4 | 18. | 18 6542 2018w14 | 19. | 19 6392 2018w13 | 20. | 20 6314 2020w8 | |------------------------------| 21. | 21 6271 2019w48 | 22. | 22 6102 2019w2 | 23. | 23 6066 2019w51 | 24. | 24 5946 2018w15 | 25. | 25 5776 2019w3 | |------------------------------| 26. | 26 5745 2020w1 | 27. | 27 5728 2019w13 | 28. | 28 5603 2020w12 | 29. | 29 5596 2019w20 | 30. | 30 5573 2020w6 | |------------------------------| 31. | 31 5395 2020w2 | 32. | 32 5392 2020w13 | 33. | 33 5375 2019w43 | 34. | 34 5373 2019w24 | 35. | 35 5253 2019w15 | |------------------------------| 36. | 36 5237 2020w9 | 37. | 37 5160 2019w42 | 38. | 38 5109 2020w11 | 39. | 39 5043 2018w18 | 40. | 40 5002 2019w19 | |------------------------------| 41. | 41 4979 2019w10 | 42. | 42 4880 2019w16 | 43. | 43 4832 2019w50 | 44. | 44 4820 2018w17 | 45. | 45 4817 2019w18 | |------------------------------| 46. | 46 4816 2019w44 | 47. | 47 4753 2019w45 | 48. | 48 4726 2019w9 | 49. | 49 4701 2019w41 | 50. | 50 4695 2019w14 | |------------------------------| 51. | 51 4693 2019w21 | 52. | 52 4690 2019w12 | 53. | 53 4685 2018w19 | 54. | 54 4684 2018w26 | 55. | 55 4672 2019w26 | |------------------------------| 56. | 56 4650 2019w49 | 57. | 57 4629 2019w25 | 58. | 58 4622 2020w10 | 59. | 59 4606 2018w47 | 60. | 60 4597 2019w23 | |------------------------------| 61. | 61 4584 2019w1 | 62. | 62 4582 2019w4 | 63. | 63 4574 2018w25 | 64. | 64 4508 2018w39 | 65. | 65 4505 2019w6 | |------------------------------| 66. | 66 4473 2018w23 | 67. | 67 4462 2019w28 | 68. | 68 4449 2018w16 | 69. | 69 4431 2018w20 | 70. | 70 4424 2018w42 | |------------------------------| 71. | 71 4408 2019w5 | 72. | 72 4386 2018w43 | 73. | 73 4382 2019w38 | 74. | 74 4377 2019w30 | 75. | 75 4367 2018w27 | |------------------------------| 76. | 76 4348 2019w39 | 77. | 77 4342 2019w22 | 78. | 78 4325 2018w40 | 79. | 79 4314 2019w8 | 80. | 80 4295 2019w11 | |------------------------------| 81. | 81 4277 2018w29 | 82. | 82 4260 2019w17 | 83. | 83 4259 2019w7 | 84. | 84 4248 2018w22 | 85. | 85 4209 2019w40 | |------------------------------| 86. | 86 4199 2018w32 | 87. | 87 4175 2018w45 | 88. | 88 4109 2018w28 | 89. | 89 4047 2018w46 | 90. | 90 4005 2019w37 | |------------------------------| 91. | 91 4005 2019w29 | 92. | 92 3981 2018w41 | 93. | 93 3965 2019w33 | 94. | 94 3953 2018w24 | 95. | 95 3903 2018w21 | |------------------------------| 96. | 96 3882 2019w27 | 97. | 97 3811 2019w34 | 98. | 98 3809 2018w30 | 99. | 99 3791 2018w48 | 100. | 100 3767 2018w33 | |------------------------------| 101. | 101 3763 2018w34 | 102. | 102 3689 2018w50 | 103. | 103 3687 2018w52 | 104. | 104 3683 2019w36 | 105. | 105 3615 2018w51 | |------------------------------| 106. | 106 3603 2019w31 | 107. | 107 3596 2018w49 | 108. | 108 3586 2018w37 | 109. | 109 3579 2019w35 | 110. | 110 3536 2018w36 | |------------------------------| 111. | 111 3489 2018w31 | 112. | 112 3346 2019w32 | 113. | 113 3321 2018w44 | 114. | 114 3186 2018w35 | +------------------------------+
|
|
|
|
tranthidung (OP)
Legendary
Offline
Activity: 2268
Merit: 4010
Farewell o_e_l_e_o
|
|
April 04, 2020, 01:03:46 AM |
|
Intra-month merits (from 24/1/2018 to 31/03/2020)There are days dropped in order to get data for entire month. Day with id > 798 dropped because those days belong to the incomplete April of 2020 (2020m4).Converted dataset: +-----------------+ | merit month | |-----------------| 1. | 39170 2018m1 | 2. | 48374 2018m2 | 3. | 32141 2018m3 | 4. | 23482 2018m4 | 5. | 19807 2018m5 | |-----------------| 6. | 18693 2018m6 | 7. | 18286 2018m7 | 8. | 16631 2018m8 | 9. | 22075 2018m9 | 10. | 18592 2018m10 | |-----------------| 11. | 17442 2018m11 | 12. | 15609 2018m12 | 13. | 22875 2019m1 | 14. | 17756 2019m2 | 15. | 21467 2019m3 | |-----------------| 16. | 20698 2019m4 | 17. | 22069 2019m5 | 18. | 20355 2019m6 | 19. | 18485 2019m7 | 20. | 16094 2019m8 | |-----------------| 21. | 17406 2019m9 | 22. | 21583 2019m10 | 23. | 42866 2019m11 | 24. | 24909 2019m12 | 25. | 28281 2020m1 | |-----------------| 26. | 25475 2020m2 | 27. | 22806 2020m3 | +-----------------+
Time series plotBasic statistics:- 50% of observed months ( 27 months) have total intra-month merits above 21467, whilst the rest 50% of them have total intra-month merits below 21467. 21467 is the median - p50. - 50% of observed months have total intra-month merits fluctuated in the range from 18286 to 24909 (the interquartile range, from p25 to p75, in raw statistics below). - Min - max: 15609 - 48374. variable | N mean sd p50 p25 p75 min max -------------+-------------------------------------------------------------------------------- merit | 27 23460.26 8221.631 21467 18286 24909 15609 48374 ----------------------------------------------------------------------------------------------
Potential outliers:. di 24909-18286 6623
. di 6623*1.5 9934.5
. di 24909+9934.5 34843.5
. di 18286-9934.5 8351.5
It means that potential outliers are months that have intra-month merits beyond 8352 or 34844. How many months are potential outliers? . count if (merit >= 34844 | merit <= 8352) & merit != . 3
3 months are outliers, in total. List of those four months: +-----------------+ | merit month | |-----------------| 1. | 39170 2018m1 | 2. | 48374 2018m2 | 23. | 42866 2019m11 | +-----------------+
Most of them occured in the year 2018, during the first three months after merit system activated. Only one outlier month detected in 2019, that is 2019m11, at 42866.
|
|
|
|
|