777 coin campaign observations (since 30/12/2018 to 19/5/2019)
21 weeks in total, so far (only weeks managed by Hhampuz).
Converted dataset from the spreadsheet:. list, abb(30)
+-------------------------------------------------------------------------------------------------+
| id week postcount btcpaid day month2 year date week2 month quarter |
|-------------------------------------------------------------------------------------------------|
1. | 1 1 708 .03082 30 12 2018 30dec2018 2018w52 2018m12 2018q4 |
2. | 2 2 1049 .04953 6 1 2019 06jan2019 2019w1 2019m1 2019q1 |
3. | 3 3 1226 .05641 13 1 2019 13jan2019 2019w2 2019m1 2019q1 |
4. | 4 4 1303 .060075 20 1 2019 20jan2019 2019w3 2019m1 2019q1 |
5. | 5 5 1348 .06284 27 1 2019 27jan2019 2019w4 2019m1 2019q1 |
|-------------------------------------------------------------------------------------------------|
6. | 6 6 1266 .06126 3 2 2019 03feb2019 2019w5 2019m2 2019q1 |
7. | 7 7 1263 .06225 10 2 2019 10feb2019 2019w6 2019m2 2019q1 |
8. | 8 8 1203 .05849 17 2 2019 17feb2019 2019w7 2019m2 2019q1 |
9. | 9 9 1203 .058315 24 2 2019 24feb2019 2019w8 2019m2 2019q1 |
10. | 10 10 1210 .056165 3 3 2019 03mar2019 2019w9 2019m3 2019q1 |
|-------------------------------------------------------------------------------------------------|
11. | 11 11 1016 .05084 10 3 2019 10mar2019 2019w10 2019m3 2019q1 |
12. | 12 12 1258 .057785 17 3 2019 17mar2019 2019w11 2019m3 2019q1 |
13. | 13 13 1186 .05373 24 3 2019 24mar2019 2019w12 2019m3 2019q1 |
14. | 14 14 922 .04392 31 3 2019 31mar2019 2019w13 2019m3 2019q1 |
15. | 15 15 1107 .052805 7 4 2019 07apr2019 2019w14 2019m4 2019q2 |
|-------------------------------------------------------------------------------------------------|
16. | 16 16 1071 .05278 14 4 2019 14apr2019 2019w15 2019m4 2019q2 |
17. | 17 17 1120 .05558 21 4 2019 21apr2019 2019w16 2019m4 2019q2 |
18. | 18 18 1037 .049555 28 4 2019 28apr2019 2019w17 2019m4 2019q2 |
19. | 19 19 910 .045645 5 5 2019 05may2019 2019w18 2019m5 2019q2 |
20. | 20 20 1051 .05085 12 5 2019 12may2019 2019w19 2019m5 2019q2 |
|-------------------------------------------------------------------------------------------------|
21. | 21 21 1310 .06036 19 5 2019 19may2019 2019w20 2019m5 2019q2 |
+-------------------------------------------------------------------------------------------------+
Time series plots: The time series plots show that both weekly postcounts and BTC-paid have reached new all time high last week.
Statistics:- Postcount: 50% of observed weeks have total postcounts above 1186, whilst 50% of rest weeks have total postcounts below 1186, the median (p50). The mean and standard deviation are 1132 and 159, respectively. Min and max are 708 and 1348, respectively. 50% of total weekly postcounts range from 1049 to 1258 (the interquartile range from p25 to p75).
- BTC paid: 50% of observed weeks have total BTC paid above 0.0556, whilst 50% of rest weeks have total BTC paid below 0.0556, the median (p50). The mean and standard deviation are 0.0538 and 0.0075, respectively. Min and max aare 0.0308 and 0.0628, respectively. 50% of total weekly BTC-paid range from 0.0508 to 0.0585 (the interquartile range from p25 to p75).
. tabstat postcount btcpaid, s(n mean sd p50 p25 p75 min max) c(s)
variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
postcount | 21 1131.762 158.1252 1186 1049 1258 708 1348
btcpaid | 21 .0538098 .0074598 .05558 .05084 .05849 .03082 .06284
----------------------------------------------------------------------------------------------
List of weeks in descending orders of total postcounts or total BTC paid
Postcount:. list postcount day month2 year date week2 month quarter, abb(30)
+---------------------------------------------------------------------------+
| postcount day month2 year date week2 month quarter |
|---------------------------------------------------------------------------|
1. | 1348 27 1 2019 27jan2019 2019w4 2019m1 2019q1 |
2. | 1310 19 5 2019 19may2019 2019w20 2019m5 2019q2 |
3. | 1303 20 1 2019 20jan2019 2019w3 2019m1 2019q1 |
4. | 1266 3 2 2019 03feb2019 2019w5 2019m2 2019q1 |
5. | 1263 10 2 2019 10feb2019 2019w6 2019m2 2019q1 |
|---------------------------------------------------------------------------|
6. | 1258 17 3 2019 17mar2019 2019w11 2019m3 2019q1 |
7. | 1226 13 1 2019 13jan2019 2019w2 2019m1 2019q1 |
8. | 1210 3 3 2019 03mar2019 2019w9 2019m3 2019q1 |
9. | 1203 17 2 2019 17feb2019 2019w7 2019m2 2019q1 |
10. | 1203 24 2 2019 24feb2019 2019w8 2019m2 2019q1 |
|---------------------------------------------------------------------------|
11. | 1186 24 3 2019 24mar2019 2019w12 2019m3 2019q1 |
12. | 1120 21 4 2019 21apr2019 2019w16 2019m4 2019q2 |
13. | 1107 7 4 2019 07apr2019 2019w14 2019m4 2019q2 |
14. | 1071 14 4 2019 14apr2019 2019w15 2019m4 2019q2 |
15. | 1051 12 5 2019 12may2019 2019w19 2019m5 2019q2 |
|---------------------------------------------------------------------------|
16. | 1049 6 1 2019 06jan2019 2019w1 2019m1 2019q1 |
17. | 1037 28 4 2019 28apr2019 2019w17 2019m4 2019q2 |
18. | 1016 10 3 2019 10mar2019 2019w10 2019m3 2019q1 |
19. | 922 31 3 2019 31mar2019 2019w13 2019m3 2019q1 |
20. | 910 5 5 2019 05may2019 2019w18 2019m5 2019q2 |
|---------------------------------------------------------------------------|
21. | 708 30 12 2018 30dec2018 2018w52 2018m12 2018q4 |
+---------------------------------------------------------------------------+
BTC paid:. list btcpaid day month2 year date week2 month quarter, abb(30)
+-------------------------------------------------------------------------+
| btcpaid day month2 year date week2 month quarter |
|-------------------------------------------------------------------------|
1. | .06284 27 1 2019 27jan2019 2019w4 2019m1 2019q1 |
2. | .06225 10 2 2019 10feb2019 2019w6 2019m2 2019q1 |
3. | .06126 3 2 2019 03feb2019 2019w5 2019m2 2019q1 |
4. | .06036 19 5 2019 19may2019 2019w20 2019m5 2019q2 |
5. | .060075 20 1 2019 20jan2019 2019w3 2019m1 2019q1 |
|-------------------------------------------------------------------------|
6. | .05849 17 2 2019 17feb2019 2019w7 2019m2 2019q1 |
7. | .058315 24 2 2019 24feb2019 2019w8 2019m2 2019q1 |
8. | .057785 17 3 2019 17mar2019 2019w11 2019m3 2019q1 |
9. | .05641 13 1 2019 13jan2019 2019w2 2019m1 2019q1 |
10. | .056165 3 3 2019 03mar2019 2019w9 2019m3 2019q1 |
|-------------------------------------------------------------------------|
11. | .05558 21 4 2019 21apr2019 2019w16 2019m4 2019q2 |
12. | .05373 24 3 2019 24mar2019 2019w12 2019m3 2019q1 |
13. | .052805 7 4 2019 07apr2019 2019w14 2019m4 2019q2 |
14. | .05278 14 4 2019 14apr2019 2019w15 2019m4 2019q2 |
15. | .05085 12 5 2019 12may2019 2019w19 2019m5 2019q2 |
|-------------------------------------------------------------------------|
16. | .05084 10 3 2019 10mar2019 2019w10 2019m3 2019q1 |
17. | .049555 28 4 2019 28apr2019 2019w17 2019m4 2019q2 |
18. | .04953 6 1 2019 06jan2019 2019w1 2019m1 2019q1 |
19. | .045645 5 5 2019 05may2019 2019w18 2019m5 2019q2 |
20. | .04392 31 3 2019 31mar2019 2019w13 2019m3 2019q1 |
|-------------------------------------------------------------------------|
21. | .03082 30 12 2018 30dec2018 2018w52 2018m12 2018q4 |
+-------------------------------------------------------------------------+