Overview
Description
Your chief executive officer (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 the healthcare assistant (HCA) at Choice Hospital, provide the data and analysis requested by your CEO, as described below. In this exercise, assume that Choice Hospital is in Colorado and use the data by the American Hospital Association found here: Hospital Statistics by State. If you wish to find data for your state of residence, you may do that and start your search on your state’s Department of Health Web site.
To compare Choice Hospital to others of comparable size in the State of Colorado, you will use the specific data points requested, perform the calculations, and prepare the presentation of the data as follows:
- You will review the available data and summarize the data points 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
- Calculate the average length of stay (ALOS) for Choice Hospital from these data.
In your Excel spreadsheet, do the following:
- List 3 hospitals from your chosen state, with one hospital listed per row.
- Enter the data in separate columns for each hospital's total patient days and total discharges.
- Enter your ALOS calculation in the next column using the total patient days and total discharges data.
- At the bottom of the column for ALOS, calculate the mean and standard deviation for the ALOS for all of the hospitals.
- Enter the mean and standard deviation in the cells below in that column, and identify which value is the mean and which is the standard deviation.
- You will submit your Excel spreadsheet and a 600–800-word summary.
- Now that you have the data on ALOS for your comparison hospitals, write a 600–800-word summary, not including the title page or the reference page, and discuss the following:
- Consider the ALOS for Choice Hospital that you calculated using the data for Choice Hospital. How does that compare to the ALOS for the hospitals in Colorado with similar numbers of licensed beds, as you calculated?
- Identify the range of ALOS for the hospitals, and consider the standard deviation value.
- Did you calculate the standard deviation of a sample or 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 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 you found in your research, and cite the reference source.
- How does the ALOS for Choice Hospital compare to the national average?
Refer to these examples for help with your assignment:
Please submit both your Excel spreadsheet and your paper.