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.

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