BitVest campaign observations (since 30/12/2018 to 08/7/2019)
28 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 1195 .0712025 30 12 2018 30dec2018 2018w52 2018m12 2018q4 |
2. | 2 2 1544 .09399 6 1 2019 06jan2019 2019w1 2019m1 2019q1 |
3. | 3 3 1666 .09738 13 1 2019 13jan2019 2019w2 2019m1 2019q1 |
4. | 4 4 1513 .09014 20 1 2019 20jan2019 2019w3 2019m1 2019q1 |
5. | 5 5 1523 .092315 27 1 2019 27jan2019 2019w4 2019m1 2019q1 |
|--------------------------------------------------------------------------------------------------|
6. | 6 6 1500 .090766 3 2 2019 03feb2019 2019w5 2019m2 2019q1 |
7. | 7 7 1455 .088646 10 2 2019 10feb2019 2019w6 2019m2 2019q1 |
8. | 8 8 1418 .085241 17 2 2019 17feb2019 2019w7 2019m2 2019q1 |
9. | 9 9 1435 .087748 24 2 2019 24feb2019 2019w8 2019m2 2019q1 |
10. | 10 10 1322 .08303 3 3 2019 03mar2019 2019w9 2019m3 2019q1 |
|--------------------------------------------------------------------------------------------------|
11. | 11 11 1116 .08944 10 3 2019 10mar2019 2019w10 2019m3 2019q1 |
12. | 12 12 1663 .093939 17 3 2019 17mar2019 2019w11 2019m3 2019q1 |
13. | 13 13 1523 .093524 24 3 2019 24mar2019 2019w12 2019m3 2019q1 |
14. | 14 14 1408 .086465 31 3 2019 31mar2019 2019w13 2019m3 2019q1 |
15. | 15 15 1510 .091433 7 4 2019 07apr2019 2019w14 2019m4 2019q2 |
|--------------------------------------------------------------------------------------------------|
16. | 16 16 1391 .087986 14 4 2019 14apr2019 2019w15 2019m4 2019q2 |
17. | 17 17 1450 .086992 21 4 2019 21apr2019 2019w16 2019m4 2019q2 |
18. | 18 18 1492 .090028 28 4 2019 28apr2019 2019w17 2019m4 2019q2 |
19. | 19 19 1291 .0775045 5 5 2019 05may2019 2019w18 2019m5 2019q2 |
20. | 20 20 1447 .084589 12 5 2019 12may2019 2019w19 2019m5 2019q2 |
|--------------------------------------------------------------------------------------------------|
21. | 21 21 1551 .091493 19 5 2019 19may2019 2019w20 2019m5 2019q2 |
22. | 22 22 1560 .094425 26 5 2019 26may2019 2019w21 2019m5 2019q2 |
23. | 23 23 1659 .0887885 2 6 2019 02jun2019 2019w22 2019m6 2019q2 |
24. | 24 24 1650 .089767 9 6 2019 09jun2019 2019w23 2019m6 2019q2 |
25. | 25 25 1618 .0916645 16 6 2019 16jun2019 2019w24 2019m6 2019q2 |
|--------------------------------------------------------------------------------------------------|
26. | 26 26 1738 .0968755 23 6 2019 23jun2019 2019w25 2019m6 2019q2 |
27. | 27 27 1866 .105072 30 6 2019 30jun2019 2019w26 2019m6 2019q2 |
28. | 28 28 1802 .0937155 7 7 2019 07jul2019 2019w27 2019m7 2019q3 |
+--------------------------------------------------------------------------------------------------+
Time series plots: Statistics:- Postcount: 50% of observed weeks have total postcounts above 1512, whilst 50% of rest weeks have total postcounts below 1512, the median (p50). The mean and standard deviation are 1511 and 168, respectively. Min and max are 1116 and 1866, respectively. 50% of total weekly postcounts range from 1426 to 1634 (the interquartile range from p25 to p75).
- BTC paid: 50% of observed weeks have total BTC paid above 0.09, whilst 50% of rest weeks have total BTC paid below 0.09, the median (p50). The mean and standard deviation are 0.0898 and 0.0063 respectively. Min and max are 0.0712 and 0.1051, respectively. 50% of total weekly BTC-paid range from 0.087 to 0.0936 (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 | 28 1510.929 167.5855 1511.5 1426.5 1634 1116 1866
btcpaid | 28 .0897914 .0062724 .090084 .08737 .0936198 .0712025 .105072
----------------------------------------------------------------------------------------------
List of weeks in descending orders of total postcounts or total BTC paid
Postcount:. list postcount week day month2 year date week2 month quarter, abb(30)
+----------------------------------------------------------------------------------+
| postcount week day month2 year date week2 month quarter |
|----------------------------------------------------------------------------------|
1. | 1866 27 30 6 2019 30jun2019 2019w26 2019m6 2019q2 |
2. | 1802 28 7 7 2019 07jul2019 2019w27 2019m7 2019q3 |
3. | 1738 26 23 6 2019 23jun2019 2019w25 2019m6 2019q2 |
4. | 1666 3 13 1 2019 13jan2019 2019w2 2019m1 2019q1 |
5. | 1663 12 17 3 2019 17mar2019 2019w11 2019m3 2019q1 |
|----------------------------------------------------------------------------------|
6. | 1659 23 2 6 2019 02jun2019 2019w22 2019m6 2019q2 |
7. | 1650 24 9 6 2019 09jun2019 2019w23 2019m6 2019q2 |
8. | 1618 25 16 6 2019 16jun2019 2019w24 2019m6 2019q2 |
9. | 1560 22 26 5 2019 26may2019 2019w21 2019m5 2019q2 |
10. | 1551 21 19 5 2019 19may2019 2019w20 2019m5 2019q2 |
|----------------------------------------------------------------------------------|
11. | 1544 2 6 1 2019 06jan2019 2019w1 2019m1 2019q1 |
12. | 1523 13 24 3 2019 24mar2019 2019w12 2019m3 2019q1 |
13. | 1523 5 27 1 2019 27jan2019 2019w4 2019m1 2019q1 |
14. | 1513 4 20 1 2019 20jan2019 2019w3 2019m1 2019q1 |
15. | 1510 15 7 4 2019 07apr2019 2019w14 2019m4 2019q2 |
|----------------------------------------------------------------------------------|
16. | 1500 6 3 2 2019 03feb2019 2019w5 2019m2 2019q1 |
17. | 1492 18 28 4 2019 28apr2019 2019w17 2019m4 2019q2 |
18. | 1455 7 10 2 2019 10feb2019 2019w6 2019m2 2019q1 |
19. | 1450 17 21 4 2019 21apr2019 2019w16 2019m4 2019q2 |
20. | 1447 20 12 5 2019 12may2019 2019w19 2019m5 2019q2 |
|----------------------------------------------------------------------------------|
21. | 1435 9 24 2 2019 24feb2019 2019w8 2019m2 2019q1 |
22. | 1418 8 17 2 2019 17feb2019 2019w7 2019m2 2019q1 |
23. | 1408 14 31 3 2019 31mar2019 2019w13 2019m3 2019q1 |
24. | 1391 16 14 4 2019 14apr2019 2019w15 2019m4 2019q2 |
25. | 1322 10 3 3 2019 03mar2019 2019w9 2019m3 2019q1 |
|----------------------------------------------------------------------------------|
26. | 1291 19 5 5 2019 05may2019 2019w18 2019m5 2019q2 |
27. | 1195 1 30 12 2018 30dec2018 2018w52 2018m12 2018q4 |
28. | 1116 11 10 3 2019 10mar2019 2019w10 2019m3 2019q1 |
+----------------------------------------------------------------------------------+
BTC paid:. list btcpaid week day month2 year date week2 month quarter, abb(30)
+---------------------------------------------------------------------------------+
| btcpaid week day month2 year date week2 month quarter |
|---------------------------------------------------------------------------------|
1. | .105072 27 30 6 2019 30jun2019 2019w26 2019m6 2019q2 |
2. | .09738 3 13 1 2019 13jan2019 2019w2 2019m1 2019q1 |
3. | .0968755 26 23 6 2019 23jun2019 2019w25 2019m6 2019q2 |
4. | .094425 22 26 5 2019 26may2019 2019w21 2019m5 2019q2 |
5. | .09399 2 6 1 2019 06jan2019 2019w1 2019m1 2019q1 |
|---------------------------------------------------------------------------------|
6. | .093939 12 17 3 2019 17mar2019 2019w11 2019m3 2019q1 |
7. | .0937155 28 7 7 2019 07jul2019 2019w27 2019m7 2019q3 |
8. | .093524 13 24 3 2019 24mar2019 2019w12 2019m3 2019q1 |
9. | .092315 5 27 1 2019 27jan2019 2019w4 2019m1 2019q1 |
10. | .0916645 25 16 6 2019 16jun2019 2019w24 2019m6 2019q2 |
|---------------------------------------------------------------------------------|
11. | .091493 21 19 5 2019 19may2019 2019w20 2019m5 2019q2 |
12. | .091433 15 7 4 2019 07apr2019 2019w14 2019m4 2019q2 |
13. | .090766 6 3 2 2019 03feb2019 2019w5 2019m2 2019q1 |
14. | .09014 4 20 1 2019 20jan2019 2019w3 2019m1 2019q1 |
15. | .090028 18 28 4 2019 28apr2019 2019w17 2019m4 2019q2 |
|---------------------------------------------------------------------------------|
16. | .089767 24 9 6 2019 09jun2019 2019w23 2019m6 2019q2 |
17. | .08944 11 10 3 2019 10mar2019 2019w10 2019m3 2019q1 |
18. | .0887885 23 2 6 2019 02jun2019 2019w22 2019m6 2019q2 |
19. | .088646 7 10 2 2019 10feb2019 2019w6 2019m2 2019q1 |
20. | .087986 16 14 4 2019 14apr2019 2019w15 2019m4 2019q2 |
|---------------------------------------------------------------------------------|
21. | .087748 9 24 2 2019 24feb2019 2019w8 2019m2 2019q1 |
22. | .086992 17 21 4 2019 21apr2019 2019w16 2019m4 2019q2 |
23. | .086465 14 31 3 2019 31mar2019 2019w13 2019m3 2019q1 |
24. | .085241 8 17 2 2019 17feb2019 2019w7 2019m2 2019q1 |
25. | .084589 20 12 5 2019 12may2019 2019w19 2019m5 2019q2 |
|---------------------------------------------------------------------------------|
26. | .08303 10 3 3 2019 03mar2019 2019w9 2019m3 2019q1 |
27. | .0775045 19 5 5 2019 05may2019 2019w18 2019m5 2019q2 |
28. | .0712025 1 30 12 2018 30dec2018 2018w52 2018m12 2018q4 |
+---------------------------------------------------------------------------------+