Free Trial

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 #448: Halloween Candy Survey

AYXAcademy
Alteryx
Alteryx

Banner 3.png

Hello Community Members,

 

A solution to last week’s challenge can be found here.

 

As Halloween approaches, we have a fun and festive challenge submitted by our esteemed user Nathan Purvis (@DataNath).  Thank you, Nathan, for this sweet challenge!

 

With the holiday rush coming, a candy manufacturing company needs your help. Your task is to create a comprehensive final report with graphs that answer two key questions:

  • What are the five most popular Halloween chocolate candies, in order by win percentage?
  • Which candies require the most ingredients? (The ingredient values are chocolate, fruity, caramel, peanutyalmondy, nougat, and crispedricewafer.)

 

The dataset provided is based on a survey of over 250,000 respondents to determine the most popular Halloween candy. To collect the data, a website was created where participants were shown two fun-sized candies and asked to select the one they would prefer to receive. Here are some key details:

  • All binary fields in the dataset are coded as 1 = yes, 0 = no (for example, chocolate = 1 means the candy contains chocolate; pluribus = 0 means it is a single item rather than multiple items in a bag or box).
  • Sugarpercent represents the percentile of sugar content for each candy.
  • Pricepercent indicates the unit price percentile compared to other candies.
  • Winpercent shows the overall win percentage of each candy in all matchups.

 

Can you rise to the challenge and help the candy company prepare for the Halloween frenzy?

 

Need a refresher? Review the following lessons in Academy to gear up:

 

Happy Halloween!

 

Source:

https://www.kaggle.com/datasets/fivethirtyeight/the-ultimate-halloween-candy-power-ranking?resource=...

AkimasaKajitani
17 - Castor
17 - Castor

Happy Halloween!

 

Spoiler
image.png

image.png

 

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached,

 

Spoiler
image.png
mmontgomery
11 - Bolide
11 - Bolide

C448

Spoiler
c448.png
bwilgus
5 - Atom
Spoiler
 
 

image.png

MelGibson
10 - Fireball
Spoiler
448.png

Hub119
11 - Bolide
11 - Bolide

Happy Halloween!

Spoiler
WC448 Picture.png
balajilolla2
10 - Fireball
Spoiler
Solution attached

Screenshot 2024-10-28 081618.jpg
lwolfie
11 - Bolide

I always enjoy a fun holiday challenge. 

Shelbey
Alteryx
Alteryx

Happy Halloween! 

 

Workflow:

Spoiler
Screenshot 2024-10-28 083116.png

Report (with a little extra Halloween flare):

Spoiler
Screenshot 2024-10-28 083152.png