COVID-19 pandemic caused a dip in candy sales in 2020, but 2020 Halloween participation is expected to return to pre-pandemic levels. According to the National Retail Federation’s annual Halloween spending survey, candy spending could reach an all-time high of around 3.1 billion, with a record $10.6 billion expected to be spent on all things Halloween.
CandyStore.com has been delivering and distributing bulk orders of candy across the country since 2007. Last year, eighteen different candies received the top vote across the country. The “best” candy title varies from state to state; different states had different top choices. In order for CandyStore.com to prepare for the high candy demand at Halloween, sales representatives have been asked to predict the most popular candy types in each state. As a sales representative, your job is to predict and then track which candy is the most popular in your area.
Create a spreadsheet with YOUR Predicted Top Ten candies listed in order. If a hundred candies are sold, predict how many of each type of candy type is needed. (Example: Out of 100 candies sold, your prediction is that 10 packages of Skittles will be sold.)
Your spreadsheet should list your Predicted Top Ten Candies, including a column with the Predicted number of each candy. Be sure to use the Summation feature to add the sum of the candies in the column. (Hint: The sum should equal 100!)
Option: Conduct an actual survey of your classmates. Ask the students to list their first, second and third choices of candy types. Create your Predicted Top Ten Candies Spreadsheet. Send home a second survey for students to complete after trick-or-treating.
You can create your own ten “best” candies or choose from the top ten national list and/or the additional top candy choices. Remember that top ten candies may vary from state-to-state, so choose carefully for your state!
Here is the list in alphabetical order of the top ten “best” candies national wide:
Hear is an alphabetical-order list of the additional top three candy choices by state (that did not make the nation-wide top ten list):
After Trick-or-Treating, divide your candy by type and count each type. Ask to count your friend, sibling or a classmate’s candy, until you have a total of 100 pieces of candy. Add a second column to your original spreadsheet and label it “Actual Candy”. Add additional candy types if needed.
Option After Trick-or-Treating Class Survey: Ask the students in your class to divide their candy by type and count the number of candies in each of the top three types. Use this data for the Actual Candy column in the spreadsheet.
Ask students to draw conclusions from the data. Prepare a written statement for CandyStore.com explaining your conclusions and your recommendations for next year’s candy needs for your area.
After your student completes the activities, share these fun facts! Reese’s Peanut Butter Cups is the overall top selling candy across the U.S; however, it didn’t win the most states! “Best” Candy title belongs to M&Ms and Sour Patch Kids; each of these candies were the most popular choice in seven states.
Bonus Question: Ask your students how Reese’s Peanut Butter Cups could be the overall top selling when it did not win the most states?
Navigating Google Sheets with JAWS Lesson: Arctic Animals