# The Sky Hospital Consortium

Anonymous

### Question Description

The Sky Hospital Consortium consists of 40 hospitals in various parts of the US. After being discharged, patients are given a survey to determine if they are satisfied with the overall service. In most cases patients are satisfied. However, some are dissatisfied. In addition, out of those who responded as being dissatisfied, some filed a formal complaint. In the attached excel file, Hospitals, are the results for the patients during a specific year. The Sky Hospital Consortium is divided into the West, Central, and East Regions.

The Sky Hospital Consortium wants to evaluate the performance of the hospitals. The Consortium wants to know which hospitals have the fewest complaints. You are to assist in the data analysis by using your knowledge of probability and conditional probability to help with the ranking of the hospitals, as well as each Region.

Managerial Report
Prepare a report (see below) with your ranking of the hospitals based on the probabilities and conditional probabilities, as well as the analysis of each region. Include the following seven (7) items in table format to support your ranking. Be sure to use five (5) decimal places for your probabilities in the table, as some of them might be quite small.

1. The probability of a patient responding “Dissatisfied” in each of the three different regions.
2. The probability of a patient filing a formal complaint in each of the three different regions.
3. The probability of a patient filing a formal complaint given a patient response of “Dissatisfied” in each of the three different regions.
4. The probability of a patient responding “Dissatisfied” for each hospital.
5. The probability of a patient filing a formal complaint for each hospital.
6. The probability of a patient filing a formal complaint given a patient response of “Dissatisfied” for each hospital.
7. Rank the hospitals within each region for each of the probabilities in 4 - 6. In other words, only rank the hospitals in the West region against the other hospitals in the West region. Perform the same analysis for the other two regions. Then, within each region, find the sum of the ranks and get an overall ranking for each hospital. Evaluate and discuss the meaning of your results. Use tables, charts, graphs, or visual dashboards to support your findings.

Your report must contain the following:

• A title page.
• An introduction that summarizes the problem.
• The body of the paper should answer the questions posed in the problem by communicating the results of your analysis. Include results of calculations, as well as charts and graphs, where appropriate.
• A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis.

### Unformatted Attachment Preview

Purchase answer to see full attachment

psumanrec
School: Duke University

Please find the answer to docs file along with the excel attached file.

West

Regional Hospital
Bell County
Danville
Eden Medical
Elton
Farr County
Fresno
Glendale
Heber Valley
Lakeview
La Paz
Main
Mountain View
Roosevelt
Ross General
Salem
South General
Total

Patients Last Year
4191
4382
1468
2223
2162
5125
7339
5418
5922
5157
4257
2840
2133
3354
3868
1096
60935

Central

Columbus
Mercy Hospital
South Point
Total

5885
2634
3300
6991
18810

East

Atlantic
Branden
Carson General
Clifton General
Columbia
District Central
Drexel
Dubois Regional
Easton
Kent
Lake Shore
Medina
Monroe
Nathan Smith
O'connor
Rye

5694
4449
1169
2588
7548
1214
4622
2303
5016
5289
5914
4366
5899
5050
6859
6224

Southern Ocean
Trenton
Spring Harbor
Sun Coast
Total

6881
2687
1712
6347
91831

Highest Probability or Rank
Lowest Probability or Rank

Patients who Are
Dissatisfied
147
497
271
206
288
485
373
473
382
305
220
492
300
120
700
77
5336

Dissatisfied Patients who
Filed a Formal
79
34
77
72
58
52
73
93
87
54
40
27
20
91
88
18
963

449
213
300
451
1413

87
36
19
57
199

0,0763
0,0809
0,0909
0,0645
0,07512

438
318
342
312
382
300
103
361
490
346
269
216
365
361
428
484

36
70
31
46
59
73
11
60
51
39
79
37
42
58
79
74

0,07692
0,07148
0,29256
0,12056
0,05061
0,24712
0,02228
0,15675
0,09769
0,06542
0,04549
0,04947
0,06187
0,07149
0,06240
0,07776

P(Dissatisfied)
Rank by P(D)
0,03508
16
0,11342
6
0,18460
1
0,09267
8
0,13321
5
0,09463
7
0,05082
14
0,08730
9
0,06451
11
0,05914
12
0,05168
13
0,17324
3
0,14065
4
0,03578
15
0,18097
2
0,07026
10
0,08757
#N/A
3
2
1
4
#N/A
9
11
1
4
16
2
20
3
7
12
18
17
14
10
13
8

387
310
205
284
6701

88
74
57
37
1101

0,05624
0,11537
0,11974
0,04475
0,07297

15
6
5
19

P(Complaint
)
0,01885
0,00776
0,05245
0,03239
0,02683
0,01015
0,00995
0,01717
0,01469
0,01047
0,00940
0,00951
0,00938
0,02713
0,02275
0,01642
0,01580
0,01478
0,01367
0,00576
0,00815
0,01058
0,00632
0,01573
0,02652
0,01777
0,00782
0,06013
0,00238
0,02605
0,01017
0,00737
0,01336
0,00847
0,00712
0,01149
0,01152
0,01189

Rank by
P(C)
6
16
1
2
4
11
12
7
9
10
14
13
15
3
5
8
#N/A
1
2
4
3
#N/A
18
7
4
6
15
1
20
5
13
16
8
14
17
12
11
10

P(C|D) Rank by P(C|D) Sum of Ranks Overall Rank
0,53741
2
24
9
0,06841
14
36
2
0,28413
4
6
16
0,34951
3
13
15
0,20139
7
16
14
0,10722
13
31
7
0,19571
9
35
3
0,19662
8
24
9
0,22775
6
26
8
0,17705
11
33
5
0,18182
10
37
1
0,05488
16
32
6
0,06667
15
34
4
0,75833
1
19
12
0,12571
12
19
12
0,23377
5
23
11
0,18047
#N/A
#N/A
#N/A
0,19376
0,16901
0,06333
0,12639
0,14084
0,08219
0,22013
0,09064
0,14744
0,15445
0,24333
0,10680
0,16620
0,10408
0,11272
0,29368
0,17130
0,11507
0,16066
0,18458
0,15289

1
2
...

flag Report DMCA
Review

Anonymous
Solid work, thanks.

Anonymous
The tutor was great. I’m satisfied with the service.

Anonymous
Goes above and beyond expectations !

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors