🧵 Untitled Thread

Anonymous at Sat, 8 Jun 2024 02:19:43 UTC No. 16221095

i need help improving a "formula" i have for rating albums

take every song on the album and rate it on a scale of 0 - 3. 0 being awful and 3 being a masterpiece

after you collect the ratings, calculate the average, the median, and the standard deviation of all the ratings.

i also added in a cohesion score, meant to boost the scores of some albums who have a good overarcing theme or style with songs that fit well together but don't hold up well on their own in a vacuum. (cohesion score can either be .5 or a full 1)

the actual formula ends up being (average + median + cohesion) - standard deviation.


I will attach a photo of my spreadsheet with scores
please keep in mind the purpose of this is to calculate an albums merit based upon each song on its own in a vacuum. There are some albums I absolutely love that got a lower score than I thought they would, so don't judge me too harshly for the scores, it's just what the formula gave me based off how much I enjoyed the songs of each album.

any advice is appreciated, i am absolutely awful at math so this entire setup may be completely retarded