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.
Electronic Health Records · Patient Data · Data Management · Data Mining · Data Cleaning · Descriptive Statistics · Heroin-Related Deaths · Drug-Related Deaths · Excel Data Analysis · Data Sorting · Bar Chart · Scatterplot
Megaminds has supported academic requirements in understanding patient data, understanding patient data and related disciplines.