Reference no: EM131111998
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 Excel file, Hospitals, linked at the bottom of the page, 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.
The probability of a patient responding "Dissatisfied" in each of the three different regions.
The probability of a patient filing a formal complaint in each of the three different regions.
The probability of a patient filing a formal complaint given a patient response of "Dissatisfied" in each of the three different regions.
The probability of a patient responding "Dissatisfied" for each hospital.
The probability of a patient filing a formal complaint for each hospital.
The probability of a patient filing a formal complaint given a patient response of "Dissatisfied" for each hospital.
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 in APA style.
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.
Attachment:- hospitals.xlsx
|
Public seminars and conferences
: In the past, we have sent our supervisors to public seminars and conferences. But we want to build an internal program that is learner- centered rather than event driven so that our supervisors are constantly improving. This program should be comp..
|
|
How you would facilitate care of patient with patients care
: Explain how you would facilitate the care of the patient with the patient's care team. Explain how the factor you selected might impact the pathophysiology of the disorder as well as the effects of prescribed drugs.
|
|
Explain how data will be used to drive supplier performance
: Implementation plan: include who is responsible for collecting data and how you will determine which suppliers will be measured.
|
|
Simple regression model
: The claim is based on a very low R2 of the simple regression model, using these two variables (CSI and sales). Discuss how you would (or should) react to this report and why. What clarifying questions might you ask?
|
|
Evaluate and discuss the meaning of your results
: Evaluate and discuss the meaning of your results. Use tables, charts, graphs, or visual dashboards to support your findings.
|
|
Question regarding the guffey and loewy
: What is the answer for activities 9.4, 9.10, 10.4, 10.26, and 10.28 in the book business communication 8th edition by Guffey and Loewy?
|
|
Explain impact these drugs might have on adult and children
: Explain the impact these drugs might have on adults and children. Explain the stepwise approach to asthma treatment and management and how this approach assists health care providers and patients in gaining and maintaining control of the disease.
|
|
Important aspects of the topics development
: History of the selected topic should be chronological and focus on the most important aspects of the topics development - Write this section as though the reader does not know about the topic, explaining the topic in detail with supporting evidence.
|
|
How the actions of the irs violated the elements
: You are a consultant for the President of Texas A&M University-Commerce. He wants to implement a strategic quality management initiative. What are the first 4 things that should be done? List and explain why and what results you would expect from ..
|