Welcome to the new SparkED Group Hub. Before you get started, check out our new program overview video

Free Trial

General Discussions

Join our discussions about the SparkED program. Learn more, share your ideas, and get connected with our community of educators, learners, and Alteryx pros.

Alteryx Halloween Festival | Candy Crunch Challenge

MadisonD
Alteryx Alumni (Retired)

Calling all data detectives and candy connoisseurs! Every year, trick-or-treaters collect a mixed bag of Halloween treasures, from skittles to peanut butter cups and even dental items and baseball cards. Join Alteryx SparkED for a spooktacular challenge as we analyze the ratings of these Halloween goodies. Discover the hidden gems, the 'meh' moments, and maybe even a few sweet surprises in the world of Halloween candy!

 

MadisonD_0-1698083180248.png

 

Happy Halloween Maveryx! Attached to this thread is a Halloween Candy Dataset from 2017, where participants rated a variety of candies and treats on a scale of 'Despair' - Dislike, 'Meh' - Average, 'Joy' - Like.

 

Clean & analyze the data to answer the questions below. Respond to the discussion with the answers, a screenshot of your workflow, and photo of YOUR favorite candy!

 

  • What type of candy or treat ranked the most well liked ('Joy') across participants?
  • What is the least favorite ('Despair') candy or treat in the United States and how many participants gave it this rating?
  • What are the top three candies or treats that had the most 'Meh' ratings?
  • What candy bars are the most polarizing (meaning at least 30% of submitted reviews for the candy bar are 'Joy', and at least 30% are 'Despair')?

Please feel free to include any other fun insights you found while analyzing the data! 

 

Ng, D. (2020, October 30). So much candy data, seriously. SCQ. https://www.scq.ubc.ca/so-much-candy-data-seriously/

20 REPLIES 20
Qiu
21 - Polaris
21 - Polaris

Somehow Candy is related to Holloween😂
This is my favorite candy: Green Tea KitKat
61QB0dXptIL.jpg

 

Spoiler
  • What type of candy or treat ranked the most well liked ('Joy') across participants?
    Any full-sized candy bar
  • What is the least favorite ('Despair') candy or treat in the United States and how many participants gave it this rating?
    Broken glow stick and 1415 participants gave it this rating in the USA
  • What are the top three candies or treats that had the most 'Meh' ratings?
    Lollipops
    Hard Candy
    Bonkers (the candy)
  • What candy bars are the most polarizing (meaning at least 30% of submitted reviews for the candy bar are 'Joy', and at least 30% are 'Despair')?
    Kinder Happy Hippo
    Licorice (yes black)
    Mike and Ike
    Pixy Stix
    Candy Crunch Challenge.PNG

 

 

AkimasaKajitani
17 - Castor
17 - Castor

Fun challenge!

I found this pokemon gummy at convinience store.

スクリーンショット 2023-10-27 002537.png

 

Spoiler
スクリーンショット 2023-10-27 002639.png

  • What type of candy or treat ranked the most well liked ('Joy') across participants?
    スクリーンショット 2023-10-27 002903.png
  • What is the least favorite ('Despair') candy or treat in the United States and how many participants gave it this rating?
    スクリーンショット 2023-10-27 002909.png
  • What are the top three candies or treats that had the most 'Meh' ratings?
    スクリーンショット 2023-10-27 002914.png
  • What candy bars are the most polarizing (meaning at least 30% of submitted reviews for the candy bar are 'Joy', and at least 30% are 'Despair')?
    スクリーンショット 2023-10-27 002921.png
aiahwieder
8 - Asteroid

What would YOU do with 100 Grand? (A slogan that has not fared well with inflation 😉)

aiahwieder_0-1698341058894.jpeg

 

Qiu
21 - Polaris
21 - Polaris

@AkimasaKajitani 
We have the same anwser, though it seems the number is not perfectly matching 😁

SGolnik
11 - Bolide
11 - Bolide

Reeces Peices.jpg

I love Reece's Pieces!!!!! This was fun!

Spoiler
 
lwolfie
11 - Bolide
Spoiler
Spoiler

1- Any Full-sized candy bar

2-Broken Glow Stick - 1624

3-Lollipops, Hard Candy, and Bonkers

4-Licorice, Kinder Happy Hippo, Mike and Ike, and Pixy Stix

Halloween2023.jpg

Favorite Candy.jpg

 

dinazulaikha18
8 - Asteroid
Spoiler
image.png
Spoiler
Sum of Age 10-19: 4200
Sum of Age 60 and above: 13800

My favorite: OIP.jfif

rodalferreira
8 - Asteroid
Spoiler
 
Candy.PNG
alisonpitt
11 - Bolide

reeses-pumpkin.png

I'm a fan of Reese's pumpkins!

Spoiler
Treat ranked most well-liked:

Treat ranked least favorite in the US:
least-well-liked-in-us.png

Top 3 "meh" ratings:
top-3-meh.png
Most polarizing treats:
most-polarizing.png
Workflow:
2023-halloween-challenge-ap.png