# US Population Problem Census Year 1790 1810 1820 1830 1840 1...

## Transcribed Text

US Population Problem Census Year 1790 1810 1820 1830 1840 1850 1860 1870 1880 1890 1900 1910 1920 1930 1940 1950 1960 1970 1980 1990 Total Increase Urban Population Increase % % 3,929,214 - - 5.1 7,239,881 9,638,453 12,860,702 17,063,353 23,191,876 31,443,321 38,558,371 50,189,209 62,979,766 76,212,168 92,228,496 106,021,537 123,202,624 142,164,569 161,325,798 189,323,175 213,302,031 236,542,199 258,709,873 15.4 7.2 8.8 10.8 15.4 19.8 25.7 28.2 35.1 39.6 45.6 51.2 56.1 56.5 64 69.9 73.6 73.7 75.2 94.9 1800 5,308,483 6.1 93.9 92.7 92.8 91.2 89.2 84.6 80.2 74.3 71.8 64.9 60.4 54.4 48.8 43.9 43.5 36 30.1 26.3 26.3 24.8 Rural % Urban Rural The spreadsheet lists the population in the United States and also the percent urban/rural. a.) Compute the total change and % change in U.S. population for each decade. b.) Compute the actual urban population and rural population for each year. c.) Make a stacked area chart of the urban and rural population. d.) Notice the rural population is relatively steady around 60 million people from 1940 on, but the % rural steadily decreases. Choose the correct reason for this: 1. The area of the rural regions continues to shrink. 2. The total population continues to grow. 2000 291,421,906 80.7 19.3 2010 308,745,538 80.9 American Eels Problem 19.1 Part d: YEAR 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 SPECIES ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER ELVER METRIC TONS POUNDS(thousands) VALUE(millions) 3.33 7.347 \$0.40 7.53 16.599 \$3.82 4.62 10.179 \$2.24 3.34 7.36 \$1.54 6.55 14.431 \$2.28 1.73 3.818 \$0.12 1.19 2.625 \$0.16 0.77 1.687 \$0.04 4.38 9.654 \$0.28 1.51 3.325 \$0.08 0.58 1.282 \$0.12 2.48 5.476 \$1.30 3.16 6.967 \$0.43 1.68 3.714 \$1.29 3.15 6.9515 \$1.49 2.36 5.199 \$0.52 1.43 3.158 \$0.58 3.89 8.585 \$7.65 9.42 20.764 \$38.76 8.2 18.076 \$32.93 4.4 9.6902 \$8.47 2.39 5.2594 \$11.42 PRICE/LB CPI 2013\$/lb Total Change Percent Change The spreadsheet gives data on the catch in Maine of baby American eels, also known as glass eels for their translucent appearance, or elvers. Eels do not reproduce in captivity thus baby eels must be caught and raised in aquaculture operations to satisfy demand in Asia. 148.2 152.4 156.9 160.5 163.0 166.6 172.2 177.1 179.9 184.0 188.9 195.3 201.6 b.) Use the CPI values to convert the Price/lb into 2013\$/lb. a.) Compute the Price/lb. 207.342 215.303 214.537 218.056 224.939 229.594 232.957 236.736 237.017 c.) Compute the annual total change in 2013\$/lb and the percent change. d.) Make a well-labeled line chart showing the % change over time.

## Solution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

By purchasing this solution you'll be able to access the following files:
Solution2.xlsx and Solution1.xlsx.

\$43.00
for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

### Find A Tutor

View available Algebra Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

• 1
• 2
• 3
Live Chats