1 / 4

Working with US Census Data

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

merry
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. 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. Working with US Census Data LSP 120 Week 6 Joanna Deszcz

  2. 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”

  3. 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

  4. Let’s try one… • Cellular Phone Statistical Abstract 2007.xls

More Related