Post
Topic
Board Meta
Re: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly)
by
tranthidung
on 02/12/2019, 02:40:52 UTC
Medians and means of intra-day merits over days of weeks.
Colors:
  • Green: highest.
  • Red: Lowest.

- In median, the highest days are Monday, Wednesday, and Thursday at 679, 661, and 653, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 588, 599, and 619, respectively.
- In means, the highest days are Monday, Wednesday, and Thursday, at 764, 755, and 750, respectively; whilst the lowest days are Saturday, Friday, and Sunday, at 627, 632, and 690, respectively.
- Monday has still been the highest day in terms of median and mean of intra-day merits over weeks. The lowest days in terms of median and mean of intra-day merits are Friday and Saturday, respectively. There are some kinda effects from the Art contest and new sMerits re-allocations.

Calendar day is in GMT time.
To take away all doubt: the first Merit was this one:
Code:
1516831941 1 2818066.msg28853325 35 877396
Use EpochConverter to convert 1516831941 (Unix Time) to GMT: Wednesday 24 January 2018 22:12:21.

Basic statistics:
Code:
. tabstat merit, s(n mean sd p50 p25 p75 min max) format(%9.1f) by(dofw)

Summary for variables: merit
     by categories of: dofw

     dofw |         N      mean        sd       p50       p25       p75       min       max
----------+--------------------------------------------------------------------------------
   Sunday |      92.0     689.5     342.7     619.0     513.5     773.5     394.0    2753.0
   Monday |      93.0     763.3     411.5     679.0     571.0     802.0     313.0    3854.0
  Tuesday |      92.0     703.2     247.3     648.0     587.0     739.5     384.0    2182.0
Wednesday |      92.0     754.6     520.8     660.5     559.5     778.5     394.0    5275.0
 Thursday |      92.0     749.4     559.1     653.0     545.0     771.5     348.0    5412.0
   Friday |      92.0     631.2     234.5     587.5     504.0     691.0     349.0    1706.0
 Saturday |      92.0     626.8     217.3     598.5     480.5     691.0     295.0    1441.0
----------+--------------------------------------------------------------------------------
    Total |     645.0     702.7     386.2     629.0     532.0     759.0     295.0    5412.0
-------------------------------------------------------------------------------------------

Box plots
Outliers displayed as red circles.

Outliers non-displayed.