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/
I don't know why I found this in 2024, but I did somehow. And I had so much fun solving it that I figured I'd post my solution!
