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 693, 676, and 672, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 597, 618, and 627, respectively.
- In means, the highest days are Wednesday, Thursday, and Monday at 927, 856, and 816, respectively; whilst the lowest days are Saturday, Friday, and Sunday, at 697, 707, and 758, 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 | 102.0 757.2 450.1 627.0 523.0 830.0 394.0 3190.0
Monday | 102.0 815.6 514.7 693.0 579.0 879.0 313.0 3854.0
Tuesday | 102.0 767.2 453.7 669.0 597.0 779.0 384.0 4193.0
Wednesday | 102.0 926.2 1340.2 671.5 570.0 797.0 394.0 13018.0
Thursday | 102.0 855.9 834.3 676.0 554.0 828.0 348.0 6762.0
Friday | 102.0 706.6 493.4 597.0 510.0 713.0 349.0 4500.0
Saturday | 102.0 697.0 398.5 617.5 508.0 747.0 295.0 3490.0
----------+--------------------------------------------------------------------------------
Total | 714.0 789.4 715.0 647.0 543.0 788.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 693 815.6274 579 879 313 3854 |
2. | 2 Thursday 676 855.8726 554 828 348 6762 |
3. | 3 Wednesday 671.5 926.1569 570 797 394 13018 |
4. | 4 Tuesday 669 767.2353 597 779 384 4193 |
5. | 5 Sunday 627 757.1863 523 830 394 3190 |
|----------------------------------------------------------------------|
6. | 6 Saturday 617.5 696.9902 508 747 295 3490 |
7. | 7 Friday 597 706.5686 510 713 349 4500 |
+----------------------------------------------------------------------+

In means

Code:

+--------------------------------------------------------------------+
| rankmean dofw mean median p25 p75 min max |
|--------------------------------------------------------------------|
1. | 1 Wednesday 926.1569 671.5 570 797 394 13018 |
2. | 2 Thursday 855.8726 676 554 828 348 6762 |
3. | 3 Monday 815.6274 693 579 879 313 3854 |
4. | 4 Tuesday 767.2353 669 597 779 384 4193 |
5. | 5 Sunday 757.1863 627 523 830 394 3190 |
|--------------------------------------------------------------------|
6. | 6 Friday 706.5686 597 510 713 349 4500 |
7. | 7 Saturday 696.9902 617.5 508 747 295 3490 |
+--------------------------------------------------------------------+