Option 2 – Critical Thinking: Sky Hospital Consortium

TheSky Hospital Consortium consists of 40 hospitals in various parts ofthe US. After being discharged, patients are given a survey to determineif they are satisfied with the overall service. In most cases patientsare satisfied. However, some are dissatisfied. In addition, out of thosewho responded as being dissatisfied, some filed a formal complaint. Inthe Excel file, Hospitals, linked at the bottom of thepage, are the results for the patients during a specific year. The SkyHospital Consortium is divided into the West, Central, and East Regions.

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

Managerial Report
Preparea report (see below) with your ranking of the hospitals based on theprobabilities and conditional probabilities, as well as the analysis ofeach region. Include the following seven (7) items in table format tosupport 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. Theprobability of a patient filing a formal complaint given a patientresponse 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 withineach region for each of the probabilities in 4 – 6. In other words,only rank the hospitals in the West region against the other hospitalsin the West region. Perform the same analysis for the other two regions.Then, within each region, find the sum of the ranksand get an overall ranking for each hospital. Evaluate and discuss themeaning of your results. Use tables, charts, graphs, or visualdashboards to support your findings.

Write a report thatadheres to the Written Assignment Requirements under the heading“Expectations for CSU-Global Written Assignments” found in the CSU-Global Guide to Writing and APA Requirements.As with all written assignments at CSU-Global, you should have in-textcitations and a reference page. An example paper is provided in the MTH410 Guide to Writing with Statistics, linked at the bottom of the page.

Your report must contain the following:

• A title page in APA style.
• An introduction that summarizes the problem.
• Thebody of the paper should answer the questions posed in the problem bycommunicating the results of your analysis. Include results ofcalculations, 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.

Submit your Excel file in addition to your report.