[Solved] Health

Assignment Prompt & Instructions

– a year ago

**files (1)**

– ## Finallabproject.docx

**## Finallabproject.docx**

Please keep the assignment on a word doc

Choose one of the following options for your analysis. Using the data included in the file
[AB202019_Ch14_casemixindex_1996_2018_20190628 CA.xlsx](https://bccc.instructure.com/courses/36562/files/3432668?wrap=1) [Download AB202019_Ch14_casemixindex_1996_2018_20190628 CA.xlsx](https://bccc.instructure.com/courses/36562/files/3432668/download?download_frd=1). Prepare a graphic that compares Your Hospital’s CMI to your benchmark facility, the county’s, and the state’s CMI for the past five years. Only include facilities in your analysis that have data for the past five years.

| | | | |
| — | — | — | — |
| | **Option A** | **Option B** | **Option C** |
| **County** | Orange | Fresno | San Diego |
| **Your Hospital** | Huntington Beach Hospital | Community Regional MC | Scripps Green Hospital |
| **Benchmark Facility** | Mission Hospital Regional MC | St. Agnes Medical Center | Sharp Coronado Hospital |

            Evaluate the data contained in your graphic. What types of insights or conclusions can be drawn from this information about your hospital, your benchmark facility, the county, and the state for each year? Was your assigned benchmark facility a good benchmark? If not, which facility in the assigned county would be better?

            Prepare a short report that evaluates the possible explanations as for why your facility’s overall CMI was higher or lower than the benchmark facility, the county, and the state average for each year. Include any explanation of outliers that may be in the county.

[AB202019_EXAMPLE_Ch14_Case Mix Index Analysis Sample Report.docx](https://bccc.instructure.com/courses/36562/files/3432669?wrap=1) [Download AB202019_EXAMPLE_Ch14_Case Mix Index Analysis Sample Report.docx](https://bccc.instructure.com/courses/36562/files/3432669/download?download_frd=1)

**## Finallabproject.docx**

Please keep the assignment on a word doc

Choose one of the following options for your analysis. Using the data included in the file
[AB202019_Ch14_casemixindex_1996_2018_20190628 CA.xlsx](https://bccc.instructure.com/courses/36562/files/3432668?wrap=1) [Download AB202019_Ch14_casemixindex_1996_2018_20190628 CA.xlsx](https://bccc.instructure.com/courses/36562/files/3432668/download?download_frd=1). Prepare a graphic that compares Your Hospital’s CMI to your benchmark facility, the county’s, and the state’s CMI for the past five years. Only include facilities in your analysis that have data for the past five years.

| | | | |
| — | — | — | — |
| | **Option A** | **Option B** | **Option C** |
| **County** | Orange | Fresno | San Diego |
| **Your Hospital** | Huntington Beach Hospital | Community Regional MC | Scripps Green Hospital |
| **Benchmark Facility** | Mission Hospital Regional MC | St. Agnes Medical Center | Sharp Coronado Hospital |

            Evaluate the data contained in your graphic. What types of insights or conclusions can be drawn from this information about your hospital, your benchmark facility, the county, and the state for each year? Was your assigned benchmark facility a good benchmark? If not, which facility in the assigned county would be better?

            Prepare a short report that evaluates the possible explanations as for why your facility’s overall CMI was higher or lower than the benchmark facility, the county, and the state average for each year. Include any explanation of outliers that may be in the county.

[AB202019_EXAMPLE_Ch14_Case Mix Index Analysis Sample Report.docx](https://bccc.instructure.com/courses/36562/files/3432669?wrap=1) [Download AB202019_EXAMPLE_Ch14_Case Mix Index Analysis Sample Report.docx](https://bccc.instructure.com/courses/36562/files/3432669/download?download_frd=1)