Student : Danish Ilyas Professor : Sergei Andronikov / Sara Hummell
Questions
Question 1: How many counties are selected and what is the total number of people in them (in 2010) Answer: 623 counties are selected and 56,940,241 people are living in them
Question 2: How many cities in the United States had more than 1 million people in 2007? Answer: 9 Cities in United States have more than 1 million people in 2007.
Question 3: How many counties with more males than females lost population between 2000 and 2010? Where are they mainly located? Answer: 290 counties have more males than females lost population between 2000 and 2010 and they were located mainly in the middle part of the USA.
Question 4: How many counties remain selected? Answer: 177 were selected with population less than 10000
Question 5: How many city names begin with the work New? Answer: 32 cities were there with the name New but not like Newcastle in USA
Question 6: How many counties in the United States are intersected by rivers? Answer: 900 counties in USA are intersected by rivers.
Question 7: Which of these counties containing capitals has the smallest 2010 population? What is the capital and which state is it in? Answer: Hughes has the smallest 2010 population. The capital is Pierre and State is South Dakota.
Question 8: How many US cities are within 20 miles of an interstate highway? Answer: 3321 US cities are within 20 miles of an Interstate highway.
Question 9: What percentage of the cities are within 20 miles of an interstate? Answer: 93.36% of cities are within the 20 miles of an Interstate
Question 10: Which rivers intersect Texas? Answer: Brazos, Canadian, Pecos, Red, Rio Granade are the rivers intersecting the Texas state.
Question 11: Now which rivers are selected? Answer: Flathead and Salt are the rivers selected
Question 12: How many counties will be in the survey? What is the total number of people who live in these counties? Answer: 19 counties will be in the survey and 863,967 total people live in those counties.