Bitcoin Forum
October 19, 2019, 01:43:46 PM *
News: 10th anniversary art contest
 
   Home   Help Search Login Register More  
Pages: « 1 [2] 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 »  All
  Print  
Author Topic: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly)  (Read 22122 times)
tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
December 09, 2018, 12:14:03 AM
Last edit: December 09, 2018, 08:23:52 AM by tranthidung
 #21

Thanks LoyceV for updates last two weeks.
I am busy recent days, so I did not update my topic last week.
I will do it hours later today.


Abstract (for truncated dataset)
50% of observed days (since 19/02/2018 to 02/12/2018) have its total daily merits below 626 (the median) or higher than 626.
Importantly, 50% of observed days have their total daily merits in the range from 521 to 774, which is the interquartile range that ranges from the 25th quartile (Q1) to the 75th quartile (Q3).
The minimum and maximum daily merits during the period are 347 and 2463, respectively.
Potential outliers are days that have total merits above 1154 or below 142.
About medians of merits over days of week, Monday is the highest with 674 merits distributed on Mondays in medians, and Friday is the lowest with the median of Friday merits is 542. There are nearly 24% difference between the medians of Friday and Monday.
And, Friday is the only day of week which has median lower than 600.


Updates:
1) Daily merits
1.1. Full dataset (from 24/1/2018 to 2/12/2018)
I dropped days after 2/12/2018 because those days belong to the 2018w49, which has not completed with LoyceV data source).
Now, lets' take a look at its basic statistics:
During the whole period since the beginning day of merit system, the daily merits
has its median is 643, which means that 50% of those observed days have their daily merits above 643, and 50% of them have their daily merits above 643.
- The interquartile range (from 25th to 75th quartile): is 530 - 858. It means that 50% of those observed days have daily merits in the range from 530 to 858. In addition, 25% of those days have daily merits below 530 (below the 25h quartile), while 25% of them have daily merits above 858 (above the 75th quartile).
- The mean +/- standard deviation: is 880 +/- 952. I don't want to use those statistics due to dramatical biases from outliers.

Extremely potential outliers are days have their total daily merits above 1350 or below 38. Detailed calculations presented below:
- Below: Q1 -1.5*IQR = 530-(1.5*328) = 38;
- or Above: Q3 + 1.5*IQR = 858+(1.5*328) = 1350.
- IQR = Q3 - Q1 = 858 - 530 = 328

From now on, I only presented analytical results for truncated dataset.
What is truncated dataset?
It is the dataset, after truncating / dropping all days before 19/02/2018, which are extremely outliers.
Code:
. list id date week month merit if merit > 1350 & merit != .

     +--------------------------------------------+
     |  id        date      week    month   merit |
     |--------------------------------------------|
  1. |   1   24jan2018    2018w4   2018m1   13018 |
  2. |   2   25jan2018    2018w4   2018m1    6761 |
  3. |   3   26jan2018    2018w4   2018m1    4493 |
  4. |   4   27jan2018    2018w4   2018m1    3489 |
  5. |   5   28jan2018    2018w4   2018m1    3188 |
     |--------------------------------------------|
  6. |   6   29jan2018    2018w5   2018m1    3799 |
  7. |   7   30jan2018    2018w5   2018m1    4192 |
  8. |   8   31jan2018    2018w5   2018m1    2820 |
  9. |   9   01feb2018    2018w5   2018m2    2545 |
 10. |  10   02feb2018    2018w5   2018m2    2568 |
     |--------------------------------------------|
 11. |  11   03feb2018    2018w5   2018m2    1867 |
 12. |  12   04feb2018    2018w5   2018m2    2167 |
 13. |  13   05feb2018    2018w6   2018m2    2077 |
 14. |  14   06feb2018    2018w6   2018m2    2308 |
 15. |  15   07feb2018    2018w6   2018m2    2141 |
     |--------------------------------------------|
 16. |  16   08feb2018    2018w6   2018m2    2141 |
 17. |  17   09feb2018    2018w6   2018m2    1448 |
 18. |  18   10feb2018    2018w6   2018m2    1747 |
 19. |  19   11feb2018    2018w6   2018m2    1442 |
 21. |  21   13feb2018    2018w7   2018m2    1579 |
     |--------------------------------------------|
 22. |  22   14feb2018    2018w7   2018m2    2513 |
 23. |  23   15feb2018    2018w7   2018m2    1991 |
 24. |  24   16feb2018    2018w7   2018m2    1411 |
 25. |  25   17feb2018    2018w7   2018m2    1608 |
 27. |  27   19feb2018    2018w8   2018m2    1403 |
     |--------------------------------------------|
 32. |  32   24feb2018    2018w8   2018m2    1409 |
 34. |  34   26feb2018    2018w9   2018m2    1382 |
 38. |  38   02mar2018    2018w9   2018m3    1696 |
 48. |  48   12mar2018   2018w11   2018m3    1354 |
236. | 236   16sep2018   2018w37   2018m9    2463 |
     |--------------------------------------------|
237. | 237   17sep2018   2018w38   2018m9    1862 |
     +--------------------------------------------+
As you can easily see that there are some days listed as extremely outliers after 19th Feb. 2018, but I left them in the dataset, not truncated them, in order to have full weeks in truncated dataset.

- Median: 626
- Interquartile range: 521 - 774
- Mean +/- standard deviation: 695 +/- 268
- Extremely potential outliers: above 1154 or below 142.
With IQR = 774 - 521 = 253
Q1 - 1.5*IQR = 521 - 1.5*253 = 141.5 ~ 142
Q3 + 1.5*IQR = 774 + 1.5*253 = 1153.5 ~ 1154.


Box plots
a) Box plot of daily merits since 19th February 2018 to 2nd December 2018.
Merit after presents statistics of the whole period from 19/2/2018 to 2/12/2018.
w26 presents statistics of the period that started on 19/2/2018 to the end of the week26 (on 01/7/2018)

b) Box plot of daily merit (full dataset). This one is only for reference.


Merits over days of week
Raw statistics
Code:
Summary for variables: merit
     by categories of: dofw

     dofw |         N      mean        sd       p50       p25       p75       min       max
----------+--------------------------------------------------------------------------------
   Sunday |      41.0     715.7     360.5     603.0     476.0     829.0     412.0    2463.0
   Monday |      41.0     771.3     314.1     674.0     562.0     884.0     455.0    1862.0
  Tuesday |      41.0     715.0     246.1     632.0     580.0     767.0     383.0    1326.0
Wednesday |      41.0     723.5     227.1     652.0     562.0     761.0     435.0    1268.0
 Thursday |      41.0     687.0     220.7     644.0     528.0     774.0     376.0    1333.0
   Friday |      41.0     611.7     238.0     542.0     463.0     698.0     348.0    1696.0
 Saturday |      41.0     639.5     223.3     614.0     463.0     688.0     347.0    1409.0
----------+--------------------------------------------------------------------------------
    Total |     287.0     694.8     268.1     626.0     521.0     774.0     347.0    2463.0
-------------------------------------------------------------------------------------------
What we got here?
The days of week that have lowest and highest means of totally merits are Friday and Wednesday, at 612 and 724 merits distributed, respectively.
It means there are (724 - 612) = 212 merit difference or the Wednesday have nearly 18% total merits higher than the Friday. Personally, it is a dramatical difference.
Code:
. di (724-612)*100/612
18.300654
Now, how about median difference?
The days of week that have lowest and highest medians of totally merits are Friday and Monday, at 542 and 674, respectively.
It means that there are (674-542) = 132 merit points diference between the Friday and Monday.
In other words, there are nearly 24% difference between the medians of Friday and Monday.
Code:
. di (674-542)*100/542
24.354244

Box plots:
a) Outliers displayed.

b) Outliers non-displayed.

Statistics of full dataset (just for reference)
Code:
Summary for variables: merit
     by categories of: dofw

     dofw |         N      mean        sd       p50       p25       p75       min       max
----------+--------------------------------------------------------------------------------
   Sunday |      45.0     831.8     557.3     619.0     486.0     880.0     412.0    3188.0
   Monday |      44.0     882.5     582.4     681.0     575.5     945.0     455.0    3799.0
  Tuesday |      44.0     849.9     628.7     638.5     580.0     890.5     383.0    4192.0
Wednesday |      45.0    1114.5    1882.6     681.0     569.0     963.0     435.0   13018.0
 Thursday |      45.0     924.5     995.1     673.0     530.0     846.0     376.0    6761.0
   Friday |      45.0     777.7     695.0     554.0     475.0     774.0     348.0    4493.0
 Saturday |      45.0     776.2     542.4     627.0     506.0     778.0     347.0    3489.0
----------+--------------------------------------------------------------------------------
    Total |     313.0     879.7     951.8     643.0     530.0     858.0     347.0   13018.0
-------------------------------------------------------------------------------------------


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
1571492626
Hero Member
*
Offline Offline

Posts: 1571492626

View Profile Personal Message (Offline)

Ignore
1571492626
Reply with quote  #2

1571492626
Report to moderator
1571492626
Hero Member
*
Offline Offline

Posts: 1571492626

View Profile Personal Message (Offline)

Ignore
1571492626
Reply with quote  #2

1571492626
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1571492626
Hero Member
*
Offline Offline

Posts: 1571492626

View Profile Personal Message (Offline)

Ignore
1571492626
Reply with quote  #2

1571492626
Report to moderator
1571492626
Hero Member
*
Offline Offline

Posts: 1571492626

View Profile Personal Message (Offline)

Ignore
1571492626
Reply with quote  #2

1571492626
Report to moderator
1571492626
Hero Member
*
Offline Offline

Posts: 1571492626

View Profile Personal Message (Offline)

Ignore
1571492626
Reply with quote  #2

1571492626
Report to moderator
tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
December 09, 2018, 07:07:00 AM
Last edit: December 09, 2018, 07:21:00 AM by tranthidung
 #22

Full converted daily dataset (used for analysis in the above thread).
Code:
. list id merit day month2 year date dofw week month

     +-------------------------------------------------------------------------------+
     |  id   merit   day   month2   year        date        dofw      week     month |
     |-------------------------------------------------------------------------------|
  1. |   1   13018    24        1   2018   24jan2018   Wednesday    2018w4    2018m1 |
  2. |   2    6761    25        1   2018   25jan2018    Thursday    2018w4    2018m1 |
  3. |   3    4493    26        1   2018   26jan2018      Friday    2018w4    2018m1 |
  4. |   4    3489    27        1   2018   27jan2018    Saturday    2018w4    2018m1 |
  5. |   5    3188    28        1   2018   28jan2018      Sunday    2018w4    2018m1 |
     |-------------------------------------------------------------------------------|
  6. |   6    3799    29        1   2018   29jan2018      Monday    2018w5    2018m1 |
  7. |   7    4192    30        1   2018   30jan2018     Tuesday    2018w5    2018m1 |
  8. |   8    2820    31        1   2018   31jan2018   Wednesday    2018w5    2018m1 |
  9. |   9    2545     1        2   2018   01feb2018    Thursday    2018w5    2018m2 |
 10. |  10    2568     2        2   2018   02feb2018      Friday    2018w5    2018m2 |
     |-------------------------------------------------------------------------------|
 11. |  11    1867     3        2   2018   03feb2018    Saturday    2018w5    2018m2 |
 12. |  12    2167     4        2   2018   04feb2018      Sunday    2018w5    2018m2 |
 13. |  13    2077     5        2   2018   05feb2018      Monday    2018w6    2018m2 |
 14. |  14    2308     6        2   2018   06feb2018     Tuesday    2018w6    2018m2 |
 15. |  15    2141     7        2   2018   07feb2018   Wednesday    2018w6    2018m2 |
     |-------------------------------------------------------------------------------|
 16. |  16    2141     8        2   2018   08feb2018    Thursday    2018w6    2018m2 |
 17. |  17    1448     9        2   2018   09feb2018      Friday    2018w6    2018m2 |
 18. |  18    1747    10        2   2018   10feb2018    Saturday    2018w6    2018m2 |
 19. |  19    1442    11        2   2018   11feb2018      Sunday    2018w6    2018m2 |
 20. |  20    1331    12        2   2018   12feb2018      Monday    2018w7    2018m2 |
     |-------------------------------------------------------------------------------|
 21. |  21    1579    13        2   2018   13feb2018     Tuesday    2018w7    2018m2 |
 22. |  22    2513    14        2   2018   14feb2018   Wednesday    2018w7    2018m2 |
 23. |  23    1991    15        2   2018   15feb2018    Thursday    2018w7    2018m2 |
 24. |  24    1411    16        2   2018   16feb2018      Friday    2018w7    2018m2 |
 25. |  25    1608    17        2   2018   17feb2018    Saturday    2018w7    2018m2 |
     |-------------------------------------------------------------------------------|
 26. |  26    1289    18        2   2018   18feb2018      Sunday    2018w7    2018m2 |
 27. |  27    1403    19        2   2018   19feb2018      Monday    2018w8    2018m2 |
 28. |  28    1169    20        2   2018   20feb2018     Tuesday    2018w8    2018m2 |
 29. |  29    1266    21        2   2018   21feb2018   Wednesday    2018w8    2018m2 |
 30. |  30    1279    22        2   2018   22feb2018    Thursday    2018w8    2018m2 |
     |-------------------------------------------------------------------------------|
 31. |  31    1046    23        2   2018   23feb2018      Friday    2018w8    2018m2 |
 32. |  32    1409    24        2   2018   24feb2018    Saturday    2018w8    2018m2 |
 33. |  33    1186    25        2   2018   25feb2018      Sunday    2018w8    2018m2 |
 34. |  34    1382    26        2   2018   26feb2018      Monday    2018w9    2018m2 |
 35. |  35    1326    27        2   2018   27feb2018     Tuesday    2018w9    2018m2 |
     |-------------------------------------------------------------------------------|
 36. |  36     991    28        2   2018   28feb2018   Wednesday    2018w9    2018m2 |
 37. |  37    1333     1        3   2018   01mar2018    Thursday    2018w9    2018m3 |
 38. |  38    1696     2        3   2018   02mar2018      Friday    2018w9    2018m3 |
 39. |  39    1089     3        3   2018   03mar2018    Saturday    2018w9    2018m3 |
 40. |  40     989     4        3   2018   04mar2018      Sunday    2018w9    2018m3 |
     |-------------------------------------------------------------------------------|
 41. |  41    1245     5        3   2018   05mar2018      Monday   2018w10    2018m3 |
 42. |  42    1074     6        3   2018   06mar2018     Tuesday   2018w10    2018m3 |
 43. |  43    1109     7        3   2018   07mar2018   Wednesday   2018w10    2018m3 |
 44. |  44     922     8        3   2018   08mar2018    Thursday   2018w10    2018m3 |
 45. |  45     789     9        3   2018   09mar2018      Friday   2018w10    2018m3 |
     |-------------------------------------------------------------------------------|
 46. |  46    1023    10        3   2018   10mar2018    Saturday   2018w10    2018m3 |
 47. |  47    1091    11        3   2018   11mar2018      Sunday   2018w10    2018m3 |
 48. |  48    1354    12        3   2018   12mar2018      Monday   2018w11    2018m3 |
 49. |  49     994    13        3   2018   13mar2018     Tuesday   2018w11    2018m3 |
 50. |  50    1159    14        3   2018   14mar2018   Wednesday   2018w11    2018m3 |
     |-------------------------------------------------------------------------------|
 51. |  51    1130    15        3   2018   15mar2018    Thursday   2018w11    2018m3 |
 52. |  52     840    16        3   2018   16mar2018      Friday   2018w11    2018m3 |
 53. |  53     797    17        3   2018   17mar2018    Saturday   2018w11    2018m3 |
 54. |  54    1035    18        3   2018   18mar2018      Sunday   2018w11    2018m3 |
 55. |  55     992    19        3   2018   19mar2018      Monday   2018w12    2018m3 |
     |-------------------------------------------------------------------------------|
 56. |  56    1322    20        3   2018   20mar2018     Tuesday   2018w12    2018m3 |
 57. |  57    1227    21        3   2018   21mar2018   Wednesday   2018w12    2018m3 |
 58. |  58     764    22        3   2018   22mar2018    Thursday   2018w12    2018m3 |
 59. |  59     733    23        3   2018   23mar2018      Friday   2018w12    2018m3 |
 60. |  60    1045    24        3   2018   24mar2018    Saturday   2018w12    2018m3 |
     |-------------------------------------------------------------------------------|
 61. |  61     858    25        3   2018   25mar2018      Sunday   2018w12    2018m3 |
 62. |  62     808    26        3   2018   26mar2018      Monday   2018w13    2018m3 |
 63. |  63     879    27        3   2018   27mar2018     Tuesday   2018w13    2018m3 |
 64. |  64     848    28        3   2018   28mar2018   Wednesday   2018w13    2018m3 |
 65. |  65    1043    29        3   2018   29mar2018    Thursday   2018w13    2018m3 |
     |-------------------------------------------------------------------------------|
 66. |  66     928    30        3   2018   30mar2018      Friday   2018w13    2018m3 |
 67. |  67     968    31        3   2018   31mar2018    Saturday   2018w13    2018m3 |
 68. |  68    1233     1        4   2018   01apr2018      Sunday   2018w13    2018m4 |
 69. |  69    1146     2        4   2018   02apr2018      Monday   2018w14    2018m4 |
 70. |  70    1080     3        4   2018   03apr2018     Tuesday   2018w14    2018m4 |
     |-------------------------------------------------------------------------------|
 71. |  71    1061     4        4   2018   04apr2018   Wednesday   2018w14    2018m4 |
 72. |  72     838     5        4   2018   05apr2018    Thursday   2018w14    2018m4 |
 73. |  73     620     6        4   2018   06apr2018      Friday   2018w14    2018m4 |
 74. |  74     614     7        4   2018   07apr2018    Saturday   2018w14    2018m4 |
 75. |  75    1056     8        4   2018   08apr2018      Sunday   2018w14    2018m4 |
     |-------------------------------------------------------------------------------|
 76. |  76     884     9        4   2018   09apr2018      Monday   2018w15    2018m4 |
 77. |  77     768    10        4   2018   10apr2018     Tuesday   2018w15    2018m4 |
 78. |  78     963    11        4   2018   11apr2018   Wednesday   2018w15    2018m4 |
 79. |  79     917    12        4   2018   12apr2018    Thursday   2018w15    2018m4 |
 80. |  80     682    13        4   2018   13apr2018      Friday   2018w15    2018m4 |
     |-------------------------------------------------------------------------------|
 81. |  81     681    14        4   2018   14apr2018    Saturday   2018w15    2018m4 |
 82. |  82     592    15        4   2018   15apr2018      Sunday   2018w15    2018m4 |
 83. |  83     609    16        4   2018   16apr2018      Monday   2018w16    2018m4 |
 84. |  84     628    17        4   2018   17apr2018     Tuesday   2018w16    2018m4 |
 85. |  85     681    18        4   2018   18apr2018   Wednesday   2018w16    2018m4 |
     |-------------------------------------------------------------------------------|
 86. |  86     848    19        4   2018   19apr2018    Thursday   2018w16    2018m4 |
 87. |  87     463    20        4   2018   20apr2018      Friday   2018w16    2018m4 |
 88. |  88     522    21        4   2018   21apr2018    Saturday   2018w16    2018m4 |
 89. |  89     880    22        4   2018   22apr2018      Sunday   2018w16    2018m4 |
 90. |  90     709    23        4   2018   23apr2018      Monday   2018w17    2018m4 |
     |-------------------------------------------------------------------------------|
 91. |  91     626    24        4   2018   24apr2018     Tuesday   2018w17    2018m4 |
 92. |  92     687    25        4   2018   25apr2018   Wednesday   2018w17    2018m4 |
 93. |  93     675    26        4   2018   26apr2018    Thursday   2018w17    2018m4 |
 94. |  94     583    27        4   2018   27apr2018      Friday   2018w17    2018m4 |
 95. |  95     623    28        4   2018   28apr2018    Saturday   2018w17    2018m4 |
     |-------------------------------------------------------------------------------|
 96. |  96     682    29        4   2018   29apr2018      Sunday   2018w17    2018m4 |
 97. |  97     822    30        4   2018   30apr2018      Monday   2018w18    2018m4 |
 98. |  98     741     1        5   2018   01may2018     Tuesday   2018w18    2018m5 |
 99. |  99     759     2        5   2018   02may2018   Wednesday   2018w18    2018m5 |
100. | 100     747     3        5   2018   03may2018    Thursday   2018w18    2018m5 |
     |-------------------------------------------------------------------------------|
101. | 101     597     4        5   2018   04may2018      Friday   2018w18    2018m5 |
102. | 102     688     5        5   2018   05may2018    Saturday   2018w18    2018m5 |
103. | 103     599     6        5   2018   06may2018      Sunday   2018w18    2018m5 |
104. | 104     898     7        5   2018   07may2018      Monday   2018w19    2018m5 |
105. | 105     618     8        5   2018   08may2018     Tuesday   2018w19    2018m5 |
     |-------------------------------------------------------------------------------|
106. | 106     761     9        5   2018   09may2018   Wednesday   2018w19    2018m5 |
107. | 107     475    10        5   2018   10may2018    Thursday   2018w19    2018m5 |
108. | 108     867    11        5   2018   11may2018      Friday   2018w19    2018m5 |
109. | 109     415    12        5   2018   12may2018    Saturday   2018w19    2018m5 |
110. | 110     719    13        5   2018   13may2018      Sunday   2018w19    2018m5 |
     |-------------------------------------------------------------------------------|
111. | 111     674    14        5   2018   14may2018      Monday   2018w20    2018m5 |
112. | 112     700    15        5   2018   15may2018     Tuesday   2018w20    2018m5 |
113. | 113     652    16        5   2018   16may2018   Wednesday   2018w20    2018m5 |
114. | 114     574    17        5   2018   17may2018    Thursday   2018w20    2018m5 |
115. | 115     542    18        5   2018   18may2018      Friday   2018w20    2018m5 |
     |-------------------------------------------------------------------------------|
116. | 116     587    19        5   2018   19may2018    Saturday   2018w20    2018m5 |
117. | 117     617    20        5   2018   20may2018      Sunday   2018w20    2018m5 |
118. | 118     626    21        5   2018   21may2018      Monday   2018w21    2018m5 |
119. | 119     639    22        5   2018   22may2018     Tuesday   2018w21    2018m5 |
120. | 120     531    23        5   2018   23may2018   Wednesday   2018w21    2018m5 |
     |-------------------------------------------------------------------------------|
121. | 121     554    24        5   2018   24may2018    Thursday   2018w21    2018m5 |
122. | 122     370    25        5   2018   25may2018      Friday   2018w21    2018m5 |
123. | 123     575    26        5   2018   26may2018    Saturday   2018w21    2018m5 |
124. | 124     559    27        5   2018   27may2018      Sunday   2018w21    2018m5 |
125. | 125     589    28        5   2018   28may2018      Monday   2018w22    2018m5 |
     |-------------------------------------------------------------------------------|
126. | 126     638    29        5   2018   29may2018     Tuesday   2018w22    2018m5 |
127. | 127     599    30        5   2018   30may2018   Wednesday   2018w22    2018m5 |
128. | 128     687    31        5   2018   31may2018    Thursday   2018w22    2018m5 |
129. | 129     698     1        6   2018   01jun2018      Friday   2018w22    2018m6 |
130. | 130     461     2        6   2018   02jun2018    Saturday   2018w22    2018m6 |
     |-------------------------------------------------------------------------------|
131. | 131     511     3        6   2018   03jun2018      Sunday   2018w22    2018m6 |
132. | 132     773     4        6   2018   04jun2018      Monday   2018w23    2018m6 |
133. | 133     731     5        6   2018   05jun2018     Tuesday   2018w23    2018m6 |
134. | 134     504     6        6   2018   06jun2018   Wednesday   2018w23    2018m6 |
135. | 135     506     7        6   2018   07jun2018    Thursday   2018w23    2018m6 |
     |-------------------------------------------------------------------------------|
136. | 136     766     8        6   2018   08jun2018      Friday   2018w23    2018m6 |
137. | 137     672     9        6   2018   09jun2018    Saturday   2018w23    2018m6 |
138. | 138     575    10        6   2018   10jun2018      Sunday   2018w23    2018m6 |
139. | 139     519    11        6   2018   11jun2018      Monday   2018w24    2018m6 |
140. | 140     422    12        6   2018   12jun2018     Tuesday   2018w24    2018m6 |
     |-------------------------------------------------------------------------------|
141. | 141     786    13        6   2018   13jun2018   Wednesday   2018w24    2018m6 |
142. | 142     528    14        6   2018   14jun2018    Thursday   2018w24    2018m6 |
143. | 143     445    15        6   2018   15jun2018      Friday   2018w24    2018m6 |
144. | 144     654    16        6   2018   16jun2018    Saturday   2018w24    2018m6 |
145. | 145     464    17        6   2018   17jun2018      Sunday   2018w24    2018m6 |
     |-------------------------------------------------------------------------------|
146. | 146     601    18        6   2018   18jun2018      Monday   2018w25    2018m6 |
147. | 147     662    19        6   2018   19jun2018     Tuesday   2018w25    2018m6 |
148. | 148     707    20        6   2018   20jun2018   Wednesday   2018w25    2018m6 |
149. | 149     705    21        6   2018   21jun2018    Thursday   2018w25    2018m6 |
150. | 150     774    22        6   2018   22jun2018      Friday   2018w25    2018m6 |
     |-------------------------------------------------------------------------------|
151. | 151     643    23        6   2018   23jun2018    Saturday   2018w25    2018m6 |
152. | 152     829    24        6   2018   24jun2018      Sunday   2018w25    2018m6 |
153. | 153    1138    25        6   2018   25jun2018      Monday   2018w26    2018m6 |
154. | 154     435    26        6   2018   26jun2018     Tuesday   2018w26    2018m6 |
155. | 155     516    27        6   2018   27jun2018   Wednesday   2018w26    2018m6 |
     |-------------------------------------------------------------------------------|
156. | 156     470    28        6   2018   28jun2018    Thursday   2018w26    2018m6 |
157. | 157     479    29        6   2018   29jun2018      Friday   2018w26    2018m6 |
158. | 158     778    30        6   2018   30jun2018    Saturday   2018w26    2018m6 |
159. | 159     641     1        7   2018   01jul2018      Sunday   2018w26    2018m7 |
160. | 160     711     2        7   2018   02jul2018      Monday   2018w27    2018m7 |
     |-------------------------------------------------------------------------------|
161. | 161     902     3        7   2018   03jul2018     Tuesday   2018w27    2018m7 |
162. | 162     557     4        7   2018   04jul2018   Wednesday   2018w27    2018m7 |
163. | 163     577     5        7   2018   05jul2018    Thursday   2018w27    2018m7 |
164. | 164     475     6        7   2018   06jul2018      Friday   2018w27    2018m7 |
165. | 165     506     7        7   2018   07jul2018    Saturday   2018w27    2018m7 |
     |-------------------------------------------------------------------------------|
166. | 166     525     8        7   2018   08jul2018      Sunday   2018w27    2018m7 |
167. | 167     455     9        7   2018   09jul2018      Monday   2018w28    2018m7 |
168. | 168     620    10        7   2018   10jul2018     Tuesday   2018w28    2018m7 |
169. | 169     555    11        7   2018   11jul2018   Wednesday   2018w28    2018m7 |
170. | 170     644    12        7   2018   12jul2018    Thursday   2018w28    2018m7 |
     |-------------------------------------------------------------------------------|
171. | 171     542    13        7   2018   13jul2018      Friday   2018w28    2018m7 |
172. | 172     627    14        7   2018   14jul2018    Saturday   2018w28    2018m7 |
173. | 173     796    15        7   2018   15jul2018      Sunday   2018w28    2018m7 |
174. | 174     636    16        7   2018   16jul2018      Monday   2018w29    2018m7 |
175. | 175     641    17        7   2018   17jul2018     Tuesday   2018w29    2018m7 |
     |-------------------------------------------------------------------------------|
176. | 176     608    18        7   2018   18jul2018   Wednesday   2018w29    2018m7 |
177. | 177     554    19        7   2018   19jul2018    Thursday   2018w29    2018m7 |
178. | 178     606    20        7   2018   20jul2018      Friday   2018w29    2018m7 |
179. | 179     567    21        7   2018   21jul2018    Saturday   2018w29    2018m7 |
180. | 180     547    22        7   2018   22jul2018      Sunday   2018w29    2018m7 |
     |-------------------------------------------------------------------------------|
181. | 181     684    23        7   2018   23jul2018      Monday   2018w30    2018m7 |
182. | 182     444    24        7   2018   24jul2018     Tuesday   2018w30    2018m7 |
183. | 183     492    25        7   2018   25jul2018   Wednesday   2018w30    2018m7 |
184. | 184     673    26        7   2018   26jul2018    Thursday   2018w30    2018m7 |
185. | 185     521    27        7   2018   27jul2018      Friday   2018w30    2018m7 |
     |-------------------------------------------------------------------------------|
186. | 186     418    28        7   2018   28jul2018    Saturday   2018w30    2018m7 |
187. | 187     420    29        7   2018   29jul2018      Sunday   2018w30    2018m7 |
188. | 188     471    30        7   2018   30jul2018      Monday   2018w31    2018m7 |
189. | 189     632    31        7   2018   31jul2018     Tuesday   2018w31    2018m7 |
190. | 190     435     1        8   2018   01aug2018   Wednesday   2018w31    2018m8 |
     |-------------------------------------------------------------------------------|
191. | 191     376     2        8   2018   02aug2018    Thursday   2018w31    2018m8 |
192. | 192     421     3        8   2018   03aug2018      Friday   2018w31    2018m8 |
193. | 193     695     4        8   2018   04aug2018    Saturday   2018w31    2018m8 |
194. | 194     768     5        8   2018   05aug2018      Sunday   2018w31    2018m8 |
195. | 195     595     6        8   2018   06aug2018      Monday   2018w32    2018m8 |
     |-------------------------------------------------------------------------------|
196. | 196     610     7        8   2018   07aug2018     Tuesday   2018w32    2018m8 |
197. | 197     647     8        8   2018   08aug2018   Wednesday   2018w32    2018m8 |
198. | 198     471     9        8   2018   09aug2018    Thursday   2018w32    2018m8 |
199. | 199     567    10        8   2018   10aug2018      Friday   2018w32    2018m8 |
200. | 200     517    11        8   2018   11aug2018    Saturday   2018w32    2018m8 |
     |-------------------------------------------------------------------------------|
201. | 201     587    12        8   2018   12aug2018      Sunday   2018w32    2018m8 |
202. | 202     513    13        8   2018   13aug2018      Monday   2018w33    2018m8 |
203. | 203     565    14        8   2018   14aug2018     Tuesday   2018w33    2018m8 |
204. | 204     626    15        8   2018   15aug2018   Wednesday   2018w33    2018m8 |
205. | 205     470    16        8   2018   16aug2018    Thursday   2018w33    2018m8 |
     |-------------------------------------------------------------------------------|
206. | 206     451    17        8   2018   17aug2018      Friday   2018w33    2018m8 |
207. | 207     561    18        8   2018   18aug2018    Saturday   2018w33    2018m8 |
208. | 208     432    19        8   2018   19aug2018      Sunday   2018w33    2018m8 |
209. | 209     658    20        8   2018   20aug2018      Monday   2018w34    2018m8 |
210. | 210     600    21        8   2018   21aug2018     Tuesday   2018w34    2018m8 |
     |-------------------------------------------------------------------------------|
211. | 211     612    22        8   2018   22aug2018   Wednesday   2018w34    2018m8 |
212. | 212     530    23        8   2018   23aug2018    Thursday   2018w34    2018m8 |
213. | 213     528    24        8   2018   24aug2018      Friday   2018w34    2018m8 |
214. | 214     385    25        8   2018   25aug2018    Saturday   2018w34    2018m8 |
215. | 215     476    26        8   2018   26aug2018      Sunday   2018w34    2018m8 |
     |-------------------------------------------------------------------------------|
216. | 216     457    27        8   2018   27aug2018      Monday   2018w35    2018m8 |
217. | 217     383    28        8   2018   28aug2018     Tuesday   2018w35    2018m8 |
218. | 218     488    29        8   2018   29aug2018   Wednesday   2018w35    2018m8 |
219. | 219     514    30        8   2018   30aug2018    Thursday   2018w35    2018m8 |
220. | 220     379    31        8   2018   31aug2018      Friday   2018w35    2018m8 |
     |-------------------------------------------------------------------------------|
221. | 221     432     1        9   2018   01sep2018    Saturday   2018w35    2018m9 |
222. | 222     412     2        9   2018   02sep2018      Sunday   2018w35    2018m9 |
223. | 223     536     3        9   2018   03sep2018      Monday   2018w36    2018m9 |
224. | 224     567     4        9   2018   04sep2018     Tuesday   2018w36    2018m9 |
225. | 225     654     5        9   2018   05sep2018   Wednesday   2018w36    2018m9 |
     |-------------------------------------------------------------------------------|
226. | 226     509     6        9   2018   06sep2018    Thursday   2018w36    2018m9 |
227. | 227     458     7        9   2018   07sep2018      Friday   2018w36    2018m9 |
228. | 228     395     8        9   2018   08sep2018    Saturday   2018w36    2018m9 |
229. | 229     455     9        9   2018   09sep2018      Sunday   2018w36    2018m9 |
230. | 230     472    10        9   2018   10sep2018      Monday   2018w37    2018m9 |
     |-------------------------------------------------------------------------------|
231. | 231     580    11        9   2018   11sep2018     Tuesday   2018w37    2018m9 |
232. | 232     595    12        9   2018   12sep2018   Wednesday   2018w37    2018m9 |
233. | 233     540    13        9   2018   13sep2018    Thursday   2018w37    2018m9 |
234. | 234     517    14        9   2018   14sep2018      Friday   2018w37    2018m9 |
235. | 235     463    15        9   2018   15sep2018    Saturday   2018w37    2018m9 |
     |-------------------------------------------------------------------------------|
236. | 236    2463    16        9   2018   16sep2018      Sunday   2018w37    2018m9 |
237. | 237    1862    17        9   2018   17sep2018      Monday   2018w38    2018m9 |
238. | 238    1294    18        9   2018   18sep2018     Tuesday   2018w38    2018m9 |
239. | 239    1268    19        9   2018   19sep2018   Wednesday   2018w38    2018m9 |
240. | 240     846    20        9   2018   20sep2018    Thursday   2018w38    2018m9 |
     |-------------------------------------------------------------------------------|
241. | 241     807    21        9   2018   21sep2018      Friday   2018w38    2018m9 |
242. | 242     944    22        9   2018   22sep2018    Saturday   2018w38    2018m9 |
243. | 243     804    23        9   2018   23sep2018      Sunday   2018w38    2018m9 |
244. | 244     749    24        9   2018   24sep2018      Monday   2018w39    2018m9 |
245. | 245     596    25        9   2018   25sep2018     Tuesday   2018w39    2018m9 |
     |-------------------------------------------------------------------------------|
246. | 246     562    26        9   2018   26sep2018   Wednesday   2018w39    2018m9 |
247. | 247     675    27        9   2018   27sep2018    Thursday   2018w39    2018m9 |
248. | 248     518    28        9   2018   28sep2018      Friday   2018w39    2018m9 |
249. | 249     669    29        9   2018   29sep2018    Saturday   2018w39    2018m9 |
250. | 250     619    30        9   2018   30sep2018      Sunday   2018w39    2018m9 |
     |-------------------------------------------------------------------------------|
251. | 251     509     1       10   2018   01oct2018      Monday   2018w40   2018m10 |
252. | 252     760     2       10   2018   02oct2018     Tuesday   2018w40   2018m10 |
253. | 253     705     3       10   2018   03oct2018   Wednesday   2018w40   2018m10 |
254. | 254     521     4       10   2018   04oct2018    Thursday   2018w40   2018m10 |
255. | 255     513     5       10   2018   05oct2018      Friday   2018w40   2018m10 |
     |-------------------------------------------------------------------------------|
256. | 256     660     6       10   2018   06oct2018    Saturday   2018w40   2018m10 |
257. | 257     603     7       10   2018   07oct2018      Sunday   2018w40   2018m10 |
258. | 258     678     8       10   2018   08oct2018      Monday   2018w41   2018m10 |
259. | 259     578     9       10   2018   09oct2018     Tuesday   2018w41   2018m10 |
260. | 260     639    10       10   2018   10oct2018   Wednesday   2018w41   2018m10 |
     |-------------------------------------------------------------------------------|
261. | 261     616    11       10   2018   11oct2018    Thursday   2018w41   2018m10 |
262. | 262     399    12       10   2018   12oct2018      Friday   2018w41   2018m10 |
263. | 263     460    13       10   2018   13oct2018    Saturday   2018w41   2018m10 |
264. | 264     430    14       10   2018   14oct2018      Sunday   2018w41   2018m10 |
265. | 265     655    15       10   2018   15oct2018      Monday   2018w42   2018m10 |
     |-------------------------------------------------------------------------------|
266. | 266     626    16       10   2018   16oct2018     Tuesday   2018w42   2018m10 |
267. | 267     732    17       10   2018   17oct2018   Wednesday   2018w42   2018m10 |
268. | 268     774    18       10   2018   18oct2018    Thursday   2018w42   2018m10 |
269. | 269     643    19       10   2018   19oct2018      Friday   2018w42   2018m10 |
270. | 270     538    20       10   2018   20oct2018    Saturday   2018w42   2018m10 |
     |-------------------------------------------------------------------------------|
271. | 271     853    21       10   2018   21oct2018      Sunday   2018w42   2018m10 |
272. | 272     694    22       10   2018   22oct2018      Monday   2018w43   2018m10 |
273. | 273     674    23       10   2018   23oct2018     Tuesday   2018w43   2018m10 |
274. | 274     759    24       10   2018   24oct2018   Wednesday   2018w43   2018m10 |
275. | 275     553    25       10   2018   25oct2018    Thursday   2018w43   2018m10 |
     |-------------------------------------------------------------------------------|
276. | 276     424    26       10   2018   26oct2018      Friday   2018w43   2018m10 |
277. | 277     426    27       10   2018   27oct2018    Saturday   2018w43   2018m10 |
278. | 278     415    28       10   2018   28oct2018      Sunday   2018w43   2018m10 |
279. | 279     534    29       10   2018   29oct2018      Monday   2018w44   2018m10 |
280. | 280     529    30       10   2018   30oct2018     Tuesday   2018w44   2018m10 |
     |-------------------------------------------------------------------------------|
281. | 281     495    31       10   2018   31oct2018   Wednesday   2018w44   2018m10 |
282. | 282     433     1       11   2018   01nov2018    Thursday   2018w44   2018m11 |
283. | 283     454     2       11   2018   02nov2018      Friday   2018w44   2018m11 |
284. | 284     430     3       11   2018   03nov2018    Saturday   2018w44   2018m11 |
285. | 285     464     4       11   2018   04nov2018      Sunday   2018w44   2018m11 |
     |-------------------------------------------------------------------------------|
286. | 286     562     5       11   2018   05nov2018      Monday   2018w45   2018m11 |
287. | 287     405     6       11   2018   06nov2018     Tuesday   2018w45   2018m11 |
288. | 288     691     7       11   2018   07nov2018   Wednesday   2018w45   2018m11 |
289. | 289     843     8       11   2018   08nov2018    Thursday   2018w45   2018m11 |
290. | 290     536     9       11   2018   09nov2018      Friday   2018w45   2018m11 |
     |-------------------------------------------------------------------------------|
291. | 291     688    10       11   2018   10nov2018    Saturday   2018w45   2018m11 |
292. | 292     788    11       11   2018   11nov2018      Sunday   2018w45   2018m11 |
293. | 293     591    12       11   2018   12nov2018      Monday   2018w46   2018m11 |
294. | 294     580    13       11   2018   13nov2018     Tuesday   2018w46   2018m11 |
295. | 295     569    14       11   2018   14nov2018   Wednesday   2018w46   2018m11 |
     |-------------------------------------------------------------------------------|
296. | 296     650    15       11   2018   15nov2018    Thursday   2018w46   2018m11 |
297. | 297     499    16       11   2018   16nov2018      Friday   2018w46   2018m11 |
298. | 298     347    17       11   2018   17nov2018    Saturday   2018w46   2018m11 |
299. | 299     486    18       11   2018   18nov2018      Sunday   2018w46   2018m11 |
300. | 300     898    19       11   2018   19nov2018      Monday   2018w47   2018m11 |
     |-------------------------------------------------------------------------------|
301. | 301     767    20       11   2018   20nov2018     Tuesday   2018w47   2018m11 |
302. | 302     608    21       11   2018   21nov2018   Wednesday   2018w47   2018m11 |
303. | 303     759    22       11   2018   22nov2018    Thursday   2018w47   2018m11 |
304. | 304     348    23       11   2018   23nov2018      Friday   2018w47   2018m11 |
305. | 305     716    24       11   2018   24nov2018    Saturday   2018w47   2018m11 |
     |-------------------------------------------------------------------------------|
306. | 306     462    25       11   2018   25nov2018      Sunday   2018w47   2018m11 |
307. | 307     531    26       11   2018   26nov2018      Monday   2018w48   2018m11 |
308. | 308     510    27       11   2018   27nov2018     Tuesday   2018w48   2018m11 |
309. | 309     558    28       11   2018   28nov2018   Wednesday   2018w48   2018m11 |
310. | 310     643    29       11   2018   29nov2018    Thursday   2018w48   2018m11 |
     |-------------------------------------------------------------------------------|
311. | 311     554    30       11   2018   30nov2018      Friday   2018w48   2018m11 |
312. | 312     530     1       12   2018   01dec2018    Saturday   2018w48   2018m12 |
313. | 313     424     2       12   2018   02dec2018      Sunday   2018w48   2018m12 |
     +-------------------------------------------------------------------------------+


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
December 09, 2018, 07:08:32 AM
Last edit: December 09, 2018, 02:10:25 PM by tranthidung
 #23

Update on weekly merit analysis.

1) Full weekly converted dataset
Code:
.         list

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


2) Time series plot


3) Basic statistics (for truncated dataset)
The median of weekly merits is 4388. It means that 50% of observed weeks have their merits above 4388, and 50% of them have their merits below 4388.
The interquartile range, from 3818 to  4953, discloses that 50% of observed their merits above 3818 and below 4953. It also means that 25% of weeks have their merits below 3818 and 25% of weeks have their merits above 4953.
The minimum and maximum of observed weeks (since 19/02/2018 to 02/12/2018) are 3065 and 8806, respectively.


3) Box plot
Full dataset

Only weeks of truncated dataset.

Potential outliers:
Q1 = 3818
Q3 = 4953
----> IQR = Q3 - Q1 = 4953 - 3818 = 1135
----> 1.5*IQR = 1135*1.5 = 1702.5
Potential outliers are weeks that have total merits above 6655.5 (~6656) or below 2115 (~2116).
Detail calculations presented below
Code:
* Q1 - 1.5*IQR
. di 3818-1702.5
2115.5

* Q3 + 1.5*IQR
. di 4953+1702.5
6655.5

There are seven weeks are potential outliers:
Code:
. list week merit if merit > 6656 | merit < 2116, abb(30)        

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


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
December 09, 2018, 01:28:36 PM
Last edit: December 09, 2018, 03:06:33 PM by tranthidung
 #24

Update on monthly merit analysis:
Notes:
- The January is incomplete month (only from 24th Jan. to then end of Jan.)
- The December has been dropped due to incomplete month.


Abstract
- The first three months of 2018, January, February, and March are the highest month in terms of total montly merits. The fact is not strange, obviously.
- Interestingly, there is a spike in September, when a demoted wave of Junior Members occured, which in turn resulted in massive merit abusements.
- Median is 19597, and the interquartile range is from 18047 to 32084.


1) Time series plot

2) Basic statistics
Mean +/- standard deviation: 24944 +/- 10505
Median (Interquartile range): 19597 (18047 - 32084)
Min - Max: 16317 - 46630

Code:
. list month merit

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


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
December 15, 2018, 05:55:42 PM
 #25

I have still waited for the update statistics from LoyceV.
I guess that LoyceV will help with new dataset tomorrow. This week has witness a bit delayed update from LoyceV.
Anyway, it does not matter with me. I will wait patiently.


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
LoyceV
Legendary
*
Online Online

Activity: 1638
Merit: 4825


Largest Merit Circle on BPIP!


View Profile WWW
December 15, 2018, 08:29:00 PM
 #26

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

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

tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
December 16, 2018, 06:56:41 AM
Last edit: December 16, 2018, 01:34:27 PM by tranthidung
 #27

Sorry if I bothered you with the reminding thread above.
Family day Tongue Here it is:
The thread has been reserved for later analytical results.

Quick glance, the last week looks normal, there is no extremely potential outliers, that have total merits beyond 142 (below) or 1154 (above)/
Only the following day:
Code:
Day 320: 397 Merit
The 320th day has a bit low total merit, but it is still been in the range from 142 to 1154; and only a little bit outside the Interquartile range (521 to 774)


Thank you so much for help me with data, again.


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
LoyceV
Legendary
*
Online Online

Activity: 1638
Merit: 4825


Largest Merit Circle on BPIP!


View Profile WWW
December 22, 2018, 09:28:23 PM
 #28

Updated data:

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

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

tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
December 27, 2018, 03:38:30 PM
Last edit: December 28, 2018, 02:23:02 PM by tranthidung
 #29

Thank you for the updated data last week, LoyceV.
Last week, merit distribution over the forum looks normal, a little bit lower then previous week, but still in normal range.

I have been busy last three weeks, so I will keep your data for later use.
I will update the topic after the end of December and get your update data.


Several quick updates:

1) Daily Time Series Plot:

From now on, only presented truncated dataset, since 19 Feb. 2018 to 19 Dec. 2018.
2) Daily Merit statistics:
Code:
.         tabstat merit, s(n mean sd p50 p25 p75 min max)

    variable |         N      mean        sd       p50       p25       p75       min       max
-------------+--------------------------------------------------------------------------------
       merit |       304  685.3882  264.3009     618.5     516.5     767.5       347      2463
----------------------------------------------------------------------------------------------
The median of daily merits decreased gradually over time, 619 for the last week compared to 626 as of the attached image below.


3) Weekly Merit Statistics:

4) Day of week merit distribution:

I will update later




By the way, I wish you and others who visit the topic a happy new year.
Additionally, we have come very close to the day at which we will have the one year anniversary of Merit system.


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
LoyceV
Legendary
*
Online Online

Activity: 1638
Merit: 4825


Largest Merit Circle on BPIP!


View Profile WWW
December 28, 2018, 10:15:51 AM
 #30

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

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

tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
December 28, 2018, 02:54:59 PM
Last edit: January 05, 2019, 09:44:20 AM by tranthidung
 #31

Updates:
Daily merits in the forum, from 24/01/2018 to 23/12/2018

Thanks LoyceV for all data updates last three weeks.

Notes:
- I dropped the last 4 days (the last day is incomplete day) from your dataset in order to have full weeks for my analysis
- Assumed calendar days are in Dutch time.



ABSTRACT (for truncated dataset)
1) 50% of observed days (since 19/02/2018 to 23/12/2018) have its total daily merits below 619 (the median) or higher than 619.
2) Importantly, 50% of observed days have their total daily merits in the range from 515 to 767, which is the interquartile range that ranges from the 25th quartile (Q1) to the 75th quartile (Q3).
3) The minimum and maximum daily merits during the period are 316 and 2463, respectively.
4) Potential outliers are days that have total merits above 1144 or below 138.
5) About medians of merits over days of week, Monday is the highest with 666 merits distributed on Mondays in medians, and Friday is the lowest with the median of Friday merits is 539. There are nearly 24% (23.56%) difference between the medians of Friday and Monday.
There are two days that have medians lower than 600, Friday (539) and Saturday (581)
6) Interestingly, within the last three weeks, we have seen the new All-Time-Low, at 316 merit on 22/12/2018.


1) Daily merits

It is easily to see that the median of truncated dataset has gradually decreased, 619 for now, and a little bit lower than 626 [median of the period from 19/2/2018 to 02/12/2018, shown in the below image]


Box plots
a) Box plot of daily merits since 24th January 2018 to 23th December 2018, at specific weeks, within periods after and before 19/2/2018
- Merit after: presents statistics of the whole period from 19/2/2018 to 23/12/2018;
- Merit before: presents statistics for the period from 24/1/2018 to 18/2/2018;
- Merit: presents statistics for merit during the whole period, from 24/1/2018 to 23/12/2018;
- w31 presents statistics of the period that started on 30/7/2018 to the end of the week31 (on 05/8/2018); and so on for w32, w33, ..., w51.

b) Box plot of daily merit, at specific weeks, and within the period since 19/2/2018
The plot has better display than of the above. In reality, we only pay attention on the merit distribution after truncating outliers on days before 19/2/2018.


Merits over days of week
Raw statistics
Code:
Summary for variables: merit
     by categories of: dofw

     dofw |         N      mean        sd       p50       p25       p75       min       max
----------+--------------------------------------------------------------------------------
   Sunday |      44.0     703.6     352.1     601.0     470.0     816.5     397.0    2463.0
   Monday |      44.0     760.9     306.3     666.0     549.0     853.0     455.0    1862.0
  Tuesday |      44.0     701.7     243.5     627.0     572.5     763.5     383.0    1326.0
Wednesday |      44.0     714.5     222.4     649.5     560.0     760.0     435.0    1268.0
 Thursday |      44.0     675.9     217.9     639.5     517.5     769.0     376.0    1333.0
   Friday |      44.0     605.3     231.0     539.0     469.0     690.0     348.0    1696.0
 Saturday |      44.0     622.3     225.4     581.0     460.5     688.0     316.0    1409.0
----------+--------------------------------------------------------------------------------
    Total |     308.0     683.4     263.6     618.5     515.0     766.5     316.0    2463.0
-------------------------------------------------------------------------------------------
What we got here?
The days of week that have lowest and highest means of totally merits are Friday and Monday, at 606 and 761 merits distributed, respectively.
It means there are (761 - 606) = 155 merit difference or the Wednesday have nearly 26% (25.57%) total merits higher than the Friday. Personally, it is a dramatical difference.
Code:
. di (761-606)*100/606
25.577558
Now, how about median difference?
The days of week that have lowest and highest medians of totally merits are Friday and Monday, at 539 and 666, respectively.
It means that there are (666-539) = 127 merit points diference between the Friday and Monday.
In other words, there are nearly 24% (23.56%) difference between the medians of Friday and Monday.
Code:
. di (666-539)*100/539
23.562152

Box plots:
a) Outliers displayed.

b) Outliers non-displayed.

Statistics of full dataset (just for reference)
Code:
Summary for variables: merit
     by categories of: dofw

     dofw |         N      mean        sd       p50       p25       p75       min       max
----------+--------------------------------------------------------------------------------
   Sunday |      48.0     813.4     544.9     618.0     481.0     869.0     397.0    3188.0
   Monday |      47.0     865.6     567.4     678.0     562.0     898.0     455.0    3799.0
  Tuesday |      47.0     828.8     613.7     632.0     578.0     879.0     383.0    4192.0
Wednesday |      48.0    1081.9    1826.1     659.5     565.5     905.5     435.0   13018.0
 Thursday |      48.0     899.5     968.0     647.0     524.5     844.5     376.0    6761.0
   Friday |      48.0     761.5     675.6     548.0     477.0     770.0     348.0    4493.0
 Saturday |      48.0     751.9     533.6     618.5     462.0     747.0     316.0    3489.0
----------+--------------------------------------------------------------------------------
    Total |     334.0     857.6     925.6     637.0     521.0     843.0     316.0   13018.0
-------------------------------------------------------------------------------------------


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
December 30, 2018, 03:34:33 PM
 #32

Converted daily merit (full dataset) which used for the analysis in previous post.
Code:
. list id merit day month2 year date dofw week month

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

Let's get discover it and make your own analysis if you want.


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
December 30, 2018, 03:39:35 PM
Last edit: January 04, 2019, 03:50:02 AM by tranthidung
 #33

Update on Weekly merit (from 24/01/2018 to 23/12/2018)

Time Series Plot

Basic statistics
Both mean and median of the truncated data have decreased a little bit than figures of truncated dataset from 24/1/2018 to 02/12/2018.
The mean decreased from 4864 to 4785, whilst the median fell from 4388 to 4309.

Potential outliers
IQR = | Q1 - Q3 | = | 4937 - 3794 | = 1143.
1.5*IQR = 1143 * 1.5 = 1714.5
Q1 - 1.5 IQR = 3794 - 1714.5 = 2079.5 ~ 2080.
Q3 + 1.5 IQR = 4937 + 1714.5 = 6651.5 ~ 6652.

In short, potential outliers are weeks that have total merits distributed over 6652 or below 2080.

Now, let's see how many weeks are potential outliers.
11 weeks are potential outliers in total (results shown below), and none of them occured in the recent weeks.  Grin
Code:
. list if merit > 6652 | merit < 2080

     +-----------------+
     |    week   merit |
     |-----------------|
  1. |  2018w4   30949 |
  2. |  2018w5   19958 |
  3. |  2018w6   13304 |
  4. |  2018w7   11722 |
  5. |  2018w8    8758 |
     |-----------------|
  6. |  2018w9    8806 |
  7. | 2018w10    7253 |
  8. | 2018w11    7309 |
  9. | 2018w12    6941 |
 10. | 2018w13    6707 |
     |-----------------|
 35. | 2018w38    7825 |
     +-----------------+


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
January 04, 2019, 03:52:54 AM
 #34

Updated weekly dataset on the assumed calendar in Dutch time.

Notes:
- The week #4 is incomplete one, but I use it due to very high merits distributed within the week, and use it for the statistics on the before / after period.
- The week #52 dropped due to imcomplete one.

Code:
. list week merit

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


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
LoyceV
Legendary
*
Online Online

Activity: 1638
Merit: 4825


Largest Merit Circle on BPIP!


View Profile WWW
January 04, 2019, 08:21:17 AM
 #35

Updated weekly dataset on the assumed calendar in Dutch time.
If you used my data, it's not Dutch time but "Merit time":
I've used the same "time convention" as I used for my full merit transaction history: "Days" start the second the first Merit was transfered, and count exactly 3600*24 seconds after that. It has nothing to do with calendar days in any time zone. "Weeks" use the same, but count 7*3600*24 seconds after the first Merit transaction.

tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
January 04, 2019, 04:05:45 PM
 #36

I known, hence I used 'assumed' calendar days.
< ... >
And, in your another post, you disclosed that it maybe Dutch time.
I started the day the second AdolfinWolf received the first Merit from theymos (Wed Jan 24 23:12:21 2018) (I think this is Dutch time, not forum time).
I known that it's better if I can pinpoint exactly calendar time, but even Theymos have not cared about that (I remembered that I read Theymos' opinion at this point some place in the forum).
One more thing, if I used these assumed calendar days in Dutch time, the first day is probably incomplete day.


To sum up, I think that it's acceptable to call it as assumed calendar days in Dutch time with a note.


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
LoyceV
Legendary
*
Online Online

Activity: 1638
Merit: 4825


Largest Merit Circle on BPIP!


View Profile WWW
January 04, 2019, 04:10:19 PM
 #37

I known that it's better if I can pinpoint exactly calendar time, but even Theymos have not cared about that
It would have been much more considerate if theymos would have sent the first Merit at midnight exactly Tongue

To take away all doubt: the first Merit was this one:
Code:
1516831941 1 2818066.msg28853325 35 877396
Use EpochConverter to convert 1516831941 (Unix Time) to GMT: Wednesday 24 January 2018 22:12:21.

LoyceV
Legendary
*
Online Online

Activity: 1638
Merit: 4825


Largest Merit Circle on BPIP!


View Profile WWW
January 05, 2019, 08:24:05 AM
 #38

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

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

tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
January 05, 2019, 11:16:39 AM
Last edit: January 05, 2019, 01:45:40 PM by tranthidung
 #39

Thanks for your clarification, LoyceV. From now on, I will use assumed calendar days in GTM time.
It would have been much more considerate if theymos would have sent the first Merit at midnight exactly Tongue

To take away all doubt: the first Merit was this one:
Code:
1516831941 1 2818066.msg28853325 35 877396
Use EpochConverter to convert 1516831941 (Unix Time) to GMT: Wednesday 24 January 2018 22:12:21.



- Assumed calendar days in GMT time. I have still used the term 'assumed calendar days in GMT time' due to they are not exactly days in GMT time.
For instance:
The first day is 24/1/2018, which actually lasted for around 1 hours till the launch timepoint of merit system.
Whilst, the first day of LoyceV dataset is counted from the timepoint of first merit sent to 24 hours later.
- I think used 'assumed' is nearly acceptable for now.


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 739



View Profile
January 05, 2019, 11:22:56 AM
Last edit: January 14, 2019, 02:43:41 AM by tranthidung
 #40

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

(1) New All-Time-Low found on 24Dec 2018, with 312 merits distributed during the day (the day with id #335 in LoyceV's original dataset).
This newest ATL is a little bit lower than the previous one that found on 22 Dec 2018, with 316 merits distributed during that day.
(2) Potential outliers are days that have intraday total merits beyond 131 or 1143;
(3) Mean of intraday merits over the period is 617, whilst the interquartile range is from 510 to 763
(4) Friday is the day over weeks has lowest intraday merits in terms of both median and mean, at 536, and 601 respectively.



1) Basic statistics
Daily merit time series plot
- Mean +/- sd: 677 +/- 265
- Meadian (interquartile range): 617 (510 - 763)
It means that 50% of days observed have intraday merits above 617 or below 617; and 50% of those observed days have intraday merits range from 510 to 763.

2) The 50 lowest day in terms of daily merits
Code:
. list merit id date dofw day month2 year week month

     +-------------------------------------------------------------------------------+
     | merit    id        date        dofw   day   month2   year      week     month |
     |-------------------------------------------------------------------------------|
  1. |   312   335   24dec2018      Monday    24       12   2018   2018w52   2018m12 |
  2. |   316   333   22dec2018    Saturday    22       12   2018   2018w51   2018m12 |
  3. |   325   340   29dec2018    Saturday    29       12   2018   2018w52   2018m12 |
  4. |   347   338   27dec2018    Thursday    27       12   2018   2018w52   2018m12 |
  5. |   347   298   17nov2018    Saturday    17       11   2018   2018w46   2018m11 |
     |-------------------------------------------------------------------------------|
  6. |   348   304   23nov2018      Friday    23       11   2018   2018w47   2018m11 |
  7. |   370   122   25may2018      Friday    25        5   2018   2018w21    2018m5 |
  8. |   376   191   02aug2018    Thursday     2        8   2018   2018w31    2018m8 |
  9. |   376   342   31dec2018      Monday    31       12   2018   2018w52   2018m12 |
 10. |   377   326   15dec2018    Saturday    15       12   2018   2018w50   2018m12 |
     |-------------------------------------------------------------------------------|
 11. |   379   220   31aug2018      Friday    31        8   2018   2018w35    2018m8 |
 12. |   383   217   28aug2018     Tuesday    28        8   2018   2018w35    2018m8 |
 13. |   385   214   25aug2018    Saturday    25        8   2018   2018w34    2018m8 |
 14. |   386   339   28dec2018      Friday    28       12   2018   2018w52   2018m12 |
 15. |   389   341   30dec2018      Sunday    30       12   2018   2018w52   2018m12 |
     |-------------------------------------------------------------------------------|
 16. |   395   228   08sep2018    Saturday     8        9   2018   2018w36    2018m9 |
 17. |   397   320   09dec2018      Sunday     9       12   2018   2018w49   2018m12 |
 18. |   399   262   12oct2018      Friday    12       10   2018   2018w41   2018m10 |
 19. |   402   329   18dec2018     Tuesday    18       12   2018   2018w51   2018m12 |
 20. |   405   287   06nov2018     Tuesday     6       11   2018   2018w45   2018m11 |
     |-------------------------------------------------------------------------------|
 21. |   412   222   02sep2018      Sunday     2        9   2018   2018w35    2018m9 |
 22. |   415   109   12may2018    Saturday    12        5   2018   2018w19    2018m5 |
 23. |   415   278   28oct2018      Sunday    28       10   2018   2018w43   2018m10 |
 24. |   418   186   28jul2018    Saturday    28        7   2018   2018w30    2018m7 |
 25. |   420   187   29jul2018      Sunday    29        7   2018   2018w30    2018m7 |
     |-------------------------------------------------------------------------------|
 26. |   421   192   03aug2018      Friday     3        8   2018   2018w31    2018m8 |
 27. |   422   140   12jun2018     Tuesday    12        6   2018   2018w24    2018m6 |
 28. |   424   276   26oct2018      Friday    26       10   2018   2018w43   2018m10 |
 29. |   424   313   02dec2018      Sunday     2       12   2018   2018w48   2018m12 |
 30. |   426   277   27oct2018    Saturday    27       10   2018   2018w43   2018m10 |
     |-------------------------------------------------------------------------------|
 31. |   430   284   03nov2018    Saturday     3       11   2018   2018w44   2018m11 |
 32. |   430   264   14oct2018      Sunday    14       10   2018   2018w41   2018m10 |
 33. |   432   208   19aug2018      Sunday    19        8   2018   2018w33    2018m8 |
 34. |   432   221   01sep2018    Saturday     1        9   2018   2018w35    2018m9 |
 35. |   433   282   01nov2018    Thursday     1       11   2018   2018w44   2018m11 |
     |-------------------------------------------------------------------------------|
 36. |   435   154   26jun2018     Tuesday    26        6   2018   2018w26    2018m6 |
 37. |   435   190   01aug2018   Wednesday     1        8   2018   2018w31    2018m8 |
 38. |   444   182   24jul2018     Tuesday    24        7   2018   2018w30    2018m7 |
 39. |   445   143   15jun2018      Friday    15        6   2018   2018w24    2018m6 |
 40. |   451   206   17aug2018      Friday    17        8   2018   2018w33    2018m8 |
     |-------------------------------------------------------------------------------|
 41. |   454   283   02nov2018      Friday     2       11   2018   2018w44   2018m11 |
 42. |   455   167   09jul2018      Monday     9        7   2018   2018w28    2018m7 |
 43. |   455   229   09sep2018      Sunday     9        9   2018   2018w36    2018m9 |
 44. |   457   216   27aug2018      Monday    27        8   2018   2018w35    2018m8 |
 45. |   458   324   13dec2018    Thursday    13       12   2018   2018w50   2018m12 |
     |-------------------------------------------------------------------------------|
 46. |   458   227   07sep2018      Friday     7        9   2018   2018w36    2018m9 |
 47. |   460   263   13oct2018    Saturday    13       10   2018   2018w41   2018m10 |
 48. |   461   130   02jun2018    Saturday     2        6   2018   2018w22    2018m6 |
 49. |   462   306   25nov2018      Sunday    25       11   2018   2018w47   2018m11 |
 50. |   463    87   20apr2018      Friday    20        4   2018   2018w16    2018m4 |
     |-------------------------------------------------------------------------------|

3) The 50 highest day in terms of daily merits
Code:
. list merit id date dofw day month2 year week month

     +-------------------------------------------------------------------------------+
     | merit    id        date        dofw   day   month2   year      week     month |
     |-------------------------------------------------------------------------------|
  1. | 13018     1   24jan2018   Wednesday    24        1   2018    2018w4    2018m1 |
  2. |  6761     2   25jan2018    Thursday    25        1   2018    2018w4    2018m1 |
  3. |  4493     3   26jan2018      Friday    26        1   2018    2018w4    2018m1 |
  4. |  4192     7   30jan2018     Tuesday    30        1   2018    2018w5    2018m1 |
  5. |  3799     6   29jan2018      Monday    29        1   2018    2018w5    2018m1 |
     |-------------------------------------------------------------------------------|
  6. |  3489     4   27jan2018    Saturday    27        1   2018    2018w4    2018m1 |
  7. |  3188     5   28jan2018      Sunday    28        1   2018    2018w4    2018m1 |
  8. |  2820     8   31jan2018   Wednesday    31        1   2018    2018w5    2018m1 |
  9. |  2568    10   02feb2018      Friday     2        2   2018    2018w5    2018m2 |
 10. |  2545     9   01feb2018    Thursday     1        2   2018    2018w5    2018m2 |
     |-------------------------------------------------------------------------------|
 11. |  2513    22   14feb2018   Wednesday    14        2   2018    2018w7    2018m2 |
 12. |  2463   236   16sep2018      Sunday    16        9   2018   2018w37    2018m9 |
 13. |  2308    14   06feb2018     Tuesday     6        2   2018    2018w6    2018m2 |
 14. |  2167    12   04feb2018      Sunday     4        2   2018    2018w5    2018m2 |
 15. |  2141    16   08feb2018    Thursday     8        2   2018    2018w6    2018m2 |
     |-------------------------------------------------------------------------------|
 16. |  2141    15   07feb2018   Wednesday     7        2   2018    2018w6    2018m2 |
 17. |  2077    13   05feb2018      Monday     5        2   2018    2018w6    2018m2 |
 18. |  1991    23   15feb2018    Thursday    15        2   2018    2018w7    2018m2 |
 19. |  1867    11   03feb2018    Saturday     3        2   2018    2018w5    2018m2 |
 20. |  1862   237   17sep2018      Monday    17        9   2018   2018w38    2018m9 |
     |-------------------------------------------------------------------------------|
 21. |  1747    18   10feb2018    Saturday    10        2   2018    2018w6    2018m2 |
 22. |  1696    38   02mar2018      Friday     2        3   2018    2018w9    2018m3 |
 23. |  1608    25   17feb2018    Saturday    17        2   2018    2018w7    2018m2 |
 24. |  1579    21   13feb2018     Tuesday    13        2   2018    2018w7    2018m2 |
 25. |  1448    17   09feb2018      Friday     9        2   2018    2018w6    2018m2 |
     |-------------------------------------------------------------------------------|
 26. |  1442    19   11feb2018      Sunday    11        2   2018    2018w6    2018m2 |
 27. |  1411    24   16feb2018      Friday    16        2   2018    2018w7    2018m2 |
 28. |  1409    32   24feb2018    Saturday    24        2   2018    2018w8    2018m2 |
 29. |  1403    27   19feb2018      Monday    19        2   2018    2018w8    2018m2 |
 30. |  1382    34   26feb2018      Monday    26        2   2018    2018w9    2018m2 |
     |-------------------------------------------------------------------------------|
 31. |  1354    48   12mar2018      Monday    12        3   2018   2018w11    2018m3 |
 32. |  1333    37   01mar2018    Thursday     1        3   2018    2018w9    2018m3 |
 33. |  1331    20   12feb2018      Monday    12        2   2018    2018w7    2018m2 |
 34. |  1326    35   27feb2018     Tuesday    27        2   2018    2018w9    2018m2 |
 35. |  1322    56   20mar2018     Tuesday    20        3   2018   2018w12    2018m3 |
     |-------------------------------------------------------------------------------|
 36. |  1294   238   18sep2018     Tuesday    18        9   2018   2018w38    2018m9 |
 37. |  1289    26   18feb2018      Sunday    18        2   2018    2018w7    2018m2 |
 38. |  1279    30   22feb2018    Thursday    22        2   2018    2018w8    2018m2 |
 39. |  1268   239   19sep2018   Wednesday    19        9   2018   2018w38    2018m9 |
 40. |  1266    29   21feb2018   Wednesday    21        2   2018    2018w8    2018m2 |
     |-------------------------------------------------------------------------------|
 41. |  1245    41   05mar2018      Monday     5        3   2018   2018w10    2018m3 |
 42. |  1233    68   01apr2018      Sunday     1        4   2018   2018w13    2018m4 |
 43. |  1227    57   21mar2018   Wednesday    21        3   2018   2018w12    2018m3 |
 44. |  1186    33   25feb2018      Sunday    25        2   2018    2018w8    2018m2 |
 45. |  1169    28   20feb2018     Tuesday    20        2   2018    2018w8    2018m2 |
     |-------------------------------------------------------------------------------|
 46. |  1159    50   14mar2018   Wednesday    14        3   2018   2018w11    2018m3 |
 47. |  1146    69   02apr2018      Monday     2        4   2018   2018w14    2018m4 |
 48. |  1138   153   25jun2018      Monday    25        6   2018   2018w26    2018m6 |
 49. |  1130    51   15mar2018    Thursday    15        3   2018   2018w11    2018m3 |
 50. |  1109    43   07mar2018   Wednesday     7        3   2018   2018w10    2018m3 |
     |-------------------------------------------------------------------------------|

4) Intraday merits over days of week
- In medians of intraday merits, and GMT time, lowest days are Friday, Saturday and Sunday, at 536, 575 and 599 respectively.
- In means of intraday merits, and GMT time, lowest days are Friday, Saturday, and Thursday at 601, 616, and 669.
- The highest days in terms of means and medians are both Monday, at 657 and 743 respectively.
More details in the raw results below.

Code:
. tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f) by(dofw)

Summary for variables: merit
     by categories of: dofw

     dofw |         N      mean        sd       p50       p25       p75       min       max
----------+--------------------------------------------------------------------------------
   Sunday |      45.0     696.6     351.2     599.0     464.0     804.0     389.0    2463.0
   Monday |      46.0     742.7     311.6     656.5     534.0     822.0     312.0    1862.0
  Tuesday |      45.0     696.8     243.0     626.0     567.0     760.0     383.0    1326.0
Wednesday |      45.0     713.4     220.0     652.0     562.0     759.0     435.0    1268.0
 Thursday |      45.0     668.6     220.9     636.0     514.0     764.0     347.0    1333.0
   Friday |      45.0     600.4     230.7     536.0     463.0     682.0     348.0    1696.0
 Saturday |      45.0     615.6     227.1     575.0     460.0     688.0     316.0    1409.0
----------+--------------------------------------------------------------------------------
    Total |     316.0     676.5     264.4     616.5     509.5     762.5     312.0    2463.0
-------------------------------------------------------------------------------------------
Plots:
- Outliers displayed with red circles.

- Outliers non-displayed.


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
Pages: « 1 [2] 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 »  All
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!