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 930, 853, and 813, respectively; whilst the lowest days are Saturday, Friday, and Sunday, at 695, 705, and 752, 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 | 99.0 751.9 455.9 625.0 517.0 797.0 394.0 3190.0
   Monday | 99.0 812.7 521.6 685.0 574.0 865.0 313.0 3854.0
  Tuesday | 98.0 764.1 462.5 659.5 592.0 761.0 384.0 4193.0
Wednesday | 99.0 929.3 1360.4 667.0 563.0 788.0 394.0 13018.0
Thursday | 99.0 853.8 846.7 674.0 550.0 811.0 348.0 6762.0
   Friday | 99.0 704.8 500.2 596.0 508.0 713.0 349.0 4500.0
Saturday | 99.0 694.6 404.2 614.0 486.0 724.0 295.0 3490.0
----------+--------------------------------------------------------------------------------
   Total | 692.0 787.3 725.9 642.5 538.5 778.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 685 812.7475 574 865 313 3854 |
  2. | 2 Thursday 674 853.7778 550 811 348 6762 |
  3. | 3 Wednesday 667 929.2525 563 788 394 13018 |
  4. | 4 Tuesday 659.5 764.051 592 761 384 4193 |
  5. | 5 Sunday 625 751.8687 517 797 394 3190 |
   |----------------------------------------------------------------------|
  6. | 6 Saturday 614 694.5555 486 724 295 3490 |
  7. | 7 Friday 596 704.7778 508 713 349 4500 |
   +----------------------------------------------------------------------+

In means

Code:

+--------------------------------------------------------------------+
   | rankmean dofw mean median p25 p75 min max |
   |--------------------------------------------------------------------|
  1. | 1 Wednesday 929.2525 667 563 788 394 13018 |
  2. | 2 Thursday 853.7778 674 550 811 348 6762 |
  3. | 3 Monday 812.7475 685 574 865 313 3854 |
  4. | 4 Tuesday 764.051 659.5 592 761 384 4193 |
  5. | 5 Sunday 751.8687 625 517 797 394 3190 |
   |--------------------------------------------------------------------|
  6. | 6 Friday 704.7778 596 508 713 349 4500 |
  7. | 7 Saturday 694.5555 614 486 724 295 3490 |
   +--------------------------------------------------------------------+