Working with us census data
This presentation is the property of its rightful owner.
Sponsored Links
1 / 4

Working with US Census Data PowerPoint PPT Presentation


  • 80 Views
  • Uploaded on
  • Presentation posted in: General

Working with US Census Data. LSP 120 Week 6 Joanna Deszcz. Before you begin - Be Careful. We will be using a dataset provided by the U.S. Census Bureau Government datasets often need to be “cleaned up”. Things to check for…. Convert Formulas to values

Download Presentation

Working with US Census Data

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


Working with us census data

Working with US Census Data

LSP 120

Week 6

Joanna Deszcz


Before you begin be careful

Before you begin - Be Careful

  • We will be using a dataset provided by the U.S. Census Bureau

  • Government datasets often need to be “cleaned up”


Things to check for

Things to check for…

  • Convert Formulas to values

  • Convert numeric text values to numbers

  • Check for hidden rows

  • Delete rows and columns of unwanted data

  • Omit any projected data points

  • Techniques in Excel shows how to address each of these


Let s try one

Let’s try one…

  • Cellular Phone Statistical Abstract 2007.xls


  • Login