Statistical Analysis using Excel

Virtual Professional Practice Experience Assignment 7 (15 hours)

Statistical Analysis using Excel Associate/ Bachelor Level

Skill:

 Perform data analysis for healthcare statistics  Demonstrate data display through the use of charts and graphs  Aggregate relevant statistical data  Analyze and report statistical data such as patient days, length of stay, deaths, births,

procedures performed.

Roles incorporating the skill:

 Healthcare Department Heads and Managers  Coding Supervisors  Data Analysts  Cancer Registrar  Medical Office Administrator  Consultants  Revenue Cycle/Reimbursement Managers/Auditors

Delivery areas:

 Healthcare Organizations  State and Federal agencies that gather and report data  Quality Improvement and Risk Management Departments and Organizations  Cancer Registries

 Critical Thinking exercise:

 Use the hospital data provided from the attached spreadsheet to complete the following activities. You will see on the excel file that there are two hospitals PHOMH and PHWMH.

 The discharges tab shows information regarding the payer sources in order to create a pie graphs for each facility.

 The Emergency Department monthly data showing two months of comparison should

be used to create a bar graph demonstrating the variations in volume for each facility's ED. The data reflects 2 months to compare 7/2018 and 7/2019 for PHWMH.

 The discharged data tab provides the information for the inpatient deaths (= expired)

each month for each hospital. The discharge by month tab shows the total inpatient discharges for each hospital. Using excel create a table of reportable inpatient deaths and discharges for each month in the reporting year. Calculate the death rate for each month. Using the data in your table, create a line graph showing the death rate for one full year.

Virtual Professional Practice Experience Assignment 7 (15 hours)

Statistical Analysis using Excel Associate/ Bachelor Level

 The patient days’ tab provides two years’ worth of data - 2018 and 2019 (201801 = January 2018) for both hospitals. Using the patient day’s data, create a line graph demonstrating the trend in patient days over the course of a year for each of the 2 years. You will have two line graphs, one for each year.

 Using the patient days create a word report comparing and analyzing your data

collection and graph and discuss any variations in data and possible causes.

