I explain my situation.
I have 30 sheep producing milk and 10 different customers that assess drinking it. To determine which of sheep milk is the best I would like to figure out how to establish a ranking.
Each customer has voted for the milk of a sheep.
For example 6 customers for a sheep have voted "5" (1 to 5). 2 customers have voted for another sheep "5". 1 client to another sheep voted "5". The last customer has always voted "5" for yet another sheep.
Since all customers have the same moral influence on me I would like to understand how to give to the milk a value from 0 to 10 weighing more number of people.
The first sheep that received 6 votes may not be worth 10 (the maximum) as the other just because everyone voted the maximum (5).
It seems more logical that the sheep 1 is worth 10 (the max) and the second 2 (because only two people who voted "5"), the third sheep equal to 1 (as well as the fourth) and the other sheep that have had zero votes have 0 as a value.
I hope I was clear.
I am using excel.