Forum Home Forum Home > Site News, Newbies, Help and Improvements > Help us improve the site
  New Posts New Posts RSS Feed - Ratings, my new method
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic ClosedRatings, my new method

 Post Reply Post Reply Page  123 6>
Author
Message
Fight Club View Drop Down
Prog Reviewer
Prog Reviewer


Joined: May 21 2006
Location: United States
Status: Offline
Points: 572
Direct Link To This Post Topic: Ratings, my new method
    Posted: December 17 2007 at 23:13

This was originally posted in the collaborator's discussion forum, Micky felt general members should have a say on this as well.


Okay I basically worked on this all day and came up with some good stuff.

I basically took the formula mentioned above:

- N = # of votes for an album
- M = Minimum votes required to enter top 100 (assume this is 50)
- A = Arithmetic mean of an album
- R = Average rating of all the albums on the site. (assume this is 3.5)
- O = Overall Rating

O = A * [N / (N + M)] + R * [M / (N+M)]
 
but I incorporated the collab/prog reviewer ratings into it better. I'll use Script for a Jester's Tear as an example:
 
As of now it has a total of 252 ratings, I counted 44 of those by Collaborators and Prog Reviewers. That makes 208 non-collab ratings. Suppose everyone's ratings had a weight of 1 while collabs/prog reviewers had a weight of 3. I think this is fair, as giving us a weight of 10 is just ridiculous. I'll leave this up to the admins to decide though.
 
So say each collab rating counted as 3. That would make virtually 132 ratings by collabs and reviewers. Now for the album.
 
61% of Script's ratings are 5 stars. So I took the number of ratings (N) multiplied by 0.61 and subtracted 23, as 23 of these 5 star ratings were by collabs. I then multiplied 23 by 3 (since each collab rating has a weight of 3) and added that to the previous answer. Multiply this by 5 (since it's 5 stars) and you come up with 998.6. Use this same method for the 4, 3, 2, and 1 stars. Add everything together, divide by the virtual number of ratings (which is 340 since the collabs have extra weight) and this comes out to a general average of 4.36
 
Now incorporate this into my formula A * [N / (N + M)] + R * [M / (N+M)]
and you come up with an Overall score of 4.25
 
I worked this out on a number of albums and came out with this list for an example:
 
Selling England          - 4.55
Thick as a brick           - 4.53
Wish You Were Here - 4.53
Foxtrot                           - 4.53
Dark Side                     - 4.51
Close to the Edge      - 4.49
In the Court of the       - 4.46
Animals                        - 4.36
Moving Pictures          - 4.36
Red                               - 4.35
Fragile                          - 4.34
Pawn Hearts               - 4.33
Nursery Cryme            - 4.33
Godbluff                        - 4.31
Hamburger Concerto - 4.30
In a Glass House       - 4.30
Si On Avait...                 - 4.28
Crime of the Century  - 4.27
Per Un Amico              - 4.26
Moonmadness           - 4.26
In the Land of Grey...  - 4.26
Depois De Fim           - 4.25
Script for a Jester       - 4.25
A Farewell to Kings   - 4.23
Hybris                           - 4.22
Hot Rats                      - 4.21
Storia Di...                    - 4.20
Birds of Fire                 - 4.20
Scenes froma Mem.. - 4.19
Elegant Gypsy             - 4.14
In Absentia                  - 4.13
Io Sono Nato               - 4.13
Quadrophenia            - 4.10
Uomo Di...                   - 4.06
 
I only did this with most of the high rankers in the top 100 and a few other experiments such as Scenes and In Absentia. So far I think this looks REALLY accurate, especially compared to the way it is now. Also, the ratings have the ability to fluctuate with this method and won't just stick in the same spot like they would have with the previous formula.
 
Of course some of this is inaccurate because I made up the minimum votes required to be in the top 100 and the arithmetic mean of the entire database. I feel 50 for a minimum number of required votes and a 3.5 mean seemed right. All these variables can be changed depending on what the collaborators feel is best.

By having the 3.5 thrown in there it's a little bit like Easy Livin's proposal, but not too radical. If we determine the average of every album on the site, we get an idea of what rating everything might come close to. This way it edges an album's overall rating toward that mean, but only just a little. This is mainly most effective for new albums and albums without a lot of ratings. It also helps balance the rating against biased votes (which is what we're trying to solve here right?) So, from what I can see we're lessening that problem, but also improving upon what we have already.

Another VERY positive thing I noticed is that new albums with only a few reviews will actually start out with lower ratings and climb as they grow more popular. Personally, I think this is a huge improvement over the previous system where albums would always start with a 5 and drop over time.

I think this is a great improvement on accuracy because now albums with only 5 reviews won't have a ridiculous rating. Say for example a new album only has 5 ratings. 2 of those are by collabs, 3 are not. 3 people rated it a 5 including one collab. 2 people gave it a 4, one of those also a collab. With this new method the album will only come to a rating of 3.66 instead of a weighted average of 4.55. Does this make more sense? What are your thoughts?
Back to Top
Fight Club View Drop Down
Prog Reviewer
Prog Reviewer


Joined: May 21 2006
Location: United States
Status: Offline
Points: 572
Direct Link To This Post Posted: December 17 2007 at 23:19
I also posted this:

Well here's what I'm working with right now, you visibly see all the sh*t I have going through it lol. This is King Crimson's Lizard at the moment.



For anyone who wishes to see how the formula works themselves, I uploaded the excel file here Anyone with Microsoft Excel should be able to open it.

I also made it so one can change the overall mean of all the albums (which right now is set to 3.5), and the weight of collaborator/prog reviewer ratings.



Edited by Fight Club - December 18 2007 at 12:42
Back to Top
Fight Club View Drop Down
Prog Reviewer
Prog Reviewer


Joined: May 21 2006
Location: United States
Status: Offline
Points: 572
Direct Link To This Post Posted: December 18 2007 at 02:01
I also posted this in response to someone who had some concerns about the treatment of more obscure albums and less popular genres.

I do agree with that there are tons of albums out there that are just too obscure or inaccessible to get the recognition they deserve. However, I do not feel this is as much of a concern when it comes to ratings. Anyone delving into the obscure will realize that these albums won't have as high of a rating, and that's understandable. Because the truth is, the opinions of 200 people is just more trustworthy than the opinions of 10. People who have been exploring prog for a while will understand this.

As I've told Micky earlier, the ratings serve their main purpose to those new to prog, and the new proggers will be more likely to get into the more popular stuff before the obscure stuff. The ratings should reflect this. If we get tons of zeuhl and RIO stuff with ratings a good deal higher than everything else, the newbies will be thinking "huh?". You understand what I'm getting at?

Also as far as the algorithm goes, the number of ratings is one of the factors incorporated into. A minimum number of ratings for an album to be in the top 100, which also reflects the overall rating of the album. I have that number set at 50 at the moment. Depending on what number we agree on, this can be changed. The way it works is, the further below this number the amount of ratings is, the lower the overall rating will be. So if this number was set to 25 instead of 50, the overall rating would increase.

The thing about this new method is, every album can be compared solely by its rating, and a list can be compiled this way. There is no extra algorithm needed to compile a top 100, as the new method makes it so everything can be sorted purely by its rating. One of the improvements of it, in my opinion.

EDIT: I thought about this a little more and there are a few things that can be done, concerning your worries.

First of all, we can have not just one rating, but two. Their will be the overall rating displayed, which uses the new method, depending on number of reviews, average, etc. But we can also have the arithmetic mean displayed. By having two ratings displayed, people can see both sides. This way everyone is happy.

Secondly, I'm not sure about this, but as you said, some genres are more popular than others. Perhaps we can have a slightly different rating method for each genre. For example: I have it set to 50 ratings to be included in the top 100 (which factors into the overall rating). However, for Zeuhl, which is significantly less popular than symphonic prog, 50 ratings is much more impressive than 50 ratings in symph prog. Am I right? So perhaps, the amount needed for top 100 placement could vary between genres. Say it would be 50 for symph prog, while 30 for zeuhl, considering the popularity difference.

What do you think of this?

2ND EDIT:

I did some editing to the formula. I think you might like this, personally I find it pretty awesome. What I did was I set up separate values to input into the minimum # of ratings field for each genre. I came up with these numbers through their popularity. I figured this out by averaging the amount of votes for the top 20 albums of each genre. Through this I could see that symphonic prog was significantly more popular than every other genre, while indo prog was by far the least. I gave symph prog a value of 50, while everything else's values were decided through diving their averages by that of symph prog, then multiplying by 50.

For example: Symph prog is 50, Canterbury - 11, Eclectic - 27, Prog Metal - 24, Zeuhl - 5, and so on...

This basically means the symphonic prog genre is about 10 times more popular than the zeuhl genre, at least on this site. This is taken into consideration now when coming up with the overall score, so each album's rating can be compared to that of its genre. Thus no genre is favored over another, and each is considered equally when it comes to determining a rating.

I think each album's overall rating could be determined using this method, while for top 100 lists everything should stick to my previous method (the minimum # of ratings value staying at 50.)

Here's a visible representation of what I have going on ATM:



Anyone wishing to mess around with it themselves, I uploaded the excel file here



Edited by Fight Club - December 18 2007 at 12:42
Back to Top
Fight Club View Drop Down
Prog Reviewer
Prog Reviewer


Joined: May 21 2006
Location: United States
Status: Offline
Points: 572
Direct Link To This Post Posted: December 18 2007 at 12:47
Okay I extended this even further, making separate rating formulas. I made a couple album pages in the file as examples, but right now there's a formula for an overall rating relating specifically to an album's genre, a rating relating to every (for top 100 purposes), an average giving collab votes extra weight, a straight average of every vote, and the current rating on the site. This way someone can view all sides of spectrum and rely on the method he prefers.

Here's Caravan's If I Could... as an example:



Anyone wishing to see all this for themselves can download my Microsoft Excel file here
Back to Top
micky View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: October 02 2005
Location: .
Status: Offline
Points: 46843
Direct Link To This Post Posted: December 18 2007 at 13:21
Love what you have here Matt Clap   I'll pm Pat to have a looksie if he hasn't broke away for the holidays .. as I will do in a couple of days myself
The Pedro and Micky Experience - When one no longer requires psychotropics to trip
Back to Top
Fight Club View Drop Down
Prog Reviewer
Prog Reviewer


Joined: May 21 2006
Location: United States
Status: Offline
Points: 572
Direct Link To This Post Posted: December 18 2007 at 13:38
Originally posted by micky micky wrote:

Love what you have here Matt Clap   I'll pm Pat to have a looksie if he hasn't broke away for the holidays .. as I will do in a couple of days myself


I'm glad you like it Big%20smile
Back to Top
micky View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: October 02 2005
Location: .
Status: Offline
Points: 46843
Direct Link To This Post Posted: December 18 2007 at 13:46
really like it...

back to work I go... I will look at that formula closer tonight.. got caught up in genre team business last night and didn't get to it.
The Pedro and Micky Experience - When one no longer requires psychotropics to trip
Back to Top
Fight Club View Drop Down
Prog Reviewer
Prog Reviewer


Joined: May 21 2006
Location: United States
Status: Offline
Points: 572
Direct Link To This Post Posted: December 18 2007 at 16:38
Originally posted by micky micky wrote:

really like it...

back to work I go... I will look at that formula closer tonight.. got caught up in genre team business last night and didn't get to it.


A'ight, awesome. I'm interested to see what you make of it Smile
Back to Top
Atavachron View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: September 30 2006
Location: Pearland
Status: Offline
Points: 65864
Direct Link To This Post Posted: December 18 2007 at 16:43
y'know FC, I was ready to dismiss this whole ridiculous idea of yours but frankly results don't lie, and those new adjustments for the top albums are much more inline with reality IMO

very interesting, good work


Back to Top
1800iareyay View Drop Down
Prog Reviewer
Prog Reviewer


Joined: November 18 2006
Location: United States
Status: Offline
Points: 2492
Direct Link To This Post Posted: December 18 2007 at 16:57
Ugh, you just had to make me look at math on my break didn't you? Wink

Seriously though, this looks great as far as I can tell, but I have one question? Where do the ratings without reviews fit in? Maybe this could also be the solution to the issue Bob brought up about the spam ratings. Maybe if the ratings without reviews didn't count toward the overall rating, it would cease the pointless ratings. We could allow people to rate without reviews, but it would explicitly state that it would ahve no effect on teh overall score unless submitted with a written review.

Keep up the good work Matt. Clap
Back to Top
Fight Club View Drop Down
Prog Reviewer
Prog Reviewer


Joined: May 21 2006
Location: United States
Status: Offline
Points: 572
Direct Link To This Post Posted: December 18 2007 at 16:59
Originally posted by Atavachron Atavachron wrote:

y'know FC, I was ready to dismiss this whole ridiculous idea of yours but frankly results don't lie, and those new adjustments for the top albums are much more inline with reality IMO

very interesting, good work




I'm still tweaking it, but I think so too. The thing is, I have two separate rating methods, one to apply everything into a top 100, and then a genre specific method. Since each genre receives a different treatment I think it makes sense to have a different rating method. It's not too different, just takes in the amount of ratings differently.

For example: since RIO is a lot less popular than symphonic prog, the amount of ratings is a less important factor in the overall rating.

Also, that's not a COMPLETE list of top albums. A lot are probably still missing, as I only figured out the ratings to those that are there.
Back to Top
micky View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: October 02 2005
Location: .
Status: Offline
Points: 46843
Direct Link To This Post Posted: December 18 2007 at 17:00
ooohh... micky like that idea... let the people have their ratings only  reviews... but they count only with  a review.  Controversial to be sure... but I like it.  Probably an admin/owner call.
The Pedro and Micky Experience - When one no longer requires psychotropics to trip
Back to Top
Fight Club View Drop Down
Prog Reviewer
Prog Reviewer


Joined: May 21 2006
Location: United States
Status: Offline
Points: 572
Direct Link To This Post Posted: December 18 2007 at 17:04
Originally posted by 1800iareyay 1800iareyay wrote:

Ugh, you just had to make me look at math on my break didn't you? Wink

Seriously though, this looks great as far as I can tell, but I have one question? Where do the ratings without reviews fit in? Maybe this could also be the solution to the issue Bob brought up about the spam ratings. Maybe if the ratings without reviews didn't count toward the overall rating, it would cease the pointless ratings. We could allow people to rate without reviews, but it would explicitly state that it would ahve no effect on teh overall score unless submitted with a written review.

Keep up the good work Matt. Clap


Well the way I have it now, ratings w/out reviews count just as much as non collab ratings with reviews. I did it this way, because at the moment I can't actually SEE all the ratings, nor can I see all the non collab reviews alone.

So in my method I gave collab/prog reviewer ratings a weight of 3 with everything else a weight of 1. The way I figured it out was so I didn't have to count all the ratings on a page I highlighted the block of collab reviews and opened the source code in firefox. I then copied that to a word document and told it to fine 5stars.gif, 4stars, and so on so I could tell how many of each there was. I can't do this with the other reviews ratings, because to see all non collab reviews, I also have to show all the collab reviews (therefore I cannot tell them apart in Word). And I just can't see non review ratings in general at all anymore Angry

Of course if we can all decide on the specifics of this new method later. Obviously I'm sure whoever does this rating stuff has access to all the information we need. Then we can decide on weights between ratings, the overall mean, and stuff like that. Some of the factors I have in right now are still my own speculation/decisions.
Back to Top
Fight Club View Drop Down
Prog Reviewer
Prog Reviewer


Joined: May 21 2006
Location: United States
Status: Offline
Points: 572
Direct Link To This Post Posted: December 18 2007 at 17:58
OK, I added yet another method into all this. There's a separate sheet now in my Excel file, where one can input the total amount of ratings with reviews, which it will only take into account. The way I did this was I had the page display every review and after counting the collab reviews, I simply subtracted them from the whole to figure out the non-collab reviews.

The algorithm now gives non collab ratings a weight of 1 and collab ratings a weight of 3. Same as before, except that ratings without reviews aren't even considered in the equation.

The old method is still there, but I just have a separate page for both of them now. Play around with whichever you prefer.

Here's a screenshot using Images & Words as an example. Notice how its rating significantly drops with only review-ratings.

EDIT: I'm actually not how sure I am of this "only ratings with reviews count" thing. From the looks of it, A LOT of ratings will drop significantly this way.



Get the updated excel file to try on your own here


Edited by Fight Club - December 18 2007 at 18:09
Back to Top
Sofagrisen View Drop Down
Forum Groupie
Forum Groupie


Joined: January 18 2007
Location: Norway
Status: Offline
Points: 45
Direct Link To This Post Posted: December 18 2007 at 18:07
This is better than the currant top list algorithm...
Back to Top
micky View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: October 02 2005
Location: .
Status: Offline
Points: 46843
Direct Link To This Post Posted: December 18 2007 at 18:10
I like that a lot....  curious as to what the example album list (from above) might like like now.. using that latest tweek...
The Pedro and Micky Experience - When one no longer requires psychotropics to trip
Back to Top
Fight Club View Drop Down
Prog Reviewer
Prog Reviewer


Joined: May 21 2006
Location: United States
Status: Offline
Points: 572
Direct Link To This Post Posted: December 18 2007 at 18:12
Originally posted by micky micky wrote:

I like that a lot....  curious as to what the example album list (from above) might like like now.. using that latest tweek...


Haha... Well it'll take me a while to go through that sh*t load of albums again, but I'll see.

Only thing is, the minimum number of reviews (previously ratings) might have to be changed now since there will be a lot less ratings. Also, what about all the people who have rated TONS of albums, but never reviewed? All that time will be wasted now.


Edited by Fight Club - December 18 2007 at 18:14
Back to Top
micky View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: October 02 2005
Location: .
Status: Offline
Points: 46843
Direct Link To This Post Posted: December 18 2007 at 18:14
Originally posted by Fight Club Fight Club wrote:

Originally posted by micky micky wrote:

I like that a lot....  curious as to what the example album list (from above) might like like now.. using that latest tweek...


Haha... Well it'll take me a while to go through that sh*t load of albums again, but I'll see.


I think that is a nice middle course....  for those who want ratings without  review here... and those that want them eliminated for integreties sake .. for the sake of the lists.  Everyone can RATE the albums . but only those that  REVIEW the ablums shall affect the rating. 

that again.. is probably for closed door dicussion.. and not this thread.  But I'd like to see.. and have all see.. just what that does to the lists.


Edited by micky - December 18 2007 at 18:15
The Pedro and Micky Experience - When one no longer requires psychotropics to trip
Back to Top
rushfan4 View Drop Down
Special Collaborator
Special Collaborator
Avatar
Honorary Collaborator

Joined: May 22 2007
Location: Michigan, U.S.
Status: Offline
Points: 66807
Direct Link To This Post Posted: December 18 2007 at 18:17

I think that you have to remember that many of the ratings without reviews may have been done by non-English speaking members of the site who aren't comfortable enough with their English skills to write reviews in English.  It wouldn't be fair to exclude their reviews because they don't have written reviews.

Back to Top
1800iareyay View Drop Down
Prog Reviewer
Prog Reviewer


Joined: November 18 2006
Location: United States
Status: Offline
Points: 2492
Direct Link To This Post Posted: December 18 2007 at 18:23
Originally posted by micky micky wrote:


I think that is a nice middle course....  for those who want ratings without  review here... and those that want them eliminated for integreties sake .. for the sake of the lists.  Everyone can RATE the albums . but only those that  REVIEW the ablums shall affect the rating. 

that again.. is probably for closed door dicussion.. and not this thread.  But I'd like to see.. and have all see.. just what that does to the lists.

What can I say, I'm a Middle Path. I like the effect it had on Matt's list. His algorithm might solve a lot of complaining on the site.
Back to Top
 Post Reply Post Reply Page  123 6>

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.144 seconds.
Donate monthly and keep PA fast-loading and ad-free forever.