Do your tables and charts suggest a disproportionate burden of the illness among age groups

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Q1[20 points] Use the worksheet Covid_Cases_by Age_Race in A3 Excel File to answer this question. The data on the worksheet is a perfect representative sample of the Health Department dataset that contains data on the number of cases of the Coronavirus Disease 2019 (COVID-19) by different age groups in New York City. The data has been retrieved from https://www1.nyc.gov/site/doh/covid/covid-19-data.page. - 1 - Using the Patient Age Group variable: a) Prepare a frequency table and share it in your Word/pdf file. b) Prepare a relative frequency table and share it in your Word/pdf file. c) Prepare Pareto Charts for both Frequency Table and Relative Frequency Tables share it in your Word/pdf file. d) Comment on the tables and explain your results. e) Do your tables and charts suggest a disproportionate burden of the illness among age groups? Explain. Q2[20 points] Use the worksheet Covid_Cases_by Age_Race in A3 Excel File to answer this question. The data on the worksheet is a perfect representative sample of the Health Department dataset that contains data on the number of cases of the Coronavirus Disease 2019 (COVID-19) by different race groups in New York City. Data on people identified as other categories, including Native American/Alaska Native or multi-racial, are not provided here. The data has been retrieved from https://www1.nyc.gov/site/doh/covid/covid-19-data.page. Using the Patient Race Group variable: a) Prepare a frequency table and share it in your Word/pdf file. b) Prepare a relative frequency table and share it in your Word/pdf file. c) Prepare Pareto Charts for both Frequency Table and Relative Frequency Tables, nicely title them and share them in in your Word/pdf file. d) Comment on the tables and explain your results. e) Do your tables reveal continued deep disparities by race? Explain.

Attachments:

Expert's Answer

673 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme