Healthcare Data Analysis for Decision Making - Assignment 1

This assignment analyzes healthcare data from an emergency department, focusing on trauma severity, age group response rates, and mortality. Question 1 examines the relationship between trauma severity and gender, analyzes response rates across different age groups, and presents findings through tables and charts. Question 2 investigates mortality rates across various age groups and diseases, including gastroenteritis, respiratory diseases, and heart diseases, with calculations provided. Question 3 utilizes a chi-square test to analyze suicide rates in Europe, comparing urban and rural areas, and provides a conclusion based on the statistical findings and relevant literature.

Running head: HEALTHCARE DATA FOR DECISION MAKING
Healthcare Data for Decision Making
Name of the Student:
Name of the University:
Author note:

1
HEALTHCARE DATA FOR DECISION MAKING
Table of Contents
Answer to the question 1............................................................................................................2
Part (a)....................................................................................................................................2
Part (b)....................................................................................................................................2
Part (c)....................................................................................................................................2
Part (d)....................................................................................................................................2
Part (e)....................................................................................................................................3
Answer to the question 2............................................................................................................4
Answer to the question 3............................................................................................................5
Bibliography...............................................................................................................................7
Answer to the question 1

2
HEALTHCARE DATA FOR DECISION MAKING
Part (a)
Table 1 Cross table Trauma by gender
Summary of finding: Table 1 shows the relationship between trauma severities by gender
Analysis: It has been seen that the severe trauma severity has the highest percentage among
the gender. The percentage of male severe trauma severity is 57.69 % and female is 47.87 %.
Similarly the lowest percentage of severity has been seen in the mild category. In this
category the percentage of male and female is 15.38 % and 22.34%.
Part (b)
The most common severity level is severe.
Part (c)
The relative frequency percentage of male is 52.53%
Part (d)
Table 2 Summary statistics of age group by Response rate
Summary of finding: Table 2 shows the summary statistics of age group by response rate.
Analysis: It has been seen that the maximum number response rate has been seen in the age
group of 60 to 69 and the minimum of response rate has been seen in the age group of 80 or

3
HEALTHCARE DATA FOR DECISION MAKING
above. The mean response rate among three age group is 1396.61, 1449.09 and 1461.86. The
standard deviation of response rate among the three different age group is approximately five
differences from each other. Moreover the highest variability has been seen in the group 60 to
69 and the lowest variability has been seen in more than 80 age group.
Part (e)
60 to 69 70 to 79 80 or more Total
0
5
10
15
20
25
30
35
40
Bar chart on Trauma Severity by Age Group
Trauma severity (mild) Trauma severity (moderate)
Trauma severity (severe)
Class
Frequency
Figure 1 Bar chart on Trauma severity by Age group
Summary of finding: Figure 1 shows the compound bar chart on Trauma severity by age
group. Analysis: In X-axis represent the class of age group and the Y-axis represent the
frequency. Moreover the three different bar shows the mild, moderate and severe trauma
severity.
It has been seen that in 60 to 69 age group mild trauma severity has the highest
frequency and severe severity has the minimum frequency. Similarly in the 70 to 79 age
group the mild has the highest frequency and the moderate severity has the minimum
frequency. Again in the 80 or more age group the severe severity has the highest frequency
and the moderate has the minimum. As a total from all the age group the mild shows the
maximum and the moderate has the minimum frequency.

4
HEALTHCARE DATA FOR DECISION MAKING
Conclusion:
Hence it may be concluded that the trauma severity is fluctuated among all the age
group.
Answer to the question 2
The ratio of death in gastroenteritis in the 0-9 age group is 0.004800. Similarly in 70-
79 age group the death rate is 0.005263.
Again the ratio of death in respiratory disease in the age group 0-9 is 0.0016.
Similarly in 70-79 age group the death rate is 0.010526.
And the ratio of death in heart disease in the age group 0-9 is 0.004. Similarly in 70-
79 age group the death rate is 0.0210526.
From the above three disease it has been seen that in the age group 0-9 the
gastroenteritis disease has the highest death ratio and the respiratory disease has the
minimum. Similarly in the age group 70-79 the heart disease has the highest death ratio and
the gastroenteritis disease has the minimum.
The proportion of death due to respiratory disease is 0.2 and the proportion of death
for heart disease is 0.05.
The annual mortality rate in the age group 20 to 29 is 0.016 and in the 80 + years age
group is 0.047. Hence it may be concluded that the annual mortality has been maximum in
the age group 80 or more.
The odd of dying between 50 to 59 age group are gastroenteritis disease, heart and
respiratory disease. The calculation has been shown in the excel file.

5
HEALTHCARE DATA FOR DECISION MAKING
Answer to the question 3
Chi square test output
Summary: Chi-square test
Analysis:
It has been seen from the chi square test that the P-value (0.19) is larger than the alpha
(0.05). Hence it may be concluded that there is a differences on suicide between the different
country and rural and urban.
No, the views on suicide does not change. Because the urban people are active and
aware different issue and problem. They do not take decision to suicide as compared to rural
people. It is recommended that the people from rural should be aware from all problem and
daily life situation. Due to lack of information awareness this kind of cases has been shown.
Conclusion:

6
HEALTHCARE DATA FOR DECISION MAKING
Yes, today’s life all the people of Europe are active and aware. In modern science and
technology the people from rural does not become backward to do better work as compared
to urban people. Yes thus this shows that in the present time there is no vast difference of
suicide between the rural and urban people of Europe.

7
HEALTHCARE DATA FOR DECISION MAKING
Bibliography
Emanuel, E. J., Onwuteaka-Philipsen, B. D., Urwin, J. W., & Cohen, J. (2016). Attitudes and
practices of euthanasia and physician-assisted suicide in the United States, Canada,
and Europe. Jama, 316(1), 79-90.
McHugh, M. L. (2013). The chi-square test of independence. Biochemia medica: Biochemia
medica, 23(2), 143-149.
Molina, G., Weiser, T. G., Lipsitz, S. R., Esquivel, M. M., Uribe-Leitz, T., Azad, T., ... &
Haynes, A. B. (2015). Relationship between cesarean delivery rate and maternal and
neonatal mortality. Jama, 314(21), 2263-2270.
Plonsky, L. (2015). Statistical power, p values, descriptive statistics, and effect sizes: A
“back-to-basics” approach to advancing quantitative methods in L2 research. In
Advancing quantitative methods in second language research (pp. 23-45). Routledge.