+1443 776-2705 panelessays@gmail.com

Competencies

In this project, you will demonstrate your mastery of the following competencies:

  • Use descriptive statistics for business analysis
  • Perform regression analysis to address an authentic problem
  • Apply statistics in the business environment

Overview

You have been hired as a consultant by a large hospital chain. As part of its expansion plan, the organization wants to open a new hospital in a small- to medium-sized town (with a population of 10,000–50,000). Previously, senior management hired a market research firm to do an initial feasibility analysis. The firm presented the management team with two options:

  • Option A: Open a small facility of 90–100 beds.
  • Option B: Open a medium-sized facility of 300–350 beds.

The hospital’s vice president of operations and finance has tasked you with doing an in-depth analysis to determine which of the two options will be the most profitable, given the expense range of $55–$75 million. The hospital has provided you with a data set that contains data about admissions, personnel, and hospital beds, and attributes of the data such as outpatient visits, births, total expense, and census information.

Prompt

Part 1: Data Analysis Workbook

Analyze the data from the provided Hospital Data Set (linked below) and identify current and future trends and patterns in operations.

  1. Descriptive Analysis: Open a new Excel file and title it Data Analysis Workbook. In the workbook, create a sheet titled P1_Descriptive Analysis. Present descriptive statistics (mean, median, standard deviation, and range) in a table for four attributes from the data set.
  2. Analyze the current hospital data to identify trends and patterns in hospital admissions and costs.
    1. Admission Trends and Charts: Create a sheet titled P1_Admission Trends in your Data Analysis Workbook. Then, create two pie charts and two column/bar charts. 
      1. For Pie Chart #1: One slice should be labeled Admissions. Choose another attribute for the second slice. For Pie Chart #2, both slices can be attributes of your choice.
      2. For the two column/bar charts: Ensure that one column is titled Admissions for both charts. Choose a different attribute for the other column.
    2. Expense Trends and Charts: Create a sheet titled P1_Expense Trends in your Data Analysis Workbook. Then, create two column charts and two line charts.
      1. For the two column/bar charts: Ensure that one column is titled Expense for both charts. Choose a different attribute for the other column.
      2. For Line Chart #1, one of the lines should represent Expense; choose another attribute for the second line. For Line Chart #2, both lines can represent attributes of your choice.
  3. Outliers: Identify any outliers that you see and explain how they have an impact on the overall admission and expense trends. Outliers are the data points that can have an impact on your averages and basic descriptive analysis.
  4. Identify future trends and attributes that impact expenses and admissions by adding new sheets to your Data Analysis Workbook per the descriptions below.
    1.  Perform two bivariate regressions to provide recommendations.
      1. For the first bivariate regression, the dependent variable should be Total Expense. Choose an independent variable from one of the remaining attributes.
      2. Create a sheet titled P2_1st_Bivariate_Regression in your Data Analysis Workbook.
      3. For the second bivariate regression, the dependent variable should be Admissions. Choose an independent variable from one of the remaining variables.
      4. Create a sheet titled P2_2nd_Bivariate_Regression in your Data Analysis Workbook.
      5. What would be the right attribute size (independent variable) seems most appropriate to lead you in the expense range of $55–$75 million?
    2. Perform two multivariate regressions to provide recommendations.
      1. For the first multivariate regression, the dependent variable should be Total Expense (the column in the data set). Choose two independent variables from one of the remaining attributes.
      2. Within your Data Analysis Workbook, create a sheet titled P2_1st_Multi_Regression.
      3. Which combination of the attributes seems most appropriate to lead you in the expense range of $55–$75 million?
      4. For the second multivariate regression, the dependent variable should be Admissions (the column name in the data set). You should choose two independent variables from one of the remaining attributes.
      5. Within your Data Analysis Workbook, create a sheet titled P2_2nd_Multi_Regression.
      6. Which combination of the attributes would seem appropriate that would lead you in the expense range of $55–$75 million?

Part 2: Final Recommendation Analysis PowerPoint Presentation

Create a presentation designed for senior management and the board of directors to share the results of your analysis and provide your final recommendation.

  1. Current State Analysis (slides 1–3): State the option (A or B) that you chose and three reasons for your choice.
    1. Which option (Option A or Option B) would you choose based on your analysis, given the expense range of $55–$75 million?
    2. Why did you choose your selected attributes?
    3. Describe any relationships or trends you observed while conducting your analysis.
  2. Predictions and Trends Analysis (slides 4–6): Present the predictions based on the regressions that you have analyzed.
    1. Briefly describe the key elements for each regression presented in Excel. Cite the regression coefficient, regression line equation, p–value, and significance F in your description.
    2. Which of the independent variables are impactful, and why?
  3. Summary (slide 7): Summarize your findings for an executive audience.

Guidelines for Submission

To complete this project, you must submit the following:

  • Data Analysis Workbook
    Submit your Data Analysis Workbook as an Excel file.
  • Final Recommendations Analysis:
    Create a PowerPoint presentation with 7-10 slides. Any sources should be cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations.

Supporting Materials

The following resources support your work on the project:

Data Set: Hospital Data Set

Use the following two sheets:

  1. All Hospitals
  2. Small Hospitals (Beds <= 40)

Sheet1

All Hospitals

Hospital Number State Region Number Control Number Service Number Beds Admissions Census Outpatient Visits Births Total Expense Payroll Expense Personnel Region Control Service Gen Med & Surg or Not Births or Not
0001 1 6 4 1 247 11801 144 120979 1111 147587 53436 947 East South Central NonGov NonProfit Gen Med & Surg 1 1
0002 1 6 6 1 69 3086 29 89568 455 66150 25627 467 East South Central Other Nonprofit Gen Med & Surg 1 1
0003 1 6 1 1 101 4076 43 122433 475 63002 26426 749 East South Central Gov NonFed Gen Med & Surg 1 1
0004 1 6 1 1 236 7342 113 196025 534 104601 42704 968 East South Central Gov NonFed Gen Med & Surg 1 1
0005 1 6 5 2 100 2538 90 11897 0 29113 15460 328 East South Central InvestorOwned ForProfit Rehab 0 0
0006 1 6 4 1 297 14081 227 105526 266 203360 79182 1459 East South Central NonGov NonProfit Gen Med & Surg 1 1
0007 1 6 6 1 328 15057 230 128566 1074 210436 68238 1089 East South Central Other Nonprofit Gen Med & Surg 1 1
0008 1 6 1 1 1062 71339 931 449155 4087 1211518 448379 7525 East South Central Gov NonFed Gen Med & Surg 1 1
0009 1 6 1 1 49 1882 19 44779 284 25958 10319 229 East South Central Gov NonFed Gen Med & Surg 1 1
0010 1 6 5 1 45 917 12 20227 0 17108 5357 137 East South Central InvestorOwned ForProfit Gen Med & Surg 1 0
0011 1 6 6 1 115 6558 64 91950 751 93554 35401 837 East South Central Other Nonprofit Gen Med & Surg 1 1
0012 1 6 6 7 66 1465 35 14 0 8759 5141 237 East South Central Other Nonprofit Psychiatric 0 0
0013 1 6 5 1 139 11296 144 145620 1223 171197 59085 1247 East South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0014 1 6 5 2 38 975 34 0 0 11908 7168 223 East South Central InvestorOwned ForProfit Rehab 0 0
0015 1 6 1 1 47 1492 23 34907 0 15951 7265 204 East South Central Gov NonFed Gen Med & Surg 1 0
0016 1 6 1 1 20 414 4 8559 1 12252 4658 543 East South Central Gov NonFed Gen Med & Surg 1 1
0017 1 6 5 1 286 13393 195 77055 1316 230662 53028 992 East South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0018 1 6 5 1 250 5911 99 61468 0 79855 24234 690 East South Central InvestorOwned ForProfit Gen Med & Surg 1 0
0019 1 6 1 1 163 1424 95 11071 0 20903 9601 283 East South Central Gov NonFed Gen Med & Surg 1 0
0020 1 6 1 1 90 4478 52 136322 326 58315 21382 398 East South Central Gov NonFed Gen Med & Surg 1 1
0021 1 6 5 1 150 9608 102 101608 696 141010 46399 918 East South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0022 1 6 1 1 876 42317 571 749346 5161 734465 294038 6355 East South Central Gov NonFed Gen Med & Surg 1 1
0023 1 6 1 1 70 1840 24 54693 342 23635 9615 191 East South Central Gov NonFed Gen Med & Surg 1 1
0024 1 6 4 1 236 7321 88 75454 759 88411 28799 582 East South Central NonGov NonProfit Gen Med & Surg 1 1
0025 1 6 6 4 60 881 20 0 0 4669 2400 101 East South Central Other Nonprofit Children’s 0 0
0026 1 6 4 1 349 14271 206 141714 1664 194730 67056 1594 East South Central NonGov NonProfit Gen Med & Surg 1 1
0027 1 6 5 1 192 9633 132 161064 616 132434 41923 1048 East South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0028 1 6 1 1 132 6961 113 52463 1 158332 72559 1335 East South Central Gov NonFed Gen Med & Surg 1 1
0029 1 6 1 1 183 9860 114 85838 3370 98885 38869 808 East South Central Gov NonFed Gen Med & Surg 1 1
0030 1 6 1 1 387 18638 251 244136 793 365265 92770 1830 East South Central Gov NonFed Gen Med & Surg 1 1
0031 1 6 2 1 245 2371 191 406795 0 239083 109056 1519 East South Central Gov Fed Gen Med & Surg 1 0
0032 1 6 5 2 70 1769 63 4895 0 17765 10375 181 East South Central InvestorOwned ForProfit Rehab 0 0
0033 1 6 6 1 251 12383 165 148650 1332 167909 62421 1305 East South Central Other Nonprofit Gen Med & Surg 1 1
0034 1 6 6 1 40 1087 12 36430 0 19832 6678 133 East South Central Other Nonprofit Gen Med & Surg 1 0
0035 1 6 6 1 40 2186 26 43691 0 25243 8994 188 East South Central Other Nonprofit Gen Med & Surg 1 0
0036 1 6 5 1 35 2494 23 25095 0 42454 12839 272 East South Central InvestorOwned ForProfit Gen Med & Surg 1 0
0037 1 6 1 1 50 2469 27 63552 0 31504 11267 233 East South Central Gov NonFed Gen Med & Surg 1 0
0038 1 6 1 1 684 31544 461 440489 3244 430129 195618 3735 East South Central Gov NonFed Gen Med & Surg 1 1
0039 2 9 5 4 200 1142 175 0 0 29618 17257 268 Pacific InvestorOwned ForProfit Children’s 0 0
0040 2 9 6 1 217 5137 128 314245 1164 209350 81309 998 Pacific Other Nonprofit Gen Med & Surg 1 1
0041 2 9 1 1 50 870 33 46231 122 49342 21551 317 Pacific Gov NonFed Gen Med & Surg 1 1
0042 2 9 1 1 45 2152 25 44336 379 85817 33660 404 Pacific Gov NonFed Gen Med & Surg 1 1
0043 2 9 4 1 50 1366 30 34846 223 61824 27145 409 Pacific NonGov NonProfit Gen Med & Surg 1 1
0044 2 9 6 1 25 736 22 23731 173 35091 17860 253 Pacific Other Nonprofit Gen Med & Surg 1 1
0045 2 9 5 1 74 4415 42 82404 736 106524 42325 447 Pacific InvestorOwned ForProfit Gen Med & Surg 1 1
0046 2 9 1 1 27 158 21 9395 1 12948 6131 99 Pacific Gov NonFed Gen Med & Surg 1 1
0047 2 9 6 1 117 2951 76 84606 459 111425 49283 651 Pacific Other Nonprofit Gen Med & Surg 1 1
0048 2 9 1 1 22 157 14 11538 0 9502 3412 56 Pacific Gov NonFed Gen Med & Surg 1 0
0049 3 8 6 1 22 342 3 14878 2 12856 6090 126 Mountain Other Nonprofit Gen Med & Surg 1 1
0050 3 8 6 1 14 368 4 36039 0 20618 10789 161 Mountain Other Nonprofit Gen Med & Surg 1 0
0051 3 8 6 1 243 17978 187 161416 3691 298698 123569 1671 Mountain Other Nonprofit Gen Med & Surg 1 1
0052 3 8 6 1 110 4487 50 96982 597 130830 50750 674 Mountain Other Nonprofit Gen Med & Surg 1 1
0053 3 8 6 1 267 13751 170 67590 1287 318500 117760 1590 Mountain Other Nonprofit Gen Med & Surg 1 1
0054 3 8 6 1 212 12992 125 90839 2877 206568 80582 1139 Mountain Other Nonprofit Gen Med & Surg 1 1
0055 3 8 5 2 75 1323 50 13283 0 20397 11673 157 Mountain InvestorOwned ForProfit Rehab 0 0
0056 3 8 6 1 25 1757 16 49705 286 36471 15949 245 Mountain Other Nonprofit Gen Med & Surg 1 1
0057 3 8 1 1 180 9204 116 385163 690 224503 96512 1562 Mountain Gov NonFed Gen Med & Surg 1 1
0058 3 8 4 1 25 1337 8 34937 726 23040 9507 145 Mountain NonGov NonProfit Gen Med & Surg 1 1
0059 3 8 6 1 25 569 6 27539 0 22599 9315 180 Mountain Other Nonprofit Gen Med & Surg 1 0
0060 3 8 1 7 299 64 237 0 0 55242 27553 465 Mountain Gov NonFed Psychiatric 0 0
0061 3 8 5 1 100 4781 49 52973 442 51593 27515 367 Mountain InvestorOwned ForProfit Gen Med & Surg 1 1
0062 3 8 6 1 268 12147 168 45444 0 394787 123267 3707 Mountain Other Nonprofit Gen Med & Surg 1 0
0063 3 8 6 4 363 12857 208 216121 0 626869 254026 3012 Mountain Other Nonprofit Children’s 0 0
0064 3 8 6 1 586 30222 403 472684 4708 888665 350540 4265 Mountain Other Nonprofit Gen Med & Surg 1 1
0065 3 8 6 1 134 6998 70 73441 0 167304 62244 955 Mountain Other Nonprofit Gen Med & Surg 1 0
0066 3 8 6 7 16 758 14 0 0 3775 2035 31 Mountain Other Nonprofit Psychiatric 0 0
0067 3 8 6 1 72 4185 31 47459 1039 49784 24466 416 Mountain Other Nonprofit Gen Med & Surg 1 1
0068 3 8 1 1 49 1902 11 156077 601 55487 24499 389 Mountain Gov NonFed Gen Med & Surg 1 1
0069 3 8 6 1 53 2516 19 30112 1030 57492 16770 290 Mountain Other Nonprofit Gen Med & Surg 1 1
0070 3 8 6 1 373 16138 194 106656 1687 232441 84904 1445 Mountain Other Nonprofit Gen Med & Surg 1 1
0071 3 8 6 1 73 2442 28 776354 450 143919 73733 1028 Mountain Other Nonprofit Gen Med & Surg 1 1
0072 3 8 4 1 486 16414 216 144429 2537 247813 90143 1429 Mountain NonGov NonProfit Gen Med & Surg 1 1
0073 3 8 4 1 262 11125 142 186699 0 187411 69626 1131 Mountain NonGov NonProfit Gen Med & Surg 1 0
0074 3 8 5 2 60 1096 37 3055 0 15401 7836 136 Mountain InvestorOwned ForProfit Rehab 0 0
0075 3 8 5 2 80 1490 52 0 0 18686 10580 183 Mountain InvestorOwned ForProfit Rehab 0 0
0076 3 8 5 7 72 2583 59 2545 0 16391 9507 154 Mountain InvestorOwned ForProfit Psychiatric 0 0
0077 3 8 6 1 591 30654 351 147876 5602 419401 169728 2912 Mountain Other Nonprofit Gen Med & Surg 1 1
0078 3 8 6 1 161 7249 110 206776 0 137169 50660 978 Mountain Other Nonprofit Gen Med & Surg 1 0
0079 3 8 6 1 479 23082 362 479259 1882 644405 212667 3710 Mountain Other Nonprofit Gen Med & Surg 1 1
0080 3 8 1 1 48 464 17 16243 0 17913 8626 163 Mountain Gov NonFed Gen Med & Surg 1 0
0081 3 8 6 1 406 16560 183 168888 3349 304891 116242 1615 Mountain Other Nonprofit Gen Med & Surg 1 1
0082 4 7 6 1 25 1239 13 27295 370 19450 8133 146 West South Central Other Nonprofit Gen Med & Surg 1 1
0083 4 7 6 1 210 8039 116 217948 740 153651 56908 1131 West South Central Other Nonprofit Gen Med & Surg 1 1
0084 4 7 5 7 77 2303 67 23 0 10396 5699 128 West South Central InvestorOwned ForProfit Psychiatric 0 0
0085 4 7 6 1 113 5673 72 73002 560 80571 39144 602 West South Central Other Nonprofit Gen Med & Surg 1 1
0086 4 7 4 1 25 814 8 28746 0 16303 8082 176 West South Central NonGov NonProfit Gen Med & Surg 1 0
0087 4 7 6 1 25 374 4 14809 0 9526 3902 78 West South Central Other Nonprofit Gen Med & Surg 1 0
0088 4 7 6 1 25 524 6 3454 0 7273 3211 72 West South Central Other Nonprofit Gen Med & Surg 1 0
0089 4 7 6 1 65 2104 18 31018 220 33644 15597 397 West South Central Other Nonprofit Gen Med & Surg 1 1
0090 4 7 6 1 80 2430 28 38167 419 31647 14511 339 West South Central Other Nonprofit Gen Med & Surg 1 1
0091 4 7 6 1 154 7871 85 106921 1827 130843 48161 1060 West South Central Other Nonprofit Gen Med & Surg 1 1
0092 4 7 1 2 26 409 14 0 0 4769 1407 46 West South Central Gov NonFed Rehab 0 0
0093 4 7 6 1 33 1172 16 78405 167 24258 11529 201 West South Central Other Nonprofit Gen Med & Surg 1 1
0094 4 7 6 1 41 2093 15 24010 0 18497 8556 197 West South Central Other Nonprofit Gen Med & Surg 1 0
0095 4 7 6 1 85 389 51 8865 0 9177 4828 160 West South Central Other Nonprofit Gen Med & Surg 1 0
0096 4 7 6 1 25 871 8 34604 91 13416 6274 144 West South Central Other Nonprofit Gen Med & Surg 1 1
0097 4 7 5 1 120 4510 45 53083 604 68026 23462 483 West South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0098 4 7 5 1 15 334 5 6270 0 7085 2851 83 West South Central InvestorOwned ForProfit Gen Med & Surg 1 0
0099 4 7 5 2 60 1353 48 5984 0 13106 7573 154 West South Central InvestorOwned ForProfit Rehab 0 0
0100 4 7 5 6 21 1067 5 7741 0 30261 8943 215 West South Central InvestorOwned ForProfit Surgical 0 0
0101 4 7 5 10 50 391 30 0 0 16160 6372 122 West South Central InvestorOwned ForProfit Long-term Acute 0 0
0102 4 7 5 7 80 2147 44 700 0 12626 4885 168 West South Central InvestorOwned ForProfit Psychiatric 0 0
0103 4 7 5 7 92 2116 82 135503 0 22604 14185 293 West South Central InvestorOwned ForProfit Psychiatric 0 0
0104 4 7 6 1 270 12221 137 143927 1108 191789 72823 1850 West South Central Other Nonprofit Gen Med & Surg 1 1
0105 4 7 1 1 22 343 3 23509 0 8672 3209 77 West South Central Gov NonFed Gen Med & Surg 1 0
0106 4 7 5 1 39 2253 21 34240 786 27178 8541 169 West South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0107 4 7 4 10 25 243 18 0 0 7986 3035 57 West South Central NonGov NonProfit Long-term Acute 0 0
0108 4 7 5 2 60 1349 42 6264 0 13460 7213 131 West South Central InvestorOwned ForProfit Rehab 0 0
0109 4 7 4 1 374 13423 181 155352 1803 222260 66364 1515 West South Central NonGov NonProfit Gen Med & Surg 1 1
0110 4 7 5 10 34 443 31 0 0 13380 4638 81 West South Central InvestorOwned ForProfit Long-term Acute 0 0
0111 4 7 5 1 303 16080 221 164022 1101 222233 67210 1654 West South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0112 4 7 5 1 25 688 10 34935 0 12491 5787 187 West South Central InvestorOwned ForProfit Gen Med & Surg 1 0
0113 4 7 6 1 127 4368 39 127489 761 73668 29860 728 West South Central Other Nonprofit Gen Med & Surg 1 1
0114 4 7 6 1 25 766 7 30365 0 18489 6063 135 West South Central Other Nonprofit Gen Med & Surg 1 0
0115 4 7 5 1 105 1738 13 23666 159 28610 8601 146 West South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0116 4 7 5 1 79 1210 18 25187 0 13394 6170 136 West South Central InvestorOwned ForProfit Gen Med & Surg 1 0
0117 4 7 5 1 193 6459 95 53731 545 69568 25673 552 West South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0118 4 7 4 10 26 184 13 0 0 5987 2189 48 West South Central NonGov NonProfit Long-term Acute 0 0
0119 4 7 6 7 50 1284 19 17409 0 7854 4421 104 West South Central Other Nonprofit Psychiatric 0 0
0120 4 7 4 1 282 12220 163 165910 939 177930 64996 1271 West South Central NonGov NonProfit Gen Med & Surg 1 1
0121 4 7 5 1 73 1462 29 54718 0 29140 13746 282 West South Central InvestorOwned ForProfit Gen Med & Surg 1 0
0122 4 7 6 1 100 6714 71 44448 801 93900 33731 717 West South Central Other Nonprofit Gen Med & Surg 1 1
0123 4 7 4 1 380 17108 195 235587 1329 253280 85355 1935 West South Central NonGov NonProfit Gen Med & Surg 1 1
0124 4 7 6 1 25 1065 11 19235 105 16257 7581 142 West South Central Other Nonprofit Gen Med & Surg 1 1
0125 4 7 5 2 15 195 6 0 0 3547 2277 49 West South Central InvestorOwned ForProfit Rehab 0 0
0126 4 7 6 4 338 14845 222 343993 0 481478 203821 3644 West South Central Other Nonprofit Children’s 0 0
0127 4 7 5 11 112 6212 57 29716 0 121442 34839 718 West South Central InvestorOwned ForProfit Heart 0 0
0128 4 7 1 7 222 657 202 0 0 54375 25253 605 West South Central Gov NonFed Psychiatric 0 0
0129 4 7 6 10 37 297 23 0 0 11923 4491 87 West South Central Other Nonprofit Long-term Acute 0 0
0130 4 7 6 1 688 28692 434 145990 3223 428638 137364 2497 West South Central Other Nonprofit Gen Med & Surg 1 1
0131 4 7 6 2 100 1429 50 128710 0 28984 13442 258 West South Central Other Nonprofit Rehab 0 0
0132 4 7 5 4 124 2485 108 348588 0 16482 9838 217 West South Central InvestorOwned ForProfit Children’s 0 0
0133 4 7 4 1 447 20145 279 147739 1567 362736 136371 1857 West South Central NonGov NonProfit Gen Med & Surg 1 1
0134 4 7 1 1 453 22679 373 443761 2945 579073 189007 3641 West South Central Gov NonFed Gen Med & Surg 1 1
0135 4 7 1 1 45 1611 12 31689 216 22819 10871 240 West South Central Gov NonFed Gen Med & Surg 1 1
0136 4 7 6 1 72 2210 24 32295 0 20739 10322 300 West South Central Other Nonprofit Gen Med & Surg 1 0
0137 4 7 6 4 60 1302 54 84229 0 15746 7478 132 West South Central Other Nonprofit Children’s 0 0
0138 4 7 6 1 25 287 3 6935 0 8982 4220 103 West South Central Other Nonprofit Gen Med & Surg 1 0
0139 4 7 1 1 65 1671 21 25702 335 26385 13139 247 West South Central Gov NonFed Gen Med & Surg 1 1
0140 4 7 6 1 49 2454 19 20172 305 26361 11180 260 West South Central Other Nonprofit Gen Med & Surg 1 1
0141 4 7 4 1 25 734 8 28124 0 15051 6127 111 West South Central NonGov NonProfit Gen Med & Surg 1 0
0142 4 7 6 1 209 8987 103 98943 626 153916 60890 1244 West South Central Other Nonprofit Gen Med & Surg 1 1
0143 4 7 6 1 25 866 9 19542 1 14154 5194 109 West South Central Other Nonprofit Gen Med & Surg 1 1
0144 4 7 6 1 20 553 6 27892 0 14018 5831 127 West South Central Other Nonprofit Gen Med & Surg 1 0
0145 4 7 5 1 104 1935 19 37988 363 31247 9415 185 West South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0146 4 7 5 1 51 3457 21 18489 0 45210 11859 217 West South Central InvestorOwned ForProfit Gen Med & Surg 1 0
0147 4 7 6 1 225 12197 131 121750 1512 162617 56567 999 West South Central Other Nonprofit Gen Med & Surg 1 1
0148 4 7 5 7 103 4218 85 10341 0 16963 8179 155 West South Central InvestorOwned ForProfit Psychiatric 0 0
0149 4 7 4 1 25 338 4 11676 0 9560 3628 51 West South Central NonGov NonProfit Gen Med & Surg 1 0
0150 4 7 6 1 125 44232 58 114887 518 58749 25991 541 West South Central Other Nonprofit Gen Med & Surg 1 1
0151 4 7 4 1 16 182 2 12120 0 7616 3189 46 West South Central NonGov NonProfit Gen Med & Surg 1 0
0152 4 7 1 1 25 849 13 11917 0 14501 7443 201 West South Central Gov NonFed Gen Med & Surg 1 0
0153 4 7 6 1 333 9216 146 203053 1023 179928 78359 1400 West South Central Other Nonprofit Gen Med & Surg 1 1
0154 4 7 6 1 46 796 12 19507 0 16498 7911 129 West South Central Other Nonprofit Gen Med & Surg 1 0
0155 4 7 4 1 147 10980 88 190838 1327 142139 43805 963 West South Central NonGov NonProfit Gen Med & Surg 1 1
0156 4 7 5 1 151 5907 69 76202 920 72983 23369 491 West South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0157 4 7 1 1 25 1016 12 15159 0 8757 3496 114 West South Central Gov NonFed Gen Med & Surg 1 0
0158 4 7 6 10 27 181 14 0 0 6848 2834 52 West South Central Other Nonprofit Long-term Acute 0 0
0159 4 7 6 1 286 11941 151 90279 1224 175492 78163 1233 West South Central Other Nonprofit Gen Med & Surg 1 1
0160 4 7 4 1 58 1758 17 26117 0 25923 8694 136 West South Central NonGov NonProfit Gen Med & Surg 1 0
0161 4 7 5 2 60 1556 51 6213 0 21421 10239 174 West South Central InvestorOwned ForProfit Rehab 0 0
0162 4 7 5 1 54 2211 17 30161 569 25934 11105 267 West South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0163 4 7 5 1 346 16323 170 170416 3784 216831 77320 1374 West South Central InvestorOwned ForProfit Gen Med & Surg 1 1
0164 4 7 6 1 49 1560 14 25746 206 24738 9100 212 West South Central Other Nonprofit Gen Med & Surg 1 1
0165 4 7 5 7 62 707 35 0 0 13188 7393 86 West South Central InvestorOwned ForProfit Psychiatric 0 0
0166 4 7 5 1 103 1727 15 35749 0 21248 7515 188 West South Central InvestorOwned ForProfit Gen Med & Surg 1 0
0167 4 7 4 1 24 340 4 26773 0 10196 3897 39 West South Central NonGov NonProfit Gen Med & Surg 1 0
0168 4 7 1 1 204 1173 173 23487 0 19690 10160 321 West South Central Gov NonFed Gen Med & Surg 1 0
0169 4 7 6 1 33 1446 15 46720 160 20904 8685 206 West South Central Other Nonprofit Gen Med & Surg 1 1
0170 4 7 4 1 15 656 7 17508 0 13508 5487 132 West South Central NonGov NonProfit Gen Med & Surg 1 0
0171 5 9 1 1 87 353 42 10826 0 14262 5612 135 Pacific Gov NonFed Gen Med & Surg 1 0
0172 5 9 6 1 136 7545 75 79412 976 172802 58133 770 Pacific Other Nonprofit Gen Med & Surg 1 1
0173 5 9 4 1 208 16629 174 141739 2570 265718 92189 1555 Pacific NonGov NonProfit Gen Med & Surg 1 1
0174 5 9 6 1 335 16620 209 65890 1823 272077 115729 1677 Pacific Other Nonprofit Gen Med & Surg 1 1
0175 5 9 6 1 67 2632 33 632249 0 70173 23422 299 Pacific Other Nonprofit Gen Med & Surg 1 0
0176 5 9 6 1 72 3784 34 98219 0 107843 35005 405 Pacific Other Nonprofit Gen Med & Surg 1 0
0177 5 9 4 1 255 17910 200 162968 3063 336015 123659 1920 Pacific NonGov NonProfit Gen Med & Surg 1 1
0178 5 9 5 10 91 966 74 0 0 33165 17529 247 Pacific InvestorOwned ForProfit Long-term Acute 0 0
0179 5 9 1 1 71 3280 35 42135 504 55980 23718 329 Pacific Gov NonFed Gen Med & Surg 1 1
0180 5 9 6 1 441 19306 284 176085 7071 686698 184498 1931 Pacific Other Nonprofit Gen Med & Surg 1 1
0181 5 9 1 1 30 166 20 35791 4 20116 10384 157 Pacific Gov NonFed Gen Med & Surg 1 1
0182 5 9 1 1 107 5512 45 99266 1733 97832 39751 703 Pacific Gov NonFed Gen Med & Surg 1 1
0183 5 9 6 1 320 14089 160 324087 1960 485942 143408 1575 Pacific Other Nonprofit Gen Med & Surg 1 1
0184 5 9 6 1 130 8550 95 66350 1250 281000 91305 897 Pacific Other Nonprofit Gen Med & Surg 1 1
0185 5 9 6 1 343 14606 268 109107 2704 305957 125190 1473 Pacific Other Nonprofit Gen Med & Surg 1 1
0186 5 9 4 1 25 1368 14 149712 190 67464 23778 356 Pacific NonGov NonProfit Gen Med & Surg 1 1
0187 5 9 1 1 436 23997 336 320686 2567 516531 170082 2812 Pacific Gov NonFed Gen Med & Surg 1 1
0188 5 9 6 1 183 9378 110 188944 0 372504 139870 1039 Pacific Other Nonprofit Gen Med & Surg 1 0
0189 5 9 6 1 181 2700 122 53761 0 78355 35154 431 Pacific Other Nonprofit Gen Med & Surg 1 0
0190 5 9 6 1 326 25303 287 153246 4100 357028 119378 1590 Pacific Other Nonprofit Gen Med & Surg 1 1
0191 5 9 6 1 49 2279 20 41255 341 66405 22091 373 Pacific Other Nonprofit Gen Med & Surg 1 1
0192 5 9 4 1 423 6873 236 192702 601 303344 132380 1060 Pacific NonGov NonProfit Gen Med & Surg 1 1
0193 5 9 6 1 48 3373 23 41692 1408 80226 26304 328 Pacific Other Nonprofit Gen Med & Surg 1 1
0194 5 9 6 1 199 11037 121 93334 1324 179064 73334 1033 Pacific Other Nonprofit Gen Med & Surg 1 1
0195 5 9 6 12 186 5997 164 189642 0 684310 234381 3041 Pacific Other Nonprofit Cancer 0 0
0196 5 9 1 1 161 6297 67 186696 1147 123250 46034 823 Pacific Gov NonFed Gen Med & Surg 1 1
0197 5 9 6 1 158 9404 109 67714 1706 214357 82420 1011 Pacific Other Nonprofit Gen Med & Surg 1 1
0198 5 9 1 1 345 21642 315 114112 3369 447038 171636 2077 Pacific Gov NonFed Gen Med & Surg 1 1
0199 5 9 4 1 153 6279 78 171660 574 185790 53610 955 Pacific NonGov NonProfit Gen Med & Surg 1 1
0200 5 9 6 1 170 8826 101 227507 1368 378159 163286 1295 Pacific Other Nonprofit Gen Med & Surg 1 1
0201 5 9 1 1 104 508 80 15650 60 21481 9101 208 Pacific Gov NonFed Gen Med & Surg 1 1
0202 5 9 4 1 106 5953 51 51097 904 145437 59514 479 Pacific NonGov NonProfit Gen Med & Surg 1 1
0203 5 9 4 1 25 1613 15 44276 392 37088 13170 167 Pacific NonGov NonProfit Gen Med & Surg 1 1
0204 5 9 6 1 218 12905 127 74017 1686 256109 69735 1105 Pacific Other Nonprofit Gen Med & Surg 1 1
0205 5 9 6 7 61 3601 50 0 0 13843 8748 117 Pacific Other Nonprofit Psychiatric 0 0
0206 5 9 6 1 808 38832 655 348909 6061 871869 314032 3814 Pacific Other Nonprofit Gen Med & Surg 1 1
0207 5 9 4 1 436 24390 255 323821 3771 455549 151705 1894 Pacific NonGov NonProfit Gen Med & Surg 1 1
0208 5 9 4 1 369 14804 195 242921 1931 450249 140813 1812 Pacific NonGov NonProfit Gen Med & Surg 1 1
0209 5 9 4 1 462 20074 286 264993 2401 397775 139112 1979 Pacific NonGov NonProfit Gen Med & Surg 1 1
0210 5 9 6 1 334 10014 133 102619 1989 233559 89607 1020 Pacific Other Nonprofit Gen Med & Surg 1 1
0211 5 9 6 13 75 4971 49 54911 866 71395 28346 363 Pacific Other Nonprofit Obstetrics & Gynecology 0 1
0212 5 9 6 1 173 9497 111 169545 1345 310565 120069 1128 Pacific Other Nonprofit Gen Med & Surg 1 1
0213 5 9 4 1 199 9890 114 211639 770 207403 80729 1587 Pacific NonGov NonProfit Gen Med & Surg 1 1
0214 5 9 4 1 49 2113 11 413225 1976 94608 32190 791 Pacific NonGov NonProfit Gen Med & Surg 1 1
0215 5 9 5 1 238 10867 131 49916 1311 122432 42298 675 Pacific InvestorOwned ForProfit Gen Med & Surg 1 1
0216 5 9 1 1 122 2528 116 134996 446 87839 34537 477 Pacific Gov NonFed Gen Med & Surg 1 1
0217 5 9 5 1 109 8204 68 52040 2186 106595 50344 627 Pacific InvestorOwned ForProfit Gen Med & Surg 1 1
0218 5 9 6 1 52 2440 23 41031 303 60080 20164 183 Pacific Other Nonprofit Gen Med & Surg 1 1
0219 5 9 1 1 179 3640 139 110437 460 60737 26214 431 Pacific Gov NonFed Gen Med & Surg 1 1
0220 5 9 6 1 173 10027 104 84988 0 309842 98842 1296 Pacific Other Nonprofit Gen Med & Surg 1 0
0221 5 9 6 1 285 16311 200 96820 3820 426789 150786 1943 Pacific Other Nonprofit Gen Med & Surg 1 1
0222 5 9 6 1 499 28574 338 302923 3772 578370 236687 2749 Pacific Other Nonprofit Gen Med & Surg 1 1
0223 5 9 6 1 313 15586 164 296798 2568 337574 114318 1518 Pacific Other Nonprofit Gen Med & Surg 1 1
0224 5 9 6 1 25 2036 19 75187 335 65266 21814 280 Pacific Other Nonprofit Gen Med & Surg 1 1
0225 5 9 5 1 153 8174 104 58377 0 140229 63308 718 Pacific InvestorOwned ForProfit Gen Med & Surg 1 0
0226 5 9 6 1 829 30867 538 638187 2691 1165015 418649 7109 Pacific Other Nonprofit Gen Med & Surg 1 1
0227 5 9 1 1 170 2265 125 62097 451 65162 25416 397 Pacific Gov NonFed Gen Med & Surg 1 1
0228 5 9 6 1 148 4468 53 25820 0 54357 23455 395 Pacific Other Nonprofit Gen Med & Surg 1 0
0229 5 9 6 1 420 21424 271 137612 0 474606 151120 3174 Pacific Other Nonprofit Gen Med & Surg 1 0
0230 5 9 6 4 373 16385 228 129813 5667 464833 143211 1260 Pacific Other Nonprofit Children’s 0 1
0231 5 9 6 1 131 10706 130 120664 2584 237292 98263 1057 Pacific Other Nonprofit Gen Med & Surg 1 1
0232 5 9 5 1 167 9645 114 83892 1398 152946 71135 880 Pacific InvestorOwned ForProfit Gen Med & Surg 1 1
0233 5 9 6 10 105 759 69 15 0 50347 21846 293 Pacific Other Nonprofit Long-term Acute 0 0
0234 5 9 6 1 318 17338 189 87049 4445 333375 128893 1358 Pacific Other Nonprofit Gen Med & Surg 1 1
0235 5 9 6 1 881 49752 689 715574 6908 2363629 897605 10915 Pacific Other Nonprofit Gen Med & Surg 1 1
0236 5 9 6 4 347 13822 282 318966 0 811422 338746 4663 Pacific Other Nonprofit Children’s 0 0
0237 5 9 5 1 127 4171 68 20690 756 81344 23704 391 Pacific InvestorOwned ForProfit Gen Med & Surg 1 1
0238 5 9 6 1 56 2223 86 10574 0 51550 20288 291 Pacific Other Nonprofit Gen Med & Surg 1 0
0239 5 9 6 7 55 991 36 115156 0 27151 14322 305 Pacific Other Nonprofit Psychiatric 0 0
0240 5 9 6 1 374 13117 164 81112 3942 277818 112266 1279 Pacific Other Nonprofit Gen Med & Surg 1 1
0241 5 9 5 1 434 13517 232 55188 3728 239041 91841 1168 Pacific InvestorOwned ForProfit Gen Med & Surg 1 1
0242 5 9 6 1 199 13337 107 72191 1835 1044977 103168 1105 Pacific Other Nonprofit Gen Med & Surg 1 1
0243 5 9 6 1 250 10078 208 308802 0 612026 195246 2553 Pacific Other Nonprofit Gen Med & Surg 1 0
0244 5 9 1 7 72 1066 70 124156 0 32013 18538 384 Pacific Gov NonFed Psychiatric 0 0
0245 5 9 6 1 371 15509 192 61943 1518 347874 142098 1648 Pacific Other Nonprofit Gen Med & Surg 1 1
0246 5 9 5 1 204 6060 80 36308 0 103970 43720 666 Pacific InvestorOwned ForProfit Gen Med & Surg 1 0
0247 5 9 6 1 327 6821 190 62051 621 176020 65088 751 Pacific Other Nonprofit Gen Med & Surg 1 1
0248 5 9 1 1 466 23222 448 736692 1936 1410580 544840 7350 Pacific Gov NonFed Gen Med & Surg 1 1
0249 5 9 6 4 30 351 2 11786 0 33325 13468 177 Pacific Other Nonprofit Children’s 0 0
0250 5 9 4 1 271 8215 131 94286 0 229408 78965 1035 Pacific NonGov NonProfit Gen Med & Surg 1 0
0251 5 9 1 7 74 2006 68 18189 0 49674 29840 323 Pacific Gov NonFed Psychiatric 0 0
0252 5 9 6 12 60 526 13 99109 0 113176 26591 432 Pacific Other Nonprofit Cancer 0 0
0253 5 9 6 1 350 15612 186 108565 3711 306479 110344 1433 Pacific Other Nonprofit Gen Med & Surg 1 1
0254 5 9 4 1 353 20151 246 70497 4053 339316 124483 1644 Pacific NonGov NonProfit Gen Med & Surg 1 1
0255 5 9 6 1 46 1377 10 52389 732 43261 13716 208 Pacific Other Nonprofit Gen Med & Surg 1 1
0256 5 9 6 4 340 12850 209 236383 0 432698 169765 1984 Pacific Other Nonprofit Children’s 0 0
0257 5 9 6 1 106 4570 56 148127 1568 86361 35029 782 Pacific Other Nonprofit Gen Med & Surg 1 1
0258 5 9 1 1 17 635 4 9885 110 57637 17304 259 Pacific Gov NonFed Gen Med & Surg 1 1
0259 5 9 5 1 73 3525 38 57106 708 67484 35108 387 Pacific InvestorOwned ForProfit Gen Med & Surg 1 1
0260 5 9 1 1 112 8886 111 389166 1960 470257 153631 1761 Pacific Gov NonFed Gen Med & Surg 1 1
0261 5 9 6 1 233 12456 140 155587 2041 288036 84332 1198 Pacific Other Nonprofit Gen Med & Surg 1 1
0262 5 9 6 1 12 246 1 2947 0 13669 4055 40 Pacific Other Nonprofit Gen Med & Surg 1 0
0263 5 9 4 1 186 10152 114 212537 794 245597 91338 1137 Pacific NonGov NonProfit Gen Med & Surg 1 1
0264 5 9 6 4 54 1863 21 22779 0 47141 7990 92 Pacific Other Nonprofit Children’s 0 0
0265 5 9 4 1 232 19850 232 185606 2825 430083 134390 1775 Pacific NonGov NonProfit Gen Med & Surg 1 1
0266 5 9 5 1 455 23520 335 133194 3917 400656 188071 1899 Pacific InvestorOwned ForProfit Gen Med & Surg 1 1
0267 5 9 6 1 423 17307 225 91564 1852 488759 155458 2023 Pacific Other Nonprofit Gen Med & Surg 1 1
0268 5 9 5 6 23 700 5 29355 0 32592 8784 173 Pacific InvestorOwned ForProfit Surgical 0 0
0269 5 9 6 1 248 11775 159 281892 1212 421951 143713 1668 Pacific Other Nonprofit Gen Med & Surg 1 1
0270 5 9 5 1 101 4676 43 19804 1495 69893 20412 295 Pacific InvestorOwned ForProfit Gen Med & Surg 1 1
0271 5 9 1 1 439 22131 329 286121 2442 458800 188192 2625 Pacific Gov NonFed Gen Med & Surg 1 1
0272 5 9 6 1 33 1096 8 57911 163 48964 20489 213 Pacific Other Nonprofit Gen Med & Surg 1 1
0273 5 9 1 1 420 19220 240 250113 5227 632313 276997 1549 Pacific Gov NonFed Gen Med & Surg 1 1
0274 5 9 5 1 252 14894 148 87896 3163 209218 96086 1140 Pacific InvestorOwned ForProfit Gen Med & Surg 1 1
0275 5 9