Data Presentation: NJ OSME Drug-Related Deaths in NJ Counties
This assignment focuses on data presentation and management using drug-related death data from New Jersey counties. The assignment is part of the Understanding Patient Data course and develops practical skills in inspecting, cleaning, organizing, analyzing, and presenting patient-related datasets using Microsoft Excel. Students are required to use the data provided in the file “5.3a Chart on Drug Deaths by NJ County (2015)” and input the county-level information into an Excel spreadsheet. The assignment requires students to inspect and clean the data where necessary, including removing, imputing, and explaining incomplete data entries. Students must also organize and sort the data and obtain descriptive statistics for heroin drug-related deaths and a second variable of their choice. The analysis includes creating descriptive statistics for four variables and comparing the descriptive statistics of heroin with a selected variable. Students must create a copy of the original dataset on a separate worksheet, sort total deaths from largest to smallest, and create a 2-D bar chart and scatterplot. The charts are then used to develop interpretive statements about heroin-related deaths based on the combined analysis of the visualizations. The assignment also requires students to use descriptive statistics to compare the central tendency of three specified variables: Cocaine, Fentanyl, and Oxycodone. A separate worksheet must contain a key or log explaining variable names, abbreviations, and terms used in the dataset. The assignment develops practical skills in Excel-based healthcare data analysis, descriptive statistics, data visualization, interpretation of patient data, and data management. The grading criteria include data input and cleaning, descriptive statistics, sorted data, bar chart creation, scatterplot presentation, and interpretive analysis. The completed assignment must be submitted electronically in Microsoft Excel (.xls or .xlsx) format.
Read Model Answer →