NEED DONE ASAP! HAD A PREVIOUS TEACHER FAIL TO TURN IN THE ASSIGNMENT. 

Few math problems and a 2-3 page paper. Math problems need explanation and tables. Not just the answers. 

Paper has 2-3 pages APA style. 

• 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

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.

• 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,000Assume projected population increase of 8% in service area over the next 10 years.

Table 15-5 Hospital Admissions, by Community

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.

PAPER

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.

Table 14-5 Number of Student Complaints by Complaint Type

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