1 / 18

Searching, Exporting, Cleaning, & Graphing US Census Data Kelly Clonts

Searching, Exporting, Cleaning, & Graphing US Census Data Kelly Clonts Presentation for UC Berkeley, D-Lab March 18, 2014. Learning Objectives . To become familiar with the types of data published by the US Census Bureau US Decennial Census American Community Survey

nituna
Download Presentation

Searching, Exporting, Cleaning, & Graphing US Census Data Kelly Clonts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Searching, Exporting, Cleaning, & Graphing US Census Data Kelly Clonts Presentation for UC Berkeley, D-Lab March 18, 2014

  2. Learning Objectives • To become familiar with the types of data published by the US Census Bureau • US Decennial Census • American Community Survey • To understand how to search and analyze US Census data • Find appropriate data • Download and format data in Excel • Create population pyramids using Excel

  3. The Census The Census • Decennial • American Community Survey

  4. The Census Go to census.gov • Quick Facts • Select State or City

  5. Fact Finder 2 Go to American Fact Finder 2 on your web browser at: factfinder2.census.gov • “Advanced search” • Layout • Geographies

  6. Fact Finder 2: Locating an Area Level of Geography

  7. Fact Finder 2: Locating an Area • Find your neighborhood • Geographies > Address > Tract (like neighborhood)

  8. Fact Finder 2: ACS data • What kind of data do you want? • Can add multiple geographies (but not overlapping subjects) • Select your current or home town tract & the city • Dataset • 2012 ACS • Subject • Search B08301. Means of Transportation to Work • Must clear prior selection before re-searching View Dataset

  9. Fact Finder 2: ACS data • What kind of data do you want? • Subject • Search “income” • Search Means of Transportation to Work • Must clear prior selection before re-searching View Dataset

  10. Margin of Error (ACS) • Margin of error (MoE) • Number of households = 1,000 +/- 100 • Number of households = 20,000 +/- 400 • 1,000 +/- 100 tells us that we are 90% confident that the number of households is between 900 and 1100 • When would the MoE be a problem?

  11. Margin of Error (ACS) The uncertainty associated with an estimate that is based on data gathered from a sample of the population rather than the full population -US Census claims no Margin of Error

  12. US Census • What kind of data do you want? • Dataset • 2010 100% • Subjects • Population Age Groups and Sex: 2010 Census Summary File 1

  13. Locating an Area • Export Data • Download • CSV • Excel • Clean • CSV – change header names • Excel • Delete extra rows • Make Columns equal size, delete unnecessary • Change to number

  14. Population Pyramid Analyzing • Copy data to a new Sheet • Delete Unnecessary Data • Multiply Males by -1 • Copy raw values Graphing • Highlight data • Insert>bar • Clean up

  15. Population Pyramid • Graphing and Analyzing Data • Compare to region (City, Bay Area, State) • Analyze data • Equality of gender? • Age distribution?

  16. Social Explorer • Go to socialexplorer.com

  17. Social Explorer • Go to socialexplorer.com • Maps & Tables

  18. Social Explorer

More Related