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, 675, and 667, respectively; whislt the lowest days are Friday, Saturday, and Sunday at 596, 613, and 623, respectively.
- In means, the highest days are Wednesday, Thursday, and Monday at 932, 857, and 812, respectively; whilst the lowest days are Saturday, Friday, and Sunday, at 692, 708, and 751, 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 | 98.0 750.7 458.1 623.0 517.0 789.0 394.0 3190.0
Monday | 98.0 811.5 524.2 684.5 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 | 98.0 856.6 850.6 675.0 550.0 811.0 348.0 6762.0
Friday | 98.0 707.2 502.2 596.0 510.0 713.0 349.0 4500.0
Saturday | 98.0 691.3 405.0 613.0 486.0 717.0 295.0 3490.0
----------+--------------------------------------------------------------------------------
Total | 685.0 787.8 729.4 642.0 538.0 777.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 684.5 811.4694 574 825 313 3854 |
2. | 2 Thursday 675 856.6021 550 811 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 623 750.7041 517 789 394 3190 |
|----------------------------------------------------------------------|
6. | 6 Saturday 613 691.3062 486 717 295 3490 |
7. | 7 Friday 596 707.2041 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 856.6021 675 550 811 348 6762 |
3. | 3 Monday 811.4694 684.5 574 825 313 3854 |
4. | 4 Tuesday 765.6288 660 592 761 384 4193 |
5. | 5 Sunday 750.7041 623 517 789 394 3190 |
|--------------------------------------------------------------------|
6. | 6 Friday 707.2041 596 510 713 349 4500 |
7. | 7 Saturday 691.3062 613 486 717 295 3490 |
+--------------------------------------------------------------------+