Help with finding an Average Rating Winner
I have a rating system set up on my website and I have a database that calculated for each item the average rating (out of 5 stars) and the total number of votes.
So say if a viewer picks 5/5 then their average is 5 out of 1 vote
However if I were to want to pick a top 3 for example why should an item with only 1 vote be at the top when somebody with 4 stars and 59 votes be placed below?
Is there a way to calculate a good "rating leader" using these two values?
or if not could you please provide me with another value that I could try and capture that may sort this out?
Cheers in advance!