Answered step by step
Verified Expert Solution
Question
1 Approved Answer
excel pics are posted 231 A Hospital 2 Adventist Medical Center - Reedley 3 AHMC Anaheim Regional Medical Center 4 Alameda County Medical Center -
excel pics are posted
231 A Hospital 2 Adventist Medical Center - Reedley 3 AHMC Anaheim Regional Medical Center 4 Alameda County Medical Center - Highland Hospital 5 Alta Bates Summit Medical Center - Alta Bates Campus 6 Antelope Valley Hospital 7 Arrowhead Regional Medical Center 8 Bakersfield Memorial Hospital 9 Banner Lassen Medical Center 10 Barstow Community Hospital 11 Barton Memorial Hospital 12 Beverly Hospital 13 California Hospital Medical Center 14 California Pacific Medical Center - California Campus 15 California Pacific Medical Center - St. Luke's Campus 16 Cedars-Sinai Medical Center 17 Centinela Hospital Medical Center 18 Central Valley General Hospital 19 Citrus Valley Medical Center - Queen of the Valley Campus 20 Clovis Community Medical Center 21 Coastal Communities Hospital 22 Community Hospital of San Bernardino 23 Community Hospital of the Monterey Peninsula 24 Community Memorial Hospital 25 Community Regional Medical Center 26 Contra Costa Regional Medical Center CaliforniaC Section Rates B City County Reedley Fresno Anaheim Orange Oakland Alameda Berkeley Alameda Lancaster Los Angeles Colton San Bernardino Bakersfield Kern Susanville Lassen Barstow San Bernardino South Lake Tahoe El Dorado Montebello Los Angeles Los Angeles Los Angeles San Francisco San Francisco San Francisco San Francisco Los Angeles Los Angeles Inglewood Los Angeles Hanford Kings West Covina Los Angeles Clovis Fresno Santa Ana Orange San Bernardino San Bernardino Monterey Monterey Ventura Ventura Fresno Fresno Martinez contra costa D E C-Sections Deliveries 84 352 119 537 68 338 547 2330 496 1475 151 734 174 1170 24 75 20 100 37 134 81 280 1194 468 2153 96 448 828 2873 42 158 189 604 290 1242 469 1605 63 200 174 537 119 433 226 955 311 1293 202 712 F Percent 23.86% 22.35% 20.41% 23.48% 33.69% 20.71% 14.96% 33.33% 20.00% 28.36% 35.06% 23.53% 21.7496 21.65% 28.82% 27.22% 31.46% 23.35% 29.22% 31.50% 32.40% 27.71% 23.66% 24.13% 28.37% 4 READY G A 26 Contra Costa Regional Medical Center 27 Corona Regional Medical Center 28 Dameron Hospital 29 Delano Regional Medical Center 30 Desert Regional Medical Center 31 Desert Valley Hospital 32 Doctors Hospital of Manteca 33 Doctors Medical Center of Modesto 34 Dominican Hospital 35 Downey Regional Medical Center 36 East Los Angeles Doctors Hospital 37 Eden Medical Center 38 El Camino Hospital 39 El Camino Hospital Los Gatos 40 El Centro Regional Medical Center 41 Emanuel Medical Center 42 Enloe Medical Center 43 Fairchild Medical Center 44 Feather River Hospital 45 Foothill Presbyterian Hospital 46 Fountain Valley Regional Hospital & Medical Center 47 Fremont Medical Center 48 French Hospital Medical Center 49 Garden Grove Hospital and Medical Center 50 Garfield Medical Center 51 George L Mee Memorial Hospital Californiac Section Rates B C Martinez Contra Costa Corona Riverside Stockton San Joaquin Delano Kern Palm Springs Riverside Victorville San Bernardino Manteca San Joaquin Modesto Stanislaus Santa Cruz Santa Cruz Downey Los Angeles Los Angeles Los Angeles Castro Valley Alameda Mountain View Santa Clara Los Gatos Santa Clara El Centro Imperial Turlock Stanislaus Chico Butte Yreka Siskiyou Paradise Butte Glendora Los Angeles Fountain Valley Orange Yuba City Sutter San Luis Obispo San Luis Obispo Garden Grove Orange Monterey Park Los Angeles King City Monterey D 202 61 84 67 240 69 51 259 61 74 61 125 495 58 118 51 134 10 72 100 E 712 326 261 216 1006 308 214 991 291 328 116 512 1851 362 304 391 554 53 F 28.37% 18.71% 32.57% 31.48% 23.96% 22.40% 23.83 26.24% 21.09% 22.56% 52.59% 22.18% 26.74% 16.30% 39.14% 13.04% 24.19% 20.75% 22.93% 38.9195 28.42% 23.48% 25.97% 27.91% 28.115 21.43 314 371 143 59 138 449 21 257 1309 609 231 498 1601 98 A1 Xfx Hospital G E 98 834 658 A 51 George L. Mee Memorial Hospital 52 Glendale Adventist Medical Center 53 Glendale Memorial Hospital and Health Center 54 Good Samaritan Hospital - Los Angeles 55 Good Samaritan Hospital - San Jose 56 Greater El Monte Community Hospital 57 Hazel Hawkins Memorial Hospital 58 Hemet Valley Medical Center 59 Henry Mayo Newhall Memorial Hospital 60 Hi-Desert Medical Center 61 Hoag Memorial Hospital Presbyterian 62 Hollywood Presbyterian Medical Center 63 Huntington Memorial Hospital 64 John F. Kennedy Memorial Hospital 65 John Muir Medical Center - Walnut Creek Campus 66 Kaiser Ontario Medical Center Campus 67 Kaiser Permanente Antioch Medical Center 68 Kaiser Permanente Baldwin Park Medical Center 69 Kaiser Permanente Downey Medical Center 70 Kaiser Permanente Fontana Medical Center 71 Kaiser Permanente Fresno Medical Center 72 Kaiser Permanente Los Angeles Medical Center 73 Kaiser Permanente Modesto Medical Center 74 Kaiser Permanente Moreno Valley Medical Center 75 Kaiser Permanente Oakland Medical Center 76 Kaiser Permanente Orange County Anaheim Medical Center B King City Glendale Glendale Los Angeles San Jose So. El Monte Hollister Hemet Valencia Joshua Tree Newport Beach Los Angeles Pasadena Indio Walnut Creek Ontario Antioch Baldwin Park Downey Fontana Fresno Los Angeles Modesto Moreno Valley Oakland Anaheim C Monterey Los Angeles Los Angeles Los Angeles Santa Clara Los Angeles San Benito Riverside Los Angeles San Bernardino Orange Los Angeles Los Angeles Riverside Contra Costa San Bernardino Contra Costa Los Angeles Los Angeles San Bernardino Fresno LOS Angeles Stanislaus Riverside Alameda Orange D 21 276 223 298 401 42 41 100 93 53 654 377 380 140 168 202 126 243 299 322 99 277 179 98 207 305 1142 1288 120 126 361 459 144 2529 1228 1346 569 971 752 556 1043 1272 1210 468 1022 878 378 949 1242 F 21.43% 33.09% 34.01% 26.18% 31.13% 35.83% 32.54% 27.98% 20.48% 36.81% 25.90% 30.70% 28.23% 24.78% 17.4096 26,99% 22.66% 23.30% 23.58% 26.53% 21.15% 27.10% 20.50% 26.19% 21.926 24.64% G D 305 253 158 115 A 76 Kaiser Permanente Orange County Anaheim Medical Center 77 Kaiser Permanente Orange County Irvine Medical Center 78 Kaiser Permanente Panorama City Medical Center 79 Kaiser Permanente Redwood City Medical Center 80 Kaiser Permanente Riverside Medical Center 81 Kaiser Permanente Roseville Medical Center 82 Kaiser Permanente San Diego Medical Center 83 Kaiser Permanente San Francisco Medical Center 84 Kaiser Permanente San Jose Medical Center 85 Kaiser Permanente San Leandro Medical Center 86 Kaiser Permanente Santa Clara Medical Center 87 Kaiser Permanente Santa Rosa Medical Center 88 Kaiser Permanente South Bay Medical Center (Harbor City) 89 Kaiser Permanente South Sacramento Medical Center 90 Kaiser Permanente Vacaville Medical Center 91 Kaiser Permanente Vallejo Medical Center 92 Kaiser Permanente Walnut Creek Medical Center 93 Kaiser Permanente West Los Angeles Medical Center 94 Kaiser Permanente Woodland Hills Medical Center 95 Kaweah Delta Health Care District 96 Kern Medical Center 97 La Palma Intercommunity Hospital 98 Little Company of Mary - San Pedro Hospital 99 Little Company of Mary Hospital - Torrance 100 Lodi Memorial Hospital 101 Coma Linda University Medical Center California Section Rates B Anaheim Irvine Panorama City Redwood City Riverside Roseville San Diego San Francisco San Jose San Leandro Santa Clara Santa Rosa Harbor City Sacramento Vacaville Vallejo Walnut Creek Los Angeles Woodland Hills Visalia Bakersfield La Palma San Pedro Torrance Lodi Loma Linda Orange Orange Los Angeles San Mateo Riverside Placer San Diego San Francisco Santa Clara Alameda Santa Clara Sonoma Los Angeles Sacramento Solano Solano Contra Costa Los Angeles Los Angeles Tulare Kern Orange Los Angeles Los Angeles San Joaquin San Bernardino 236 303 485 276 157 150 478 176 226 180 81 109 289 269 122 343 139 23 44 310 62 197 E 1242 985 772 718 1056 1794 1618 1235 776 740 1725 789 893 861 418 504 1275 719 633 1268 574 137 192 1068 291 816 F 24.64% 25.69% 20.60% 16.02% 22.44% 16.95% 30.04% 22.35% 20.23% 20.4196 27.77% 22.43% 25.31% 20.91% 19.38% 21.83% 22.67% 23.64% 19.279 27.13% 24.22% 17.5296 22.92% 29.129 21.65% 24.14% READY D 197 75 22 557 104 E 816 421 115 2024 463 20 256 155 285 652 230 320 101 Loma Linda University Medical Center 102 Loma Linda University Medical Center - Murrieta 103 Lompoc Valley Medical Center 104 Long Beach Memorial Medical Center 105 Los Alamitos Medical Center 106 Los Angeles Community Hospital 107 Los Angeles County - Harbor - UCLA Medical Center 108 Los Angeles County - Olive View - UCLA Medical Center 109 Los Angeles County + University of Southern California 110 Los Robles Hospital & Medical Center 111 Mad River Community Hospital 112 Madera Community Hospital 113 Mammoth Hospital 114 Marian Medical Center 115 Marin General Hospital 116 Marshall Medical Center 117 Mayers Memorial Hospital District 118 Memorial Hospital Los Banos 119 Memorial Hospital of Gardena 120 Memorial Medical Center 121 Mendocino Coast District Hospital 122 Mercy General Hospital 123 Mercy Healthcare Bakersfield - Mercy Southwest Hospital 124 Mercy Hospital of Folsom 125 Mercy Medical Center Merced 126 Mercy Medical Center Mount Shasta Californiac-Section Rates B Loma Linda San Bernardino Murrieta Riverside Lompoc Santa Barbara Long Beach Los Angeles Los Alamitos Orange Los Angeles Los Angeles Torrance Los Angeles Sylmar Los Angeles Los Angeles Los Angeles Thousand Oaks Ventura Arcata Humboldt Madera Madera Mammoth Lakes Mono Santa Maria Santa Barbara Greenbrae Marin Placerville El Dorado Fall River Mills Shasta Los Banos Merced Gardena Los Angeles Modesto Stanislaus Fort Bragg Mendocino Sacramento Sacramento Bakersfield Kern Folsom Sacramento Merced Merced Mount Shasta Siskiyou 14 83 40 78 207 38 89 5 219 100 51 4 77 123 207 9 173 247 81 43 869 518 185 17 191 224 667 44 615 979 350 569 46 24.14% 18.05% 19.13% 27.57% 22.68% 70.00% 32.42% 26.45% 27.37% 31.75% 16.96% 27.81% 13.95% 25.20% 19.50% 28.11% 23.53% 40.84% 55.36% 31.18% 22.73% 28.13% 25.33% 23.14% 33.049 21.74% 188 10 1 rapids D G E 46 604 566 524 856 861 894 308 495 538 436 126 Mercy Medical Center Mount Shasta 127 Mercy Medical Center Redding 128 Mercy San Juan Medical Center 129 Methodist Hospital of Sacramento 130 Methodist Hospital of Southern California 131 Mills-Peninsula Health Services 132 Mission Hospital - Mission Viejo 133 Montclair Hospital Medical Center 134 Monterey Park Hospital 135 Natividad Medical Center 136 NorthBay Medical Center 137 Northern Inyo Hospital 138 Northridge Hospital Medical Center 139 O'Connor Hospital 140 Orange Coast Memorial Medical Center 141 Oroville Hospital 142 Pacific Alliance Medical Center 143 Pacifica Hospital of the Valley 144 Palo Verde Hospital 145 Palomar Medical Center 146 Paradise Valley Hospital 147 Parkview Community Hospital Medical Center 148 Petaluma Valley Hospital 149 Pioneers Memorial Hospital 150 Plumas District Hospital 151 Pomerado Hospital Californiac-Section Rates B c Mount Shasta Siskiyou Redding Shasta Carmichael Sacramento Sacramento Sacramento Arcadia Los Angeles Burlingame San Mateo Mission Viejo Orange Montclair San Bernardino Monterey Park Los Angeles Salinas Monterey Fairfield Solano Bishop Inyo Northridge Los Angeles San Jose Santa Clara Fountain Valley Orange Oroville Butte Los Angeles Los Angeles Sun Valley Los Angeles Blythe Riverside Escondido San Diego National City San Diego Riverside Riverside Petaluma Sonoma Brawley Imperial Plumas Quincy Poway San Diego 10 149 148 143 194 240 256 87 205 128 108 15 126 241 182 34 186 44 11 294 125 224 33 172 5 117 65 383 1009 563 110 683 79 21.74% 24.83% 26.33% 27.29% 22.66% 27.87% 28.75% 28.57% 41.6296 23.98% 24.77% 24.62% 32.90% 23.8996 32.33% 31.82% 27.38% 55.70% 25.58% 29.5678 28.38% 31.37% 21.57% 27.39% 18.52% 25.055 43 998 444 714 153 628 27 467 G E 467 2195 1427 1123 1032 998 250 151 Pomerado Hospital 152 Pomona Valley Hospital Medical Center 153 Presbyterian Intercommunity Hospital 154 Providence Holy Cross Medical Center - Mission Hills 155 Providence Saint Joseph Medical Center - Burbank 156 Providence Tarzana Medical Center 157 Queen of the Valley Medical Center 158 Redlands Community Hospital 159 Redwood Memorial Hospital 160 Regional Medical Center of San Jose 161 Ridgecrest Regional Hospital 162 Riverside Community Hospital 163 Riverside County Regional Medical Center 164 Ronald Reagan UCLA Medical Center 165 Saddleback Memorial Medical Center - Laguna Hills Campus 166 Saint Agnes Medical Center 167 Saint John's Health Center 168 Salinas Valley Memorial Healthcare System 169 San Antonio Community Hospital 170 San Dimas Community Hospital 171 San Francisco General Hospital Medical Center 172 San Gabriel Valley Medical Center 173 San Gorgonio Memorial Hospital 174 San Joaquin Community Hospital 175 San Joaquin General Hospital 276 San Ramon Regional Medical Center California Section Rates B Poway Pomona Whitter Mission Hills Burbank Tarzana Napa Redlands Fortuna San Jose Ridgecrest Riverside Moreno Valley Los Angeles Laguna Hills Fresno Santa Monica Salinas Upland San Dimas San Francisco San Gabriel Banning Bakersfield French Camp San Ramon San Diego Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Napa San Bernardino Humboldt Santa Clara Kern Riverside Riverside Los Angeles Orange Fresno Los Angeles Monterey San Bernardino Los Angeles San Francisco Los Angeles Riverside Kem San Joaquin Contra Costa D 117 446 360 256 331 348 59 169 16 48 51 384 91 201 288 257 296 114 226 72 67 336 35 176 86 94 838 88 147 141 1096 422 757 1071 847 1037 501 783 197 387 1252 107 1045 409 282 F 25.05% 20.36% 25.30% 22.89% 32.07% 34.87% 23.60% 20.29% 19.32%6 33.33% 36.88% 35.13% 21.56% 26.55% 26.98% 30.34% 28.64% 22.95% 28.86% 36.5595 17.31% 26.845 32.7156 16.94% 21.0396 33.699 G D 94 281 207 171 18 55 233 A 176 San Ramon Regional Medical Center San Ramon 177 Santa Barbara Cottage Hospital Santa Barbara 178 Santa Clara Valley Medical Center San Jose 179 Santa Monica UCLA Medical Center and Orthopaedic Hospital Santa Monica 180 Santa Paula Hospital Santa Paula 181 Santa Rosa Memorial Hospital Santa Rosa 182 Scripps Memorial Hospital Encinitas Encinitas 183 Scripps Memorial Hospital La Jolla La Jolla 184 Scripps Mercy Hospital Chula Vista Chula Vista 185 Scripps Mercy Hospital San Diego San Diego 186 Sequoia Hospital Redwood City 187 Sharp Chula Vista Medical Center Chula Vista 188 Sharp Grossmont Hospital La Mesa 189 Sharp Memorial Hospital San Diego 190 Sierra Nevada Memorial Hospital Grass Valley 191 Sierra View District Hospital Porterville 192 Sierra Vista Regional Medical Center San Luis Obispo 193 Simi Valley Hospital Simi Valley Sonoma 194 Sonoma Valley Hospital Sonora 195 Sonora Regional Medical Center Murrieta 196 Southwest Healthcare System. Rancho Springs/Murrieta San Bernardino 197 St. Bernardine Medical Center Red Bluft 198 St. Elizabeth Community Hospital 199 St. Francis Medical Center Lynwood St. Helena 200 St. Helena Hospital Clearlake 201 St. Helena Hospital Clearlake California Section Rates C Contra Costa Santa Barbara Santa Clara Los Angeles Ventura Sonoma San Diego San Diego San Diego San Diego San Mateo San Diego San Diego San Diego Nevada Tulare San Luis Obispo Ventura Sonoma Tuolumne Riverside San Bernardino Tehama Los Angeles 520 163 179 202 228 346 1178 24 89 E 282 894 959 670 111 239 775 1569 670 764 615 801 1292 3484 152 378 420 259 49 198 2018 559 210 1372 104 66 F 33.69% 31.43% 21.69% 25.52% 17.12% 23.43% 30.19% 33.21% 24.48% 23.56% 31.47% 28,46% 26.78% 33.84% 16,45% 23.54% 32.62% 20.46% 14.29% 42,42% 19.74% 23.97% 26.19% 30.10% 19.2896 19.70% 136 52 7 83 201 134 54 412 20 Napa uske 13 fx Hospital D 13 194 A 201 St. Helena Hospital Clearlake 202 St. John's Regional Medical Center - Oxnard 203 St. Joseph Hospital - Eureka 204 St. Joseph Hospital - Orange 205 St. Joseph's Medical Center of Stockton 206 St. Jude Medical Center 207 St. Louise Regional Hospital 208 St. Mary Medical Center - Apple Valley 209 St. Mary Medical Center - Long Beach 210 St. Rose Hospital 211 Stanford Hospital and Clinics 212 Sutter Amador Hospital 213 Sutter Coast Hospital 214 Sutter Davis Hospital 215 Sutter Delta Medical Center 216 Sutter Lakeside Hospital 217 Sutter Maternity and Surgery Center of Santa Cruz 218 Sutter Medical Center of Santa Rosa 219 Sutter Medical Center Sacramento - Sutter Memorial 220 Sutter Roseville Medical Center 221 Sutter Solano Medical Center 222 Sutter Tracy Community Hospital 223 Tahoe Forest Hospital 224 Torrance Memorial Medical Center 225 Tri-City Medical Center 226 Tulare District Hospital Californiac-SectionRates B Clearlake Oxnard Eureka Orange Stockton Fullerton Gilroy Apple Valley Long Beach Hayward Stanford Jackson Crescent City Davis Antioch Lakeport Santa Cruz Santa Rosa Sacramento Roseville Vallejo Tracy Truckee Torrance Oceanside Tulare Lake Ventura Humboldt Orange San Joaquin Orange Santa Clara San Bernardino Los Angeles Alameda Santa Clara Amador Del Norte Yolo Contra Costa Lake Santa Cruz Sonoma Sacramento Placer Solano San Joaquin Nevada Los Angeles San Diego Tulare 39 558 167 172 37 175 271 51 365 41 25 71 70 35 73 121 416 211 38 77 32 360 243 75 E 66 654 143 1759 709 816 165 707 864 257 1511 102 86 598 322 95 457 568 1535 961 201 198 161 1213 780 266 19.70% 29.66% 27.27% 31.72% 23.70% 21.20% 23.03% 24.75% 31.48% 20.23% 24.16% 41.18% 29.07% 12.04% 21.7496 37.89% 16.1996 21.49% 27.10% 22.06% 18.91% 38.89% 19.88% 29.68% 31.15% 28.20% G E 961 201 198 D 211 38 77 32 360 243 75 161 1213 780 266 A 220 Sutter Roseville Medical Center 221 Sutter Solano Medical Center 222 Sutter Tracy Community Hospital 223 Tahoe Forest Hospital 224 Torrance Memorial Medical Center 225 Tri-City Medical Center 226 Tulare District Hospital 227 Twin Cities Community Hospital 228 UC Davis Medical Center 229 UC Irvine Medical Center 230 UC San Diego Health System Hillcrest 231 UCSF Medical Center - Mt. Zion 232 Ukiah Valley Medical Center 233 Valley Presbyterian Hospital 234 Valley Care Health System 235 Ventura County Medical Center 236 Verdugo Hills Hospital 237 Victor Valley Community Hospital 238 Washington Hospital Healthcare System 239 Watsonville Community Hospital 240 West Hills Hospital & Medical Center 241 Western Medical Center - Anaheim 242 Western Medical Center - Santa Ana 243 White Memorial Medical Center 244 Whittier Hospital Medical Center 245 Woodland Healthcare California Section Rates B Roseville Vallejo Tracy Truckee Torrance Oceanside Tulare Templeton Sacramento Orange San Diego San Francisco Ukiah Van Nuys Pleasanton Ventura Glendale Victorville Fremont watsonville West Hills Anaheim Santa Ana Los Angeles Whittier Woodland placer Solano San Joaquin Nevada Los Angeles San Diego Tulare San Luis Obispo Sacramento Orange San Diego San Francisco Mendocino Los Angeles Alameda Ventura Los Angeles San Bernardino Alameda Santa Cruz Los Angeles Orange Orange Los Angeles Los Angeles Yolo 117 102 201 198 49 251 151 8S 92 91 226 107 105 74 221 421 445 868 1069 250 936 565 420 245 293 753 328 336 311 502 1101 1173 203 F 22.06% 18.91% 38.89% 19.88% 29.68% 31.15% 28,20% 20.36% 27.79% 22.87% 23.16% 18.52% 19.60% 26.92% 26.90% 20.48% 37.9696 31.40% 30.15% 32629 31-25% 23.79% 31.03% 24.70% 31.54% 17.73% 155 272 369 36 Please use the attached California C-Section Excel spreadsheet to complete this assignment. Using your knowledge of the VLOOKUP command in Microsoft Excel, please indicate the incidence of C-Sections per 100,000 females of childbearing age by county. Callfornia-C-Section-Rates.xls Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started