Assignment 3 Workbook Market Share - demo

Question 1 Answer Partition Alliance Hospital Capital City Hospital Charity Hospital Citrus Grove hospital Adult Medical 5.8% 45.5% 8.3% 3.2% Adult Surgical 3.4% 61.1% 4.6% 0.5% Newborn and Neonate 5.2% 41.6% 3.9% 3.0% Obstetrics 4.9% 45.0% 4.1% 3.0% Paediatrics 0.5% 1.9% 4.9% 0.0% Total 4.7% 47.0% 6.0% 2.3% Answer Capital City eattle Grace and Westsid 2% 2% Sum of Discharges Hospital Name partition Alliance Hospital Capital City Hospital Charity Hospital Citrus Grove hospital Adult Medical 2788 22029 4008 1530 Adult Surgical 1012 18103 1355 147 Newborn and Neonate 728 5887 550 421 Obstetrics 710 6499 592 439 Paediatrics 26 105 265 2 Total Result 5264 52623 6770 2539 Q1.1. Complete the market share table below Q1.2. Which hospital has the highest market share of Adult Surgical cases? Q1.3. Which two hospitals are Capital City Hospital's biggest competitors in Newborn and Neonate care? Q1.4. What is Greenfield Hospital's market share of Adult Medical cases? Q1.5. What percentage of total cases were provided by out of county hospitals?

Hospital Market Share of Springfield County Greenfield Hospital Guardian Hospital Healthy Children's Hospital Hope Hospital Lakewood Hospital 2.0% 2.6% 0.0% 3.6% 3.3% 0.1% 0.9% 0.1% 0.6% 0.3% 0.0% 5.4% 3.7% 1.4% 0.0% 0.0% 5.2% 0.0% 1.4% 0.0% 0.0% 0.1% 88.7% 0.1% 0.0% 0.9% 2.7% 4.8% 2.1% 1.5% de Greenfield Hospital Guardian Hospital Healthy Children's Hospital Hope Hospital Lakewood Hospital 984 1239 13 1743 1595 20 272 23 181 75 763 520 196 754 201 1 3 4845 6 1005 3031 5401 2327 1670

Question 2 Answer Patient Neighbourhood 1. Central Capital City 0.7% 45.4% 0.4% 0.7% 0.3% 6.2% 2. Eastern Capital City 0.1% 15.5% 0.2% 0.3% 2.4% 8.6% 3. Western Capital City 0.5% 16.7% 0.1% 11.0% 8.2% 2.6% 4. East Rural Springfield 0.2% 10.4% 98.3% 0.5% 50.9% 71.7% 5. West Rural Springfield 95.9% 7.7% 0.1% 83.1% 28.6% 6.2% 6. Out of County 2.6% 4.3% 0.9% 4.5% 9.7% 4.7% Total 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Answer 51% 40.5% Health Children's 6.2% Patient Neighbourhood Alliance HospitaCapital City HospCharity HospitalCitrus Grove hosGreenfield Hosp Guardian Hospit 1. Central Capital City 36 23865 25 17 3 187 2. Eastern Capital City 6 8146 16 8 24 261 3. Western Capital City 28 8812 8 279 82 78 4. East Rural Springfield 13 5488 6652 12 512 2174 5. West Rural Springfield 5046 4026 8 2110 287 188 6. Out of County 135 2286 61 113 97 143 Total 5264 52623 6770 2539 1005 3031 Q2.1. Complete this catchment table Alliance Hospital Capital City Hospital Charity Hospital Citrus Grove hospital Greenfield Hospital Guardian Hospital Q2.2. What percent of Greenfield Hospital's cases live in East Rural Springfield? Q2.3. What percent of Westside Hospital's cases live in Eastern Capital City? Q2.4. Which hospital has the highest percentage of patients from Out of County? Q2.5. What percent of Guardian Hospital's cases live in Central Capital City?

Hope Hospital Total Cases 28.1% 0.3% 0.5% 23.6% 0.4% 34.1% 21.0% 30.7% 15.9% 0.3% 0.3% 3.1% 0.0% 40.5% 9.8% 14.0% 21.0% 0.0% 10.8% 60.8% 0.0% 3.1% 16.7% 18.1% 13.2% 98.9% 0.2% 1.2% 0.0% 20.5% 15.4% 19.0% 9.2% 0.0% 85.0% 9.4% 91.6% 1.1% 37.1% 14.7% 12.5% 0.5% 3.2% 2.0% 8.1% 0.7% 0.0% 3.6% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Healthy ChildrenHope Hospital Lakewood Hosp Seattle Grace HoTiny Town Hosp Westside HospitZ. Out of CountyTotal Cases 1520 6 9 3444 2 4783 470 34367 860 7 5 456 5679 219 15687 1136 1 181 8878 436 373 20292 713 2301 3 172 2870 343 21253 499 1419 1366 477 159 829 16414 673 12 53 291 42 92 3998 5401 2327 1670 14607 521 14019 2234 112011 Healthy Children's Hospital Lakewood Hospital Seattle Grace Hospital Tiny Town Hospital Westside Hospital Z. Out of County Hospitals

Answer Capital City Hospital 223 Charity Hospital Citrus Grove hospGreenfield Hospital Guardian Hospital 223 69 59 66 223 69 59 66 e?

Healthy Children's Hospital Hope Hospital Lakewood Hospital Seattle Grace Hospital Tiny Town Hospital 2 91 78 268 10 2 91 78 268 10