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

 

 

 

 

^{"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."}