Unit 3 Assignment: Calculating and Charting Basic Health Care Data Unit Outcomes addressed in this assignment: Calculate basic statistics from provided data.Understand how to chart worksheet data.Crea

Unit 3 Assignment: Calculating and Charting Basic Health Care Data

Unit Outcomes addressed in this assignment:

• Calculate basic statistics from provided data.
• Understand how to chart worksheet data.
• Create an embedded chart or one on its own chart sheet.
• Format the elements in a chart.
• Select the appropriate type of chart for a given set of data.

Course Outcomes addressed in this assignment:

HI230-3: Explain the principles of quality assurance in health information management.

HI230-5: Measure the performance of a healthcare facility through standard metrics.

Instructions:

• Download the data file for this assignment,HI230 Unit 3 Assignment Patient Census Data: ABC Medical Center
• Using the provided nominal data, create a column/bar chart depicting the data by type of visit. Include data labels on the outside of each bar and include a chart title.
• Using the provided nominal data, create a pie chart depicting the breakdown by patient status. Include percentage labels and include a chart title.
• Calculate the average (mean) length of stay by month for data provided. Create a line chart by month for the average length of stay (LOS). Set your average to 2 decimals, include labels above the marker and include a chart title.

Table: Monthly Average LOSJanFebMar[Continue all months]Average LOS

Requirements: Your charting assignment should:

• include the data table and 3 specified charts--either embedded or as separate chart pages
• be saved as a single MS Excel .xlsx workbook containing the data table and all charts