DATA ANALYSIS

1.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.

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

3. 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.

4. 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.

5. 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.

6. 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.