Help me choose a utility algorithm

Question

Algorithms

We need to come up with a utility algorithm. That is:
The greater the number of ratings (count) and the average rating (avg), the more useful the user.

Considering only avg is somehow not suitable. It turns out that the person who was voted for less times will be more useful than the person who was voted for more.
Considering only the sum of the ratings is also stupid. A person who has a lot of bad ratings can go to the top.

Answer 1

There is a very good article on this topic.

Answer 2

K=(count+avg)/(sum+avg+1)
the less, the more useful.

---

In this formula: sum is the sum of marks (points)
(As I understood in the table-screen, the sum of AVERAGE values: sum=avg*count)
Example:
sum=1+2+3=6
count=3
avg=sum/count= 6/3=2
(count+avg)/(sum+avg+1)=(3+2)/(6+2+1)=5/9=0.56
and
sum=1+1+1+1+1 +2=7
count=6
avg=sum/count=7/6=1.167
(count+avg)/(sum+avg+1)=(6+1.167)/(7+1.167+1)=7.167/9.167= 0.782
i.e. It turns out that the 1st option is more useful.

---

PS: I didn’t test deeply, I wrote “offhand”

Answer 3

(As I understand in the screenshot table, the sum of AVERAGE values: sum=avg*count)

sum is the arithmetic mean.
Thanks, I'll try your solution

Answer 4

www.evanmiller.org/how-not-to-sort-by-average-rating.html