A solution to last week’s challenge can be found here.
This Halloween challenge was kindly contributed by Kenda Sanderson (@Kenda). We extend our gratitude to Kenda for her significant contributions to our Community!
Are you of the opinion that modern scary movies are better than their predecessors, or are you a devoted fan of classic directors like Polanski and Hitchcock?
In this challenge, you will immerse yourself in the realm of horror films to discover whether their ratings and earnings have improved over the years or if the classics remain unbeatable. The provided IMDb (Internet Movie Database) dataset encompasses a compilation of horror movies released over the last 100 years.
For this challenge, you should focus exclusively on horror genre movies, and exclude any films that are also considered comedies.
Your tasks:
- Calculate a weighted movie rating for each decade, with the number of votes serving as the weight. All movies possess a rating, so they can all be included in this task, even if their revenue data is unavailable.
- Calculate the average earnings for each decade, considering only movies with reported revenue values.
- Create a line graph to visualize the changes in ratings and revenue over time.
Helpful hint:
- When you calculate the weighted movie rating, you can think of it like a SUMPRODUCT function in Excel.
Source: https://www.kaggle.com/datasets/shreyanshverma27/imdb-horror-chilling-movie-dataset
