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 691, 676, and 670, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 596, 615, and 627, respectively.
- In means, the highest days are Wednesday, Thursday, and Monday at 927, 857, and 815, respectively; whilst the lowest days are Saturday, Friday, and Sunday, at 697, 708, and 756, 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:

Summary for variables: merit
   by categories of: dofw

   dofw | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
   Sunday | 101.0 755.4 452.0 627.0 523.0 805.0 394.0 3190.0
   Monday | 101.0 815.0 517.3 691.0 579.0 865.0 313.0 3854.0
  Tuesday | 101.0 766.0 455.8 663.0 597.0 777.0 384.0 4193.0
Wednesday | 101.0 927.0 1346.8 670.0 570.0 792.0 394.0 13018.0
Thursday | 101.0 856.1 838.4 676.0 554.0 813.0 348.0 6762.0
   Friday | 101.0 707.1 495.8 596.0 510.0 713.0 349.0 4500.0
Saturday | 101.0 696.1 400.4 615.0 508.0 724.0 295.0 3490.0
----------+--------------------------------------------------------------------------------
   Total | 707.0 789.0 718.5 645.0 542.0 787.0 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 691 815 579 865 313 3854 |
  2. | 2 Thursday 676 856.1485 554 813 348 6762 |
  3. | 3 Wednesday 670 927.0198 570 792 394 13018 |
  4. | 4 Tuesday 663 766.0495 597 777 384 4193 |
  5. | 5 Sunday 627 755.4357 523 805 394 3190 |
   |----------------------------------------------------------------------|
  6. | 6 Saturday 615 696.1485 508 724 295 3490 |
  7. | 7 Friday 596 707.1386 510 713 349 4500 |
   +----------------------------------------------------------------------+

In means

Code:

+--------------------------------------------------------------------+
   | rankmean dofw mean median p25 p75 min max |
   |--------------------------------------------------------------------|
  1. | 1 Wednesday 927.0198 670 570 792 394 13018 |
  2. | 2 Thursday 856.1485 676 554 813 348 6762 |
  3. | 3 Monday 815 691 579 865 313 3854 |
  4. | 4 Tuesday 766.0495 663 597 777 384 4193 |
  5. | 5 Sunday 755.4357 627 523 805 394 3190 |
   |--------------------------------------------------------------------|
  6. | 6 Friday 707.1386 596 510 713 349 4500 |
  7. | 7 Saturday 696.1485 615 508 724 295 3490 |
   +--------------------------------------------------------------------+