Statistics Levels statistics - Research for monthly reports

EDIT @ 10/18/2016 - I have changed the name of this topic as it was first intended to be a simple report of stats for september 2016 from the website itself. Eventually it turns into a real statistic methodology dicussion because of the competences of members arround. That's great as it is now possible to rank levels according to several criteria importances and not only each of them separatly. I will publish some results/threads for the last couple of monthes (for history) before regular and monthly releases.
__________

At the end of August @vince started a thread about sorting levels on a specific date range. I really loved that! (Thanks Vince!). More than one month after I think it could be great to do that each month. Originally I have posted that on the previous thread but it is maybe more relevant and organised in a special thread.

As one post cannot have more than 10000 characters I am going to do that in several parts.

So Here are the stats for september (well... much more now), from the 09/01/2016 to the 10/06/2016 included (MM/DD/YYYY). You can click on the links of the titles for a direct access

____________________
20 most viewed

N°	Title	Author	Views	Rate	Likes	Comments	Date
1	Praying For Rain	nGord	1K	3	1	58	10/02/2016
2	Deserted Curse	meko	650	3	2	23	09/20/2016
3	Opening Doors	meko	604	7	4	22	09/12/2016
4	The Mountain	meko	590	3	4	21	09/09/2016
5	Limbo	richardfu_	587	10	4	14	09/02/2016
6	Begin Again	meko	564	3	2	20	09/05/2016
7	Headroom	ZachMan	562	0	1	0	09/08/2016
8	Transformers (re)	Gepeto	500	3	1	21	09/07/2016
9	Glyph Walk	richardfu_	496	11	3	19	09/16/2016
10	No way to Win	TR O	494	5	3	29	09/12/2016
11	Special Forces Vol I	S. Nagy	468	4	1	19	09/04/2016
12	Padlock Game v2	TR O	467	3	0	28	09/18/2016
13	OOOOOOO SCAAARYYYYY!!!!	Scare Crow	419	0	0	24	09/21/2016
14	Expedition IV	richardfu_	406	10	1	16	09/12/2016
15	STEPPING UP	Mike_CN	387	0	0	24	09/24/2016
16	Castle	KPACABA	371	0	1	11	09/11/2016
17	Choice	meko	357	7	2	19	10/03/2016
18	Mountain Depth	richardfu_	353	7	5	10	09/10/2016
19	Expedition III	richardfu_	353	9	3	9	09/06/2016
20	Cursed Tower	richardfu_	343	2	0	11	09/06/2016

 

20 most commented

N°	Title	Author	Views	Rate	Likes	Comments	Date
1	Praying For Rain	nGord	1K	3	1	58	10/02/2016
2	No way to Win	TR O	494	5	3	29	09/12/2016
3	Padlock Game v2	TR O	467	3	0	28	09/18/2016
4	STEPPING UP	Mike_CN	387	0	0	24	09/24/2016
5	OOOOOOO SCAAARYYYYY!!!!	Scare Crow	419	0	0	24	09/21/2016
6	Deserted Curse	meko	650	3	2	23	09/20/2016
7	Opening Doors	meko	604	7	4	22	09/12/2016
8	Swamp	Khudrat	223	5	0	21	10/05/2016
9	The Mountain	meko	590	3	4	21	09/09/2016
10	Transformers (re)	Gepeto	500	3	1	21	09/07/2016
11	Begin Again	meko	564	3	2	20	09/05/2016
12	Choice	meko	357	7	2	19	10/03/2016
13	Glyph Walk	richardfu_	496	11	3	19	09/16/2016
14	Special Forces Vol I	S. Nagy	468	4	1	19	09/04/2016
15	Super Mario Bros V3	sawdust	316	5	2	18	09/30/2016
16	Crouching Tiger	TR O	316	8	4	17	09/27/2016
17	Plan B	LooKing?	220	4	0	16	09/23/2016
18	Expedition IV	richardfu_	406	10	1	16	09/12/2016
19	Mini Outpost	richardfu_	337	13	1	15	10/03/2016
20	Flipped	sawdust	247	2	1	15	09/23/2016

 

20 most rated

N°	Title	Author	Views	Rate	Likes	Comments	Date
1	Mini Outpost	richardfu_	337	13	1	15	10/03/2016
2	Glyph Walk	richardfu_	496	11	3	19	09/16/2016
3	Path of Courage	richardfu_	328	10	2	13	09/30/2016
4	Expedition IV	richardfu_	406	10	1	16	09/12/2016
5	Limbo	richardfu_	587	10	4	14	09/02/2016
6	Dark Waters	richardfu_	238	9	3	10	10/02/2016
7	Expedition III	richardfu_	353	9	3	9	09/06/2016
8	Crouching Tiger	TR O	316	8	4	17	09/27/2016
9	Choice	meko	357	7	2	19	10/03/2016
10	Claw Machine Box	TR O	274	7	1	12	10/01/2016
11	Chateau Sawdust	sawdust	220	7	3	8	09/23/2016
12	Opening Doors	meko	604	7	4	22	09/12/2016
13	Mountain Depth	richardfu_	353	7	5	10	09/10/2016
14	Ship Picking	richardfu_	172	6	2	5	09/27/2016
15	Expedition V	richardfu_	273	6	2	7	09/22/2016
16	Fishing	richardfu_	254	6	3	7	09/18/2016
17	Swamp	Khudrat	223	5	0	21	10/05/2016
18	Jump pipe	Muslim Arizzy	154	5	1	11	10/02/2016
19	Super Mario Bros V3	sawdust	316	5	2	18	09/30/2016
20	Sudoku	MScript	161	5	2	10	09/28/2016

 

20 most liked

N°	Title	Author	Views	Rate	Likes	Comments	Date
1	Mountain Depth	richardfu_	353	7	5	10	09/10/2016
2	Ancient Temple	Lazarus	146	1	5	1	09/04/2016
3	Safebreaker2	cheinz	74	4	4	4	10/02/2016
4	Rails	MScript	116	3	4	5	09/29/2016
5	6 Piece Burr	sawdust	142	4	4	4	09/28/2016
6	Crouching Tiger	TR O	316	8	4	17	09/27/2016
7	Opening Doors	meko	604	7	4	22	09/12/2016
8	The Mountain	meko	590	3	4	21	09/09/2016
9	Limbo	richardfu_	587	10	4	14	09/02/2016
10	Dark Waters	richardfu_	238	9	3	10	10/02/2016
11	Electric Cute	LooKing?	137	3	3	6	09/30/2016
12	A lofty goal	Jose Luis Galiano	137	2	3	6	09/30/2016
13	Chateau Sawdust	sawdust	220	7	3	8	09/23/2016
14	Cae11	Chuckthulhu	192	5	3	9	09/19/2016
15	Fishing	richardfu_	254	6	3	7	09/18/2016
16	Glyph Walk	richardfu_	496	11	3	19	09/16/2016
17	Swivel	Muslim Arizzy	193	3	3	13	09/13/2016
18	Manage Your Time	Muslim Arizzy	79	2	3	1	09/12/2016
19	No way to Win	TR O	494	5	3	29	09/12/2016
20	Screenshot_2016-09-08-23-01-41-47	Muslim Arizzy	172	5	3	4	09/08/2016

 

That's interesting. Here is how I see things:

• the most commented = there's something to speak about
• the most viewed = there's something interesting to see
• the most rated = there's high quality content
• the most liked = there's something... to like

To me, "the most viewed" means something relevant where "the most commented" could be tendencious. But I agree that "the most rated levels" is more relevant than anything. On the other hand I've seen a default in the rated method: it doesn't take care of the ratings. So you could have 20 rates for a level with a rating of 3 Fortunately , for real, levels are rated when people prefer to add a positive rating. But the prefered way to consider ratings should be an equation with rates and ratings (if you've got an idea on that tell me )

Everything is based on the orders proposed by the website for each category. It could be better with an access to raw data (base) but it is not possible. Maybe I'll try to figure out the rating more than just the number of rates but that's less obvious to code as it needs to reorder everything with this new result not just from what the website tell us on that.

Otherwise, maybe someone could find an algorythm that I can use to melt all the data and build a chart of the 20 best levels of the month?

 

@vince From what I have understood you was parsing also the number of rates, not the rating number, isn't it?

There's a difference between them because the "ratings stars" (red frame on the picture above) is not the same than the rating notation (shown by the arrow) . Maybe (rates x ratings) = valuable notation? But then we could have (3 rates x 5 ratings = 15) < (10 rates x 2 ratings = 20) witch is bad...

I don't know how the views are counted as many time I came to a level without downloading and nothing changes in the views count (at least on the moment). The same when I download it. Maybe there's some delay.

Many people just come and download I think. They are not obliged to rate so, that's part of the deal Maybe some don't even speak english. My kid used to came to the website on my back but he doesn't read english (french is coming soon ), so no need for that. What we don't know is if a downloader needs to be registered to count as a view. Otherwise, to rate people needs to be registered. Maybe that's the point

 

Wow... I do love this conversation For now I am back to coding to get the whole data over a range of dates, but of course, everything is from "now" . So I do not take just the 20 of each categories given from the website, but I am grabbing all data in a range in order to do whatever I want with that (I'll check if I come to the same result than the website ). So @sawdust and @B Hill your advices are really precious. @B Hill I would not be surprised that you work in a Big Data company

I'll dig on math and stats and let you know. For now I try to end up something good with the data

 

I was reminded of Quartiles on Wikipedia @B Hill according to your sheets this method seems relevant. So I am digging on the subject to try to implement something in my code. I didn't get yet what decides the score you assigned to each quartile.