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/
Somehow Candy is related to Holloween😂
This is my favorite candy: Green Tea KitKat
- 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
Fun challenge!
I found this pokemon gummy at convinience store.
- 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')?
What would YOU do with 100 Grand? (A slogan that has not fared well with inflation 😉)
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
I'm a fan of Reese's pumpkins!
Treat ranked least favorite in the US:
Most polarizing treats:
Workflow:
