econ project
Project one
Bin lou
Econ 301
9/18/19
Q#1: Breakdown of U.S population with respect to age? https://factfinder.census.gov/faces/tableservices/jsf/pages/productview.xhtml?pid=ACS_17_5YR_DP05&src=pt
Scatter plot
Under 5 years 5 to 9 years 10 to 14 years 15 to 19 years 20 to 24 years 25 to 34 years 35 to 44 years 45 to 54 years 55 to 59 years 60 to 64 years 65 to 74 years 75 to 84 years 85 years and over 19853515 20445122 20713111 21219050 22501965 44044173 40656419 43091143 21523460 19224060 27503389 14087477 6141523
Q#2: What is the difference in sale amount of single-family homes in different parts of US? https://www.nar.realtor/sites/default/files/documents/ehs-07-2019-single-family-only-2019-08-21.pdf
Units: (1000)
Clustred column chart of Sale amoount in 1000s of Single family Homes
U.S Jul Aug Sep Oct Nov 2016 2017 2018 2018 2018 2018 2018 2018 4838000 4892000 4742000 4790000 4760000 4600000 4620000 4630000 North east Jul Aug Sep Oct Nov 2016 2017 2018 2018 2018 2018 2018 2018 617000 615000 581000 580000 590000 570000 580000 600000 Midwest Jul Aug Sep Oct Nov 2016 2017 2018 2018 2018 2018 2018 2018 1222000 1222000 1192000 1190000 1210000 1190000 1180000 1220000 South Jul Aug Sep Oct Nov 2016 2017 2018 2018 2018 2018 2018 2018 1955000 1989000 1972000 1980000 1970000 1890000 1910000 1900000 West Jul Aug Sep Oct Nov 2016 2017 2018 2018 2018 2018 2018 2018 1044000 1066000 997000 1040000 990000 950000 950000 910000
Q#3: How number of marriages varies in U.S from 2000 to 2017? https://www.cdc.gov/nchs/data/dvs/national-marriage-divorce-rates-00-17.pdf
Units(1000 person)
2017 2016 2015 2014 1 2013 1 2012 2011 2010 2009 2008 2007 2006 2 2005 2004 2003 2002 2001 2000 2236496 2251411 2221579 2140272 2081301 2131000 2118000 2096000 2080000 2157000 2197000 2193000 2249000 2279000 2245000 2290000 2326000 2315000
Q#4: What is racial composition in U.S? https://factfinder.census.gov/faces/tableservices/jsf/pages/productview.xhtml?pid=ACS_17_5YR_DP05&src=pt
[百分比] White Black or African American American Indian Asian Native Hawaiian Some other race 24297 2820 44631272 5487131 20371856 1327014 17282368
Q#5: What is the range of median Household income in U.S? https://www.census.gov/data/academy/courses/excel.html
Upper limit
Frequency