Data Utilization and Presentation

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 the HCA 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.

Don't use plagiarized sources. Get Your Custom Essay on
Data Utilization and Presentation
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!
Order Essay

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 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.

Homework Paper
Order NOW For A 10% Discount!
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

All our papers are original and written from scratch. We will email you a plagiarism report alongside your completed paper once done.

Free Revisions

All papers are submitted ahead of time. We do this to allow you time to point out any area you would need revision on, and help you for free.

Free Title-page

A title page preceeds all your paper content. Here, you put all your personal information and this we give out for free.

Free Bibliography

Without a reference/bibliography page, any academic paper is incomplete and doesnt qualify for grading. We also offer this for free.

Originality & Security

At Homeworkpaper.net, we take confidentiality seriously and all your personal information is stored safely and do not share it with third parties for any reasons whatsoever. Our work is original and we send plagiarism reports alongside every paper.

24/7 Customer Support

Our agents are online 24/7. Feel free to contact us through email or talk to our live agents.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

We work around the clock to see best customer experience.

Pricing

Flexible Pricing

Our prices are pocket friendly and you can do partial payments. When that is not enough, we have a free enquiry service.

Communication

Admission help & Client-Writer Contact

When you need to elaborate something further to your writer, we provide that button.

Deadlines

Paper Submission

We take deadlines seriously and our papers are submitted ahead of time. We are happy to assist you in case of any adjustments needed.

Reviews

Customer Feedback

Your feedback, good or bad is of great concern to us and we take it very seriously. We are, therefore, constantly adjusting our policies to ensure best customer/writer experience.