Preview

Analysis of 2010 Us Census Data

Better Essays
Open Document
Open Document
943 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Analysis of 2010 Us Census Data
Analysis of 2010 US Census Data

TARTU 2013

Table of Contents
1. 2. 3. Abstract ............................................................................................................................... 3 US Census ........................................................................................................................... 4 Implementation ................................................................................................................... 5 3.1. 3.2. 3.3. Constraints ................................................................................................................... 5 Software ....................................................................................................................... 5 Implementation ............................................................................................................ 5

Conclusion .................................................................................................................................. 8 References .................................................................................................................................. 9

2

1. Abstract
The purpose of this project is to analyze the changes in United States education, income and demographics over ten years (from 2000 to 2010). For this US census data is used which should be available at the website of US Census Bureau (www.census.gov). The goals of this project are comparing the 2000 and 2010 US census data and find out how attributes like education, income and demographics have changed over ten years by making an OLAP solution for this. To achieve that, two datasets are needed – 2000 and 2010 US census full datasets. Another goal is to make snapshots of 2010 US census data so that they could fit into Excel and they could be used in Data Mining course exercises.

3

2. US Census
The United States Census is a decennial census that is organized by The Bureau of the



References: 1. Wikipedia.org, United States Census, 16.12.2012. http://en.wikipedia.org/wiki/United_States_Census - last viewed 04.01.2013. 2. Wikipedia.org, 2000 United States Census, 27.11.2012. http://en.wikipedia.org/wiki/2000_United_States_Census - last viewed 04.01.2013. 3. Wikipedia.org, 2010 United States Census, 01.01.2013. http://en.wikipedia.org/wiki/2010_United_States_Census - last viewed 04.01.2013. 4. 2000 US Census Data. http://biit.cs.ut.ee/~vilo/edu/Data/census2000/extract_full.csv.gz - last viewed 04.01.2013 5. MonteDB 5. http://www.monetdb.org/ - last viewed 04.01.2013. 6. SquirreL SQL Client. http://squirrel-sql.sourceforge.net/ - last viewed 04.01.2013. 7. Pentaho 4.8 http://www.pentaho.com/explore/pentaho-business-analytics/ - last viewed 04.01.2013 9

You May Also Find These Documents Helpful

  • Powerful Essays

    Keller Econ 545 Project

    • 4023 Words
    • 13 Pages

    Colby, S. & Ortman, J. (2015). Projections of the Size and Composition of the U.S. Population: 2014 to…

    • 4023 Words
    • 13 Pages
    Powerful Essays
  • Satisfactory Essays

    In the Map 5, the data of the total population in states of the U.S is quantitative data that is discrete. The data values of population size fall within the range from 560,000 to 38,000,000. As population is unevenly distributed throughout the United States, using the natural breaks method can cluster those states whose population share the relatively same size, which can better interpret the distribution of the population within the country. The sequential color scheme of orange can be identified as commonly used color scheme for visualize population and population…

    • 468 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Stat 231 Course Notes

    • 7029 Words
    • 29 Pages

    1 PPDAC 1.1 1.2 1.3 1.4 1.5 2 Problem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Plan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Conclusion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 2 4 5 7 8 8 8 9 10 10 10 11 11 12 14 16…

    • 7029 Words
    • 29 Pages
    Satisfactory Essays
  • Powerful Essays

    Gi Bill of 1944

    • 4063 Words
    • 17 Pages

    U.S. Bureau of the Census, U.S. Census of Population: 1960. Vol, I Characteristics of the Population.…

    • 4063 Words
    • 17 Pages
    Powerful Essays
  • Good Essays

    The U.S Census, is tasked with counting how many people are living in the United States every ten years.() This…

    • 743 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    2010 Census Profile

    • 2566 Words
    • 64 Pages

    Data Note: Hispanic population can be of any race. Census 2010 medians are computed from reported data distributions.…

    • 2566 Words
    • 64 Pages
    Satisfactory Essays
  • Good Essays

    United States Census Bureau. (2011). Statistical abstract of the United States: 2012. Retrieved on October 14, 2011 from: http://www.census.gov/compendia/statab/2012/tables/12s0038.pdf…

    • 988 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Throughout the 17th and 18th century, life in the newly created colonies in the new world flourished. These colonies were divided between the north and the south, and life was very different. People say that life could have been more similar than different; however studies show that these two colonies were very much different.…

    • 721 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    US Census Bureau Essay

    • 684 Words
    • 3 Pages

     How important is the FDCA project for the U.S. Census Bureau? How does it impact decision making and operational activities?…

    • 684 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Census Bureau, 2013 CPS. The use of data not collected by researchers directly is considered to be secondary data. This secondary data were taken from the U.S. Census Bureau website and analyzed. Currently, it is the latest CPS data available according to the U.S. Census Bureau website (U.S. Department of Commerce, 2015). The CPS consists of several different sections and sub categories, over 5,000 households and 200 questions. The data are cross-sectional, in that it was completed in 2013, randomly selected, and consist of a nationally represented sample. Cross-sectional data, according to Lavrakassec (2008) “are data that are collected from participants at one point in time” (Lavrakassec, 2008). He explained that in instances when surveys could not be observed directly cross-sectional data are used. These types of data are often times not collected at the same time, but over a period of time, although cross-sectional data allow sample data to be collected at a faster rate on time without bias (Lavrakassec,…

    • 1070 Words
    • 5 Pages
    Good Essays
  • Better Essays

    Census Bureau expanded the American Community Survey sample to 3 million households. (United States Census Bureau, 2015) Then on January, 2006 the American Community Survey included group quarters in their information. They decided to provide annually updated social, economic, and housing data for states and communities. This was very helpful for the fact I did not want to show very old data pertaining to Texas.…

    • 2163 Words
    • 9 Pages
    Better Essays
  • Good Essays

    Since 1790, every ten years a national census is conducted in order to gather information and data about population and housing. The census also helps determine how many electoral votes each state receives in the presidential election. A…

    • 920 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Toronto CMA has experienced a rapid growth in population during the past decades. The question is: will current ministry policies on planning cities suffice to keep the current standards of living if the growth in population continues with the same rate?…

    • 981 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    The main objective of the paper was to find if White African men and men from English-speaking Africa have higher net hourly earnings than that of nonwhite and non-speaking English people. Secondly, to find if South African men have higher net hourly earnings over men from a number of selected African countries. Third, to find if black African make more hourly than black African American men and women.…

    • 922 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Demand & Forecasting

    • 1081 Words
    • 5 Pages

    Cited: United States Census Bureau, US department of commerce, retrieved October 22, 2012 from http://quickfacts.census.gov/qfd/states/34/3445690.html…

    • 1081 Words
    • 5 Pages
    Better Essays