econ project

Q#1

Age	Population
Under 5 years	19,853,515			Question:		Breakdown Population of U.S with respect to age?
5 to 9 years	20,445,122
10 to 14 years	20,713,111
15 to 19 years	21,219,050
20 to 24 years	22,501,965
25 to 34 years	44,044,173
35 to 44 years	40,656,419
45 to 54 years	43,091,143
55 to 59 years	21,523,460
60 to 64 years	19,224,060
65 to 74 years	27,503,389
75 to 84 years	14,087,477
85 years and over	6,141,523

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

Sales Price of Existing Single-Family Homes
Year	Month	U.S	North east	Midwest	South	West		Question:
2016		4,838,000	617,000	1,222,000	1,955,000	1,044,000			What is the difference in sale amount of single family homes in different parts of US?
2017		4,892,000	615,000	1,222,000	1,989,000	1,066,000
2018		4,742,000	581,000	1,192,000	1,972,000	997,000
2018	Jul	4,790,000	580,000	1,190,000	1,980,000	1,040,000
2018	Aug	4,760,000	590,000	1,210,000	1,970,000	990,000
2018	Sep	4,600,000	570,000	1,190,000	1,890,000	950,000
2018	Oct	4,620,000	580,000	1,180,000	1,910,000	950,000
2018	Nov	4,630,000	600,000	1,220,000	1,900,000	910,000
2018	Dec	4,450,000	570,000	1,120,000	1,850,000	910,000
2019	Jan	4,360,000	570,000	1,090,000	1,820,000	880,000
2019	Feb	4,910,000	580,000	1,190,000	2,110,000	1,030,000
2019	Mar	4,670,000	570,000	1,100,000	2,040,000	960,000
2019	Apr	4,630,000	540,000	1,110,000	2,000,000	980,000
2019	May	4,760,000	570,000	1,160,000	2,040,000	990,000
2019	Jun	4,710,000	570,000	1,180,000	2,000,000	960,000
2019	Jul	4,840,000	570,000	1,200,000	2,030,000	1,040,000

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

Provisional number of marriages and marriage rate: United States, 2000-2017
Year	Marriages	Population	Rate per 1,000 total population			Question:	How number of marriages varries in U.S from 2000 to 2017?
2017	2,236,496	325,719,178	6.9
2016	2,251,411	323,127,513	7.0
2015	2,221,579	321,418,820	6.9
2014 1	2,140,272	308,759,713	6.9
2013 1	2,081,301	306,136,672	6.8
2012	2,131,000	313,914,040	6.8
2011	2,118,000	311,591,917	6.8
2010	2,096,000	308,745,538	6.8
2009	2,080,000	306,771,529	6.8
2008	2,157,000	304,093,966	7.1
2007	2,197,000	301,231,207	7.3
2006 2	2,193,000	294,077,247	7.5
2005	2,249,000	295,516,599	7.6
2004	2,279,000	292,805,298	7.8
2003	2,245,000	290,107,933	7.7
2002	2,290,000	287,625,193	8.0
2001	2,326,000	284,968,955	8.2
2000	2,315,000	281,421,906	8.2

Marriages

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

Racial Composition
White	242,972,820	What is racial composition of U.S?
Black or African American	44,631,272
American Indian	5,487,131
Asian	20,371,856
Native Hawaiian	1,327,014
Some other race	17,282,368

White Black or African American American Indian Asian Native Hawaiian Some other race 242972820 44631272 5487131 20371856 1327014 17282368

Q#5

Geographic Area	Median HH Income	Bin
United States	53889	45000		Question		What is range of median Household income in U.S
Alabama	43623	50000
Alaska	72515	55000
Arizona	50255	60000
Arkansas	41371	65000
California	61818	70000
Colorado	60629						Bin	Frequency
Connecticut	70331						45000	5
Delaware	60509						50000	13
District of Columbia	70848						55000	9
Florida	47507						60000	4
Georgia	49620						65000	4
Hawaii	69515						70000	3
Idaho	47583						More	5
Illinois	57574
Indiana	49255
Iowa	53183
Kansas	52205
Kentucky	43740
Louisiana	45047
Maine	49331
Maryland	74551
Massachusetts	68563
Michigan	49576
Minnesota	61492
Mississippi	39665
Missouri	48173
Montana	47169
Nebraska	52997
Nevada	51847
New Hampshire	66779
New Jersey	72093
New Mexico	44963
New York	59269
North Carolina	46868
North Dakota	57181
Ohio	49429
Oklahoma	46879
Oregon	51243
Pennsylvania	53599
Rhode Island	56852
South Carolina	45483
South Dakota	50957

45000 50000 55000 60000 65000 70000 More 5 13 9 4 4 3 5

Upper limit

Frequency