Visualizing with Charts and Graphs using Excel

User Generated

unlqra69sna

Business Finance

Description

Use the attached U.S. Census Bureau data and instructions to create the required charts and graphs.

Unformatted Attachment Preview

Part 3 Instructions 1 2 3 4 5 6 7 Part 3 Instructions The US Census Bureau would like to examine population trends between different regions. Using the data collected in the "Region Population (Historical)" sheet, insert both a stacked and a 100% stacked column chart containing columns by year. Include titles or legends as appropriate. The Bureau is trying to decide the future of population growth by age group. The second sheet, "Age Population (historical)," contains information on the percentage of the US population that falls within selected age groups. Use the data to create three charts: a line chart, a stacked line chart, and a 100% stacked line chart. Place the charts below the data in the same worksheet and label appropriately. The "Metropolitan Pop (2007-12)" worksheet provides information on the population growth of the ten most populous metropolitan areas. Generate three charts—a column chart, bar chart, and line chart—that summarize the data, making sure to include titles if needed. Place the preferred chart in a new worksheet called "By Metropolitan Area" and the other two charts below the data. Move the new sheet immediately after the sheet containing the original data. You would like to put together a pie chart for 2007-08. Insert a pie of pie chart with a cutoff of fields with a population of fewer than 5,000,000 being relegated to the smaller pie. The bigger pie pieces should appear in order by population number. Use the "point explosion" feature to offset the combined pie segment. Move the chart to its own worksheet, entitled "Pie of Pie," and place it immediately after the "By Metropolitan Area" sheet. Insert a bar of pie chart for 2008-09 with the same cutoff and point explosion mentioned above. Move the chart to its own workseet, entitled "Bar of Pie" and place the sheet immediately after the "Pie of Pie" sheet. The "Fast Growing Pop (2007-12)" worksheet provides information on the population growth of the ten fastest-growing metropolitan areas. The Bureau is interested in the long-term trends in population growth for these areas. Sparklines provide a quick look at the major trends in data. Insert two different forms of sparkline, one set in the row below the data (Row 13) contrasting areas within a year, and the other immediately to the right in column G comparing an area through the period of years. Choose the most appropriate sparkline. Include both high point The three fastest-growing areas are Palm Coast, St. George, and Las Vegas. To quickly visualize national changes in these three areas between 2007 and 2012, insert a doughnut chart containing only those fields in those specific years. Include a legend and chart title that makes the content clear. Place the chart to the right of the data. United States Population by Region Region: Northeast Midwest West South 2000 53,666,295 64,491,431 63,439,136 100,565,549 2005 54,451,230 65,751,872 67,833,726 107,479,771 2010 55,387,174 66,977,505 72,119,326 114,862,858 2015 56,283,891 67,907,403 76,044,679 121,182,847 Population by Age Groups Age 2013 2014 Under 18 26% 24% 18-24 10% 10% 25-44 30% 27% 45-64 22% 26% 65 and over 12% 13% Total 100% 100% 2015 25% 11% 25% 24% 15% 100% 2016 21% 11% 29% 23% 16% 100% Population Growth for the Ten Most Populous Metropolitan Areas Area 2007-08 2008-09 2009-10 2010-11 2011-12 NY 17,596,302 17,692,920 18,093,431 18,323,002 18,897,109 LA 11,302,592 11,903,932 12,265,627 12,365,627 12,828,837 Chicago 8,403,029 8,502,921 8,705,240 9,098,316 9,461,105 Dallas 4,503,677 4,982,281 5,075,893 5,161,544 6,371,773 Philadelphia 5,057,709 5,209,391 5,402,182 5,687,157 5,965,343 Houston 4,715,407 4,931,215 5,528,076 5,840,192 5,946,800 DC 4,294,946 4,201,391 4,503,923 4,796,183 5,582,170 Miami 4,201,586 4,240,395 4,830,482 5,007,564 5,564,635 Atlanta 3,850,381 3,940,281 4,038,281 4,247,981 5,268,860 Boston 3,945,671 4,028,643 4,289,521 4,391,344 4,552,402 Population Growth for the Ten Fastest-Growing Areas Area Palm Coast St. George Las Vegas Raleigh-Cary Cape Coral Provo-Orem Greeley Austin Myrtle Beach Bend 2007-08 49,832 90,354 1,375,765 797,071 440,888 376,774 180,926 1,249,763 196,629 115,367 2008-09 55,928 92,121 1,602,945 940,292 490,192 402,921 183,023 1,492,021 209,921 134,940 2009-10 60,918 95,104 1,830,992 105,381 592,033 438,012 200,492 1,582,039 229,406 153,022 2010-11 73,043 120,958 1,805,692 107,382 601,855 463,828 204,291 1,730,921 246,986 142,103 2011-12 95,696 138,115 1,951,269 1,130,490 618,754 526,810 252,825 1,716,289 269,291 157,733
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached is the excel ...


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags