Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I cannot upload the dataset but here is a screenshot of part of it. I think you may still be able to answer without the

I cannot upload the dataset but here is a screenshot of part of it. I think you may still be able to answer without the actual dataset.

image text in transcribedimage text in transcribed
The task is to explore the US census population estimates by county for 2015 from the package usmap (load the data frame from countypop. RData ). The data frame has 3142 rows and 4 variables: fips is the 5-digit FIPS code corresponding to the county; abbr is the 2- letter state abbreviation; county is the full county name; pop_2015 is the 2015 population estimate (in number of people) for the corresponding county. Each row of the data frame represents a different county or a county equivalent. For the sake of simplicity, when we say a county, that also includes a county equivalent and when we say a state, that also includes the District of Columbia. Answer the following questions. a. How many unique 2-letter state abbreviations are there (1 point)? b. What is the total number of counties in the US (1 point)? C. How many unique county names are there (1 point)? d. What are the top 10 most common county names (2 points)? e. Which state has the largest number of counties? Which state has the smallest number of counties (1 points)? f. What is the average population of a county in the US (1 point)? g. Which state has the largest county in terms of population? How many people live in the largest county in terms of population (2 points)? h. What is the largest county in terms of population of each of the states (2 points)? i. What is the average population of the 100 largest counties in the US (2 points)? j. How many people live in each of the states (2 points)? K. What is the average population of a county in California (2 points)? I. What is the average population of a county in each of the states (2 points)?fips abbr county pop 2015 176 05129 AR Searcy County 177 05131 AR Sebastian County 127780 178 05133 AR Sevier County 17290 179 05135 AR Sharp County 16212 180 05137 AR Stone County 12456 18 1 05139 AR. Union County 40144 182 05141 AR Van Buren County 167 71 183 05143 AR. Washington County 225477 184 05145 AR. White County 79161 185 05147 AR. Woodruff County 6741 186 05149 AR. Yell County 21713 187 06001 CA Alameda County 1638215 18 8 06003 CA Alpine County 1110 189 06005 CA Amador County 37001 190 06007 CA Butte County 225411 191 06002 CA Calaveras County 44828 192 06011 CA Colusa County 21482

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Short Course In Automorphic Functions

Authors: Joseph Lehner

1st Edition

0486799921, 9780486799926

More Books

Students also viewed these Mathematics questions

Question

What is A free product or gift?

Answered: 1 week ago