ollows: 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,
ollows:
- 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:HospitalLicensed BedsTotal DischargesTotal Patient DaysInpatient SurgeriesBirthsInpatient Admissions for Emergency DepartmentsEmergency Department VisitsTotal Outpatient VisitsChoice 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 600-800 word summary.
Now that you have the data on ALOS for your comparison hospitals, write 600-800 word summary, 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?
Please submit both your Excel spreadsheet and your paper.