Update for last week:Time series plotsIntra-day merits:(1) Full dataset(2) Truncated datasetQuick statistics:- 50% of observed days (393, some days truncated due to outliers) have intra-day merits ranges from 521 to 761 (the interquartile range, from p25 to p75).
- 50% of those days have intra-day merits above 623, and the rest 50% of days have intra-day merits below 523 (the median).
. tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f)
variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 393.0 678.1 247.5 623.0 521.0 761.0 312.0 2463.0
----------------------------------------------------------------------------------------------
Intra-week merits:Quick statistics:- 50% of 60 observed weeks have intra-week merits ranges from 3836 to 5397 (the interquartile range, from p25 to p75).
- 50% of observered weeks have intra-week merits above 4491, whilst the rest 50% of weeks have intra-week merits below 4491 (the median).
. tabstat merit, s(n mean sd p50 p25 p75 min max)
variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
merit | 60 5707.417 4279.576 4490.5 3836 5396.5 3065 30949
----------------------------------------------------------------------------------------------
ABSTRACT
Intra-day merits:
Notes:
- The part of the asbstract describes figures of intraday merits over the period from 19/2/2018 to 18/3/2019 (truncated dataset);
- Days from 24/1/2018 to 18/2/2018 truncated due to highly potential outliers; and days after 18/3/2019 truncated as well due to incomplete week (the 2019w12);
- Statistics presented in the post are for truncated dataset.
(1) Potential outliers are days that have intraday total merits beyond 161 or 1121;
(2) Median of intraday merits over the period is 623;
(3) 50% of observed days have their intra-day merits range from 521 to 761 (the interquartile range);
(4) Friday [in GTM time] is the day over weeks has lowest intraday merits in terms of both median and mean, at 561, and 613, respectively.
(5) There are 25 potential outliers in total, and there is only two potential outlier days happened in early weeks of 2019, on 09 Jan. 2019 and 14 Jan. 2019, at 1161, and 1127, respectively.
(6) Minimum and maximum of intraday merits (full dataset) are 312 and 13018, on 11/2/2019 and 24/1/2018 respectively.
Intra-week merits:
Notes:
The part of the abstract use full dataset, only dropped last two days due to incomple week (2019w10).
(1) The median of intra-week merits is 4491;
(2) 50% of observed weeks (59 weeeks in total), have total merits in the range from 3836 to 5397 (the interquaritle range of intra-week merits);
(3) Minimum and maximum of intraweek merits are 3065 and 30949, in 2018w35, and 2018w4, respectively;
(4) Seven potential outliers [beyond 1496 or 7738], all of them occurred in the year 2018.