slide1
Download
Skip this Video
Download Presentation
Searching, Exporting, Cleaning, & Graphing US Census Data Kelly Clonts

Loading in 2 Seconds...

play fullscreen
1 / 18

Searching, Exporting, Cleaning, & Graphing US Census Data Kelly Clonts - PowerPoint PPT Presentation


  • 61 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Searching, Exporting, Cleaning, & Graphing US Census Data Kelly Clonts' - nituna


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1
Searching, Exporting, Cleaning, & Graphing US Census Data

Kelly Clonts

Presentation for UC Berkeley, D-Lab

March 18, 2014

learning objectives
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
the census
The Census

The Census

  • Decennial
  • American Community Survey
the census1
The Census

Go to census.gov

  • Quick Facts
  • Select State or City
fact finder 2
Fact Finder 2

Go to American Fact Finder 2 on your web browser at: factfinder2.census.gov

  • “Advanced search”
  • Layout
  • Geographies
slide7
Fact Finder 2: Locating an Area
  • Find your neighborhood
    • Geographies > Address > Tract (like neighborhood)
slide8
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

slide9
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

margin of error acs
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?

margin of error acs1
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

us census
US Census
  • What kind of data do you want?
    • Dataset
      • 2010 100%
    • Subjects
      • Population

Age Groups and Sex:

2010 Census Summary File 1

locating an area
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
population pyramid
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
population pyramid1
Population Pyramid
  • Graphing and Analyzing Data
    • Compare to region (City, Bay Area, State)
    • Analyze data
      • Equality of gender?
      • Age distribution?
social explorer
Social Explorer
  • Go to socialexplorer.com
social explorer1
Social Explorer
  • Go to socialexplorer.com
    • Maps & Tables
ad