Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How many people (age 25 and over) in the U.S. have not attained education past the 2 nd grade? [I will use the sum of

How many people (age 25 and over) in the U.S. have not attained education past the 2nd grade? [I will use the sum of 3002 to 3006]

Which state in the U.S. has the highest ratio of people who have not completed any schooling?

Which U.S. county has the highest proportion of individuals 25 or over who have completed a Doctorate Degree? (Means numDoctorates/totalPop)

image text in transcribed

this is short portion of data, we can ignore other states. assume first row in Dallas second Tarrant

ACS18_5yr_B15003001 ACS18_5yr_B15003002 ACS18_5yr_B15003003 ACS18_5yr_B15003004 ACS18_5yr_B15003005 ACS18_5yr_B15003006 ACS18_5yr_B15003007 ACS18_5yr_B15003008 ACS18_5yr_B15003009 ACS18_5yr_B15003010 ACS18_5yr_B15003011 ACS18_5yr_B15003012 ACS18_5yr_B15003013 ACS18_5yr_B15003014 ACS18_5yr_B15003015 ACS18_5yr_B15003016 ACS18_5yr_B15003017 ACS18_5yr_B15003018 ACS18_5yr_B15003019 ACS18_5yr_B15003020 ACS18_5yr_B15003021 ACS18_5yr_B15003022 ACS18_5yr_B15003023 ACS18_5yr_B15003024 ACS18_5yr_B15003025
37166 287 0 0 23 0 70 22 3 122 108 321 840 892 849 667 10104 2015 2235 5319 2998 5903 3406 510 472
146989 1355 14 46 0 0 61 227 96 515 343 1321 2012 3314 2742 2264 33308 7271 9930 22336 13759 30431 11338 2992 1314

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

Step: 3

blur-text-image

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

MySQL/PHP Database Applications

Authors: Brad Bulger, Jay Greenspan, David Wall

2nd Edition

0764549634, 9780764549632

More Books

Students also viewed these Databases questions