"Top Rated Video" Sorting algorithm

[Siddarth Gaonkar]

hi, I am looking for a algorithm that will sort the videos by top-rated. One of the things to consider is that if the average rating for a video that is rated 200 times is 4.7 should be higher than a video that has an average rating of 5 which has been rated only once. Regards, Siddarth

Siddarth Gaonkar

[Henry Minute]

Question: How many additional times must the 5 voted video be voted 5 for before it is higher rated than the 4.7 video?

Henry Minute If you open a can of worms, any viable solution *MUST* involve a larger can.

[Siddarth Gaonkar]

that is the question i have. I can accept any algorithm that will have some logic around the idea that a video that has been rated high many times is higher than a video that is rated higher only by a few number of users. also, what is the effect of age of the video on this.

Siddarth Gaonkar

[Henry Minute]

Siddarth Gaonkar wrote:

I can accept any algorithm that will have some logic around the idea that a video that has been rated high many times is higher than a video that is rated higher only by a few number of users.

I think you need to get that part sorted out before you move on to the sorting part and I'm not sure that this is the right place to get the info you want. You might try googling 'Ranking System algorithms' or something like that. If you can find an answer out there, by all means come back here for the sorting part. You'll find lots of opinions on that.

Henry Minute If you open a can of worms, any viable solution *MUST* involve a larger can.

[Member 4501940]

To be honest, you have to lie! You could assume that every video has the same number of votes. The votes that are not 'real' would be neutral or average. If your scale is 1-5 and every video has the same number of votes then the video with the one vote at 5 also has 199 at 2.5. ((199*2.5)+(1*5))/200 video 2 needs 176 votes at 5 to equal video 2's rating better still assume all videos have 1000 votes (or whatever) - still works out the same video 1 with 200 votes at 4.7 (200*4.7+800*2.5)/1000=2.94 video 2 with 1 vote at 5 (1*5+999*2.5)/1000=2.503 video 2 with 176 votes at 5 (176*5+(1000-176)*2.5)/1000=2.94