Question

am at a loss here am I dividing the percentages or multiplying something. the year and the population I think any help please and thanks

日か Insert Draw Page Layout Formulas Data Review ViewHelp AutoS gtq1eU 44 urban.xlsx - Excel Tell me what you want to do Cut AutoSum A General E Copy Ein- | 의·ム ヨFEE 트트 를Merge & Center. : Conditional Format as Cell Insert Delete Format Sort &Find & Filter Select B l u. $. % , Format Painter Clear Formatting Table Styles Styles Font Alignment Number Cells Editing 1 Census 3 1790 5 1810 Increase Urban Rural The spreadsheet lists the population in the United States and also the percent urban/rural. YearPopulation Increase 3,929,214 Urban 94.9 93.9 92.7 92.8 91.2 10.889.2 a.) Compute the total change and % change in us. population for each decade. 7 1830 12,860,702 8 1840 17,063,353 91850 23,191,876 10 1860 31,443,321 11 1870 38,558,371 12 1880 50,189,209 13 1890 62,979,766 14 1900 76,212,168 15 1910 92,228,496 16 1920 106,021,537 17 1930 123,202,624 18 1940 142,164,569 19 1950 161,325,798 20 1960 189,323,175 21 1970 213,302,031 22 1980 236,542,199 231990 258.709.873 8.8 84.6 b.) Compute the actual urban population and rural population for each year. 80.2 28.2 35.1 39.6 45.6 1.8 64.9 60.4 c.) Make a stacked area chart of the urban and rural population. 56.1 56.5 43.9 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: 43.5 69.9 30.1 73.6 26.3 1. The area of the rural regions continues to shrink. 2. The total population continues to grow #4 Urban + 100% 11:48 PM 3/22/2019 0V

Answer 1

  

Bocki- Excel (Product Activation Failed) HOME INSERT PAGE LAYOUT FORMULAS DAIA REWIEW VE Gang AutoSum A Conditional Format as Neutral Formatting Table Caleulation Check Cell Insert Delete Format Sort & Find& ilter Select Format Painter 179039,29,214 1B0O53,08,183 13,79,269 25.98236 18102,39,81 19,31,398 26.63721 1820 96,38,453 23,98,572 24.88545 18301,8,60,70 32,2,249 5.055 94.9 200389.914 93.9 323817.163 84.6 1114941.674 92.8 G693968.616 91.2 1131741.776 1,17,28,960 17,28,824 19,81,666 61,24,939 89,44,484 6.1 Chart Title 7.2 1B40 17063353 42,02,651 24.6296910.89.2 1842842.124 1,52,20,511 1B50 23191876 61,2B,523 26.1253 15.1 81.6 3571518.901 1,96,20,327 80.2 6225777.558 2,52,17,543 4.3 9903501.347 2,86,48,870 71.8 14153356.94 3,0,35,852 13190 62979766 1,27,90,557 20.30899 351 64.9 22105897.87 4,08,73,868 111900 76212168 1,32,32,102 17.362583 30180018.53 1,60,32,119 54.4 42056194.18 5,01,/2,302 48,8 54283026.94 5,17,38,510 17 1930 123204 1,71,81,087 13.945396.143.9 69116672.06 5,40,85,952 10 180 31443321 8,51445 26.24228 1870 38558371 71,15,050 18.45267 1890 5018209 1,16,30,838 23.17398 19.8 25.7 12 15 16 1910 92228496 1,60,16,328 17.35592 1920 106021537 1,37,93,041 13.00366 45.6 1 2 4 , B y 1U 11 12 13 14 15 1b 1, 18 19 20 21 18 19 20 21 1940 142164569 1,89,61,945 13.33802 1950 161325798 1,91,61,229 11.B7735 1960 18932315 2,79,97,37 14.78814 1970 213302175 2,39,79,000 11.2418 190 36542199 2,32,40,024 9.824996 56.5 43.5 80322981.49 6,18,41,5BB 36 103218510.7 5,80,77,287 30.1 132336899.3 5,69,86,276 26.4 156390400.8 5,63,11,774 6.3 1743316007 6,22,10,598 231990 25,87,09,873 2,21,67,674 8.568546 75.224.8 194549824.5 641,60,049 Stacked Area chart of Rural and urban population 69.9 73.6 73.7 1 Urban Series Rural 21 dl This is because the total population increases on a steady note form 1940 onwards tending to an increase in The rural population is steady around 60 million people from 1940 but % rural decreases 26 population making raral constant 28 30 Sheet1舟 ョ圜凹- + 100% O Type here to search rP ^ D4bG 에 ENG 23-03-2019 2