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

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
ilainef
5 - Atom

Hershey's

vbaumel
7 - Meteor

This was a fun one!

Spoiler
Q1: What type of candy or treat ranked the most well liked ('JOY') across participants?
--Any full-sized candy bar
Q2: What is the least favorite ('DESPAIR') candy or treat in the United States and how many participants gave it this rating?
--"Broken glow stick" with 1,415
Q3: What are the top three candies or treats that had the most 'MEH' ratings?
--Lollipops, Hard Candy, and Bonkers (the candy)
Q4: 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'?
--Licorice (yes black), Kinder Happy Hippo, Pixy Stix, and Mike and Ike

Candy Crunch Challenge.PNG

Laurap1228
11 - Bolide

Answers to the Questions:

 

Spoiler
Q1. What type of candy or treat ranked the most well liked ('Joy') across participants?  
Any full-sized candy bar
Q2. What is the least favorite ('Despair') candy or treat in the United States and how many participants gave it this rating?
1,415 participants in the US said Broken glow stick was their leat favorite.
Q3. What are the top three candies or treats that had the most 'Meh' ratings?
1. Lollipops 
2. Hard Candy 
3. Bonkers (the candy) 
Q4. 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')?
Licorice (yes black)
Kinder Happy Hippo
Pixy Stix
Mike and Ike

Picture of my workflow:

Spoiler
halloween fun.PNG

 

 

My favorite candy: TwixTwix

 

 

 

mgaronson
11 - Bolide
Spoiler
Challenge Candy Crunch Workflow Pic.png

1. Any full-sized candy bar
2. Broken glow stick - 1624
3. Meh rating - Lollipops, Hard Candy, Bonkers (the candy)
4.Polarizing - Licorice (yes black), Kinder Happy Hippo, Pixy Stix, Mike and Ike

Fun challenge! 

IMG_1877.jpeg

Medha31
8 - Asteroid
Spoiler
  • Any full sized candy bar is the most liked across participants 😍
  • Broken glow stick is disliked by 1415 participants in US 🤢
  • Lollipops, Hard Candy and Bonkers have the most 'Meh' ratings 😏
  • Kinder Happy Hippo, Licorice (yes black), Mike and Ike, Pixy Stix are most polarizing 😍🤢
    HalloweenCandyChallenge.png

    PS: My fav candy is Hersheys Kisses :D
     

    Hersheys.png

aaenugu
6 - Meteoroid

Somehow this Halloween is better compared to the previous for meScreenshot 2023-10-31 220141.pngToblerone_3362.jpg

dwhiting31
5 - Atom

My candy of choice! My answers to the questions are in the spoiler below.

 

twix_pic2.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Spoiler
Spoiler
Candy Crunch Challenge Workflow (DW).jpg
 

 

gawa
16 - Nebula
16 - Nebula

Fun!

27546_1004

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 1,415

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')?

Licorice (yes black)


image.png

Regarding Q4, when it comes to the "most", I picked one having the highest value of the sum of JOY % and DESPAIR %.

 

SahithiThota1
7 - Meteor

Happy Halloween! 'Halloween' sounds more like a 'Candy Day'. 

Well, my favorite candy is Kitkat white.

Spoiler Alert for the Candy Crunch Challenge

Find the workflow below.

 

> What type of candy or treat ranked the most well liked ('Joy') across participants?

'Any full-sized candy bar' is the candy ranked the most well liked 'Joy' across the participants.


> What is the least favorite ('Despair') candy or treat in the United States and how many participants gave it this rating?

'Broken glow stick' is the least favorite 'DESPAIR' candy in the United States and 1415 participants gave it this rating.


> What are the top three candies or treats that had the most 'Meh' ratings?

The top three candies that had the most 'MEH' ratings are 'Lollipops', 'Hard Candy', and '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')?

'Pixy Stix', 'Mike and Ike', 'Kinder Happy Hippo', 'Licorice (yes black)' candy bars are the most polarizing.

download.jpeg

 

 

sarahlovesdata_
6 - Meteoroid

That was fun!