do you want to do average * average - deviation or average * (average - deviation)?Karmine wrote:
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
The results are fairly nice the first way tho, will update later as I'm going to go have dinner
edit: updated