Working with us census data
Download
1 / 4

Working with US Census Data - PowerPoint PPT Presentation


  • 100 Views
  • Uploaded on

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

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 ' Working with US Census Data' - merry


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


ad