777 coin campaign observations (since 30/12/2018 to 28/7/2019)
31 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 |
22. | 22 22 1392 .063185 26 5 2019 26may2019 2019w21 2019m5 2019q2 |
23. | 23 23 1313 .058255 2 6 2019 02jun2019 2019w22 2019m6 2019q2 |
24. | 24 24 1362 .061228 9 6 2019 09jun2019 2019w23 2019m6 2019q2 |
25. | 25 25 1413 .06462 16 6 2019 16jun2019 2019w24 2019m6 2019q2 |
|-------------------------------------------------------------------------------------------------|
26. | 26 26 1557 .07048 23 6 2019 23jun2019 2019w25 2019m6 2019q2 |
27. | 27 27 1652 .072955 30 6 2019 30jun2019 2019w26 2019m6 2019q2 |
28. | 28 28 1418 .063805 7 7 2019 07jul2019 2019w27 2019m7 2019q3 |
29. | 29 29 1403 .06509 14 7 2019 14jul2019 2019w28 2019m7 2019q3 |
30. | 30 30 1323 .058745 21 7 2019 21jul2019 2019w29 2019m7 2019q3 |
|-------------------------------------------------------------------------------------------------|
31. | 31 31 1404 .06522 28 7 2019 28jul2019 2019w30 2019m7 2019q3 |
+-------------------------------------------------------------------------------------------------+
Time series plots: Statistics:- Postcount: 50% of observed weeks have total postcounts above 1258, whilst 50% of rest weeks have total postcounts below 1258, the median (p50). The mean and standard deviation are 1226 and 198 respectively. Min and max are 708 and 1652, respectively. 50% of total weekly postcounts range from 1071 to 1362 (the interquartile range from p25 to p75).
- BTC paid: 50% of observed weeks have total BTC paid above 0.0583, whilst 50% of rest weeks have total BTC paid below 0.0583, the median (p50). The mean and standard deviation are 0.572 and 0.0083, respectively. Min and max are 0.0308 and 0.073, respectively. 50% of total weekly BTC-paid range from 0.0528 and 0.0628 (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 | 31 1225.935 197.9463 1258 1071 1362 708 1652
btcpaid | 31 .0572125 .008286 .058315 .05278 .06284 .03082 .072955
----------------------------------------------------------------------------------------------
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. | 1652 27 30 6 2019 30jun2019 2019w26 2019m6 2019q2 |
2. | 1557 26 23 6 2019 23jun2019 2019w25 2019m6 2019q2 |
3. | 1418 28 7 7 2019 07jul2019 2019w27 2019m7 2019q3 |
4. | 1413 25 16 6 2019 16jun2019 2019w24 2019m6 2019q2 |
5. | 1404 31 28 7 2019 28jul2019 2019w30 2019m7 2019q3 |
|----------------------------------------------------------------------------------|
6. | 1403 29 14 7 2019 14jul2019 2019w28 2019m7 2019q3 |
7. | 1392 22 26 5 2019 26may2019 2019w21 2019m5 2019q2 |
8. | 1362 24 9 6 2019 09jun2019 2019w23 2019m6 2019q2 |
9. | 1348 5 27 1 2019 27jan2019 2019w4 2019m1 2019q1 |
10. | 1323 30 21 7 2019 21jul2019 2019w29 2019m7 2019q3 |
|----------------------------------------------------------------------------------|
11. | 1313 23 2 6 2019 02jun2019 2019w22 2019m6 2019q2 |
12. | 1310 21 19 5 2019 19may2019 2019w20 2019m5 2019q2 |
13. | 1303 4 20 1 2019 20jan2019 2019w3 2019m1 2019q1 |
14. | 1266 6 3 2 2019 03feb2019 2019w5 2019m2 2019q1 |
15. | 1263 7 10 2 2019 10feb2019 2019w6 2019m2 2019q1 |
|----------------------------------------------------------------------------------|
16. | 1258 12 17 3 2019 17mar2019 2019w11 2019m3 2019q1 |
17. | 1226 3 13 1 2019 13jan2019 2019w2 2019m1 2019q1 |
18. | 1210 10 3 3 2019 03mar2019 2019w9 2019m3 2019q1 |
19. | 1203 9 24 2 2019 24feb2019 2019w8 2019m2 2019q1 |
20. | 1203 8 17 2 2019 17feb2019 2019w7 2019m2 2019q1 |
|----------------------------------------------------------------------------------|
21. | 1186 13 24 3 2019 24mar2019 2019w12 2019m3 2019q1 |
22. | 1120 17 21 4 2019 21apr2019 2019w16 2019m4 2019q2 |
23. | 1107 15 7 4 2019 07apr2019 2019w14 2019m4 2019q2 |
24. | 1071 16 14 4 2019 14apr2019 2019w15 2019m4 2019q2 |
25. | 1051 20 12 5 2019 12may2019 2019w19 2019m5 2019q2 |
|----------------------------------------------------------------------------------|
26. | 1049 2 6 1 2019 06jan2019 2019w1 2019m1 2019q1 |
27. | 1037 18 28 4 2019 28apr2019 2019w17 2019m4 2019q2 |
28. | 1016 11 10 3 2019 10mar2019 2019w10 2019m3 2019q1 |
29. | 922 14 31 3 2019 31mar2019 2019w13 2019m3 2019q1 |
30. | 910 19 5 5 2019 05may2019 2019w18 2019m5 2019q2 |
|----------------------------------------------------------------------------------|
31. | 708 1 30 12 2018 30dec2018 2018w52 2018m12 2018q4 |
+----------------------------------------------------------------------------------+
BTC paid:. list btcpaid week day month2 year date week2 month quarter, abb(30)
+--------------------------------------------------------------------------------+
| btcpaid week day month2 year date week2 month quarter |
|--------------------------------------------------------------------------------|
1. | .072955 27 30 6 2019 30jun2019 2019w26 2019m6 2019q2 |
2. | .07048 26 23 6 2019 23jun2019 2019w25 2019m6 2019q2 |
3. | .06522 31 28 7 2019 28jul2019 2019w30 2019m7 2019q3 |
4. | .06509 29 14 7 2019 14jul2019 2019w28 2019m7 2019q3 |
5. | .06462 25 16 6 2019 16jun2019 2019w24 2019m6 2019q2 |
|--------------------------------------------------------------------------------|
6. | .063805 28 7 7 2019 07jul2019 2019w27 2019m7 2019q3 |
7. | .063185 22 26 5 2019 26may2019 2019w21 2019m5 2019q2 |
8. | .06284 5 27 1 2019 27jan2019 2019w4 2019m1 2019q1 |
9. | .06225 7 10 2 2019 10feb2019 2019w6 2019m2 2019q1 |
10. | .06126 6 3 2 2019 03feb2019 2019w5 2019m2 2019q1 |
|--------------------------------------------------------------------------------|
11. | .061228 24 9 6 2019 09jun2019 2019w23 2019m6 2019q2 |
12. | .06036 21 19 5 2019 19may2019 2019w20 2019m5 2019q2 |
13. | .060075 4 20 1 2019 20jan2019 2019w3 2019m1 2019q1 |
14. | .058745 30 21 7 2019 21jul2019 2019w29 2019m7 2019q3 |
15. | .05849 8 17 2 2019 17feb2019 2019w7 2019m2 2019q1 |
|--------------------------------------------------------------------------------|
16. | .058315 9 24 2 2019 24feb2019 2019w8 2019m2 2019q1 |
17. | .058255 23 2 6 2019 02jun2019 2019w22 2019m6 2019q2 |
18. | .057785 12 17 3 2019 17mar2019 2019w11 2019m3 2019q1 |
19. | .05641 3 13 1 2019 13jan2019 2019w2 2019m1 2019q1 |
20. | .056165 10 3 3 2019 03mar2019 2019w9 2019m3 2019q1 |
|--------------------------------------------------------------------------------|
21. | .05558 17 21 4 2019 21apr2019 2019w16 2019m4 2019q2 |
22. | .05373 13 24 3 2019 24mar2019 2019w12 2019m3 2019q1 |
23. | .052805 15 7 4 2019 07apr2019 2019w14 2019m4 2019q2 |
24. | .05278 16 14 4 2019 14apr2019 2019w15 2019m4 2019q2 |
25. | .05085 20 12 5 2019 12may2019 2019w19 2019m5 2019q2 |
|--------------------------------------------------------------------------------|
26. | .05084 11 10 3 2019 10mar2019 2019w10 2019m3 2019q1 |
27. | .049555 18 28 4 2019 28apr2019 2019w17 2019m4 2019q2 |
28. | .04953 2 6 1 2019 06jan2019 2019w1 2019m1 2019q1 |
29. | .045645 19 5 5 2019 05may2019 2019w18 2019m5 2019q2 |
30. | .04392 14 31 3 2019 31mar2019 2019w13 2019m3 2019q1 |
|--------------------------------------------------------------------------------|
31. | .03082 1 30 12 2018 30dec2018 2018w52 2018m12 2018q4 |
+--------------------------------------------------------------------------------+