Utah Population The population of Utah is growing rapidly. It has increased nearly 25% since 2000. The Utah Population table details the estimated population for each county in Utah for each year from 2000 to 2009. Complete the tasks to look for trends or patterns in the population growth in the State. Task # Points Task Description Construct a line chart to examine the "Total Population" growth (row 35 of the worksheet) for the years 2000-2009. Format the chart with the title "Total Utah Population and a legend to the right of the chart. Use the dates in row 5 of the worksheet as the labels for the horizontal axis. 1 10 N 2 Add a linear trendline to the "Total Utah Population chart. (Notice how closely this follows the actual data.) 15 Construct a line chart to compare the population growth for the years 2000- 2009 in the following counties: Davis, Salt Lake, Utah, and Weber. Format the chart with the title "Population in Selected Counties and a legend to the right of the chart. Use the dates in row 5 of the worksheet as the labels for the horizontal axis Total: 27 Home Insert Insert Draw Page Layout Formulas Data Review View Assignment Tell me insert Calibri (Bodyl + A A General ZY WOO Paste B TV A CF Conditional Formatting F Formatos Table Cell Styles Stres I? Delete Format U JE Sort FRE Ear Font Ali Nanter Cers Cicbeard Al 3 D D H K 1 The population of this growing rady has increasince 2008 The table below as the estimated with county in Utah for each year from 2000 to 2005 complete the stock for rent in the population within the State CORE 4,113 t 2003 5.990 45.7 100,173 19,665 887 356,175 14.2 10,49 2009 6,267 45.902 115,200 19,95 941 300,027 10 23 14 15 16 17 nd 21 er 19 ng 20 21 County ver County Down Cache Court Cwton County Derett County David County Duches County mery County Guild County Orwd County Iron County Buab County Kane County Mild County Mora Corty Pute County Ruth County Salt Cum San Juan County Sanpety Ser County ummit County Toodle County Cott U COUNTY Watch County Within County Wwenty Weber County tota lopulta 2000 6,010 12,872 91.373 20,154 921 240,293 14,371 10,546 4,748 8,199 33,90 2.221 6.079 12,195 7.155 141 1,464 SO1,051 14,173 22,0 10 29.987 41615 25.253 11.40 15.017 110 2.529 127.00 2. 2001 6,003 43.632 93,298 19.491 521 244578 14,540 10,65 4,657 2,515 34,724 2,186 5,055 12.100 7,19 1,197 1921 114 116 13,1 5,040 44,522 97,277 19,145 ERR 249,335 14,796 1053 4550 2716 3,640 2.473 5.994 12,22 7400 1,1 1.826 93451 13.276 23.230 18, 11,63 45,577 26.173 197,200 16,735 99,412 2514 104 2.1 2004 5,998 65,575 102, 1941 514 262.689 14327 10,165 4.18 BASI 17010 3,777 01 11,90 7.551 1,874 2013 54,271 11,928 21.12 10.101 3706 411/06 26.466 414,114 1727 110,294 3415 110.442 7:45 2005 2006 6,067 45 46,722 104540106,299 19 150 19,202 916 924 269.695 279037 15,133 1546 1031 10,264 4,119 4.374 9.066 9.291 19,298 41203 5,132 6.167 6410 11.491 11,89 7.752 Ro 1.362 1,350 2005 1.972 560.067 85.482 13,887 11.964 23,717 23/16 19,031 19,160 A 14,30 S0092 52,153 26 22 103 612201 11.126 19,891 119,119 126,720 240) 2462 213667 216.165 2419 2,582724 3,793 16,061 1,50 6.00 12,151 7.444 1,165 2007 936,378 1122 23,112 18.30 32.44 47,331 20160 09:45 1712 104.14 24 207457 2.179316 2007 5068 47,63 108,655 39,666 504 287, 16,191 10.140 4,499 9,423 41,231 9,551 4.454 11,886 BARB 11 2,053 1,002,425 14,370 SES 19.602 154 54.220 2911 $12.900 20,31 132256 248) 221,044 2008 5.162 4905 111,873 19,665 912 295,061 16,926 10,470 4,600 9,598 44,194 090 G.SE 12,095 1,744 1.400 2.141 1,018.527 14.168 25,514 19,961 16,200 56,865 29 834 30,629 4,675 9,660 45,20 10,744 6.601 12,276 Sca 1,411 2.100 1,034905 15.069 25 18,670 36,00 23 Te 24 e 25 26 PITE CISTE SCO in 20 KIC CE 42,720 25.097 # US 22 S. 33 16,000 94624 2,507 2003 2.2013 30,96 1678 2,50 227,193 2.222.14) 31.536 545307 2000 137.471 2,601 28.01 PE SE Education Apple PC Sales Utah Population
