Bitcoin Forum
May 24, 2019, 10:53:23 AM *
News: Latest Bitcoin Core release: 0.18.0 [Torrent] (New!)
 
   Home   Help Search Login Register More  
Pages: [1] 2 3 4 5 6 7 8 9 »  All
  Print  
Author Topic: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly)  (Read 12775 times)
tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 14, 2018, 01:26:50 PM
Last edit: November 21, 2018, 03:02:03 PM by tranthidung
Merited by minifrij (10), TMAN (10), LoyceV (8), Welsh (5), tbct_mt2 (4), DdmrDdmr (3), bones261 (2), joniboini (2), Daniel91 (1), franckuestein (1), r1s2g3 (1), Heisenberg_Hunter (1), 1miau (1)
 #1

DAILY MERIT TIME-SERIES




I will keep the topic update regularly on weekly basis (mainly because I use weekly data dumps from LoyceV).
Updates will be posted in the last thread of the topic (not in the OP) at specific point of time.






Hello all,

As I stated months ago, that I have planned to make a time series analysis on merit distribution in the forum over time (since 24th January, 2018).
In the topic, I will show you a time series on different time-scale (daily, weekly, monthly, quarterly, and probably yearly in the very far future from now on).


Data sources
1) Original data set (by LoyceV)
2) Fully converted dataset (made by myself)
Someone who have interests and want to get datasets, please visit there.
I want to post all here, but it seems that the OP is unable to last too long (some limitations on total words/ rows from forum rules, I guess).
Details about date time format in my converted dataset explains clearly at the bottom of the topic.


In the OP, I will present you analyses based on full data and truncated data (the first twenty-six days [from 24th Jan. to 18th Feb.] dropped).

Firstly, let's take a look at a full dataset.
From the above image, it is clearly that daily distributed merits plummeted since the first day (launched day) of merit system at 13018, then fell to 4192 after 7 days, and decreased to 2308 after two weeks. After around 76 days, the daily merits dropped to 884, then fluctuated insignificantly from there.
I will present more on medians of daily merits below [somewhere around 650 merits distributed per day].

Secondly, let's take a look at a truncated dataset.
What is truncated dataset. From original one, I truncated the first two days in order to present you a closer, clearer plot.
Of course, these two days are definitely outliers in the dataset, started from January; and there are more outliers, which will be taken into consideration later.
With the plot from truncated dataset, we can easily see that there are a sudden spike in 16th September, daily merits rocketed to 2463, then decreased gradually to 1862, 1294, and 1268 three days later.
These September's spikes occured due to new changes on merit system and forum rank requirements, which aims at Junior members. Demoted Junior members got massively thousands of merits to rank up again in next four days. In other words, the effects of new rank requirements on Junior Member tailed off fastly after four days.


Trend
So, what is kind of trend we have?
In both full and truncated datasets, it is clearly that the general trend of merit distribution is downwards, has gradually fallen over nearly 1 year after the beginning day of merit system.
The linear regression lines shown via red lines in plots.
Despite of suddenly spikes in September, they did not last long enough to make a trend-break. Consequently, in general, merit distribution in the forum has still been in long-term downwards trend.


Mean +/- standard deviation; Median (Interquartile range), minimum and maximum.
Yeah, by now, I only shows you overview on daily distributed merits over around 10 months of 2018.

Now, let's spend a couple of minutes to look at the statistics on daily merits (means, standard deviations, medians, interquartile range, and potential outliers).

As always, with un-normal distributed variables, in the case, daily distributed merits, medians are better statistics to use.
Medians are better because they present nearly true means, and are not affected significantly by potential outliers.

In the part of my analysis, I present three versions of merit dataset:
(1) Full dataset: start from 24th Jan. 2018, to the last updated day.
(2) Partially truncated dataset: the first two days, 24th and 25th Jan. with 13018 and 6761 distributed merits per day, respectively, were truncated.
(3) Fully truncated dataset: all days before 19th Feb. 2018, were truncated.

Now, firstly let's take a look at descriptive time-series plots of two period, before and since 19th Feb 2018.
Before 19th Feb. 2018:

Since 19th Feb. 2018:
The reason why I truncated dataset into two parts explains below.
Statistics:
From the full dataset, we can easily identify potential outliers, both below and above potential outliers.
They are calculated via the following formula:

Potential outliers are data points which higher than Q3 + 1.5*IQR or lower than Q1 - 1.5*IQR
With:
- IQR = Q3 - Q1 (interquartile range presented in the above table with Q1 - Q3, respectively)
- Q1: the 25th quartile
- Q3: the 75th quartile.


Let's calculate cut-offs of potential outliers based on full daily dataset.
IQR = Q3 – Q1 = 884 – 534 = 350;
1.5*IQR = 1.5*350 = 525
Potential outliers:
-   Above Q3 +1.5*IQR = 884 +525 = 1409
-   Below Q1 – 1.5*IQR = 534 – 525 = 9
To sum up, days with total merits above 1409 or below 9 are highly potential outliers.
How many potential outliers we have so far?
There are 27 days which have daily merits above 1409, most of them (24 days) are continuous days from 24th Jan. to 17th Feb. It means 88.9% of those outliers occur before the March. However, I truncated the 18th Feb. in order to have fully weeks for weekly analysis.
Below is the list of those days.
Code:
. list id date merit if merit >1409

     +-------------------------+
     |  id        date   merit |
     |-------------------------|
  1. |   1   24jan2018   13018 |
  2. |   2   25jan2018    6761 |
  3. |   3   26jan2018    4493 |
  4. |   4   27jan2018    3489 |
  5. |   5   28jan2018    3188 |
     |-------------------------|
  6. |   6   29jan2018    3799 |
  7. |   7   30jan2018    4192 |
  8. |   8   31jan2018    2820 |
  9. |   9   01feb2018    2545 |
 10. |  10   02feb2018    2568 |
     |-------------------------|
 11. |  11   03feb2018    1867 |
 12. |  12   04feb2018    2167 |
 13. |  13   05feb2018    2077 |
 14. |  14   06feb2018    2308 |
 15. |  15   07feb2018    2141 |
     |-------------------------|
 16. |  16   08feb2018    2141 |
 17. |  17   09feb2018    1448 |
 18. |  18   10feb2018    1747 |
 19. |  19   11feb2018    1442 |
 21. |  21   13feb2018    1579 |
     |-------------------------|
 22. |  22   14feb2018    2513 |
 23. |  23   15feb2018    1991 |
 24. |  24   16feb2018    1411 |
 25. |  25   17feb2018    1608 |
 38. |  38   02mar2018    1696 |
     |-------------------------|
236. | 236   16sep2018    2463 |
237. | 237   17sep2018    1862 |
     +-------------------------+
The first part of the merit dataset (outliers): the median is 2154 merit per day, with 50% of days have daily merits range from 1608 to 3188 (the interquartile range, from Q1 to Q3). The minimum and maximum figures of the period are 1289 and 13018, respectively.

The second part of merit dataset (mostly not contains outliers): The median of the second part (start from 19th Feb. 2018 to 14th November 2018) is 627, with 50% of days have daily merits range from 525 to 788. The minimum and maximum figures of the period are 370 and 2463, respectively.

The above table presents that there are no significant difference between medians of full and truncated dataset, at 652 and 627, respectively. Nevertheless, there are more considerable diferecence between the means of full and truncated datasets, at 899 and 703, respectively.
It means, mean of daily merits in full dataset is 196 points higher than as of truncated one, whilst the median of daily merits in full dataset is only 25 points higher than as of truncated one

One more time, medians show their magical meanings. Extremely high values of daily merits in early days don’t have too much impact on median.

A basic statistics of truncated dataset:
a) Median: 627, it means that 50% of observed days have total distributed merits lower than 627 and 50% of observed days have total distributed merits higher than 627.
b) Interquartile range (IQR, from Q1 to Q3): 525 - 788, it means that 50% of observed days have total daily distributed merits within the range from 525 to 788 points per day. Additionally, 25% of observed days have less than 525 merits distributed per day, and 25% of observed days have more than 788 merits distributed per day.
Days which have values lower than Q1 (525) and higher than Q3 (788) are called extreme values, and they are likely potential outliers.
c) Min - Max: the minimum and maximum daily distributed merits are 370 and 4493, respectively, for truncated dataset; and are 370 and 13018, respectively for full dataset. By now, the all-time-high of daily distributed merit is 13018. The ATH is extremely difficulty to be beaten at any odds. In my assumption, I believe that new all time high (higher than 13018) will only occured if new demoted wave on Senior member, Hero, and Ledgendary ranks implemented simultaneously; which might be un-realistic (Theymost might never do this).


Potential Outliers
Let's calculate cut-offs of potential outliers based on real daily dataset (truncated one) with the same formula presents above.
- Q1 = 525
- Q3 = 788
----> IQR = Q3 - Q1 = 788 - 525 = 263, hence 1.5*IQR = 1.5*263 = 395.

Q1 - 1.5*IQR = 525 - 395 = 130.
Q3 + 1.5*IQR = 788 + 395 = 1183.

It means days which have total merits distributed above 1.1k or below 130 should be taken into deeply investigation to find what's happen during those days.
So, how many extremely potential outliers we found with truncated dataset?
21 days listed below.
Code:
. list id date merit if merit >1183 & merit != .

     +-------------------------+
     |  id        date   merit |
     |-------------------------|
  1. |  27   19feb2018    1403 |
  3. |  29   21feb2018    1266 |
  4. |  30   22feb2018    1279 |
  6. |  32   24feb2018    1409 |
  7. |  33   25feb2018    1186 |
     |-------------------------|
  8. |  34   26feb2018    1382 |
  9. |  35   27feb2018    1326 |
 11. |  37   01mar2018    1333 |
 12. |  38   02mar2018    1696 |
 15. |  41   05mar2018    1245 |
     |-------------------------|
 22. |  48   12mar2018    1354 |
 30. |  56   20mar2018    1322 |
 31. |  57   21mar2018    1227 |
 42. |  68   01apr2018    1233 |
210. | 236   16sep2018    2463 |
     |-------------------------|
211. | 237   17sep2018    1862 |
212. | 238   18sep2018    1294 |
213. | 239   19sep2018    1268 |
     +-------------------------+

From the truncated dataset, there are 18 extremely potential outliers (nearly 6.7% of 269 observed days since 19th Feb. 2018).

The image also shows that there are limited days with total merits distributed are higher than 1183 (above the horizontal red line)

Box plots
The part presents box plots of daily merit for full data, part of data before 19th Jan. 2018, and the rest part of data since 19th Jan. 2018.
The medians are the horizontal lines inside boxes.
With the visual plots, we can easily see the difference between the medians of after and before datasets.
In the above box plot, outliers are not shown.


Important
1) About date time of days in the dataset:
They are not real dates on the calendar. I started from @Loycev data source, then converted them to real calendar.
With the assumption that the first day in the data source is 24th January 2018, but the first day is a assumed 24th January 2018.
The real one maybe 23th or 25th January 2018 with forum time, or Dutch time.
I meant the assumed dates are only one day before or after the real ones, so I think that we all can accept the assumed/ pseudo-dates (they are actually not big issue).

LoyceV explained below.
If you're using my "days", you're still not using "real" days:
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.
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).

2) The first week in the converted dataset contains only 5 days, and is not a fully-traditional seven-day week.
List of those five days in the first week:
Code:
. list if id <=5

     +----------------------------------------------------------------+
     | id   day   month2   year   merit        date     week    month |
     |----------------------------------------------------------------|
  1. |  1    24        1   2018   13018   24jan2018   2018w4   2018m1 |
  2. |  2    25        1   2018    6761   25jan2018   2018w4   2018m1 |
  3. |  3    26        1   2018    4493   26jan2018   2018w4   2018m1 |
  4. |  4    27        1   2018    3489   27jan2018   2018w4   2018m1 |
  5. |  5    28        1   2018    3188   28jan2018   2018w4   2018m1 |
     +----------------------------------------------------------------+

Notes:
Highly appreciate help of someone who can give me data on merit distribution over ranks, boards (and other categories) since the beginning day of merit system.

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
1558695203
Hero Member
*
Offline Offline

Posts: 1558695203

View Profile Personal Message (Offline)

Ignore
1558695203
Reply with quote  #2

1558695203
Report to moderator
1558695203
Hero Member
*
Offline Offline

Posts: 1558695203

View Profile Personal Message (Offline)

Ignore
1558695203
Reply with quote  #2

1558695203
Report to moderator
1558695203
Hero Member
*
Offline Offline

Posts: 1558695203

View Profile Personal Message (Offline)

Ignore
1558695203
Reply with quote  #2

1558695203
Report to moderator
GET 25 FREE SPINS AT REGISTRATION
GET 100% BONUS ON FIRST DEPOSIT
PLAY NOW
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1558695203
Hero Member
*
Offline Offline

Posts: 1558695203

View Profile Personal Message (Offline)

Ignore
1558695203
Reply with quote  #2

1558695203
Report to moderator
1558695203
Hero Member
*
Offline Offline

Posts: 1558695203

View Profile Personal Message (Offline)

Ignore
1558695203
Reply with quote  #2

1558695203
Report to moderator
1558695203
Hero Member
*
Offline Offline

Posts: 1558695203

View Profile Personal Message (Offline)

Ignore
1558695203
Reply with quote  #2

1558695203
Report to moderator
tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 14, 2018, 01:28:11 PM
Last edit: November 19, 2018, 07:22:34 AM by tranthidung
 #2

Weekly Analysis:
Updated at 19th Nov. 2018:

Overview plot and trend
General trend has been downward, despite of one spike due to adjustment on rank requirements aims at Junior Member rank.


Mean +/- standard deviation; Median (Interquartile range)
1)   The first period, with 4 weeks from 24th Jan. to 18th Feb. 2018 [the first week in these fours is incomplete one).
The mean of weekly merit is 18983 with standard deviation is 8739.
Minimum and maximum of the period are 11722 and 30949, respectively.
2)   The second period, since 19th Feb. 2018, with 38 weeks in total.
The median of the 38-week period is 4423, with 50% of those weeks have total weekly merits in the range from 3854 to 5487 (the interquartile range). 25% of those weeks have total weekly merit above 5487 and 25% of them have total weekly merits below 3854.
Minimum and maximum of the period are 3065 and 8806.

Potential Outliers
Interquartile Range (Q1 - Q3), with Q1 = 3854, Q3 = 5487.
--> IQR = Q3- Q1 = 5487 - 3854 = 1633.
---> 1.5*IQR = 1633*1.5 = 2450.
Therefore, extremely potential outliers are weeks with total distributed merits above 7937 or below 1404.

Formula to calculate potential outliers:
- Q3 + 1.5* IQR = 5487 +2450 = 7937;
- Q1 - 1.5*IQR = 3854 - 2450 = 1404.
Now, let’s see how many extremely potential outliers we have. Only two.

Code:
    +----------------+
     |   week   merit |
     |----------------|
  1. | 2018w8    8758 |
  2. | 2018w9    8806 |
     +----------------+
They are from those days:
Code:
. list if id >26 & id < 41

     +----------------------------------------------------------------+
     | id   day   month2   year   merit        date     week    month |
     |----------------------------------------------------------------|
 27. | 27    19        2   2018    1403   19feb2018   2018w8   2018m2 |
 28. | 28    20        2   2018    1169   20feb2018   2018w8   2018m2 |
 29. | 29    21        2   2018    1266   21feb2018   2018w8   2018m2 |
 30. | 30    22        2   2018    1279   22feb2018   2018w8   2018m2 |
 31. | 31    23        2   2018    1046   23feb2018   2018w8   2018m2 |
     |----------------------------------------------------------------|
 32. | 32    24        2   2018    1409   24feb2018   2018w8   2018m2 |
 33. | 33    25        2   2018    1186   25feb2018   2018w8   2018m2 |
 34. | 34    26        2   2018    1382   26feb2018   2018w9   2018m2 |
 35. | 35    27        2   2018    1326   27feb2018   2018w9   2018m2 |
 36. | 36    28        2   2018     991   28feb2018   2018w9   2018m2 |
     |----------------------------------------------------------------|
 37. | 37     1        3   2018    1333   01mar2018   2018w9   2018m3 |
 38. | 38     2        3   2018    1696   02mar2018   2018w9   2018m3 |
 39. | 39     3        3   2018    1089   03mar2018   2018w9   2018m3 |
 40. | 40     4        3   2018     989   04mar2018   2018w9   2018m3 |
     +----------------------------------------------------------------+
The most interesting thing is even when new rank requirements implemented on Junior Member rank, impacts of the one did not last for too long, and ranged from the end day of week 2018w37 to the first 3 days of week #2018w38.
Consequently, both of weeks #2018w37 and #2018w38 are not extremely potential outliers.
Code:
. list if id > 234 & id < 241

     +------------------------------------------------------------------+
     |  id   day   month2   year   merit        date      week    month |
     |------------------------------------------------------------------|
235. | 235    15        9   2018     463   15sep2018   2018w37   2018m9 |
236. | 236    16        9   2018    2463   16sep2018   2018w37   2018m9 |
237. | 237    17        9   2018    1862   17sep2018   2018w38   2018m9 |
238. | 238    18        9   2018    1294   18sep2018   2018w38   2018m9 |
239. | 239    19        9   2018    1268   19sep2018   2018w38   2018m9 |
     |------------------------------------------------------------------|
240. | 240    20        9   2018     846   20sep2018   2018w38   2018m9 |
     +------------------------------------------------------------------+
Anyway, those two weeks are still potential outliers because they are higher than the 74th quartile (Q3, at 5487).
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    1740 |
     +-----------------+


███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 14, 2018, 01:28:29 PM
Last edit: November 19, 2018, 07:51:39 AM by tranthidung
 #3

Monthly Analysis:

Overview plot and trend
General trend has been downward, despite of one spike due to adjustment on rank requirements aims at Junior Member rank.


Mean +/- standard deviation; Median (Interquartile range)

The median of monthly merit so far is 18752 is interesting figure.
I remembered that I read somewhere else from another topic with almost the same figure around 18k merits distributed in a specific month.
If you know it, please share the link to me. Thanks all in advance.



Under construction, will add more details when the dataset become bigger with more monthly datapoints.

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 14, 2018, 01:28:45 PM
Last edit: November 17, 2018, 02:49:57 PM by tranthidung
 #4

Reserved for quarterly analysis.
Only reserved, because it might take years to get enough quarterly data points.

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
r1s2g3
Sr. Member
****
Offline Offline

Activity: 546
Merit: 358



View Profile
November 16, 2018, 08:32:51 PM
 #5

Q1 - 1.5*IQR = 530 - 531 = 1

530 -531 = -1 (instead of 1)

It will mean that nothing is potential outlier in below Q1 range now.
I think, you have to leave some datapoints in doing this analysis like start of Merit system and the day when number of Merit source increased. These datapoint are affected and are not same as their previous day.

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 17, 2018, 01:01:10 PM
 #6

Thank you.
I got my typos, and fixed it.
530 -531 = -1 (instead of 1)
It will mean that nothing is potential outlier in below Q1 range now.

As I stated above, I have intention to truncate extreme values, outliers for later analysis.
From real dataset, there are 24 potential outliers (nearly 8.4% of 286 observed days so far), which listed below. Only three of those 24 outliers occured after the first of Mar. In other words, 87.5% (21/24) of those outliers occured within January to February.
Full dataset will be used only for descriptive plots, whilst truncated one will be used for analysis.
Extreme values or outliers dramatically affect on results, and might mislead readers far away from the truth.
Quote
I think, you have to leave some datapoints in doing this analysis like start of Merit system and the day when number of Merit source increased. These datapoint are affected and are not same as their previous day.

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
LoyceV
Legendary
*
Online Online

Activity: 1498
Merit: 3860


Self-made Legendary outside Meta!


View Profile WWW
November 18, 2018, 10:29:07 AM
 #7

I especially like the first 2 graphs. I have a request:
Secondly, let's take a look at a truncated dataset.
Can you replace the linear "Fitted values" by something that fits all values better? I think a logarithmic fit could work.

Any idea what happened on Day 153: 1138 Merit? I noticed that already when I first produced the data.

Will you do regular updates? I can provide input data weekly, it's not much work:

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: 106 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: 676 Merit (incomplete week)

tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 18, 2018, 01:34:59 PM
Last edit: November 18, 2018, 02:12:49 PM by tranthidung
 #8

Sure, I will. This is my original intention.
What I have posted are only descriptive ones. More things to come later.
Something like this one:
Can you replace the linear "Fitted values" by something that fits all values better? I think a logarithmic fit could work.

I am not sure, but I guess it probably come from effects of two factors:
1) New merit sources in June. Not sure, because I can not check.
via the link: https://bitcointalk.org/index.php?action=merit;stats=sources, I can get only statistics on merit sources for today, not the past ones. I meant we might get something interesting if be able to retrieve time-series data of merit sources, and a total merit generation of up to 22045 sMerit per 30 days of those sources per day. Maybe weekly data is enough because @Theymos probably have not spent too much time to check and add new merit sources per day.  Smiley
I don't familiar with this, and can not retrieve the data, but you probably can do this with your skills (I guess).
2) Something behind the scene, from the dark side of the forum. Something like suddenly rocket of autobanned accounts (high-ranked ones, of course).

Anyway, thanks for your ideas, from now on, I will keep tracking these two figures (total merit sources, and their total smerit generated per month).
Quote
Any idea what happened on Day 153: 1138 Merit? I noticed that already when I first produced the data.
Now, let's take a look at truncated dataset (I truncated all days before 19th February, the same approach as of weekly analysis).
I will update the OP with truncated daily data analysis.
What I got:
IQR = 788 – 525 = 263;
1.5*IQR = 1.5*263 = 395
Potential outliers are days with total merits above 1183 or below 130. The mentioned day (153th in the dataset) with 1138 merits in total is likely a potential outlier, very close to 1183.
-   Potential above outliers: Q3 +1.5*IQR = 788 +395 = 1183
-   Potential below outliers: Q1 – 1.5*IQR = 525 – 395 = 130
Days with figures outside the interquartile range (from Q1 to Q3) should be considered as potential outliers, and days with figures outside the Q3 + 1.5*IQR and Q1 - 1.5*IQR are highly potential outliers.
Moreover, the median of daily merits from truncated dataset is 627, not change too much than the rest two dataset at 653 and 650 for full, and partially truncated ones, respectively. Median shows magic meanings, again.
I surely will do it regularly, because it is my purpose to start the topic.
Highly appreciate your help by giving me daily data (updated on weekly basis is enough).
Quote
Will you do regular updates? I can provide input data weekly, it's not much work:


By the way, I would clarify that the weekly statistics in my analysis are different than yours.
Why?
I used you daily datapoint, then converted them to weekly one one the structure of real calendar.
It means that the first week in the data set (from 24th to 28th of January) contains only five days, Wednesday to Sunday.
I will keep using the approach for my weekly analysis.
 

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
LoyceV
Legendary
*
Online Online

Activity: 1498
Merit: 3860


Self-made Legendary outside Meta!


View Profile WWW
November 18, 2018, 02:03:40 PM
 #9

Highly appreciate your help by giving me daily data (updated on weekly basis is enough).
Theymos' merit data dump happens once per week, so that's the lowest possible frequency anyway (without resorting to scraping new Merit transactions by myself).

Quote
By the way, I would clarify that the weekly statistics in my analysis are different than yours.
Why?
I used you daily datapoint, then converted them to weekly one one the structure of real calendar.
It means that the first week in the data set (from 24th to 28th of January) contains only five days, Wednesday to Sunday.
I will keep using the approach for my weekly analysis.
If you're using my "days", you're still not using "real" days:
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.
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).

tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 18, 2018, 02:05:44 PM
 #10

I know, it doesn't matter at all. Only one day before or after the r-eal one. I think we can accept it.

By now, there is no day with total distributed merit below 130, and the current lowest is 370. It is likely that merit sources and forum users actively sent their smerits around.

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 19, 2018, 03:07:04 AM
Last edit: November 19, 2018, 07:41:21 AM by tranthidung
 #11

Updated the OP, weekly, and monthly analyses, with more interesting findings, including the following table.
Daily merits
The median of daily merits of the period before 19th Feb. 2018 is 3.4 times higher than as of the period since 19th Feb. 2018, at 2154 and 627, respectively.
For full merit dataset, the all-time-high is 13018, and all-time-low is 370.

Weekly merits

Monthly merits

For more details, please visit and re-read the OP, everyone.

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 19, 2018, 06:19:25 AM
Last edit: November 19, 2018, 07:52:25 AM by tranthidung
 #12

Data sources
1) Original data set (by LoyceV)
Please get it here.
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: 106 Merit (incomplete day)
Datasets used in my analysis was taken from LoyceV source.

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

.

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 20, 2018, 01:45:40 AM
Last edit: November 21, 2018, 03:10:50 PM by tranthidung
 #13

Updated the OP with box plots.
Today, I added box plots of merit for full dataset, the part of days before 19th Jan. 2018, and the rest part of days since 19th Jan. 2018.
Now, let's adjust a little bit to have better box plot.
I made small adjustments in order to disable outliers' display in the plot (data used for the plot is still the full one, and no truncation made here). After that, we have a clearer visual box plot on the distributions of merits.
Medians displayed via horizontal lines inside boxes, and the plot presents same statistical facts as the table below.

In the boxplot, it easily see the small difference of median between full and after merit dataset, which are 652 and 627, respectively.
In contrast, the difference between before and after 19th Jan. 2018 is much more significant, with nearly 3.4 times higher for the median daily merits of the period before 19th. Jan. [2154 compared to 627].


Note:
I can do the same kind of box plot for distributions of merit over ranks, boards, and other categories.
As always, what I need is data. I have not had skills required to retrieve data or scrap data from given raw data. LoyceV proposed dataset given by Piggy. I will try learning more to use the Piggy's dataset.

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 25, 2018, 01:18:29 AM
 #14

Reserved for To-Do List next weeks' data:

1) Box plot for median of weekly merits over weeks.
This one is to track changes of median with impacts of weekly merits, especially with extreme values, both extreme highs and extreme lows.

2) Box plot and descriptive table of the percentage of change between specific week's merits and the median of weekly merits of previous period.
This one is to observe the percentage change, from which can early disclose weeks with abnormal changes of total weekly merits (extremes high or extreme lows, or simply in the range of potential outliers).
Something similar to this one:
https://bitcointalk.org/index.php?topic=2818350.msg48187605#msg48187605
But, I will use data from LoyceV's source, and will do it for more past weeks.

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
LoyceV
Legendary
*
Online Online

Activity: 1498
Merit: 3860


Self-made Legendary outside Meta!


View Profile WWW
November 25, 2018, 01:10:13 PM
 #15

But, I will use data from LoyceV's source, and will do it for more past weeks.
I'll continue posting updates in this topic:
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: 65 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: 675 Merit (incomplete week)

tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 26, 2018, 08:49:15 AM
Last edit: November 26, 2018, 01:42:11 PM by tranthidung
 #16

Thanks LoyceV for the newest data dump this week.

I converted data for my analysis, here is full converted data:
Code:
.         list, abb(30)

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



1) Box plot for median of weekly merits over weeks
[the #1 in my To-Do list above].
For below analysis and box plots, I only use data since 24th Jan. 2018 to 18th November 2018 (or equal to Week #46, which ends at the id #299) because the week #47, from id #300 to id #303, has been incomple one.
Boxplot #1: For daily merits (full data, before - after 18th Feb 2018, and over weeks since week #38)
Boxplot #2: For daily  merits (after 18th Feb 2018, and over weeks since week #38)
In the second box plot, it is clearly that both medians, interquartile range (Q3 - Q1) tend to slowly decrease over weeks.


Nevertheless, as I said before, the first four weeks (half of week 4, and weeks #5 to #7) contain extreme outliers.
In fact, I made two above box plots due to mistakes in the code, but I will leave them above for referece.
Code:
.         list, abb(30)

     +-------------------------------------------------------------------+
     |  id   day   month2   year   merit        date      week     month |
     |-------------------------------------------------------------------|
  1. |   1    24        1   2018   13018   24jan2018    2018w4    2018m1 |
  2. |   2    25        1   2018    6761   25jan2018    2018w4    2018m1 |
  3. |   3    26        1   2018    4493   26jan2018    2018w4    2018m1 |
  4. |   4    27        1   2018    3489   27jan2018    2018w4    2018m1 |
  5. |   5    28        1   2018    3188   28jan2018    2018w4    2018m1 |
     |-------------------------------------------------------------------|
  6. |   6    29        1   2018    3799   29jan2018    2018w5    2018m1 |
  7. |   7    30        1   2018    4192   30jan2018    2018w5    2018m1 |
  8. |   8    31        1   2018    2820   31jan2018    2018w5    2018m1 |
  9. |   9     1        2   2018    2545   01feb2018    2018w5    2018m2 |
 10. |  10     2        2   2018    2568   02feb2018    2018w5    2018m2 |
     |-------------------------------------------------------------------|
 11. |  11     3        2   2018    1867   03feb2018    2018w5    2018m2 |
 12. |  12     4        2   2018    2167   04feb2018    2018w5    2018m2 |
 13. |  13     5        2   2018    2077   05feb2018    2018w6    2018m2 |
 14. |  14     6        2   2018    2308   06feb2018    2018w6    2018m2 |
 15. |  15     7        2   2018    2141   07feb2018    2018w6    2018m2 |
     |-------------------------------------------------------------------|
 16. |  16     8        2   2018    2141   08feb2018    2018w6    2018m2 |
 17. |  17     9        2   2018    1448   09feb2018    2018w6    2018m2 |
 18. |  18    10        2   2018    1747   10feb2018    2018w6    2018m2 |
 19. |  19    11        2   2018    1442   11feb2018    2018w6    2018m2 |
 20. |  20    12        2   2018    1331   12feb2018    2018w7    2018m2 |
     |-------------------------------------------------------------------|
 21. |  21    13        2   2018    1579   13feb2018    2018w7    2018m2 |
 22. |  22    14        2   2018    2513   14feb2018    2018w7    2018m2 |
 23. |  23    15        2   2018    1991   15feb2018    2018w7    2018m2 |
 24. |  24    16        2   2018    1411   16feb2018    2018w7    2018m2 |
 25. |  25    17        2   2018    1608   17feb2018    2018w7    2018m2 |
     |-------------------------------------------------------------------|
 26. |  26    18        2   2018    1289   18feb2018    2018w7    2018m2 |

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 26, 2018, 01:41:11 PM
Last edit: November 26, 2018, 01:55:04 PM by tranthidung
 #17

Continue of the above thread:

Then, I created the same box plot, but for only days since 19th February till 18th November 2018 (since week 2018w8 to 2018w46).
The first four weeks since the start of merit system truncated due to extreme oultliers.

Now, let's see the difference and magical meanings of medians.
The above box plot represents medians of daily merit during the week 2018w8 (start point of the period) to specific weeks (from week 2018w26 to 2018w46). It means the box plot represent the changes of medians over the last 20 weeks (week #26 to #46).

Details statistics of medians of daily merits over weeks will be given later with a table (I will add a table later). Now, let's see raw results, and medians is p50.
Code:
. list week merit median q3 q1

     +--------------------------------------+
     |    week   merit   median    q3    q1 |
     |--------------------------------------|
  1. | 2018w26    4457      733   991   609 |
  2. | 2018w27    4253      715   979   598 |
  3. | 2018w28    4239      707   963   592 |
  4. | 2018w29    4159      693   922   589 |
  5. | 2018w30    3652      684   902   577 |
     |--------------------------------------|
  6. | 2018w31    3798      682   891   575 |
  7. | 2018w32    3994      675   880   567 |
  8. | 2018w33    3618      667   867   559 |
  9. | 2018w34    3789      652   848   555 |
 10. | 2018w35    3065      642   844   537 |
     |--------------------------------------|
 11. | 2018w36    3574      639   838   528 |
 12. | 2018w37    5630      634   829   528 |
 13. | 2018w38    7825      641   846   530 |
 14. | 2018w39    4388      640   839   531 |
 15. | 2018w40    4271      639   829   528 |
     |--------------------------------------|
 16. | 2018w41    3800      637   808   528 |
 17. | 2018w42    4821      639   807   530 |
 18. | 2018w43    3945      639   801   528 |
 19. | 2018w44    3339      628   796   521 |
 20. | 2018w45    4513      630   789   522 |
     |--------------------------------------|
 21. | 2018w46    3722      626   786   521 |
     +--------------------------------------+



Next, list of weeks with ascending medians.
Code:
. list week merit median q3 q1

     +--------------------------------------+
     |    week   merit   median    q3    q1 |
     |--------------------------------------|
  1. | 2018w46    3722      626   786   521 |
  2. | 2018w44    3339      628   796   521 |
  3. | 2018w45    4513      630   789   522 |
  4. | 2018w37    5630      634   829   528 |
  5. | 2018w41    3800      637   808   528 |
     |--------------------------------------|
  6. | 2018w42    4821      639   807   530 |
  7. | 2018w43    3945      639   801   528 |
  8. | 2018w40    4271      639   829   528 |
  9. | 2018w36    3574      639   838   528 |
 10. | 2018w39    4388      640   839   531 |
     |--------------------------------------|
 11. | 2018w38    7825      641   846   530 |
 12. | 2018w35    3065      642   844   537 |
 13. | 2018w34    3789      652   848   555 |
 14. | 2018w33    3618      667   867   559 |
 15. | 2018w32    3994      675   880   567 |
     |--------------------------------------|
 16. | 2018w31    3798      682   891   575 |
 17. | 2018w30    3652      684   902   577 |
 18. | 2018w29    4159      693   922   589 |
 19. | 2018w28    4239      707   963   592 |
 20. | 2018w27    4253      715   979   598 |
     |--------------------------------------|
 21. | 2018w26    4457      733   991   609 |
     +--------------------------------------+


One more thing, a time-series plot of median, and interquartile range (from Q1 to Q3) of daily merits, from weeks #2018w8 to #2018w46), display only for weeks #26 to #46, 20 recent weeks).
From the ascending list of medians of daily merits, the lowest and highest are 626 (at week 2018w46) and 733 (at week 2018w26).
What does it mean?
It means over the recent 20 weeks, there is 14.6% decrease of medians of daily merits (from 733 to 626), based on merit data we have till now, already truncated extreme outliers in the first four weeks.

Notes:

The interquartile range represents 50% of observed data. It means the 50% of observed days have total distribute merit per day inside the range, from Q1 to Q3.
For instance, 50% of observed days from 2018w8 to 2018w46 have total merits per day in the range from 521 to 786.
Code:
. list week merit median q3 q1

     +--------------------------------------+
     |    week   merit   median    q3    q1 |
     |--------------------------------------|
  1. | 2018w46    3722      626   786   521 |

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
tranthidung
Sr. Member
****
Offline Offline

Activity: 476
Merit: 320


Tran Thi Dzung


View Profile
November 26, 2018, 04:53:35 PM
Last edit: November 26, 2018, 11:37:24 PM by tranthidung
 #18

Reserved for the medians of daily merits over days of week, for weeks since the 19th February 2018 (2018w8).
Something similar to LoyceV work, but it is a little bit different, because I will use medians.

1) Converted data for use
Code:
. list id day month2 year date dofw week month

     +-----------------------------------------------------------------------+
     |  id   day   month2   year        date        dofw      week     month |
     |-----------------------------------------------------------------------|
  1. |   1    24        1   2018   24jan2018   Wednesday    2018w4    2018m1 |
  2. |   2    25        1   2018   25jan2018    Thursday    2018w4    2018m1 |
  3. |   3    26        1   2018   26jan2018      Friday    2018w4    2018m1 |
  4. |   4    27        1   2018   27jan2018    Saturday    2018w4    2018m1 |
  5. |   5    28        1   2018   28jan2018      Sunday    2018w4    2018m1 |
     |-----------------------------------------------------------------------|
  6. |   6    29        1   2018   29jan2018      Monday    2018w5    2018m1 |
  7. |   7    30        1   2018   30jan2018     Tuesday    2018w5    2018m1 |
  8. |   8    31        1   2018   31jan2018   Wednesday    2018w5    2018m1 |
  9. |   9     1        2   2018   01feb2018    Thursday    2018w5    2018m2 |
 10. |  10     2        2   2018   02feb2018      Friday    2018w5    2018m2 |
     |-----------------------------------------------------------------------|
 11. |  11     3        2   2018   03feb2018    Saturday    2018w5    2018m2 |
 12. |  12     4        2   2018   04feb2018      Sunday    2018w5    2018m2 |
 13. |  13     5        2   2018   05feb2018      Monday    2018w6    2018m2 |
 14. |  14     6        2   2018   06feb2018     Tuesday    2018w6    2018m2 |
 15. |  15     7        2   2018   07feb2018   Wednesday    2018w6    2018m2 |
     |-----------------------------------------------------------------------|
 16. |  16     8        2   2018   08feb2018    Thursday    2018w6    2018m2 |
 17. |  17     9        2   2018   09feb2018      Friday    2018w6    2018m2 |
 18. |  18    10        2   2018   10feb2018    Saturday    2018w6    2018m2 |
 19. |  19    11        2   2018   11feb2018      Sunday    2018w6    2018m2 |
 20. |  20    12        2   2018   12feb2018      Monday    2018w7    2018m2 |
     |-----------------------------------------------------------------------|
 21. |  21    13        2   2018   13feb2018     Tuesday    2018w7    2018m2 |
 22. |  22    14        2   2018   14feb2018   Wednesday    2018w7    2018m2 |
 23. |  23    15        2   2018   15feb2018    Thursday    2018w7    2018m2 |
 24. |  24    16        2   2018   16feb2018      Friday    2018w7    2018m2 |
 25. |  25    17        2   2018   17feb2018    Saturday    2018w7    2018m2 |
     |-----------------------------------------------------------------------|
 26. |  26    18        2   2018   18feb2018      Sunday    2018w7    2018m2 |
 27. |  27    19        2   2018   19feb2018      Monday    2018w8    2018m2 |
 28. |  28    20        2   2018   20feb2018     Tuesday    2018w8    2018m2 |
 29. |  29    21        2   2018   21feb2018   Wednesday    2018w8    2018m2 |
 30. |  30    22        2   2018   22feb2018    Thursday    2018w8    2018m2 |
     |-----------------------------------------------------------------------|
 31. |  31    23        2   2018   23feb2018      Friday    2018w8    2018m2 |
 32. |  32    24        2   2018   24feb2018    Saturday    2018w8    2018m2 |
 33. |  33    25        2   2018   25feb2018      Sunday    2018w8    2018m2 |
 34. |  34    26        2   2018   26feb2018      Monday    2018w9    2018m2 |
 35. |  35    27        2   2018   27feb2018     Tuesday    2018w9    2018m2 |
     |-----------------------------------------------------------------------|
 36. |  36    28        2   2018   28feb2018   Wednesday    2018w9    2018m2 |
 37. |  37     1        3   2018   01mar2018    Thursday    2018w9    2018m3 |
 38. |  38     2        3   2018   02mar2018      Friday    2018w9    2018m3 |
 39. |  39     3        3   2018   03mar2018    Saturday    2018w9    2018m3 |
 40. |  40     4        3   2018   04mar2018      Sunday    2018w9    2018m3 |
     |-----------------------------------------------------------------------|
 41. |  41     5        3   2018   05mar2018      Monday   2018w10    2018m3 |
 42. |  42     6        3   2018   06mar2018     Tuesday   2018w10    2018m3 |
 43. |  43     7        3   2018   07mar2018   Wednesday   2018w10    2018m3 |
 44. |  44     8        3   2018   08mar2018    Thursday   2018w10    2018m3 |
 45. |  45     9        3   2018   09mar2018      Friday   2018w10    2018m3 |
     |-----------------------------------------------------------------------|
 46. |  46    10        3   2018   10mar2018    Saturday   2018w10    2018m3 |
 47. |  47    11        3   2018   11mar2018      Sunday   2018w10    2018m3 |
 48. |  48    12        3   2018   12mar2018      Monday   2018w11    2018m3 |
 49. |  49    13        3   2018   13mar2018     Tuesday   2018w11    2018m3 |
 50. |  50    14        3   2018   14mar2018   Wednesday   2018w11    2018m3 |
     |-----------------------------------------------------------------------|
 51. |  51    15        3   2018   15mar2018    Thursday   2018w11    2018m3 |
 52. |  52    16        3   2018   16mar2018      Friday   2018w11    2018m3 |
 53. |  53    17        3   2018   17mar2018    Saturday   2018w11    2018m3 |
 54. |  54    18        3   2018   18mar2018      Sunday   2018w11    2018m3 |
 55. |  55    19        3   2018   19mar2018      Monday   2018w12    2018m3 |
     |-----------------------------------------------------------------------|
 56. |  56    20        3   2018   20mar2018     Tuesday   2018w12    2018m3 |
 57. |  57    21        3   2018   21mar2018   Wednesday   2018w12    2018m3 |
 58. |  58    22        3   2018   22mar2018    Thursday   2018w12    2018m3 |
 59. |  59    23        3   2018   23mar2018      Friday   2018w12    2018m3 |
 60. |  60    24        3   2018   24mar2018    Saturday   2018w12    2018m3 |
     |-----------------------------------------------------------------------|
 61. |  61    25        3   2018   25mar2018      Sunday   2018w12    2018m3 |
 62. |  62    26        3   2018   26mar2018      Monday   2018w13    2018m3 |
 63. |  63    27        3   2018   27mar2018     Tuesday   2018w13    2018m3 |
 64. |  64    28        3   2018   28mar2018   Wednesday   2018w13    2018m3 |
 65. |  65    29        3   2018   29mar2018    Thursday   2018w13    2018m3 |
     |-----------------------------------------------------------------------|
 66. |  66    30        3   2018   30mar2018      Friday   2018w13    2018m3 |
 67. |  67    31        3   2018   31mar2018    Saturday   2018w13    2018m3 |
 68. |  68     1        4   2018   01apr2018      Sunday   2018w13    2018m4 |
 69. |  69     2        4   2018   02apr2018      Monday   2018w14    2018m4 |
 70. |  70     3        4   2018   03apr2018     Tuesday   2018w14    2018m4 |
     |-----------------------------------------------------------------------|
 71. |  71     4        4   2018   04apr2018   Wednesday   2018w14    2018m4 |
 72. |  72     5        4   2018   05apr2018    Thursday   2018w14    2018m4 |
 73. |  73     6        4   2018   06apr2018      Friday   2018w14    2018m4 |
 74. |  74     7        4   2018   07apr2018    Saturday   2018w14    2018m4 |
 75. |  75     8        4   2018   08apr2018      Sunday   2018w14    2018m4 |
     |-----------------------------------------------------------------------|
 76. |  76     9        4   2018   09apr2018      Monday   2018w15    2018m4 |
 77. |  77    10        4   2018   10apr2018     Tuesday   2018w15    2018m4 |
 78. |  78    11        4   2018   11apr2018   Wednesday   2018w15    2018m4 |
 79. |  79    12        4   2018   12apr2018    Thursday   2018w15    2018m4 |
 80. |  80    13        4   2018   13apr2018      Friday   2018w15    2018m4 |
     |-----------------------------------------------------------------------|
 81. |  81    14        4   2018   14apr2018    Saturday   2018w15    2018m4 |
 82. |  82    15        4   2018   15apr2018      Sunday   2018w15    2018m4 |
 83. |  83    16        4   2018   16apr2018      Monday   2018w16    2018m4 |
 84. |  84    17        4   2018   17apr2018     Tuesday   2018w16    2018m4 |
 85. |  85    18        4   2018   18apr2018   Wednesday   2018w16    2018m4 |
     |-----------------------------------------------------------------------|
 86. |  86    19        4   2018   19apr2018    Thursday   2018w16    2018m4 |
 87. |  87    20        4   2018   20apr2018      Friday   2018w16    2018m4 |
 88. |  88    21        4   2018   21apr2018    Saturday   2018w16    2018m4 |
 89. |  89    22        4   2018   22apr2018      Sunday   2018w16    2018m4 |
 90. |  90    23        4   2018   23apr2018      Monday   2018w17    2018m4 |
     |-----------------------------------------------------------------------|
 91. |  91    24        4   2018   24apr2018     Tuesday   2018w17    2018m4 |
 92. |  92    25        4   2018   25apr2018   Wednesday   2018w17    2018m4 |
 93. |  93    26        4   2018   26apr2018    Thursday   2018w17    2018m4 |
 94. |  94    27        4   2018   27apr2018      Friday   2018w17    2018m4 |
 95. |  95    28        4   2018   28apr2018    Saturday   2018w17    2018m4 |
     |-----------------------------------------------------------------------|
 96. |  96    29        4   2018   29apr2018      Sunday   2018w17    2018m4 |
 97. |  97    30        4   2018   30apr2018      Monday   2018w18    2018m4 |
 98. |  98     1        5   2018   01may2018     Tuesday   2018w18    2018m5 |
 99. |  99     2        5   2018   02may2018   Wednesday   2018w18    2018m5 |
100. | 100     3        5   2018   03may2018    Thursday   2018w18    2018m5 |
     |-----------------------------------------------------------------------|
101. | 101     4        5   2018   04may2018      Friday   2018w18    2018m5 |
102. | 102     5        5   2018   05may2018    Saturday   2018w18    2018m5 |
103. | 103     6        5   2018   06may2018      Sunday   2018w18    2018m5 |
104. | 104     7        5   2018   07may2018      Monday   2018w19    2018m5 |
105. | 105     8        5   2018   08may2018     Tuesday   2018w19    2018m5 |
     |-----------------------------------------------------------------------|
106. | 106     9        5   2018   09may2018   Wednesday   2018w19    2018m5 |
107. | 107    10        5   2018   10may2018    Thursday   2018w19    2018m5 |
108. | 108    11        5   2018   11may2018      Friday   2018w19    2018m5 |
109. | 109    12        5   2018   12may2018    Saturday   2018w19    2018m5 |
110. | 110    13        5   2018   13may2018      Sunday   2018w19    2018m5 |
     |-----------------------------------------------------------------------|
111. | 111    14        5   2018   14may2018      Monday   2018w20    2018m5 |
112. | 112    15        5   2018   15may2018     Tuesday   2018w20    2018m5 |
113. | 113    16        5   2018   16may2018   Wednesday   2018w20    2018m5 |
114. | 114    17        5   2018   17may2018    Thursday   2018w20    2018m5 |
115. | 115    18        5   2018   18may2018      Friday   2018w20    2018m5 |
     |-----------------------------------------------------------------------|
116. | 116    19        5   2018   19may2018    Saturday   2018w20    2018m5 |
117. | 117    20        5   2018   20may2018      Sunday   2018w20    2018m5 |
118. | 118    21        5   2018   21may2018      Monday   2018w21    2018m5 |
119. | 119    22        5   2018   22may2018     Tuesday   2018w21    2018m5 |
120. | 120    23        5   2018   23may2018   Wednesday   2018w21    2018m5 |
     |-----------------------------------------------------------------------|
121. | 121    24        5   2018   24may2018    Thursday   2018w21    2018m5 |
122. | 122    25        5   2018   25may2018      Friday   2018w21    2018m5 |
123. | 123    26        5   2018   26may2018    Saturday   2018w21    2018m5 |
124. | 124    27        5   2018   27may2018      Sunday   2018w21    2018m5 |
125. | 125    28        5   2018   28may2018      Monday   2018w22    2018m5 |
     |-----------------------------------------------------------------------|
126. | 126    29        5   2018   29may2018     Tuesday   2018w22    2018m5 |
127. | 127    30        5   2018   30may2018   Wednesday   2018w22    2018m5 |
128. | 128    31        5   2018   31may2018    Thursday   2018w22    2018m5 |
129. | 129     1        6   2018   01jun2018      Friday   2018w22    2018m6 |
130. | 130     2        6   2018   02jun2018    Saturday   2018w22    2018m6 |
     |-----------------------------------------------------------------------|
131. | 131     3        6   2018   03jun2018      Sunday   2018w22    2018m6 |
132. | 132     4        6   2018   04jun2018      Monday   2018w23    2018m6 |
133. | 133     5        6   2018   05jun2018     Tuesday   2018w23    2018m6 |
134. | 134     6        6   2018   06jun2018   Wednesday   2018w23    2018m6 |
135. | 135     7        6   2018   07jun2018    Thursday   2018w23    2018m6 |
     |-----------------------------------------------------------------------|
136. | 136     8        6   2018   08jun2018      Friday   2018w23    2018m6 |
137. | 137     9        6   2018   09jun2018    Saturday   2018w23    2018m6 |
138. | 138    10        6   2018   10jun2018      Sunday   2018w23    2018m6 |
139. | 139    11        6   2018   11jun2018      Monday   2018w24    2018m6 |
140. | 140    12        6   2018   12jun2018     Tuesday   2018w24    2018m6 |
     |-----------------------------------------------------------------------|
141. | 141    13        6   2018   13jun2018   Wednesday   2018w24    2018m6 |
142. | 142    14        6   2018   14jun2018    Thursday   2018w24    2018m6 |
143. | 143    15        6   2018   15jun2018      Friday   2018w24    2018m6 |
144. | 144    16        6   2018   16jun2018    Saturday   2018w24    2018m6 |
145. | 145    17        6   2018   17jun2018      Sunday   2018w24    2018m6 |
     |-----------------------------------------------------------------------|
146. | 146    18        6   2018   18jun2018      Monday   2018w25    2018m6 |
147. | 147    19        6   2018   19jun2018     Tuesday   2018w25    2018m6 |
148. | 148    20        6   2018   20jun2018   Wednesday   2018w25    2018m6 |
149. | 149    21        6   2018   21jun2018    Thursday   2018w25    2018m6 |
150. | 150    22        6   2018   22jun2018      Friday   2018w25    2018m6 |
     |-----------------------------------------------------------------------|
151. | 151    23        6   2018   23jun2018    Saturday   2018w25    2018m6 |
152. | 152    24        6   2018   24jun2018      Sunday   2018w25    2018m6 |
153. | 153    25        6   2018   25jun2018      Monday   2018w26    2018m6 |
154. | 154    26        6   2018   26jun2018     Tuesday   2018w26    2018m6 |
155. | 155    27        6   2018   27jun2018   Wednesday   2018w26    2018m6 |
     |-----------------------------------------------------------------------|
156. | 156    28        6   2018   28jun2018    Thursday   2018w26    2018m6 |
157. | 157    29        6   2018   29jun2018      Friday   2018w26    2018m6 |
158. | 158    30        6   2018   30jun2018    Saturday   2018w26    2018m6 |
159. | 159     1        7   2018   01jul2018      Sunday   2018w26    2018m7 |
160. | 160     2        7   2018   02jul2018      Monday   2018w27    2018m7 |
     |-----------------------------------------------------------------------|
161. | 161     3        7   2018   03jul2018     Tuesday   2018w27    2018m7 |
162. | 162     4        7   2018   04jul2018   Wednesday   2018w27    2018m7 |
163. | 163     5        7   2018   05jul2018    Thursday   2018w27    2018m7 |
164. | 164     6        7   2018   06jul2018      Friday   2018w27    2018m7 |
165. | 165     7        7   2018   07jul2018    Saturday   2018w27    2018m7 |
     |-----------------------------------------------------------------------|
166. | 166     8        7   2018   08jul2018      Sunday   2018w27    2018m7 |
167. | 167     9        7   2018   09jul2018      Monday   2018w28    2018m7 |
168. | 168    10        7   2018   10jul2018     Tuesday   2018w28    2018m7 |
169. | 169    11        7   2018   11jul2018   Wednesday   2018w28    2018m7 |
170. | 170    12        7   2018   12jul2018    Thursday   2018w28    2018m7 |
     |-----------------------------------------------------------------------|
171. | 171    13        7   2018   13jul2018      Friday   2018w28    2018m7 |
172. | 172    14        7   2018   14jul2018    Saturday   2018w28    2018m7 |
173. | 173    15        7   2018   15jul2018      Sunday   2018w28    2018m7 |
174. | 174    16        7   2018   16jul2018      Monday   2018w29    2018m7 |
175. | 175    17        7   2018   17jul2018     Tuesday   2018w29    2018m7 |
     |-----------------------------------------------------------------------|
176. | 176    18        7   2018   18jul2018   Wednesday   2018w29    2018m7 |
177. | 177    19        7   2018   19jul2018    Thursday   2018w29    2018m7 |
178. | 178    20        7   2018   20jul2018      Friday   2018w29    2018m7 |
179. | 179    21        7   2018   21jul2018    Saturday   2018w29    2018m7 |
180. | 180    22        7   2018   22jul2018      Sunday   2018w29    2018m7 |
     |-----------------------------------------------------------------------|
181. | 181    23        7   2018   23jul2018      Monday   2018w30    2018m7 |
182. | 182    24        7   2018   24jul2018     Tuesday   2018w30    2018m7 |
183. | 183    25        7   2018   25jul2018   Wednesday   2018w30    2018m7 |
184. | 184    26        7   2018   26jul2018    Thursday   2018w30    2018m7 |
185. | 185    27        7   2018   27jul2018      Friday   2018w30    2018m7 |
     |-----------------------------------------------------------------------|
186. | 186    28        7   2018   28jul2018    Saturday   2018w30    2018m7 |
187. | 187    29        7   2018   29jul2018      Sunday   2018w30    2018m7 |
188. | 188    30        7   2018   30jul2018      Monday   2018w31    2018m7 |
189. | 189    31        7   2018   31jul2018     Tuesday   2018w31    2018m7 |
190. | 190     1        8   2018   01aug2018   Wednesday   2018w31    2018m8 |
     |-----------------------------------------------------------------------|
191. | 191     2        8   2018   02aug2018    Thursday   2018w31    2018m8 |
192. | 192     3        8   2018   03aug2018      Friday   2018w31    2018m8 |
193. | 193     4        8   2018   04aug2018    Saturday   2018w31    2018m8 |
194. | 194     5        8   2018   05aug2018      Sunday   2018w31    2018m8 |
195. | 195     6        8   2018   06aug2018      Monday   2018w32    2018m8 |
     |-----------------------------------------------------------------------|
196. | 196     7        8   2018   07aug2018     Tuesday   2018w32    2018m8 |
197. | 197     8        8   2018   08aug2018   Wednesday   2018w32    2018m8 |
198. | 198     9        8   2018   09aug2018    Thursday   2018w32    2018m8 |
199. | 199    10        8   2018   10aug2018      Friday   2018w32    2018m8 |
200. | 200    11        8   2018   11aug2018    Saturday   2018w32    2018m8 |
     |-----------------------------------------------------------------------|
201. | 201    12        8   2018   12aug2018      Sunday   2018w32    2018m8 |
202. | 202    13        8   2018   13aug2018      Monday   2018w33    2018m8 |
203. | 203    14        8   2018   14aug2018     Tuesday   2018w33    2018m8 |
204. | 204    15        8   2018   15aug2018   Wednesday   2018w33    2018m8 |
205. | 205    16        8   2018   16aug2018    Thursday   2018w33    2018m8 |
     |-----------------------------------------------------------------------|
206. | 206    17        8   2018   17aug2018      Friday   2018w33    2018m8 |
207. | 207    18        8   2018   18aug2018    Saturday   2018w33    2018m8 |
208. | 208    19        8   2018   19aug2018      Sunday   2018w33    2018m8 |
209. | 209    20        8   2018   20aug2018      Monday   2018w34    2018m8 |
210. | 210    21        8   2018   21aug2018     Tuesday   2018w34    2018m8 |
     |-----------------------------------------------------------------------|
211. | 211    22        8   2018   22aug2018   Wednesday   2018w34    2018m8 |
212. | 212    23        8   2018   23aug2018    Thursday   2018w34    2018m8 |
213. | 213    24        8   2018   24aug2018      Friday   2018w34    2018m8 |
214. | 214    25        8   2018   25aug2018    Saturday   2018w34    2018m8 |
215. | 215    26        8   2018   26aug2018      Sunday   2018w34    2018m8 |
     |-----------------------------------------------------------------------|
216. | 216    27        8   2018   27aug2018      Monday   2018w35    2018m8 |
217. | 217    28        8   2018   28aug2018     Tuesday   2018w35    2018m8 |
218. | 218    29        8   2018   29aug2018   Wednesday   2018w35    2018m8 |
219. | 219    30        8   2018   30aug2018    Thursday   2018w35    2018m8 |
220. | 220    31        8   2018   31aug2018      Friday   2018w35    2018m8 |
     |-----------------------------------------------------------------------|
221. | 221     1        9   2018   01sep2018    Saturday   2018w35    2018m9 |
222. | 222     2        9   2018   02sep2018      Sunday   2018w35    2018m9 |
223. | 223     3        9   2018   03sep2018      Monday   2018w36    2018m9 |
224. | 224     4        9   2018   04sep2018     Tuesday   2018w36    2018m9 |
225. | 225     5        9   2018   05sep2018   Wednesday   2018w36    2018m9 |
     |-----------------------------------------------------------------------|
226. | 226     6        9   2018   06sep2018    Thursday   2018w36    2018m9 |
227. | 227     7        9   2018   07sep2018      Friday   2018w36    2018m9 |
228. | 228     8        9   2018   08sep2018    Saturday   2018w36    2018m9 |
229. | 229     9        9   2018   09sep2018      Sunday   2018w36    2018m9 |
230. | 230    10        9   2018   10sep2018      Monday   2018w37    2018m9 |
     |-----------------------------------------------------------------------|
231. | 231    11        9   2018   11sep2018     Tuesday   2018w37    2018m9 |
232. | 232    12        9   2018   12sep2018   Wednesday   2018w37    2018m9 |
233. | 233    13        9   2018   13sep2018    Thursday   2018w37    2018m9 |
234. | 234    14        9   2018   14sep2018      Friday   2018w37    2018m9 |
235. | 235    15        9   2018   15sep2018    Saturday   2018w37    2018m9 |
     |-----------------------------------------------------------------------|
236. | 236    16        9   2018   16sep2018      Sunday   2018w37    2018m9 |
237. | 237    17        9   2018   17sep2018      Monday   2018w38    2018m9 |
238. | 238    18        9   2018   18sep2018     Tuesday   2018w38    2018m9 |
239. | 239    19        9   2018   19sep2018   Wednesday   2018w38    2018m9 |
240. | 240    20        9   2018   20sep2018    Thursday   2018w38    2018m9 |
     |-----------------------------------------------------------------------|
241. | 241    21        9   2018   21sep2018      Friday   2018w38    2018m9 |
242. | 242    22        9   2018   22sep2018    Saturday   2018w38    2018m9 |
243. | 243    23        9   2018   23sep2018      Sunday   2018w38    2018m9 |
244. | 244    24        9   2018   24sep2018      Monday   2018w39    2018m9 |
245. | 245    25        9   2018   25sep2018     Tuesday   2018w39    2018m9 |
     |-----------------------------------------------------------------------|
246. | 246    26        9   2018   26sep2018   Wednesday   2018w39    2018m9 |
247. | 247    27        9   2018   27sep2018    Thursday   2018w39    2018m9 |
248. | 248    28        9   2018   28sep2018      Friday   2018w39    2018m9 |
249. | 249    29        9   2018   29sep2018    Saturday   2018w39    2018m9 |
250. | 250    30        9   2018   30sep2018      Sunday   2018w39    2018m9 |
     |-----------------------------------------------------------------------|
251. | 251     1       10   2018   01oct2018      Monday   2018w40   2018m10 |
252. | 252     2       10   2018   02oct2018     Tuesday   2018w40   2018m10 |
253. | 253     3       10   2018   03oct2018   Wednesday   2018w40   2018m10 |
254. | 254     4       10   2018   04oct2018    Thursday   2018w40   2018m10 |
255. | 255     5       10   2018   05oct2018      Friday   2018w40   2018m10 |
     |-----------------------------------------------------------------------|
256. | 256     6       10   2018   06oct2018    Saturday   2018w40   2018m10 |
257. | 257     7       10   2018   07oct2018      Sunday   2018w40   2018m10 |
258. | 258     8       10   2018   08oct2018      Monday   2018w41   2018m10 |
259. | 259     9       10   2018   09oct2018     Tuesday   2018w41   2018m10 |
260. | 260    10       10   2018   10oct2018   Wednesday   2018w41   2018m10 |
     |-----------------------------------------------------------------------|
261. | 261    11       10   2018   11oct2018    Thursday   2018w41   2018m10 |
262. | 262    12       10   2018   12oct2018      Friday   2018w41   2018m10 |
263. | 263    13       10   2018   13oct2018    Saturday   2018w41   2018m10 |
264. | 264    14       10   2018   14oct2018      Sunday   2018w41   2018m10 |
265. | 265    15       10   2018   15oct2018      Monday   2018w42   2018m10 |
     |-----------------------------------------------------------------------|
266. | 266    16       10   2018   16oct2018     Tuesday   2018w42   2018m10 |
267. | 267    17       10   2018   17oct2018   Wednesday   2018w42   2018m10 |
268. | 268    18       10   2018   18oct2018    Thursday   2018w42   2018m10 |
269. | 269    19       10   2018   19oct2018      Friday   2018w42   2018m10 |
270. | 270    20       10   2018   20oct2018    Saturday   2018w42   2018m10 |
     |-----------------------------------------------------------------------|
271. | 271    21       10   2018   21oct2018      Sunday   2018w42   2018m10 |
272. | 272    22       10   2018   22oct2018      Monday   2018w43   2018m10 |
273. | 273    23       10   2018   23oct2018     Tuesday   2018w43   2018m10 |
274. | 274    24       10   2018   24oct2018   Wednesday   2018w43   2018m10 |
275. | 275    25       10   2018   25oct2018    Thursday   2018w43   2018m10 |
     |-----------------------------------------------------------------------|
276. | 276    26       10   2018   26oct2018      Friday   2018w43   2018m10 |
277. | 277    27       10   2018   27oct2018    Saturday   2018w43   2018m10 |
278. | 278    28       10   2018   28oct2018      Sunday   2018w43   2018m10 |
279. | 279    29       10   2018   29oct2018      Monday   2018w44   2018m10 |
280. | 280    30       10   2018   30oct2018     Tuesday   2018w44   2018m10 |
     |-----------------------------------------------------------------------|
281. | 281    31       10   2018   31oct2018   Wednesday   2018w44   2018m10 |
282. | 282     1       11   2018   01nov2018    Thursday   2018w44   2018m11 |
283. | 283     2       11   2018   02nov2018      Friday   2018w44   2018m11 |
284. | 284     3       11   2018   03nov2018    Saturday   2018w44   2018m11 |
285. | 285     4       11   2018   04nov2018      Sunday   2018w44   2018m11 |
     |-----------------------------------------------------------------------|
286. | 286     5       11   2018   05nov2018      Monday   2018w45   2018m11 |
287. | 287     6       11   2018   06nov2018     Tuesday   2018w45   2018m11 |
288. | 288     7       11   2018   07nov2018   Wednesday   2018w45   2018m11 |
289. | 289     8       11   2018   08nov2018    Thursday   2018w45   2018m11 |
290. | 290     9       11   2018   09nov2018      Friday   2018w45   2018m11 |
     |-----------------------------------------------------------------------|
291. | 291    10       11   2018   10nov2018    Saturday   2018w45   2018m11 |
292. | 292    11       11   2018   11nov2018      Sunday   2018w45   2018m11 |
293. | 293    12       11   2018   12nov2018      Monday   2018w46   2018m11 |
294. | 294    13       11   2018   13nov2018     Tuesday   2018w46   2018m11 |
295. | 295    14       11   2018   14nov2018   Wednesday   2018w46   2018m11 |
     |-----------------------------------------------------------------------|
296. | 296    15       11   2018   15nov2018    Thursday   2018w46   2018m11 |
297. | 297    16       11   2018   16nov2018      Friday   2018w46   2018m11 |
298. | 298    17       11   2018   17nov2018    Saturday   2018w46   2018m11 |
299. | 299    18       11   2018   18nov2018      Sunday   2018w46   2018m11 |
300. | 300    19       11   2018   19nov2018      Monday   2018w47   2018m11 |
     |-----------------------------------------------------------------------|
301. | 301    20       11   2018   20nov2018     Tuesday   2018w47   2018m11 |
302. | 302    21       11   2018   21nov2018   Wednesday   2018w47   2018m11 |
     +-----------------------------------------------------------------------+


2) Results
2.1) Full data (only for reference)
Raw resutls:
Code:
    dofw |         N      mean        sd       p50       p25       p75       min       max
----------+--------------------------------------------------------------------------------
   Sunday |      43.0     849.9     563.8     641.0     511.0     989.0     412.0    3188.0
   Monday |      43.0     890.7     586.8     684.0     589.0     992.0     455.0    3799.0
  Tuesday |      43.0     857.8     633.9     639.0     580.0     902.0     383.0    4192.0
Wednesday |      44.0    1127.2    1902.4     684.0     582.0     977.0     435.0   13018.0
 Thursday |      43.0     934.9    1017.2     673.0     528.0     848.0     376.0    6761.0
   Friday |      43.0     792.9     707.3     567.0     475.0     789.0     370.0    4493.0
 Saturday |      43.0     783.3     553.7     627.0     463.0     797.0     347.0    3489.0
----------+--------------------------------------------------------------------------------
    Total |     302.0     891.7     966.6     648.5     531.0     880.0     347.0   13018.0
-------------------------------------------------------------------------------------------
Median: p50
Q1: p25
Q3: p75
Min: Minimum
Max: Maximum
Mean: Average


- Lowest day: Friday (567)
- Highest day: Monday and Wednesday (all both at 684)
- Percentage of difference between highest and lowest: 20.6%
Code:
. di (684-567)*100/567
20.634921

2.2) First four weeks and first three days of 2018w47 dropped (I strongly suggest to use these below results)
Raw results:
Code:
    dofw |         N      mean        sd       p50       p25       p75       min       max
----------+--------------------------------------------------------------------------------
   Sunday |      39.0     729.7     364.2     617.0     486.0     853.0     412.0    2463.0
   Monday |      39.0     774.2     319.2     674.0     562.0     884.0     455.0    1862.0
  Tuesday |      39.0     718.9     250.1     632.0     580.0     768.0     383.0    1326.0
Wednesday |      39.0     730.7     230.6     654.0     562.0     786.0     435.0    1268.0
 Thursday |      39.0     686.3     226.1     644.0     521.0     838.0     376.0    1333.0
   Friday |      39.0     619.9     240.1     542.0     463.0     733.0     370.0    1696.0
 Saturday |      39.0     640.3     228.0     614.0     461.0     688.0     347.0    1409.0
----------+--------------------------------------------------------------------------------
    Total |     273.0     700.0     272.0     626.0     521.0     786.0     347.0    2463.0
-------------------------------------------------------------------------------------------

- Lowest day: Saturday (542)
- Highest day: Wednesday (654)
- Percentage of difference between highest and lowest: 20.7%
Code:
. di (654-542)*100/542
20.664207


Boxplots of merits over days of weeks
Potential outliers displayed with red circles.

Potential outliers' displays disabled.


Not sure which factors make difference between my findings and LoyceV's ones, because my analysis for full data shows that the highest median of days of week is Thursday; and I guess LoyceV findings come from full daily data.
There are three possible reasons:
1) My start 'assumed' calendar day should move backwards or forwards one day from the current one.
2) LoyceV used total merit per days of week, which significantly affected by outliers.
3) I used truncated dataset, LoyceV used full dataset.

Here is LoyceV's findings:
Code:
Merit per day of the week
Monday 36842 (13.63%)
Tuesday 38426 (14.22%)
Wednesday 37368 (13.83%)
Thursday 49743 (18.41%)
Friday 39854 (14.75%)
Saturday 34291 (12.69%)
Sunday 33611 (12.44%)

If I actually did something wrong, I believe that it highly comes from reason #1, because Wednesday is the day with highest median daily merit for both full and truncated datasets (one day earlier than LoyceV's findings - Thursday).
Waiting for LoyceV's answer at this point.

███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
#1
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
BTC 
  ●
   BTC
  BTC  
.
    ▄▄▄▀▀▀▀
 ▄██▀
███        ▄▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄▄▄
▀███▄▄▄▄▀▀▀                 ▀▀▄▄
  ▀▀▀██████████████████████████▀
   ▄█▄     ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
    ▀▀██▄▄█▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀▀
      ▄  ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
      ▀██▄  ▄▀▀▀▀▀▀▀▀▀▀▀▀▄
        ▀█▀██████████████▀▀
         ▀█▄▄ ▄▄▄▄▄▄▄▄▄▄
            █▀▄▄▄▄▄▄▄▄▄▄▀
             ▀▀▄▄▄▄▄▄▄
.
     BTC
  BTC   
  ●
  BTC  
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
███████████
██
██
██
██
██
██
██
██
██
██
██
███████████
LoyceV
Legendary
*
Online Online

Activity: 1498
Merit: 3860


Self-made Legendary outside Meta!


View Profile WWW
December 01, 2018, 08:39:36 PM
 #19

Waiting for LoyceV's answer at this point.
It's a combination of all your points. And don't forget: the data I give you here aren't calendar days, but 24*3600 seconds from the first Merit transaction. For my merit analysis I use (Dutch) calendar days.

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: 43 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: 602 Merit (incomplete week)

LoyceV
Legendary
*
Online Online

Activity: 1498
Merit: 3860


Self-made Legendary outside Meta!


View Profile WWW
December 08, 2018, 11:47:39 AM
 #20

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: 48 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: 718 Merit (incomplete week)

Pages: [1] 2 3 4 5 6 7 8 9 »  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!