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

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.

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

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.

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 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