Re: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly)
Medians and means of intra-day merits over days of weeks.
Colors:
- In median, the highest days are Monday, Wednesday, and Thursday at 677, 655, and 652, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 587, 593, and 618, respectively.
- In means, the highest days are Monday, Wednesday, and Thursday, at 760, 705, and 699, respectively; whilst the lowest days are Friday, Saturday, and Sunday, at 620, 621, and 688, respectively.
- Monday has still been the highest day in terms of median and mean of intra-day merits over weeks, in contrast Friday is the lowest days in terms of median, and mean of intra-day merits over weeks.
Calendar day is in GMT time.
Basic statistics:
Box plots
Outliers displayed as red circles.
Outliers non-displayed.
Colors:
- Green: highest.
- Red: Lowest.
- In median, the highest days are Monday, Wednesday, and Thursday at 677, 655, and 652, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 587, 593, and 618, respectively.
- In means, the highest days are Monday, Wednesday, and Thursday, at 760, 705, and 699, respectively; whilst the lowest days are Friday, Saturday, and Sunday, at 620, 621, and 688, respectively.
- Monday has still been the highest day in terms of median and mean of intra-day merits over weeks, in contrast Friday is the lowest days in terms of median, and mean of intra-day merits over weeks.
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 | 91.0 687.5 344.1 618.0 512.0 770.0 394.0 2753.0
Monday | 92.0 759.3 412.0 677.0 568.5 799.5 313.0 3854.0
Tuesday | 91.0 687.0 193.1 642.0 586.0 737.0 384.0 1327.0
Wednesday | 91.0 704.9 211.5 655.0 559.0 769.0 394.0 1476.0
Thursday | 91.0 698.2 268.0 652.0 541.0 768.0 348.0 2510.0
Friday | 91.0 619.8 209.1 587.0 500.0 683.0 349.0 1706.0
Saturday | 91.0 621.0 211.3 593.0 478.0 690.0 295.0 1441.0
----------+--------------------------------------------------------------------------------
Total | 638.0 682.6 277.9 627.5 531.0 751.0 295.0 3854.0
-------------------------------------------------------------------------------------------
Summary for variables: merit
by categories of: dofw
dofw | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
Sunday | 91.0 687.5 344.1 618.0 512.0 770.0 394.0 2753.0
Monday | 92.0 759.3 412.0 677.0 568.5 799.5 313.0 3854.0
Tuesday | 91.0 687.0 193.1 642.0 586.0 737.0 384.0 1327.0
Wednesday | 91.0 704.9 211.5 655.0 559.0 769.0 394.0 1476.0
Thursday | 91.0 698.2 268.0 652.0 541.0 768.0 348.0 2510.0
Friday | 91.0 619.8 209.1 587.0 500.0 683.0 349.0 1706.0
Saturday | 91.0 621.0 211.3 593.0 478.0 690.0 295.0 1441.0
----------+--------------------------------------------------------------------------------
Total | 638.0 682.6 277.9 627.5 531.0 751.0 295.0 3854.0
-------------------------------------------------------------------------------------------
Box plots
Outliers displayed as red circles.
Outliers non-displayed.