Considering the results just subtracting would be too muchPatatitta wrote:
yeah but that only gives you the standard deviation, which isn't really a number from 0/10, I need to weight that into the averageCorne2Plum3 wrote:
https://support.google.com/docs/answer/3094054?hl=enPatatitta wrote:
How would you calculate that?, i'm not the best at mathKarmine wrote:
You could try average - standard deviation, may not work well if there aren't many votes thoughPatatitta wrote:
if you can suggest something sureeblf2013 wrote:
What about a scoring formula?Patatitta wrote:
after I posted the first form and saw people rating 10 as a joke, I decided to change it, median works better when there is trollingCorne2Plum3 wrote:
You should use the average instead of the median value for the leaderboard
The upside imo is that it reduces score for threads that are very divisive
average = left
deviation = right
SQRT(average*average-STDEV(...)) would work better, reduces the impact of stdev but keeps it significant for high values
Otherwise you can ask abraker, he's the expert for that kind of thing