Problem 1: Using the following data, prepare a run chart, scatter chart, and control chart. A late surgery is defined as any surgical operation that was started more than 30 minutes after its scheduled time (Table).
Table: Number of Late Surgeries
|
Month
|
Number of Surgeries
|
Number of Late Surgeries
|
|
January
|
435
|
112
|
|
February
|
401
|
129
|
|
March
|
572
|
186
|
|
April
|
409
|
103
|
|
May
|
577
|
89
|
|
June
|
329
|
67
|
|
July
|
467
|
156
|
|
August
|
301
|
94
|
|
September
|
235
|
89
|
|
October
|
325
|
127
|
|
November
|
378
|
156
|
|
December
|
444
|
124
|
|
|
|
|
|
Total
|
4873
|
1432
|
Calculate the moving range b
- Table: Number of Student Complaints by Complaint Type
|
Complaint Type
|
1
|
2
|
3
|
4
|
5
|
6
|
Total Visits
|
|
September
|
34
|
38
|
16
|
45
|
13
|
103
|
824
|
|
October
|
23
|
24
|
7
|
40
|
9
|
56
|
956
|
|
November
|
14
|
50
|
11
|
20
|
26
|
34
|
1167
|
|
December
|
67
|
40
|
12
|
17
|
34
|
9
|
1034
|
|
January
|
13
|
31
|
10
|
12
|
15
|
45
|
645
|
|
February
|
20
|
60
|
4
|
13
|
9
|
6
|
1645
|
|
March
|
23
|
97
|
18
|
23
|
4
|
3
|
1432
|
|
April
|
43
|
31
|
3
|
14
|
13
|
0
|
745
|
|
May
|
4
|
25
|
0
|
12
|
16
|
1
|
456
|
|
Total
|
241
|
396
|
81
|
196
|
139
|
257
|
8904
|
- Complaint
- 1.The quality of service received
- 2.Waiting time was too long
- 3.Follow-up care was not available
- 4.Clinic was hard to find in the building
- 5.The medical care/treatment took too long
- 6.They could not find my medical record
Case Study 2: Quality Analysis
The ambulatory health service at a university is experiencing an increased number of student complaints concerning the services it offers in its walk-in urgent care clinic. Using the data in Table 14-5 on page 296 of the textbook, select a complaint for analysis. Your analysis must include a fish-bone chart, other appropriate charts (run and / or control), and any other techniques you deem necessary to analyze the data appropriately.
Write a two to three (2-3) page paper in which you:
- Construct a fish-bone chart using Word or MS Paint.
- Construct a run and / or control chart using Excel.
- Recommend to the ambulatory health service on how it can improve the services it offers in its walk-in urgent care clinic, based on your analysis. Provide a rationale for your recommendation.
Your assignment must follow these formatting requirements:
- Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format.
- Include a cover page containing the title of the assignment. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:
- Analyze projects using the tools of quantitative methods.
- Write clearly and concisely about quantitative methods for health services using proper writing mechanics.
Problem 3:
Using the following data set on hospital admissions, define the service area for Hospital A, based only on quantitative factors.
Compute the target bed capacity of Cheswick Community Hospital 10 years from now, based on the following information: Assume current population of Cheswick Community Hospital's service area = 145,000 Assume projected population increase of 8% in service area over the next 10 years.
Table: Hospital Admissions, by Community
|
Community
|
Hospital A
|
Hospital B
|
Hospital C
|
Other Hospitals
|
|
North
|
45
|
64
|
76
|
123
|
|
South
|
159
|
324
|
12
|
521
|
|
East
|
65
|
24
|
137
|
311
|
|
West
|
145
|
68
|
95
|
113
|
|
Central
|
32
|
56
|
78
|
159
|
|
Upper
|
29
|
84
|
45
|
814
|
|
Lower
|
37
|
14
|
8
|
57
|
Assume a future admission rate per 1000 of 102. Assume average length of stay of 4.7 days in 10 years. Assume a target occupancy rate of 78% in 10 years.
Newgroveton is a community of 445,000. In the most recent year, there were 750 new cases of disease A in the community. Assume the expected incidence rate for disease A is 245 per 100,000 people. Was the community's experience better or worse than expected? Explain your answer.