![]() |
|
Post Reply ![]() |
Page 123 6> |
Author | ||
Fight Club ![]() Prog Reviewer ![]() Joined: May 21 2006 Location: United States Status: Offline Points: 572 |
![]() 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.
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.
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? |
||
![]() |
||
![]() |
||
Fight Club ![]() Prog Reviewer ![]() Joined: May 21 2006 Location: United States Status: Offline Points: 572 |
![]() |
|
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 |
||
![]() |
||
![]() |
||
Fight Club ![]() Prog Reviewer ![]() Joined: May 21 2006 Location: United States Status: Offline Points: 572 |
![]() |
|
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 |
||
![]() |
||
![]() |
||
Fight Club ![]() Prog Reviewer ![]() Joined: May 21 2006 Location: United States Status: Offline Points: 572 |
![]() |
|
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 |
||
![]() |
||
![]() |
||
micky ![]() Special Collaborator ![]() Honorary Collaborator Joined: October 02 2005 Location: . Status: Offline Points: 46843 |
![]() |
|
Love what you have here Matt
![]() |
||
The Pedro and Micky Experience - When one no longer requires psychotropics to trip
|
||
![]() |
||
Fight Club ![]() Prog Reviewer ![]() Joined: May 21 2006 Location: United States Status: Offline Points: 572 |
![]() |
|
I'm glad you like it ![]() |
||
![]() |
||
![]() |
||
micky ![]() Special Collaborator ![]() Honorary Collaborator Joined: October 02 2005 Location: . Status: Offline Points: 46843 |
![]() |
|
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
|
||
![]() |
||
Fight Club ![]() Prog Reviewer ![]() Joined: May 21 2006 Location: United States Status: Offline Points: 572 |
![]() |
|
A'ight, awesome. I'm interested to see what you make of it ![]() |
||
![]() |
||
![]() |
||
Atavachron ![]() Special Collaborator ![]() ![]() Honorary Collaborator Joined: September 30 2006 Location: Pearland Status: Offline Points: 65864 |
![]() |
|
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 |
||
![]() |
||
1800iareyay ![]() Prog Reviewer ![]() Joined: November 18 2006 Location: United States Status: Offline Points: 2492 |
![]() |
|
Ugh, you just had to make me look at math on my break didn't you?
![]() 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. ![]() |
||
![]() |
||
Fight Club ![]() Prog Reviewer ![]() Joined: May 21 2006 Location: United States Status: Offline Points: 572 |
![]() |
|
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. |
||
![]() |
||
![]() |
||
micky ![]() Special Collaborator ![]() Honorary Collaborator Joined: October 02 2005 Location: . Status: Offline Points: 46843 |
![]() |
|
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
|
||
![]() |
||
Fight Club ![]() Prog Reviewer ![]() Joined: May 21 2006 Location: United States Status: Offline Points: 572 |
![]() |
|
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 ![]() 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. |
||
![]() |
||
![]() |
||
Fight Club ![]() Prog Reviewer ![]() Joined: May 21 2006 Location: United States Status: Offline Points: 572 |
![]() |
|
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 |
||
![]() |
||
![]() |
||
Sofagrisen ![]() Forum Groupie ![]() Joined: January 18 2007 Location: Norway Status: Offline Points: 45 |
![]() |
|
This is better than the currant top list algorithm...
|
||
![]() |
||
micky ![]() Special Collaborator ![]() Honorary Collaborator Joined: October 02 2005 Location: . Status: Offline Points: 46843 |
![]() |
|
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
|
||
![]() |
||
Fight Club ![]() Prog Reviewer ![]() Joined: May 21 2006 Location: United States Status: Offline Points: 572 |
![]() |
|
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 |
||
![]() |
||
![]() |
||
micky ![]() Special Collaborator ![]() Honorary Collaborator Joined: October 02 2005 Location: . Status: Offline Points: 46843 |
![]() |
|
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
|
||
![]() |
||
rushfan4 ![]() Special Collaborator ![]() ![]() Honorary Collaborator Joined: May 22 2007 Location: Michigan, U.S. Status: Offline Points: 66806 |
![]() |
|
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. |
||
![]() |
||
![]() |
||
1800iareyay ![]() Prog Reviewer ![]() Joined: November 18 2006 Location: United States Status: Offline Points: 2492 |
![]() |
|
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. |
||
![]() |
Post Reply ![]() |
Page 123 6> |
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |