DEV Community

Ronald R
Ronald R

Posted on

DATA ANALYSIS - Highest Rated Movie in Imdb - Data set

I obtain a dataset from kaggle and I wanted to do a data analysis with it to figure out what was the highest rated movie of all time in Imdb. Funny enough I never realised that it would take quite some work to actually find it. It was never simple as a this is rated higher than this movie. No it needs quite a bit of filtering to get it.

Let's take a look at what I did. There were over 45,000 movies listed and there were some mixing data in some of them so we had to clean it all up.

Test

  • Test 1 - Highest rated movie of all time

Image description

Result - The Land

Issue - It only has 4 votes and has low confidence level since in a sample size of 14,000 it only takes about 0.0003% of the size.

  • Test 2 - Highest rated movie of all time with atleast 7,000 votes

Image description

Result - Shawshank Redemption with 14,075 votes

Issue - It may have the highest numberof votes and a significant size but we still can not exclude the fact that it only has about 60% of the total vote count

  • Test 3 - Highest rated movie of all time with atleast 10,000 votes

Image description

Result - The Dark Knight with 12,269 votes which is about 87% of the vote , we also see that Inception has the highest vote of all time

  • Test 4 - Highest rated movie of all time with atleast 10,000 votes and atleast 1 billion in revenue.

Image description

Result - The Dark Knight with 12,269 votes and also $1,004,558,444 in revenue

Conculsion

In conclusion, the tests conducted to determine the highest rated movie of all time revealed several results. The initial highest-rated movie, "The Land," was found to lack statistical significance due to its low number of votes and limited representation in the overall sample. Moving forward, tests with higher thresholds for the number of votes led to more robust conclusions.

"The Shawshank Redemption" emerged as the highest-rated movie with over 7,000 votes, but the issue of it representing only 60% of the total vote count raised concerns. A more refined criterion of at least 10,000 votes highlighted "The Dark Knight" as the top contender, comprising 87% of the votes and surpassing even the highest voted movie "Inception."

Further refinement, incorporating both high votes and substantial revenue, solidified "The Dark Knight" as the conclusive result, boasting 12,269 votes and an impressive $1,004,558,444 in revenue. This comprehensive approach ensures a more reliable determination of the highest rated movie, considering both audience appreciation and commercial success.

Top comments (0)