Ratings: Compare Ratings History with IMDb Rating

  • 8
  • Idea
  • Updated 4 years ago
  • (Edited)
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
Photo of Dan Dassow

Dan Dassow, Champion

  • 13151 Posts
  • 13396 Reply Likes

Posted 6 years ago

  • 8
Photo of Erik Boehm

Erik Boehm

  • 6 Posts
  • 2 Reply Likes
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
(Edited)
Photo of Dan Dassow

Dan Dassow, Champion

  • 13151 Posts
  • 13396 Reply Likes
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...












Photo of Brian Cheng

Brian Cheng

  • 6 Posts
  • 2 Reply Likes
I'm confused.
How do you compare your ratings to the public IMDb ratings?
And how did you get that correlation graph?
Photo of Dan Dassow

Dan Dassow, Champion

  • 13009 Posts
  • 13202 Reply Likes
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
  • Title
  • Title type
  • Directors
  • You rated
  • IMDb Rating
  • Runtime (mins)
  • Year
  • Genres
  • Num. Votes
  • Release Date (month/day/year)
  • URL
3. Import the CSV formatted file into Excel, Open Office, Google Docs or some other spreadsheet application.
4. Plot "You rated" against "IMDb Rating".
Photo of Brian Cheng

Brian Cheng

  • 6 Posts
  • 2 Reply Likes
Thank you! That's very informative! But how do you find the either the r value or the line of best fit?
Photo of Dan Dassow

Dan Dassow, Champion

  • 13009 Posts
  • 13202 Reply Likes
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