MAT543 Week 9 and 10 Homeworks Complete Solution

Question: #8524

14-2 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 14-4).
Table 14-4 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 14-5 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
o   1. The quality of service received
o   2. Waiting time was too long
o   3. Follow-up care was not available
o   4. Clinic was hard to find in the building
o   5. The medical care/treatment took too long
o   6. They could not find my medical record

•   Week 9 Case Study 2 - Submit Here
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:
1.   Construct a fish-bone chart using Word or MS Paint.
2.   Construct a run and / or control chart using Excel.
3.   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. Check with your professor for any additional instructions.
•   Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. 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.

•   Week 10 Homework - Submit Here
Due Week 10 and worth 30 points
•   Homework
o   Chapter 15: Exercises 15-1 through 15-3 (page 314 of the text)

•   15-1 Using the following data set on hospital admissions, define the service area for Hospital A, based only on quantitative factors (Table 15-5).
•   15-2 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 15-5 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.
•   15-3 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.