NEED DONE ASAP! HAD A PREVIOUS TEACHER FAIL TO TURN IN THE ASSIGNMENT.
Few math problems and a 23 page paper. Math problems need explanation and tables. Not just the answers.
Paper has 23 pages APA style.
 142 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 144).
Table 144 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 by time interval (e.g., month), sum the differences, and then divide this sum by the number of range calculation. In the example, divide by 11 to determine the average moving range. For the example, the average moving range is 5.5 births.
The upper control limit for a moving range chart (of individual values) is the average moving range × 3.27—3.27 is a constant, just as 1.96 is the constant used to calculate a 95% confidence interval when we use the central limit theorem.
In our example, therefore, the upper control limit for the moving range chart is:
Average Moving Range = 5.5 × (the constant) 3.27 = 17.985
For this control chart, 17.985 is the upper threshold limit used to evaluate the variation presented in the time series analysis we have been using involving medically complicated births. It is the upper boundary or control limit. Given the nature of this chart there is no lower limit.
 151 Using the following data set on hospital admissions, define the service area for Hospital A, based only on quantitative factors (Table 155).
 152 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,000Assume projected population increase of 8% in service area over the next 10 years.
Table 155 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.
 153 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.
PAPER
The ambulatory health service at a university is experiencing an increased number of student complaints concerning the services it offers in its walkin urgent care clinic. Using the data in Table 145 on page 296 of the textbook, select a complaint for analysis. Your analysis must include a fishbone 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 (23) page paper in which you:
1. Construct a fishbone 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 walkin 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 oneinch margins on all sides; citations and references must follow APA or schoolspecific format. Check with your professor for any additional instructions.
Table 145 Number of Student Complaints by Complaint Type
Complaint Type 
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. Followup 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