Purchase Solution

Comparison of 6 States Uncompenstated Healthcare Costs

Not what you're looking for?

Ask Custom Question

Review the 2010 HCA Annual Investment by State Report at:

http://hcagovernmentrelations.com/utility/forms/investment-by-state2010.pdf

Complete the following:

- Pick 6 states to compare uncompensated care expenses.
- Develop a graph to display your results.
- As a healthcare manager within one of HCA's facilities, suggest ways to decrease the total uncompensated care amount.
- Write an analysis of your comparison.

Purchase this Solution

Solution Summary

This solution compares the uncompensated healthcare costs of 6 states. The states were selected to provide a range of characteristics. Analysys is provided in tables as well as pie charts via an attached Excel file.

This analysis is performed in two formats: (1) "State Break Out" with a pie chart for each state, as well as pie chart for the 6-state total and (2) "Type of Debts charts," which examines each type of debt with a pie chart break down of how each state contributes to the type of debt.

Indexes are provided for the State Break Out.

Solution Preview

I have picked 6 states (Georgia, Oklahoma, South Carolina, Florida, Kentucky and Colorado) to compare. I tried to pick states that had somewhat different trends so there were some interesting things to pick up in the analysis.

Attached is an Excel file with 2 tabs.
-Tab ...

Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.