Instructions
This prompt is based on Chapter 8, Exercise #1 in your textbook, but I am revising the instructions. Instead of creating graphics using college admissions data, I would like you to do so using COVID-19 data, and I have provided three different sources for the data below. We will skip the map and just do a table, a bar graph, and a pie chart; submit all three in a single Word or PDF document.
A.) Create a Table
In your table, create eight columns titled “Country,” “Population,” “Vaccinated,” “Percentage Vaccinated,” “Cases,” “Percentage Infected,” “Deaths,” and “Percentage Fatal.” Then create six rows below the column titles to input COVID-19 data from Johns Hopkins University from these six different countries: Portugal, United Kingdom, United States, India, Russia, and South Africa. For the Population, use the data on this population map from the U.S. Census Bureau, which has slightly different figures than it appeared Johns Hopkins used, so the percentages vaccinated will be slightly different. You can also use these population numbers for determining “Percentage Infected” and “Percentage Fatal.”
B.) Create a Bar Graph
Using the data in this spreadsheet from the Centers for Disease Control (CDC), create a standard bar graph for COVID-19 deaths by age. Use the eight age groups 0-17, 18-29, 30-39, 40-49, 50-64, 65-74, 75-84, and 85 years and older.
C.) Create a Pie Chart Using the data from this webpage from the CDC detailing hospital admissions, create a pie chart of total COVID-19 cases (near the top of the page), showing the portions of hospitalizations (“Total Admissions” on this page) and deaths.
I will post links to tutorial videos in this same lesson folder showing how to create these graphics in Word.
Instructions This prompt is based on Chapter 8, Exercise #1 in your textbook, bu
Get any assignment done by a Professional, Skilled Expert!
In-time submission and academic quality are guaranteed.
✅ 24/7 Support, ✅ Money Back Guarantee, ✅ 100% Original
Get any assignment done by a Professional, Skilled Expert!
In-time submission and academic quality are guaranteed.
✅ 24/7 Support, ✅ Money Back Guarantee, ✅ 100% Original
Discover more from Elite Homework Helpers
Subscribe to get the latest posts sent to your email.
by
Tags: