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.
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!
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/
This was a fun one!
--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
Answers to the Questions:
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:
My favorite candy: 
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!
- 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 😍🤢
PS: My fav candy is Hersheys Kisses :D
Somehow this Halloween is better compared to the previous for me
Fun!
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)
Regarding Q4, when it comes to the "most", I picked one having the highest value of the sum of JOY % and DESPAIR %.
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.
