Please include steps and formulas used to complete this task. Thank you!

The population of Utah s growing rapidly. It has increased nearly 25% since 2000. The table below details the esti ated population or each count Complete the tasks to look for trends or patterns in the population growth in the State n Utaho each hear from 2000a 2009 2000 2002 2004 2005 2006 2008 1 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. 10 Add a linear trendline to the "Total Utah Population" chart. (Notice how closely this follows the actual data.) 2 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. 3 15 Total: 27