BestMixer Overview (from 04/4/2019 to 16/5/2019)
7 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 1792 .576 4 4 2019 04apr2019 2019w14 2019m4 2019q2 |
2. | 2 2 1898 .6189 11 4 2019 11apr2019 2019w15 2019m4 2019q2 |
3. | 3 3 1846 .6084 18 4 2019 18apr2019 2019w16 2019m4 2019q2 |
4. | 4 4 1929 .6326 25 4 2019 25apr2019 2019w17 2019m4 2019q2 |
5. | 5 5 1959 .6446 2 5 2019 02may2019 2019w18 2019m5 2019q2 |
|------------------------------------------------------------------------------------------------|
6. | 6 6 2045 .6736 9 5 2019 09may2019 2019w19 2019m5 2019q2 |
7. | 7 7 1893 .623 16 5 2019 16may2019 2019w20 2019m5 2019q2 |
+------------------------------------------------------------------------------------------------+
Time series plots: Statistics:- Postcount: 50% of observed weeks have total postcounts above 1898, whilst 50% of rest weeks have total postcounts below 1898, the median (p50). The mean and standard deviation are 1909 and 81, respectively. Min and max are 1792 and 2045, respectively. 50% of total weeks have total postcounts in the range from 1846 and 1959 (the interquartile range that lasts from p25 to p75)
- BTC paid: 50% of observed weeks have total BTC paid above 0.623, whilst 50% of rest weeks have total BTC paid below 0.623, the median (p50). The mean and standard deviation are 0.6253 and 0.0303, respectively. Min and max are 0.576 and 0.6736, respectively. 50% of total weeks have total BTC paid in the range from 0.6084 and 0.6446 (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 | 7 1908.857 81.0667 1898 1846 1959 1792 2045
btcpaid | 7 .6253 .0303343 .623 .6084 .6446 .576 .6736
----------------------------------------------------------------------------------------------
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. | 6 6 2045 9 5 2019 09may2019 2019w19 2019m5 2019q2 |
2. | 5 5 1959 2 5 2019 02may2019 2019w18 2019m5 2019q2 |
3. | 4 4 1929 25 4 2019 25apr2019 2019w17 2019m4 2019q2 |
4. | 2 2 1898 11 4 2019 11apr2019 2019w15 2019m4 2019q2 |
5. | 7 7 1893 16 5 2019 16may2019 2019w20 2019m5 2019q2 |
|--------------------------------------------------------------------------------------|
6. | 3 3 1846 18 4 2019 18apr2019 2019w16 2019m4 2019q2 |
7. | 1 1 1792 4 4 2019 04apr2019 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. | 6 6 .6736 9 5 2019 09may2019 2019w19 2019m5 2019q2 |
2. | 5 5 .6446 2 5 2019 02may2019 2019w18 2019m5 2019q2 |
3. | 4 4 .6326 25 4 2019 25apr2019 2019w17 2019m4 2019q2 |
4. | 7 7 .623 16 5 2019 16may2019 2019w20 2019m5 2019q2 |
5. | 2 2 .6189 11 4 2019 11apr2019 2019w15 2019m4 2019q2 |
|------------------------------------------------------------------------------------|
6. | 3 3 .6084 18 4 2019 18apr2019 2019w16 2019m4 2019q2 |
7. | 1 1 .576 4 4 2019 04apr2019 2019w14 2019m4 2019q2 |
+------------------------------------------------------------------------------------+