Livecoin Overview (from 02/4/2019 to 04/6/2019)
10 weeks in total so far
Converted dataset from the spreadsheet:. list, abb(30)
+------------------------------------------------------------------------------------------------+
| id week postcount btcpaid day month2 year date week2 month quarter |
|------------------------------------------------------------------------------------------------|
1. | 1 1 748 .2792 2 4 2019 02apr2019 2019w14 2019m4 2019q2 |
2. | 2 2 878 .329 9 4 2019 09apr2019 2019w15 2019m4 2019q2 |
3. | 3 3 863 .3224 16 4 2019 16apr2019 2019w16 2019m4 2019q2 |
4. | 4 4 875 .3274 23 4 2019 23apr2019 2019w17 2019m4 2019q2 |
5. | 5 5 820 .3068 30 4 2019 30apr2019 2019w18 2019m4 2019q2 |
|------------------------------------------------------------------------------------------------|
6. | 6 6 964 .3599 7 5 2019 07may2019 2019w19 2019m5 2019q2 |
7. | 7 7 1211 .3928 14 5 2019 14may2019 2019w20 2019m5 2019q2 |
8. | 8 8 1072 .3435 21 5 2019 21may2019 2019w21 2019m5 2019q2 |
9. | 9 9 1134 .3659 28 5 2019 28may2019 2019w22 2019m5 2019q2 |
10. | 10 10 1105 .3598 4 6 2019 04jun2019 2019w23 2019m6 2019q2 |
+------------------------------------------------------------------------------------------------+
Time series plots: Statistics:- Postcount: 50% of observed weeks have total postcounts above 921, whilst 50% of rest weeks have total postcounts below 921, the median (p50). The mean and standard deviation are 928.9 and 149.2, respectively. Min and max are 748 and 1211, respectively. 50% of total weeks have total postcounts in the range from 863 and 1105 (the interquartile range that lasts from p25 to p75)
- BTC paid: 50% of observed weeks have total BTC paid above 0.3363, whilst 50% of rest weeks have total BTC paid below 0.3363, the median (p50). The mean and standard deviation are 0.3387 and 0.0327, respectively. Min and max are 0.2792 and 0.3928, respectively. 50% of total weeks have total BTC paid in the range from 0.3224 and 0.3599 (the interquartile range that lasts 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 | 10 967 154.2991 921 863 1105 748 1211
btcpaid | 10 .33867 .0327103 .33625 .3224 .3599 .2792 .3928
----------------------------------------------------------------------------------------------
Top highest weeks in:Postcount. list id week postcount day month2 year date week2 month quarter, abb(30)
+--------------------------------------------------------------------------------------+
| id week postcount day month2 year date week2 month quarter |
|--------------------------------------------------------------------------------------|
1. | 7 7 1211 14 5 2019 14may2019 2019w20 2019m5 2019q2 |
2. | 9 9 1134 28 5 2019 28may2019 2019w22 2019m5 2019q2 |
3. | 10 10 1105 4 6 2019 04jun2019 2019w23 2019m6 2019q2 |
4. | 8 8 1072 21 5 2019 21may2019 2019w21 2019m5 2019q2 |
5. | 6 6 964 7 5 2019 07may2019 2019w19 2019m5 2019q2 |
|--------------------------------------------------------------------------------------|
6. | 2 2 878 9 4 2019 09apr2019 2019w15 2019m4 2019q2 |
7. | 4 4 875 23 4 2019 23apr2019 2019w17 2019m4 2019q2 |
8. | 3 3 863 16 4 2019 16apr2019 2019w16 2019m4 2019q2 |
9. | 5 5 820 30 4 2019 30apr2019 2019w18 2019m4 2019q2 |
10. | 1 1 748 2 4 2019 02apr2019 2019w14 2019m4 2019q2 |
+--------------------------------------------------------------------------------------+
BTC paid. list id week btcpaid day month2 year date week2 month quarter, abb(30)
+------------------------------------------------------------------------------------+
| id week btcpaid day month2 year date week2 month quarter |
|------------------------------------------------------------------------------------|
1. | 7 7 .3928 14 5 2019 14may2019 2019w20 2019m5 2019q2 |
2. | 6 6 .3599 7 5 2019 07may2019 2019w19 2019m5 2019q2 |
3. | 8 8 .3435 21 5 2019 21may2019 2019w21 2019m5 2019q2 |
4. | 2 2 .329 9 4 2019 09apr2019 2019w15 2019m4 2019q2 |
5. | 4 4 .3274 23 4 2019 23apr2019 2019w17 2019m4 2019q2 |
|------------------------------------------------------------------------------------|
6. | 3 3 .3224 16 4 2019 16apr2019 2019w16 2019m4 2019q2 |
7. | 5 5 .3068 30 4 2019 30apr2019 2019w18 2019m4 2019q2 |
8. | 1 1 .2792 2 4 2019 02apr2019 2019w14 2019m4 2019q2 |
+------------------------------------------------------------------------------------+