Sky Hospital ConsortiumThe Sky Hospital Consortium consists

Sky Hospital ConsortiumThe Sky Hospital Consortium consists of 40 hospitals in various partsof the US. After being discharged, patients are given a survey todetermine if they are satisfied with the overall service. In most casespatients are satisfied. However, some are dissatisfied. In addition, outof those who responded as being dissatisfied, some filed a formalcomplaint. In the Excel file, Hospitals, linked at thebottom of the page, are the results for the patients during a specificyear. The Sky Hospital Consortium is divided into the West, Central, andEast Regions. The Sky Hospital Consortium wants to evaluate the performance of thehospitals. The Consortium wants to know which hospitals have the fewestcomplaints. 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 ReportPrepare a report (see below) with your ranking of the hospitals basedon the probabilities and conditional probabilities, as well as theanalysis of each region. Include the following seven (7) items in tableformat 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 apatient response of “Dissatisfied” in each of the three differentregions.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 ofthe probabilities in 4 – 6. In other words, only rank the hospitals inthe West region against the other hospitals in the West region. Performthe same analysis for the other two regions. Then, withineach region, find the sum of the ranks and get an overall ranking foreach hospital. Evaluate and discuss the meaning of your results. Usetables, charts, graphs, or visual dashboards to support your findings.Write a report that adheres to the Written AssignmentRequirements under the heading “Expectations for CSU-Global WrittenAssignments” 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.The body of the paper should answer the questions posed in theproblem by communicating the results of your analysis. Include resultsof 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. Submit your Excel file in addition to your report.

Sky Hospital ConsortiumThe Sky Hospital Consortium consists

Sky Hospital ConsortiumThe Sky Hospital Consortium consists of 40 hospitals in various partsof the US. After being discharged, patients are given a survey todetermine if they are satisfied with the overall service. In most casespatients are satisfied. However, some are dissatisfied. In addition, outof those who responded as being dissatisfied, some filed a formalcomplaint. In the Excel file, Hospitals, linked at thebottom of the page, are the results for the patients during a specificyear. The Sky Hospital Consortium is divided into the West, Central, andEast Regions. The Sky Hospital Consortium wants to evaluate the performance of thehospitals. The Consortium wants to know which hospitals have the fewestcomplaints. 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 ReportPrepare a report (see below) with your ranking of the hospitals basedon the probabilities and conditional probabilities, as well as theanalysis of each region. Include the following seven (7) items in tableformat 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 apatient response of “Dissatisfied” in each of the three differentregions.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 ofthe probabilities in 4 – 6. In other words, only rank the hospitals inthe West region against the other hospitals in the West region. Performthe same analysis for the other two regions. Then, withineach region, find the sum of the ranks and get an overall ranking foreach hospital. Evaluate and discuss the meaning of your results. Usetables, charts, graphs, or visual dashboards to support your findings.Write a report that adheres to the Written AssignmentRequirements under the heading “Expectations for CSU-Global WrittenAssignments” 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.The body of the paper should answer the questions posed in theproblem by communicating the results of your analysis. Include resultsof 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. Submit your Excel file in addition to your report.