George Mason University Quantitative Methods in Health Care Management Essay

Peer Video:

1. Nursing homes and hospital administrators implement many initiatives to reduce falls. This problem
shows how these initiatives can be measured and evaluated. Prepare a risk-adjusted control chart
for data on falls in a nursing home and interpret the results.
• Please use the following peer video as a reference for this assignment. You can find the
solution herehere – Alternative Formats .
2. The following data were obtained on post surgical infection rates. Are we having more infections than
expected from the patients’ conditions?
• You can find the solution here here – Alternative Formats .
Week
Risk of Infection for each Patient
Number Infected
1
0.9
0.8
0.7
0.8
0.9
0.85
6
2
0.7
0.8
0.7
0.6
0.8
0.9
5
3
0.8
0.95
0.92
0.87
4
4
0.5
0.6
0.66
0.67
3
5
0.3
0.4
0.5
0.4
0.5
0.34
2
6
0.3
0.4
0.5
1
3. The data below display the number of SARS (a virus similar to Covid-19) patients who
suffered from a number of comorbidities
(e.g., diabetes, heart disease, etc.) and were admitted to the hospital with severe
respiratory issues over a 24-day period. The number
of those who died is shown as well. Give this data set, answer the following:
a) As a health care professional, state a question related to this data that you could
answer using a p-chart.
b) Use a p-chart (plot the data using Excel) to answer this question and interpret the
results.
Days
Number of SARS patients with
Number of patients who died
comorbidities admitted with
respiratory issues
1
56
11
2
53
12
3
45
11
4
44
12
5
46
4
6
50
12
7
48
15
8
48
13
9
42
9
10
46
14
11
41
10
12
55
12
13
48
14
14
58
19
15
62
17
16
72
24
17
57
13
18
60
13
19
20
21
22
23
24
65
100
77
76
84
73
15
25
24
16
15
15
Instructions
In order to complete this assignment, you must submit an Excel file with each question answered in a
separate sheet. Copy both the question prompts and your answers to the file.
Fall Risks in each time period for each case
Case
Time 1
Time 2
Time 3
Time 4
Time 5
Time 6
Time 7
Time 8
1
0.25
0.55
0.4
0.15
0.55
0.75
0.2
0.35
2
0.4
0.25
0.7
0.45
0.6
0.45
0.15
0.8
3
0.7
0.4
0.6
0.7
0.45
0.05
0.1
0.5
4
0.4
0.45
0.55
0.8
0.5
0.9
0.25
0.55
5
0.15
0.2
0.7
0.45
0.65
0.5
0.6
0.75
6
0.2
0.65
0.6
0.6
0.65
0.6
0.7
0.35
7
0.5
0.1
0.55
0.25
0.25
0.7
0.4
0.6
8
0.5
0.5
0.3
0.1
0.35
0.35
0.35
0.45
9
0.3
0.75
0.65
0.8
0.6
0.65
0.5
0.3
10
0.2
0.35
0.6
0.4
0.4
0.4
0.75
0.65
11
0.4
0.65
0.05
0.25
0.35
0.6
0.65
0.75
12
0.3
0.2
0.25
0.65
0.1
0.25
0.7
0.4
13
0.45
0.65
0.45
0.8
0.4
0.75
0.55
0.45
14
0.25
0.3
0.65
0.25
0.5
0.3
0.65
0.55
15
0.25
0.25
0.7
0.6
0.25
0.25
0.7
0.35
16
0.4
0.45
0.6
0.8
0.65
0.4
0.35
0.75
17
0.45
0.3
0.25
0.85
0.25
0.75
0.65
0.6
18
0.35
0.5
0.75
0.45
0.45
0.75
0.4
0.25
19
0.25
0.75
0.5
0.7
0.55
0.7
20
0.1
0.6
0.2
0.6
0.7
5
6
21
Reported
Falls
0.5
0.65
0.45
8
6
7
8
4
5
Time 9
0.4
0.5
0.25
0.7
0.4
0.55
0.3
0.75
0.2
0.6
0.55
0.6
0.65
0.75
0.6
0.75
0.45
0.45
4
Question 2: Comparison of Rates
Farrokh Alemi, PhD