Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #395: Bone-Chilling Horror Movies

AYXAcademy
Alteryx
Alteryx

Death_Image.png

 

 

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

 

Maveryx_WC_Banner.png

 

AkimasaKajitani
17 - Castor
17 - Castor
Happy Halloween!!!
 
Spoiler
スクリーンショット 2023-10-31 002516.png

スクリーンショット 2023-10-31 002700.png

  

 

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

 

Chart

Spoiler
image.png

Workflow

Spoiler
image.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
395.jpg
sergejs_kutkovics
9 - Comet

My try

Spoiler
Capture.PNG
Spoiler
Capture1.PNG
ed_hayter
12 - Quasar

wrapping my head round excel speak was a challenge - got there eventually

 

Spoiler
image.png
JamesCharnley
13 - Pulsar
Spoiler
image.png

 

Could have been plenty cleaner but was just experimenting while trying to work out what was being asked

 

 

nSpire
8 - Asteroid
Spoiler
395.png
ds_tomalexsmith
8 - Asteroid

Done!

Spoiler
Challenge 395 (flow).png

toby49
8 - Asteroid
Spoiler
Screenshot 2023-10-30 185956.png

my solution