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:

Green: highest.
Red: Lowest.

- In median, the highest days are Monday, Thursday, and Wednesday at 685, 674, and 667, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 596, 614, and 625, respectively.
- In means, the highest days are Wednesday, Thursday, and Monday at 932, 858, and 814, respectively; whilst the lowest days are Saturday, Friday, and Sunday, at 693, 709, and 753, respectively.

Calendar day is in GMT time.

Quote from: LoyceV on January 04, 2019, 04:10:19 PM

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 | 97.0 752.7 460.0 625.0 517.0 789.0 394.0 3190.0
   Monday | 97.0 813.5 526.5 685.0 574.0 825.0 313.0 3854.0
  Tuesday | 97.0 765.6 464.7 660.0 592.0 761.0 384.0 4193.0
Wednesday | 98.0 931.4 1367.2 666.5 563.0 788.0 394.0 13018.0
Thursday | 97.0 857.1 855.0 674.0 550.0 805.0 348.0 6762.0
   Friday | 97.0 708.6 504.6 596.0 510.0 713.0 349.0 4500.0
Saturday | 97.0 692.8 406.8 614.0 486.0 717.0 295.0 3490.0
----------+--------------------------------------------------------------------------------
   Total | 680.0 789.0 731.9 643.5 538.0 777.5 295.0 13018.0
-------------------------------------------------------------------------------------------

Box plots
Outliers displayed as red circles.

Outliers non-displayed.

Details on ranks:
In medians

Code:

+----------------------------------------------------------------------+
   | rankmedian dofw median mean p25 p75 min max |
   |----------------------------------------------------------------------|
  1. | 1 Monday 685 813.5051 574 825 313 3854 |
  2. | 2 Thursday 674 857.0516 550 805 348 6762 |
  3. | 3 Wednesday 666.5 931.449 563 788 394 13018 |
  4. | 4 Tuesday 660 765.6288 592 761 384 4193 |
  5. | 5 Sunday 625 752.6701 517 789 394 3190 |
   |----------------------------------------------------------------------|
  6. | 6 Saturday 614 692.8453 486 717 295 3490 |
  7. | 7 Friday 596 708.6495 510 713 349 4500 |
   +----------------------------------------------------------------------+

In means

Code:

+--------------------------------------------------------------------+
   | rankmean dofw mean median p25 p75 min max |
   |--------------------------------------------------------------------|
  1. | 1 Wednesday 931.449 666.5 563 788 394 13018 |
  2. | 2 Thursday 857.0516 674 550 805 348 6762 |
  3. | 3 Monday 813.5051 685 574 825 313 3854 |
  4. | 4 Tuesday 765.6288 660 592 761 384 4193 |
  5. | 5 Sunday 752.6701 625 517 789 394 3190 |
   |--------------------------------------------------------------------|
  6. | 6 Friday 708.6495 596 510 713 349 4500 |
  7. | 7 Saturday 692.8453 614 486 717 295 3490 |
   +--------------------------------------------------------------------+