working with us census data
Download
Skip this Video
Download Presentation
Working with US Census Data

Loading in 2 Seconds...

play fullscreen
1 / 4

Working with US Census Data - PowerPoint PPT Presentation


  • 101 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