You have two assignments: we want you to answer a handful of specific questions using data that Slate published alongside How Many People Have Been Killed by Guns Since Newtown? and we want you to download the CDC’s data on firearm homicides and find something of your own in that data. If you’re smart, you’ll also use the extra week to start thinking about stories you’d like to work on for your team assignments and figuring out what kind of data is available for those stories.
Part 1: Slate continues to update their list of people killed by guns since the shootings in Newtown, CT just weeks before Christmas 2012. We’ve downloaded a snapshot of the data, that includes a single report of a gun death from today, September 11, 2013. Download today’s snapshot and use pivot tables and/or spreadsheet formulas to answer the following questions:
- What is the most common victim age?
- How many people of that age were killed by a firearm?
- What’s the average age of a US shooting victim since December 2012?
- Which state had the highest number of shooting victims?
- Which state had the highest number of female shooting victims?
- Manner: Homicide
- Cause or Mechanism: Firearm
- Census Region: United States (default)
- Race: All Races (default)
- Sex: Both Sexes (default)
- Years: 2008-2010
- Hispanic Origin: All (default)
- Ouptut: Standard Output (default)
- All Ages (default)
- Use 2000 as the Standard Year (default)
- Output Groups:
You’ll find a link to “Download Results in a Spreadsheet (CSV) File” at the bottom of the page. Explore the data, find something interesting and tell us what you found. Your findings should be in the form of 1-2 short paragraphs that tell us why your data or finding is relevant today and what you found. Imagine this text as the nut graf of your data story on your findings.