: Your CEO wants to review the benchmarking data used to compare Choice Hospital with other hospitals in the same geographic region. The Board of Directors is looking at expanding the Emergency Department or adding more in-patient beds. The CEO needs to know how Choice Hospital compares with other hospitals in the region to be part of the discussion and inform decisions on expansion in these areas. As you assume the role of a hospital administrator at Choice Hospital, provide the data and analysis requested by your CEO as described below. In this exercise, assume that Choice Hospital is located in Colorado, and use these data provided by the Colorado Hospital Association for Colorado hospitals. If you wish to find data for your own state of residence, you may do that and start your search at your state�s Department of Health Web site. For comparison of Choice Hospital to others in the state of Colorado of comparable size, you will use the specific data points requested, perform the calculations, and prepare the presentation of the data as follows: You will first review the data available and summarize the data points as specified for this presentation by placing them in an Excel spreadsheet. Calculate descriptive statistics for the data, as specified below. Prepare an Excel spreadsheet of the data. Review the data in the spreadsheet, and prepare a discussion of the data for Colorado hospitals compared to the data for Choice Hospital. The table below includes the data for Choice Hospital: Hospital Licensed Beds Total Discharges Total Patient Days Inpatient Surgeries Births Inpatient Admissions for Emergency Departments Emergency Department Visits Total Outpatient Visits Choice Hospital 300 15,279 70,283 4,012 256 4,781 13,342 98,993 From these data, calculate the average length of stay (ALOS) for Choice Hospital. Now look at the data for Colorado Hospitals at the link provided. Because Choice Hospital is a 300-bed facility, identify the hospitals that have between 200 and 400 licensed beds. Those are the hospitals that you will use for your comparison to Choice Hospital. In your Excel spreadsheet, do the following: List the hospitals that have 200�400 licensed beds in the first column, with 1 hospital listed per row. Next, for each of those hospitals, enter the data in separate columns for Total Patient Days and Total Discharges. In the next column, enter your calculation for ALOS using the data for Total Patient Days and Total Discharges. At the bottom of the column for ALOS, calculate the mean and standard deviation for the average length of stay for all of the hospitals. Enter the mean and standard deviation in the cells below in that column, and be sure to identify which value is the mean and which is the standard deviation. You will submit your Excel spreadsheet along with your paper. Now that you have the data on ALOS for your comparison hospitals, write a paper of 2�3 pages, not including the title page or reference page, and discuss the following: Consider the average length of stay for Choice Hospital that you calculated using the data for Choice Hospital. How does that compare to the ALOS on average for the hospitals in Colorado with similar numbers of licensed beds from your calculation? Identify the range of ALOS for the hospitals, and consider the standard deviation value. Did you calculate the standard deviation of a sample or of the entire population? What is the difference? Explain why you chose the one that you did. Research the ALOS for the United States, and find a statistic that is within the last 5 years. The ALOS may be an overall average or based on the number of beds. State the ALOS for the United States that you found in your research, and be sure to cite the reference source. How does the ALOS for Choice Hospital compare to the national average? Health care organizations track their ALOS and compare it to other facilities of similar size, patient population, or services provided. This is referred to as a benchmark. Why do health care organizations track ALOS? Why do they use a benchmark? Why would they track ALOS, and what could they do to improve their ALOS relative to a benchmark?
: Statistics Project
: English (U.S.)
: 3 pages/825 words
:APA 3 SOURCES DUE IN 20 hours
We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.Read more
The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.Read more
The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.Read more
By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.Read more