10/23/2014 (Up to date with 2022 knowledge)
Halloween Knowledge Set Revealed for Knowledge Visualization
I’ve lived in my home for 12 years, and each Halloween I get inundated with trick-or-treaters. Yr after 12 months it is like Willy Wonka’s Chocolate Manufacturing facility at my home, with sweet flying out the door. Now being a knowledge man, what do I do? Nicely that is easy, I depend them. A buddy and I preserve meticulous depend of the trick-or-treaters in 30 minute intervals, and I have been monitoring this knowledge 12 months by 12 months. After plenty of years of recording these numbers, I made a decision to make use of it as a knowledge set for knowledge visualization coaching. I’ve used this knowledge set within the knowledge visualization course on the College of Cincinnati, coaching at KPMG of their Advisory College and International Analytics coaching in addition to different knowledge visualization workshops and company coaching. On the time of penning this submit, I might estimate that over 1,000 folks have created a knowledge visualization utilizing this knowledge and based mostly on the hourly price of a few of these of us, it’s nicely over a six determine funding total.
There are a variety of the explanation why I actually like this knowledge set, and I’ve had nice success utilizing it as a educating instrument. Giant knowledge units are quite common these days. This very small knowledge set forces folks to be artistic with the info and the story they inform. It is a enjoyable subject; one thing most everybody can relate to (at the very least within the U.S.), and it is all the time attention-grabbing to see the wide selection of information visualizations which can be created throughout this train. I made a decision to make the info set public and to maintain it up to date.
Sure, in 2011 I had 869 trick-or-treaters come to my home, and in 2020 with a world pandemic, I had 219 trick-or-treaters.
Directions (sometimes 45-75 minutes in workshop format, small group or particular person or as one task at school):
1.) Decide a narrative or aim for the visualization.
Home-owner dashboard summarizing Halloween
Forecast future trick-or-treaters or estimate future sweet want
Discover variation of the variety of trick-or-treaters 12 months by 12 months
2.) This can be a quite simple knowledge set. There are only some years of information damaged down into 4 half-hour time blocks with cumulative totals. Assume broadly concerning the knowledge.
The info is time collection knowledge – any further decisions?
What comparisons are you able to make?
What desk calculations will be made?
What further knowledge will be appended from different sources to assist inform the story or full an evaluation?
NOTE – be very cautious as a result of there are lots of pitfalls at this step.
3.) Construct a knowledge visualization
Obtain Knowledge units (xlsx format):
Numbers in knowledge file for Excel are cumulative.
Numbers in knowledge file for Tableau have been unpivoted and should not cumulative.
Zip Code: 45207
Neighborhood: East Walnut Hills/Evanston (being on the border doubtless will increase the variety of trick-or-treaters
The date for trick or treating has all the time been on 10/31 (some neighborhoods change the night time for trick or treating)
The kind of sweet didn’t range 12 months by 12 months. It’s all the time a basic mixture of sweet
Official trick or deal with hours are from 6pm-8pm, however at 8pm I don’t kick the youngsters off my porch and say « no sweet for you ». These « stragglers » trickle down and by 8:15pm there are not any extra.
In many of the latest years there have been plenty of trick-or-treaters that confirmed up earlier than 6pm. The earliest was in 2020 at 4:45pm (neighbors that wished to return earlier than anybody else due to COVID-19).
For 2020, due to COVID-19, I set up two long candy chutes in order that trick-or-treaters may get sweet from a protected distance.
I additionally created a timelapse video posted on YouTube.
Teacher Notes Accessible:
Instructors who wish to use this knowledge set for his or her class or workshop can contact me at Jeff@DataPlusScience.com for detailed teacher notes on this task/train.
I hope you discover this knowledge set helpful. You probably have any questions be happy to e-mail me at Jeff@DataPlusScience.com
Jeffrey A. Shaffer
Observe on Twitter @HighVizAbility
Edited by Breanne LaCamera 1/26/2015 and posted 2/17/2015