Apollo Posted June 22, 2012 Share Posted June 22, 2012 I aggregated everyone's scores.68 people gave their ratings. I replaced everything over 10 with 10 and anything below 1 with 1. I computed the average (arithmetic mean, although I think that's a very simplistic approach) for each song and for the album for each poster, as well as the mean of means which is 6.67.Means for songs:Chinese Democracy: 6.74Shackler's Revenge: 6.83Better: 7.94Street of Dreams: 6.71If the World: 5.76There Was a Time: 8.19Catcher in the Rye: 7.02Scraped: 5.08Riad n' the Beduins: 4.78 (you people are fucking idiots)Sorry: 6.60I.R.S.: 6.53Madagascar: 6.55This I Love: 7.04Prostitute: 7.57Over a third of the posters rated TWAT a 10, in fact the only people who rated it below 7 are those who gave every song very low marks, because that's the kind of douchebags they are. I am very proud to be the only one who rated Riad a 10. B) I will show you some histograms later, but it's pretty clear that some songs split people massively getting very high and very low marks. I also wanna aggregate post counts for those who have voted and see if there's a connection between marks and how new they are here.I agree. Riad is a much better song than CD. Link to comment Share on other sites More sharing options...
The Sandman Posted June 22, 2012 Share Posted June 22, 2012 Top work.I need to do mine now Link to comment Share on other sites More sharing options...
Mysteron Posted June 22, 2012 Share Posted June 22, 2012 Great work guys, really interesting to read.Someone noted years ago that on a compact disc, the average songs at the beginning are always liked better than the average songs towards the end. But on an LP, the songs at the start of side 1 and side 2 are liked better than those towards the end of both sides. If CD had been released during the LP era, I wonder if people maybe would have liked Scraped etc.. a little more. Link to comment Share on other sites More sharing options...
SONOFABITCH Posted June 22, 2012 Share Posted June 22, 2012 That spreadsheet is sweet. Good job man. Link to comment Share on other sites More sharing options...
Guest Satanisk_Slakt Posted June 23, 2012 Share Posted June 23, 2012 Wow, this was really cool of you to do. Could the same be done for the other albums? I think it could be interesting to see how the different albums would be rated in general on the forum. Kind of like I did here: I could reorganise my list so that it's after each album as well if we do this. It would require quite a big effort from you or whoever else that would compile everyone's ratings though. Anyone else interested in it? Link to comment Share on other sites More sharing options...
GivenToFly Posted June 23, 2012 Share Posted June 23, 2012 ^ We could do it, of course, but the mods would probably move the threads to the old gnr section and there would be very few votes.I'll do it, no problem, it only took me 20 minutes or so. Link to comment Share on other sites More sharing options...
Guest Satanisk_Slakt Posted June 23, 2012 Share Posted June 23, 2012 Maybe wait till the restructure and see what changes will be made with the sections, or if the mods could allow five threads about the old band to be held in this section for two weeks or something. I'm sure there could be a way to work around it. Link to comment Share on other sites More sharing options...
YOUCOULDBEMINE. Posted June 23, 2012 Share Posted June 23, 2012 Chinese Democracy 8.5/10Shackler's Revenge 7.5/10Better 7.5/10Street Of Dreams 6/10 (I love the live versions though)If The World 6.5/10There Was A Time 6.5/10Catcher In The Rye 6.5/10Scraped 7/10Riad N' The Bedouins 6.5/10Sorry 8.5/10IRS 8/10Madagascar 7/10 (Live absolutely 10/10)This I love 7/10 (Live also 10/10)Prostitute 9/10 What I'm missing the most is the rasp on songs like Catcher and TWAT, the acoustic live version of Catcher was amazing though. Link to comment Share on other sites More sharing options...
GivenToFly Posted June 23, 2012 Share Posted June 23, 2012 I promised a histogram but then I completely forgot about it. Sorry. Here it is:People like it well enough, but there are some very low marks that drag the average down. With the last two votes added (username and ucudbmine) the mean went up from 6.67 to 6.68. The median however is 7.07 which is pretty good actually. I would love to do the same thing for the other albums although having seen this people might be unconsciously biased after this thread and knowing there will be comparisons.The histograms for songs look pretty much the same with the big modal peak to the right for TWAT and to the left for Riad and Scraped. Link to comment Share on other sites More sharing options...
Johnny Drama Posted June 24, 2012 Share Posted June 24, 2012 Chinese Democracy 6.5/10Shackler's Revenge 9/10 - hated this so much beforeBetter 6.5/10Street Of Dreams 6/10 If The World 9.5/10There Was A Time 10/10Catcher In The Rye 6/10 OvercookedScraped 4/10 Riad N' The Bedouins 7/10 - OK song, amazing drumsNow let's get down to businessSorry 9/10IRS 9/10Madagascar 8.5/10 This I love 8/10 Prostitute 10/10 Link to comment Share on other sites More sharing options...
Flayer Posted June 24, 2012 Share Posted June 24, 2012 (edited) Chinese Democracy: 5/10Shackler's Revenge: 8/10Better: 7.5/10Street of Dreams: 6.5/10If The World: 6.5/10There Was A Time: 10/10Catcher in the Rye: 7/10Scraped: 8/10Riad N' The Bedouins: 6/10Sorry: 6.5/10IRS: 7.5/10Madagascar: 6/10This I Love: 8/10Prostitute: 7/10Average: 7.11/10 Edited June 24, 2012 by Flayer Link to comment Share on other sites More sharing options...
The Sandman Posted June 24, 2012 Share Posted June 24, 2012 Chinese Democracy: 8.5/10Shackler's Revenge: 9.5/10Better: 9/10Street of Dreams: 8/10If The World: 8/10There Was A Time: 9/10Catcher in the Rye: 9.5/10Scraped: 6/10Riad N' The Bedouins: 6/10Sorry: 10/10IRS: 8.5/10Madagascar: 10/10This I Love: 9/10Prostitute: 10/10 Average: 8.64 Link to comment Share on other sites More sharing options...
the rush Posted August 8, 2012 Share Posted August 8, 2012 (edited) hey, if you have time to spare, excluding the extremes (those that would stand out in a diagram) would make the numbers more accurate. e.g. my ratings go from 5 to 9.5 with two odd 1 votes which bring the average down significantly. that is not justified and makes for bad statisticsalso median is often more accurate than aritmethic middle. e.g lets take Better- it might have 2 "1" votes, 10 "8" votes and 2 "10" votesaverage - 7,28median - 8 - more accuratehere. I've done it for Chinese democracy song:1 122 123453 1234 125 1236 12345677 12345678901234567898 12345678909 1234567810 123456789median value for CD is: 7average and less accurate i.e. more misguiding: 6.77 Edited August 8, 2012 by the rush Link to comment Share on other sites More sharing options...
GivenToFly Posted August 8, 2012 Share Posted August 8, 2012 also median is often more accurate than aritmethic middleAccurate is not the word I'd use, but I get your point and you're right, in some cases it paints a more useful picture. With large samples the median and the mean tend to converge unless there's a systemic bias. Here the bias comes from a number of posters who gave disproportionately small marks. At the other end there were few eyebrow raising ratings, so so much for the notion that there are brainwashed fanboys who lick Axl's ass unconditionally. I guess the 'haters' are more irrational than the 'nutters'.I still have the spreadsheet, it'll just take a few seconds. I'll add the last few posts too.The median is higher for all but two songs where it approximately equal. Link to comment Share on other sites More sharing options...
GivenToFly Posted August 8, 2012 Share Posted August 8, 2012 Wow, this was really cool of you to do. Could the same be done for the other albums? I think it could be interesting to see how the different albums would be rated in general on the forum. Kind of like I did here: http://www.mygnrforu...ost__p__3123837I could reorganise my list so that it's after each album as well if we do this. It would require quite a big effort from you or whoever else that would compile everyone's ratings though. Anyone else interested in it?Lacking a very large sample (150+) it would be most useful if it were the same people voting so we could make a comparison. Link to comment Share on other sites More sharing options...
Juan Pablo Posted August 8, 2012 Share Posted August 8, 2012 Chinese Democracy 6/10 (I don't like the long intro)Shackler's Revenge 7/10Better 10/10Street Of Dreams 8/10 (great song, but i prefer the early version they used to play in 2001-2002)If The World 7/10 (i don't like the effect on the *nanana* bridge, the leak was better on this point)There Was A Time 10/10Catcher In The Rye 10/10 (i LOVE May in the demo, but the Bumble solo and outro isn't bad)Scraped (4/10)Riad N' The Bedouins (5/10)Sorry (7/10)I. R. S. (9/10)Madagascar (8/10)This I Love (8/10)Prostitute (10/10) Link to comment Share on other sites More sharing options...
the rush Posted August 8, 2012 Share Posted August 8, 2012 also median is often more accurate than aritmethic middleAccurate is not the word I'd use, but I get your point and you're right, in some cases it paints a more useful picture. With large samples the median and the mean tend to converge unless there's a systemic bias. Here the bias comes from a number of posters who gave disproportionately small marks. At the other end there were few eyebrow raising ratings, so so much for the notion that there are brainwashed fanboys who lick Axl's ass unconditionally. I guess the 'haters' are more irrational than the 'nutters'.I still have the spreadsheet, it'll just take a few seconds. I'll add the last few posts too.The median is higher for all but two songs where it approximately equal.so there you have it, much nicer and useful numbers and if we turn those ,5 into whole numbers in the positive direction we have:9 - 3 songs8 - 1 song7 - 8 songs6 - 1 song5 - 1 songpretty damn good if you ask me Link to comment Share on other sites More sharing options...
RocketQueenGNR Posted August 8, 2012 Share Posted August 8, 2012 CD: 9,5Shackler's: 9Better: 10SoD: 9If the world: 6TWAT: 8,5Catcher: 9Scraped: 7Riad: 8Sorry: 10IRS: 7Madagascar: 8This I love: 10Prostitute: 10 Link to comment Share on other sites More sharing options...
TyRod Tulip Posted August 8, 2012 Share Posted August 8, 2012 CD: 6Shackler's: 9Better: 9SoD: 6If the world: 7TWAT: 8Catcher: 5Scraped: 8Riad: 2Sorry: 10IRS: 8Madagascar: 4This I love: 9Prostitute: 9 Link to comment Share on other sites More sharing options...
ZoSoRose Posted August 8, 2012 Share Posted August 8, 2012 Nice table lolChinese Democracy: 8Shackler's Revenge: 9Better: 9.5Street of Dreams: 8.5If the World: 8 (this one is a 9 live though)There Was A Time: 10Catcher in the Rye: 9Scraped: 7.5 (8.5 live)Riad N' the Bedouins: 7Sorry: 8I.R.S.: 7.5Madagascar: 9This I Love: 9Prostitute: 9 The mean is 8.5, but I would rate the album a 9 to 9.5. Nostalgia and how I like the album as a while defiantly matter. So suck it, I love Chinese lol Link to comment Share on other sites More sharing options...
Redhead74 Posted August 8, 2012 Share Posted August 8, 2012 i can't believe people still listen to the album. i put it on twice, but never managed to get through the whole thing in one listen. such a looooooong, sulky time. it's like listening to heavy tori amos to me. only it hurts more, because i hear axl's voice and keep expecting something cool to happen.You really need to listen to it when you are in the 'right' mood. I know what that is for me, can't say for you though. I must like heavy music because you are totally right about the similarity to Tori Amos' heavy songs, which I love and I've never thought about that. Thanks for the enlightenment, man! Link to comment Share on other sites More sharing options...
ZoSoRose Posted August 8, 2012 Share Posted August 8, 2012 i can't believe people still listen to the album. i put it on twice, but never managed to get through the whole thing in one listen. such a looooooong, sulky time. it's like listening to heavy tori amos to me. only it hurts more, because i hear axl's voice and keep expecting something cool to happen.You really need to listen to it when you are in the 'right' mood. I know what that is for me, can't say for you though. I must like heavy music because you are totally right about the similarity to Tori Amos' heavy songs, which I love and I've never thought about that. Thanks for the enlightenment, man! The album really is as far away as you can get from Appetite and may not sound like GNR, but I still think its a fantastic album. A lot of great songs on it, especially Better and TWAT. I guess I can kind of see Chidem as a very, very far evolution of UYI. Link to comment Share on other sites More sharing options...
Nytunz Posted August 9, 2012 Share Posted August 9, 2012 CD - 7/10SR - 7/10Better 9/10Street of Dreams 7/10 (the last minute alone 10/10)If The World - 8/10TWAT - 10/10CITR - 4/10Scraped - 9/10Riad - 9/10Sorry - 10/10IRS 5/10Madagascar 6/10TIL 9/10Prostitute 8/10 Link to comment Share on other sites More sharing options...
uruguns Posted August 9, 2012 Share Posted August 9, 2012 Chinese Democracy 1.5/10Shackler's Revenge 1/10Better 2/10Street of Dreams 1/10If the world 1/10There was a time 1.5/10Catcher in the rey 1/10Scraped 1/10Riad N the Bedouins 1/10Sorry 1/10IRS 2/10Madagascar 1.5/10This I love 1/10Prostitute 1/10lolz Link to comment Share on other sites More sharing options...
Saphyra Posted August 9, 2012 Share Posted August 9, 2012 Chinese Democracy: 10Shackler's Revenge: 10Better: 10Street Of Dreams 10If The World: 10There Was A Time: 10Catcher In The Rye: 10Scraped: 10Riad N' The Bedouins: 10Sorry: 10I.R.S.: 10Madagascar: 10This I love: 10Prostitute: 10=) Link to comment Share on other sites More sharing options...
Recommended Posts