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
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Powerful Essays

    Keller Econ 545 Project
    • 4023 Words
    • 13 Pages

    Keller Econ 545 Project

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

    • 4023 Words
    • 13 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Nt1310 Unit 3 Data Analysis Of Unemployment
    • 468 Words
    • 2 Pages

    Nt1310 Unit 3 Data Analysis Of Unemployment

    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
    Read More
  • Satisfactory Essays

    Stat 231 Course Notes
    • 7029 Words
    • 29 Pages

    Stat 231 Course Notes

    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
    Read More
  • Good Essays

    Gerrymandering Pros And Cons
    • 743 Words
    • 3 Pages

    Gerrymandering Pros And Cons

    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
    Read More
  • Satisfactory Essays

    2010 Census Profile
    • 2566 Words
    • 64 Pages

    2010 Census Profile

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

    • 2566 Words
    • 64 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Death of a Salesman Willy Loman's Mental Breakdwon
    • 959 Words
    • 4 Pages

    Death of a Salesman Willy Loman's Mental Breakdwon

    In Death of a Salesman Willy Loman was a man made of false dreams. Willy Loman was a man who destroyed himself with his false hopes and dreams. Throughout his whole life he was trying to become a Salesman like his father and he thought he would die a rich and successful man. Willy Loman was a man who tried so hard to achieve the American dream but failed to do so due to the multiple circumstances throughout his life. Environment around Willy Loman has had a huge affect on him which is causing him to be instable. Willy is not only destroyed by his own ideals but destroyed by his own two children Biff and Happy and Howard firing him also broke him down even more. Willy Loman is destroying himself trying to achieve the American Dream and trying to become a salesman like his own father but is failing to do so. He wants to own his own business. Willy also wants to be “bigger” then Uncle Charlie and that is why he never takes a job under Uncle Charlie even after getting fired. He wishes to die the “Death of a Salesmman” where many people to mourn for him and remember him as a great salesman. Willy has spent his whole life trying to achieve all these dreams of his but he still hasn’t really achieved any of them which is causing him to have a mental breakdown.…

    • 959 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Immigration in Charlotte, North Carolina
    • 988 Words
    • 4 Pages

    Immigration in Charlotte, North Carolina

    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
    Read More
  • Better Essays

    Child Poverty In Texas Research Paper
    • 2163 Words
    • 9 Pages

    Child Poverty In Texas Research Paper

    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
    Read More
  • Good Essays

    Should We Abolish The Electoral College?
    • 920 Words
    • 4 Pages

    Should We Abolish The Electoral College?

    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
    Read More
  • Good Essays

    The Demographic History of the United States
    • 721 Words
    • 3 Pages

    The Demographic History of the United States

    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
    Read More
  • Good Essays

    Unequal Representation In The US Census Bureau
    • 1070 Words
    • 5 Pages

    Unequal Representation In The US Census Bureau

    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
    Read More
  • Powerful Essays

    Population Change in the Toronto Census Metropolitan Area
    • 981 Words
    • 4 Pages

    Population Change in the Toronto Census Metropolitan Area

    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
    Read More
  • Good Essays

    The Socioeconomic Attainment Patterns of Africans in the United States
    • 922 Words
    • 4 Pages

    The Socioeconomic Attainment Patterns of Africans in the United States

    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
    Read More
  • Satisfactory Essays

    US Census Bureau Essay
    • 684 Words
    • 3 Pages

    US Census Bureau Essay

     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
    Read More
  • Better Essays

    Demand & Forecasting
    • 1081 Words
    • 5 Pages

    Demand & Forecasting

    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
    Read More