Health

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  Download AB202019_Ch14_casemixindex_1996_2018_20190628 CA.xlsx. 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  Download AB202019_EXAMPLE_Ch14_Case Mix Index Analysis Sample Report.docx