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 679, 654, and 652, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 586, 591, and 609, respectively.
- In means, the highest days are Monday, Wednesday, and Tuesday, at 728, 696, and 685, respectively; whilst the lowest days are Friday, Saturday, and Sunday, at 610, 611, and 665, 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 679, 654, and 652, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 586, 591, and 609, respectively.
- In means, the highest days are Monday, Wednesday, and Tuesday, at 728, 696, and 685, respectively; whilst the lowest days are Friday, Saturday, and Sunday, at 610, 611, and 665, 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 | 88.0 664.6 269.9 608.5 508.5 749.5 394.0 2464.0
Monday | 89.0 727.5 255.5 679.0 566.0 797.0 313.0 1863.0
Tuesday | 88.0 684.4 195.5 639.5 583.5 733.0 384.0 1327.0
Wednesday | 88.0 695.9 197.5 654.0 558.5 761.0 394.0 1271.0
Thursday | 88.0 678.4 189.9 651.5 537.0 767.5 348.0 1335.0
Friday | 88.0 609.7 187.4 585.5 500.0 663.5 349.0 1706.0
Saturday | 88.0 610.9 195.2 590.5 476.0 685.5 295.0 1410.0
----------+--------------------------------------------------------------------------------
Total | 617.0 667.4 218.1 627.0 529.0 742.0 295.0 2464.0
-------------------------------------------------------------------------------------------
Summary for variables: merit
by categories of: dofw
dofw | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
Sunday | 88.0 664.6 269.9 608.5 508.5 749.5 394.0 2464.0
Monday | 89.0 727.5 255.5 679.0 566.0 797.0 313.0 1863.0
Tuesday | 88.0 684.4 195.5 639.5 583.5 733.0 384.0 1327.0
Wednesday | 88.0 695.9 197.5 654.0 558.5 761.0 394.0 1271.0
Thursday | 88.0 678.4 189.9 651.5 537.0 767.5 348.0 1335.0
Friday | 88.0 609.7 187.4 585.5 500.0 663.5 349.0 1706.0
Saturday | 88.0 610.9 195.2 590.5 476.0 685.5 295.0 1410.0
----------+--------------------------------------------------------------------------------
Total | 617.0 667.4 218.1 627.0 529.0 742.0 295.0 2464.0
-------------------------------------------------------------------------------------------
Box plots
Outliers displayed as red circles.
Outliers non-displayed.