Champion

 • 

19.8K Messages

 • 

480.9K Points

Sunday, April 7th, 2013 3:53 AM

15

Ratings: Compare Ratings History with IMDb Rating

This would be similar to the "Compare to You" feature.The "Compared to You" feature allows one to compare one's ratings history with public ratings histories is very useful. You may wish to add to a user's profile page the correlation of each user's ratings histories with the IMDb ratings.For instance, this feature would look like this for Col Needham:Compared to IMDb: +52Rated 8229 titles with 5 or more votesSimilar ratings for 4886 of them.Thinks another 2344 are better.Thinks 999 are worse.Liked less than you:Cavalcade, Lady in the Water, You Talkin' to Me?, 4.3.2.1, Random HeartsLiked more than you:Pink Floyd The Wall, Dancer in the Dark, Dead Alive, Alphaville, Stromboli

2 Messages

 • 

178 Points

11 years ago

I would add another feature: Movies Col Needham rated that you haven't and rated higher than a 7: Some Awesome Movie, A Hidden Treasure, A Flick You Had Forgotten About

Champion

 • 

19.8K Messages

 • 

480.9K Points

11 years ago

Hi Erik Boehm, With an advanced search and a little bit of link hacking you can build of the search for Movies Col Needham rated that you haven't and rated higher than a 7. Generally, you probably would not be interested in Feature Films that have less than 5000 votes. Highest Rated Feature Films You Haven't Seen With User Rating Between 7.0 And 10 and At Least 5,000 Votes http://www.imdb.com/search/title?count=250&my_ratings=exclude&num_votes=5000,&sort=user_... If you do not exclude films with 5000 votes or more you get a lot more films. Highest Rated Feature Films You Haven't Seen With User Rating Between 7.0 And 10 http://www.imdb.com/search/title?count=250&my_ratings=exclude&sort=user_rating,desc&titl... = = = On Col Needham page you should see See all 8,640 ratings » After sorting this list by user ratings you get. These are the titles that Col Needham has rated: http://www.imdb.com/user/ur1000000/ratings?start=1&view=compact&sort=user_rating:desc&de... If you exclude titles with ratings less than 7.0 and titles that you've rated you get this. (append this to the end of the previous link: &user_rating=7.0,10&my_ratings=exclude) These are the titles that that Col Needham has rated that you have not rated that are rated 7.0 or higher in descending order of rating: http://www.imdb.com/user/ur1000000/ratings?start=1&view=compact&sort=user_rating:desc&de...

6 Messages

 • 

160 Points

10 years ago

I'm confused. How do you compare your ratings to the public IMDb ratings? And how did you get that correlation graph?

Champion

 • 

19.8K Messages

 • 

480.9K Points

Hi Brian Cheng, To compare your ratings against the average IMDb ratings. 1. Make certain you are logged into IMDb. 2. From the drop down menu under your name, click "Your Ratings". This will bring you to your ratings page. 3. Click on the compact view button, which is the third button after View. 4. This will bring you to the compact view of your ratings page. You should see a page similar to what is shown below. Your ratings are under the blue star. The IMDb average rating is under the yellow star. To create a correlation chart like the one in my previous post, you will need to export your ratings. 1. From your ratings page click Export this list in the lower right hand corner. 2. This will export a Comma Separated Variable (CSV) formatted file with the following columns (fields): position - position in list const - Title ID created - Date rated modified - Blank for ratings lists description - Blank for ratings list TitleTitle typeDirectorsYou ratedIMDb RatingRuntime (mins)YearGenresNum. VotesRelease Date (month/day/year)URL3. Import the CSV formatted file into Excel, Open Office, Google Docs or some other spreadsheet application. 4. Plot "You rated" against "IMDb Rating".

6 Messages

 • 

160 Points

Thank you! That's very informative! But how do you find the either the r value or the line of best fit?

Champion

 • 

19.8K Messages

 • 

480.9K Points

Brian, I do not know your level of understanding of Excel, spreadsheets and basic statistics. I am assuming a limited knowledge of each. The value for "Compared to you" is R (Pearson Correlation). https://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient The value shown on the plot is the R-square value, which is the square of R (Pearson Correlation). This is an example Excel. Open Office and Google Docs have similar capabilities. In Excel, you can plot the data, then add a trend line. When you add the trend line, select "Display Equation on Chart" and "Display R-squared Value on chart". You can also use the CORREL(), SLOPE() and INTERCEPT() functions in Excel to compute R, slope and intercept. http://www.excelfunctions.net/Excel-Correl-Function.html http://www.excelfunctions.net/Excel-Slope-Function.html http://www.excelfunctions.net/Excel-Intercept-Function.html I recommend that you read a good tutorial on Excel functions and plotting. http://www.excelfunctions.net/ https://www.ncsu.edu/labwrite/res/gt/graphtut-home.html