MAP 1
MAP 2
Questions
Question 1: How many counties are selected and what is the total number of people in them (in 2010)
Answer:
44 counties were selected and the total population in them is 1,568,055
Question 2: How many cities in the United States had more than 1 million people in 2007?
Answer:
9 cities in USA have more than 1 million population
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, Pierre and South Dakota are three counties containing capital with lowest population in 2010.
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,967total people live in those counties.
Question 13: Determine how many people live in cities that are within 50 miles of the state capital.
Answer:
3904580 people are with in the 50 miles of state capital.
Question 1: How many counties are selected and what is the total number of people in them (in 2010)
Answer:
44 counties were selected and the total population in them is 1,568,055
Question 2: How many cities in the United States had more than 1 million people in 2007?
Answer:
9 cities in USA have more than 1 million population
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, Pierre and South Dakota are three counties containing capital with lowest population in 2010.
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,967total people live in those counties.
Question 13: Determine how many people live in cities that are within 50 miles of the state capital.
Answer:
3904580 people are with in the 50 miles of state capital.
Exercises
Exercise 1: How many states have counties names for Thomas Jefferson? Which state has the Jefferson county with the most people in the year 2010?
Answer:
a. 26 Jefferson Counties
b. Jefferson, Kentucky had a highest population in 2010
Exercise 2: How many counties in the US have more men than women? What percentage of the counties do they represent?
Answer:
a. 822 counties have more than women than men
b. 26.1% of total counties
Exercise 3: How many cities in the US have more than Hispanics than African Americans, a median age greater than 40, and a population between 50,000 and 100,000? List the names of the thee largest.
Answer:
23 counties meet all criteria
Exercise 4: What percentage of counties in the US has a river intersecting them? What percentage of the US population live in these counties?
Answer:
900 Counties in US have River intersecting them and 28.6% of total US population live in these counties.
Exercise 5: How many counties have more than 1 million people and contain a state capital? List the states these counties are in.
Answer:
6 counties have a state capital and also more than 1 million people
They are Franklin, Fulton, Maricopa, Sacramento, Salt Lake, Travis
Exercise 6: How many cities are within 50 miles of a volcano? What is the total number of people living in those cities?
Answer:
a. 142 cities are within the distance of 50 miles from Volcano
b. 5,927,959 people live in those cities.
Exercise 7: How many other volcanoes are within 300 miles of Crater Lake, a volcano in Oregon? How many of these volcanoes are also within 50 miles of an interstate?
Answer:
a. 36 volcanoes are there with in the distance of the 300 miles from the Crater Lak
b. 15 cities are with in the distance with in 50 miles of the interstate
Exercise 1: How many states have counties names for Thomas Jefferson? Which state has the Jefferson county with the most people in the year 2010?
Answer:
a. 26 Jefferson Counties
b. Jefferson, Kentucky had a highest population in 2010
Exercise 2: How many counties in the US have more men than women? What percentage of the counties do they represent?
Answer:
a. 822 counties have more than women than men
b. 26.1% of total counties
Exercise 3: How many cities in the US have more than Hispanics than African Americans, a median age greater than 40, and a population between 50,000 and 100,000? List the names of the thee largest.
Answer:
23 counties meet all criteria
Exercise 4: What percentage of counties in the US has a river intersecting them? What percentage of the US population live in these counties?
Answer:
900 Counties in US have River intersecting them and 28.6% of total US population live in these counties.
Exercise 5: How many counties have more than 1 million people and contain a state capital? List the states these counties are in.
Answer:
6 counties have a state capital and also more than 1 million people
They are Franklin, Fulton, Maricopa, Sacramento, Salt Lake, Travis
Exercise 6: How many cities are within 50 miles of a volcano? What is the total number of people living in those cities?
Answer:
a. 142 cities are within the distance of 50 miles from Volcano
b. 5,927,959 people live in those cities.
Exercise 7: How many other volcanoes are within 300 miles of Crater Lake, a volcano in Oregon? How many of these volcanoes are also within 50 miles of an interstate?
Answer:
a. 36 volcanoes are there with in the distance of the 300 miles from the Crater Lak
b. 15 cities are with in the distance with in 50 miles of the interstate