Today, I have spare time to play with given data from the last 16 rounds of Bitblender campaign, so here are some results from my playing time.
If Hhampuz does not like such post, I won't make it next weeks. If manager supports such weekly updates, I will keep doing this every week.
Best regards,
Tran Thi Dzung
Converted dataset from the spreadsheet:. list, abb(30)
+------------------------------------------------------------------------------------------------+
| id week postcount btcpaid day month2 year date week2 month quarter |
|------------------------------------------------------------------------------------------------|
1. | 1 1 990 .2357 28 1 2019 28jan2019 2019w4 2019m1 2019q1 |
2. | 2 2 1223 .2744 4 2 2019 04feb2019 2019w5 2019m2 2019q1 |
3. | 3 3 1095 .25375 11 2 2019 11feb2019 2019w6 2019m2 2019q1 |
4. | 4 4 1182 .2683 18 2 2019 18feb2019 2019w7 2019m2 2019q1 |
5. | 5 5 1218 .28605 25 2 2019 25feb2019 2019w8 2019m2 2019q1 |
|------------------------------------------------------------------------------------------------|
6. | 6 6 1079 .2529 4 3 2019 04mar2019 2019w9 2019m3 2019q1 |
7. | 7 7 1200 .2843 11 3 2019 11mar2019 2019w10 2019m3 2019q1 |
8. | 8 8 1260 .30185 18 3 2019 18mar2019 2019w11 2019m3 2019q1 |
9. | 9 9 1233 .2899 25 3 2019 25mar2019 2019w12 2019m3 2019q1 |
10. | 10 10 1258 .3021 1 4 2019 01apr2019 2019w13 2019m4 2019q2 |
|------------------------------------------------------------------------------------------------|
11. | 11 11 1279 .3036 8 4 2019 08apr2019 2019w14 2019m4 2019q2 |
12. | 12 12 1262 .3132 15 4 2019 15apr2019 2019w15 2019m4 2019q2 |
13. | 13 13 1169 .28915 22 4 2019 22apr2019 2019w16 2019m4 2019q2 |
14. | 14 14 1233 .30635 29 4 2019 29apr2019 2019w17 2019m4 2019q2 |
15. | 15 15 1174 .29095 6 5 2019 06may2019 2019w18 2019m5 2019q2 |
|------------------------------------------------------------------------------------------------|
16. | 16 16 1310 .32685 13 5 2019 13may2019 2019w19 2019m5 2019q2 |
+------------------------------------------------------------------------------------------------+
Statistics:- Postcount: 50% of observed weeks have total postcounts above 1221, whilst 50% of rest weeks have total postcounts below 1221, the median (p50). The mean and standard deviation are 1198 and 83.2, respectively. Min and max are 990 and 1310, respectively.
- BTC paid: 50% of observed weeks have total BTC paid above 0.289, whilst 50% of rest weeks have total BTC paid below 0.289, the median (p50). The mean and standard deviation are 0.286 and 0.024, respectively. Min and max aare 0.2357 and 0.3269, respectively.
. tabstat postcount btcpaid, s(n mean sd p50 p25 p75 min max) c(s)
variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
postcount | 16 1197.813 83.19873 1220.5 1171.5 1259 990 1310
btcpaid | 16 .2862094 .0242326 .289525 .27135 .30285 .2357 .32685
----------------------------------------------------------------------------------------------
Time series plots: The time series plots show that both weekly postcounts and BTC-paid have reached new all time high last week.