Use the AHA (American Hospital Association) database. Please address the following questions: 1. Is there a difference between the average number of personnel at a rehab hospital and a psychiatric...

Use the AHA (American Hospital Association) database. Please address the following questions:

1. Is there a difference between the average number of personnel at a rehab hospital and a psychiatric hospital? Use the Hospital (AHA) database as sample data to test this hypothesis with α = .10. The variable, Service, in the Hospital database differentiates rehab hospitals (coded 2) and psychiatric hospitals (coded 7). Assume that the number of personnel is approximately normally distributed in each population and that the population variances are equal. What did you find? Is there an explanation for the results?

2. Control of a hospital has to do with the type of ownership. Two of the types of ownership in the AHA database are Nongovernment Nonprofit (coded 4) and Other Nonprofit (coded 6). Is there a significant difference in number of beds between hospitals of these two types of ownership? Assume that the population standard deviation for Nongovernment Nonprofit is 160 and for Other Nonprofit is 150.

3. Compute the proportion of hospitals in the AHA database that are government nonfederal (Gov NonFed, coded 1) and the proportion of hospitals that are investor-owned for profit (Investor Owned For Profit, coded 5). Using these as sample proportions and their respective sample sizes in the database, test to determine if there is a significant difference in the proportions of these two types of hospital in the population. Let α = .01.

Sheet1 All Hospitals Hospital NumberStateRegion NumberControl NumberService NumberBedsAdmissionsCensusOutpatient VisitsBirthsTotal ExpensePayroll ExpensePersonnelRegion Control Control_CodeService Service_CodeGen Med & Surg or NotBirths or Not 0001164124711801144120979111114758753436947East South CentralNonGov NonProfit4Gen Med & Surg11 0002166169308629895684556615025627467East South CentralOther Nonprofit6Gen Med & Surg11 000316111014076431224334756300226426749East South CentralGov NonFed1Gen Med & Surg11 00041611236734211319602553410460142704968East South CentralGov NonFed1Gen Med & Surg11 000516521002538901189702911315460328East South CentralInvestorOwned ForProfit5Rehab200 0006164129714081227105526266203360791821459East South CentralNonGov NonProfit4Gen Med & Surg11 00071661328150572301285661074210436682381089East South CentralOther Nonprofit6Gen Med & Surg11 00081611106271339931449155408712115184483797525East South CentralGov NonFed1Gen Med & Surg11 0009161149188219447792842595810319229East South CentralGov NonFed1Gen Med & Surg11 001016514591712202270171085357137East South CentralInvestorOwned ForProfit5Gen Med & Surg10 00111661115655864919507519355435401837East South CentralOther Nonprofit6Gen Med & Surg11 001216676614653514087595141237East South CentralOther Nonprofit6Psychiatric700 00131651139112961441456201223171197590851247East South CentralInvestorOwned ForProfit5Gen Med & Surg11 00141652389753400119087168223East South CentralInvestorOwned ForProfit5Rehab200 0015161147149223349070159517265204East South CentralGov NonFed1Gen Med & Surg10 0016161120414485591122524658543East South CentralGov NonFed1Gen Med & Surg11 001716512861339319577055131623066253028992East South CentralInvestorOwned ForProfit5Gen Med & Surg11 001816512505911996146807985524234690East South CentralInvestorOwned ForProfit5Gen Med & Surg10 00191611163142495110710209039601283East South CentralGov NonFed1Gen Med & Surg10 00201611904478521363223265831521382398East South CentralGov NonFed1Gen Med & Surg11 00211651150960810210160869614101046399918East South CentralInvestorOwned ForProfit5Gen Med & Surg11 002216118764231757174934651617344652940386355East South CentralGov NonFed1Gen Med & Surg11 002316117018402454693342236359615191East South CentralGov NonFed1Gen Med & Surg11 00241641236732188754547598841128799582East South CentralNonGov NonProfit4Gen Med & Surg11 0025166460881200046692400101East South CentralOther Nonprofit6Children's00 00261641349142712061417141664194730670561594East South CentralNonGov NonProfit4Gen Med & Surg11 002716511929633132161064616132434419231048East South CentralInvestorOwned ForProfit5Gen Med & Surg11 002816111326961113524631158332725591335East South CentralGov NonFed1Gen Med & Surg11 0029161118398601148583833709888538869808East South CentralGov NonFed1Gen Med & Surg11 0030161138718638251244136793365265927701830East South CentralGov NonFed1Gen Med & Surg11 00311621245237119140679502390831090561519East South CentralGov FedGen Med & Surg10 0032165270176963489501776510375181East South CentralInvestorOwned ForProfit5Rehab200 00331661251123831651486501332167909624211305East South CentralOther Nonprofit6Gen Med & Surg11 0034166140108712364300198326678133East South CentralOther Nonprofit6Gen Med & Surg10 0035166140218626436910252438994188East South CentralOther Nonprofit6Gen Med & Surg10 00361651352494232509504245412839272East South CentralInvestorOwned ForProfit5Gen Med & Surg10 00371611502469276355203150411267233East South CentralGov NonFed1Gen Med & Surg10 003816116843154446144048932444301291956183735East South CentralGov NonFed1Gen Med & Surg11 003929542001142175002961817257268PacificInvestorOwned ForProfit5Children's00 004029612175137128314245116420935081309998PacificOther Nonprofit6Gen Med & Surg11 004129115087033462311224934221551317PacificGov NonFed1Gen Med & Surg11 0042291145215225443363798581733660404PacificGov NonFed1Gen Med & Surg11 0043294150136630348462236182427145409PacificNonGov NonProfit4Gen Med & Surg11 004429612573622237311733509117860253PacificOther Nonprofit6Gen Med & Surg11 00452951744415428240473610652442325447PacificInvestorOwned ForProfit5Gen Med & Surg11 0046291127158219395112948613199PacificGov NonFed1Gen Med & Surg11 004729611172951768460645911142549283651PacificOther Nonprofit6Gen Med & Surg11 0048291122157141153809502341256PacificGov NonFed1Gen Med & Surg10 00493861223423148782128566090126MountainOther Nonprofit6Gen Med & Surg11 005038611436843603902061810789161MountainOther Nonprofit6Gen Med & Surg10 005138612431797818716141636912986981235691671MountainOther Nonprofit6Gen Med & Surg11 005238611104487509698259713083050750674MountainOther Nonprofit6Gen Med & Surg11 00533861267137511706759012873185001177601590MountainOther Nonprofit6Gen Med & Surg11 0054386121212992125908392877206568805821139MountainOther Nonprofit6Gen Med & Surg11 00553852751323501328302039711673157MountainInvestorOwned ForProfit5Rehab200 0056386125175716497052863647115949245MountainOther Nonprofit6Gen Med & Surg11 005738111809204116385163690224503965121562MountainGov NonFed1Gen Med & Surg11 00583841251337834937726230409507145MountainNonGov NonProfit4Gen Med & Surg11 00593861255696275390225999315180MountainOther Nonprofit6Gen Med & Surg10 0060381729964237005524227553465MountainGov NonFed1Psychiatric700 00613851100478149529734425159327515367MountainInvestorOwned ForProfit5Gen Med & Surg11 00623861268121471684544403947871232673707MountainOther Nonprofit6Gen Med & Surg10 006338643631285720821612106268692540263012MountainOther Nonprofit6Children's00 006438615863022240347268447088886653505404265MountainOther Nonprofit6Gen Med & Surg11 0065386113469987073441016730462244955MountainOther Nonprofit6Gen Med & Surg10 006638671675814003775203531MountainOther Nonprofit6Psychiatric700 00673861724185314745910394978424466416MountainOther Nonprofit6Gen Med & Surg11 00683811491902111560776015548724499389MountainGov NonFed1Gen Med & Surg11 00693861532516193011210305749216770290MountainOther Nonprofit6Gen Med & Surg11 00703861373161381941066561687232441849041445MountainOther Nonprofit6Gen Med & Surg11 0071386173244228776354450143919737331028MountainOther Nonprofit6Gen Med & Surg11 00723841486164142161444292537247813901431429MountainNonGov NonProfit4Gen Med & Surg11 00733841262111251421866990187411696261131MountainNonGov NonProfit4Gen Med & Surg10 007438526010963730550154017836136MountainInvestorOwned ForProfit5Rehab200 0075385280149052001868610580183MountainInvestorOwned ForProfit5Rehab200 007638577225835925450163919507154MountainInvestorOwned ForProfit5Psychiatric700 007738615913065435114787656024194011697282912MountainOther Nonprofit6Gen Med & Surg11 007838611617249110206776013716950660978MountainOther Nonprofit6Gen Med & Surg10 007938614792308236247925918826444052126673710MountainOther Nonprofit6Gen Med & Surg11 008038114846417162430179138626163MountainGov NonFed1Gen Med & Surg10 008138614061656018316888833493048911162421615MountainOther Nonprofit6Gen Med & Surg11 008247612512391327295370194508133146West South CentralOther Nonprofit6Gen Med & Surg11 008347612108039116217948740153651569081131West South CentralOther Nonprofit6Gen Med & Surg11 0084475777230367230103965699128West South CentralInvestorOwned ForProfit5Psychiatric700 00854761113567372730025608057139144602West South CentralOther Nonprofit6Gen Med & Surg11 00864741258148287460163038082176West South CentralNonGov NonProfit4Gen Med & Surg10 008747612537441480909526390278West South CentralOther Nonprofit6Gen Med & Surg10 00884761255246345407273321172West South CentralOther Nonprofit6Gen Med & Surg10 0089476165210418310182203364415597397West South CentralOther Nonprofit6Gen Med & Surg11 0090476180243028381674193164714511339West South CentralOther Nonprofit6Gen Med & Surg11 009147611547871851069211827130843481611060West South CentralOther Nonprofit6Gen Med & Surg11 009247122640914004769140746West South CentralGov NonFed1Rehab200 0093476133117216784051672425811529201West South CentralOther Nonprofit6Gen Med & Surg11 0094476141209315240100184978556197West South CentralOther Nonprofit6Gen Med & Surg10 0095476185389518865091774828160West South CentralOther Nonprofit6Gen Med & Surg10 009647612587183460491134166274144West South CentralOther Nonprofit6Gen Med & Surg11 00974751120451045530836046802623462483West South CentralInvestorOwned ForProfit5Gen Med & Surg11 00984751153345627007085285183West South CentralInvestorOwned ForProfit5Gen Med & Surg10 009947526013534859840131067573154West South CentralInvestorOwned ForProfit5Rehab200 01004756211067577410302618943215West South CentralInvestorOwned ForProfit5Surgical00 010147510503913000161606372122West South CentralInvestorOwned ForProfit5Long-term Acute00 01024757802147447000126264885168West South CentralInvestorOwned ForProfit5Psychiatric700 010347579221168213550302260414185293West South CentralInvestorOwned ForProfit5Psychiatric700 01044761270122211371439271108191789728231850West South CentralOther Nonprofit6Gen Med & Surg11 010547112234332350908672320977West South CentralGov NonFed1Gen Med & Surg10 010647513922532134240786271788541169West South CentralInvestorOwned ForProfit5Gen Med & Surg11 0107474102524318007986303557West South CentralNonGov NonProfit4Long-term Acute00 010847526013494262640134607213131West South CentralInvestorOwned ForProfit5Rehab200 01094741374134231811553521803222260663641515West South CentralNonGov NonProfit4Gen Med & Surg11 01104751034443310013380463881West South CentralInvestorOwned ForProfit5Long-term Acute00 01114751303160802211640221101222233672101654West South CentralInvestorOwned ForProfit5Gen Med & Surg11 011247512568810349350124915787187West South CentralInvestorOwned ForProfit5Gen Med & Surg10 011347611274368391274897617366829860728West South CentralOther Nonprofit6Gen Med & Surg11 01144761257667303650184896063135West South CentralOther Nonprofit6Gen Med & Surg10 0115475110517381323666159286108601146West South CentralInvestorOwned ForProfit5Gen Med & Surg11 0116475179121018251870133946170136West South CentralInvestorOwned ForProfit5Gen Med & Surg10 01174751193645995537315456956825673552West South CentralInvestorOwned ForProfit5Gen Med & Surg11 0118474102618413005987218948West South CentralNonGov NonProfit4Long-term Acute00 011947675012841917409078544421104West South CentralOther Nonprofit6Psychiatric700 0120474128212220163165910939177930649961271West South CentralNonGov NonProfit4Gen Med & Surg11 01214751731462295471802914013746282West South CentralInvestorOwned ForProfit5Gen Med & Surg10 01224761100671471444488019390033731717West South CentralOther Nonprofit6Gen Med & Surg11 01234741380171081952355871329253280853551935West South CentralNonGov NonProfit4Gen Med & Surg11 012447612510651119235105162577581142West South CentralOther Nonprofit6Gen Med & Surg11 01254752151956003547227749West South CentralInvestorOwned ForProfit5Rehab200 012647643381484522234399304814782038213644West South CentralOther Nonprofit6Children's00 01274751111262125729716012144234839718West South CentralInvestorOwned ForProfit5Heart00 01284717222657202005437525253605West South CentralGov NonFed1Psychiatric700 01294761037297230011923449187West South CentralOther Nonprofit6Long-term Acute00 013047616882869243414599032234286381373642497West South CentralOther Nonprofit6Gen Med & Surg11 0131476210014295012871002898413442258West South CentralOther Nonprofit6Rehab200 0132475412424851083485880164829838217West South CentralInvestorOwned ForProfit5Children's00 013347414472014527914773915673627361363711857West South CentralNonGov NonProfit4Gen Med & Surg11 013447114532267937344376129455790731890073641West South CentralGov NonFed1Gen Med & Surg11 0135471145161112316892162281910871240West South CentralGov NonFed1Gen Med & Surg11 01364761722210243229502073910322300West South CentralOther Nonprofit6Gen Med & Surg10 0137476460130254842290157467478132West South CentralOther Nonprofit6Children's00 013847612528736935089824220103West South CentralOther Nonprofit6Gen Med & Surg10 0139471165167121257023352638513139247West South CentralGov NonFed1Gen Med & Surg11 0140476149245419201723052636111180260West South CentralOther Nonprofit6Gen Med & Surg11 01414741257348281240150516127111West South CentralNonGov NonProfit4Gen Med & Surg10 01424761209898710398943626153916608901244West South CentralOther Nonprofit6Gen Med & Surg11 01434761258669195421141545194109West South CentralOther Nonprofit6Gen Med & Surg11 01444761205536278920140185831127West South CentralOther Nonprofit6Gen Med & Surg10 0145475110419351937988363312479415185West South CentralInvestorOwned ForProfit5Gen Med & Surg11 01464751513457211848904521011859217West South CentralInvestorOwned ForProfit5Gen Med & Surg10 0147476122512197131121750151216261756567999West South CentralOther Nonprofit6Gen Med & Surg11 01484757103421885103410169638179155West South CentralInvestorOwned ForProfit5Psychiatric700 014947412533841167609560362851West South CentralNonGov NonProfit4Gen Med & Surg10 0150476112544232581148875185874925991541West South CentralOther Nonprofit6Gen Med & Surg11 015147411618221212007616318946West South CentralNonGov NonProfit4Gen Med & Surg10 015247112584913119170145017443201West South CentralGov NonFed1Gen Med & Surg10 0153476133392161462030531023179928783591400West South CentralOther Nonprofit6Gen Med & Surg11 015447614679612195070164987911129West South CentralOther Nonprofit6Gen Med & Surg10 015547411471098088190838132714213943805963West South CentralNonGov NonProfit4Gen Med & Surg11 01564751151590769762029207298323369491West South CentralInvestorOwned ForProfit5Gen Med & Surg11 015747112510161215159087573496114West South CentralGov NonFed1Gen Med & Surg10 0158476102718114006848283452West South CentralOther Nonprofit6Long-term Acute00 0159476128611941151902791224175492781631233West South CentralOther Nonprofit6Gen Med & Surg11 0160474158175817261170259238694136West South CentralNonGov NonProfit4Gen Med & Surg10 0161475260155651621302142110239174West South CentralInvestorOwned ForProfit5Rehab200 0162475154221117301615692593411105267West South CentralInvestorOwned ForProfit5Gen Med & Surg11 01634751346163231701704163784216831773201374West South CentralInvestorOwned ForProfit5Gen Med & Surg11 016447614915601425746206247389100212West South CentralOther Nonprofit6Gen Med & Surg11 0165475762707350013188739386West South CentralInvestorOwned ForProfit5Psychiatric700 01664751103172715357490212487515188West South CentralInvestorOwned ForProfit5Gen Med & Surg10 0167474124340426773010196389739West South CentralNonGov NonProfit4Gen Med & Surg10 0168471120411731732348701969010160321West South CentralGov NonFed1Gen Med & Surg10 016947613314461546720160209048685206West South CentralOther Nonprofit6Gen Med & Surg11 01704741156567175080135085487132West South CentralNonGov NonProfit4Gen Med & Surg10 017159118735342108260142625612135PacificGov NonFed1Gen Med & Surg10 017259611367545757941297617280258133770PacificOther Nonprofit6Gen Med & Surg11 01735941208166291741417392570265718921891555PacificNonGov NonProfit4Gen Med & Surg11 01745961335166202096589018232720771157291677PacificOther Nonprofit6Gen Med & Surg11 017559616726323363224907017323422299PacificOther Nonprofit6Gen Med & Surg10 017659617237843498219010784335005405PacificOther Nonprofit6Gen Med & Surg10 017759412551791020016296830633360151236591920PacificNonGov NonProfit4Gen Med & Surg11 0178595109196674003316517529247PacificInvestorOwned ForProfit5Long-term Acute00 0179591171328035421355045598023718329PacificGov NonFed1Gen Med & Surg11 018059614411930628417608570716866981844981931PacificOther Nonprofit6Gen Med & Surg11 0181591130166203579142011610384157PacificGov NonFed1Gen Med & Surg11 018259111075512459926617339783239751703PacificGov NonFed1Gen Med & Surg11 018359613201408916032408719604859421434081575PacificOther Nonprofit6Gen Med & Surg11 0184596113085509566350125028100091305897PacificOther Nonprofit6Gen Med & Surg11 018559613431460626810910727043059571251901473PacificOther Nonprofit6Gen Med & Surg11 01865941251368141497121906746423778356PacificNonGov NonProfit4Gen Med & Surg11 018759114362399733632068625675165311700822812PacificGov NonFed1Gen Med & Surg11 01885961183937811018894403725041398701039PacificOther Nonprofit6Gen Med & Surg10 0189596118127001225376107835535154431PacificOther Nonprofit6Gen Med & Surg10 019059613262530328715324641003570281193781590PacificOther Nonprofit6Gen Med & Surg11 0191596149227920412553416640522091373PacificOther Nonprofit6Gen Med & Surg11 0192594142368732361927026013033441323801060PacificNonGov NonProfit4Gen Med & Surg11 01935961483373234169214088022626304328PacificOther Nonprofit6Gen Med & Surg11 0194596119911037121933341324179064733341033PacificOther Nonprofit6Gen Med & Surg11 019559612186599716418964206843102343813041PacificOther Nonprofit6Cancer00 01965911161629767186696114712325046034823PacificGov NonFed1Gen Med & Surg11 019759611589404109677141706214357824201011PacificOther Nonprofit6Gen Med & Surg11 019859113452164231511411233694470381716362077PacificGov NonFed1Gen Med & Surg11 0199594115362797817166057418579053610955PacificNonGov NonProfit4Gen Med & Surg11 02005961170882610122750713683781591632861295PacificOther Nonprofit6Gen Med & Surg11 Rehab & Psych Hospital NumberStateRegion NumberControl NumberService NumberBedsAdmissionsCensusOutpatient VisitsBirthsTotal ExpensePayroll ExpensePersonnelRegion Control Service Service_CodeGen Med & Surg or NotBirths or Not 000516521002538901189702911315460328East South CentralInvestorOwned ForProfitRehab200 001216676614653514087595141237East South CentralOther NonprofitPsychiatric700 00141652389753400119087168223East South CentralInvestorOwned ForProfitRehab200 0032165270176963489501776510375181East South CentralInvestorOwned ForProfitRehab200 00553852751323501328302039711673157MountainInvestorOwned ForProfitRehab200 0060381729964237005524227553465MountainGov NonFedPsychiatric700 006638671675814003775203531MountainOther NonprofitPsychiatric700 007438526010963730550154017836136MountainInvestorOwned ForProfitRehab200 0075385280149052001868610580183MountainInvestorOwned ForProfitRehab200 007638577225835925450163919507154MountainInvestorOwned ForProfitPsychiatric700 0084475777230367230103965699128West South CentralInvestorOwned ForProfitPsychiatric700 009247122640914004769140746West South CentralGov NonFedRehab200 009947526013534859840131067573154West South CentralInvestorOwned ForProfitRehab200 01024757802147447000126264885168West South CentralInvestorOwned ForProfitPsychiatric700 010347579221168213550302260414185293West South CentralInvestorOwned ForProfitPsychiatric700 010847526013494262640134607213131West South CentralInvestorOwned ForProfitRehab200 011947675012841917409078544421104West South CentralOther NonprofitPsychiatric700 01254752151956003547227749West South CentralInvestorOwned ForProfitRehab200 01284717222657202005437525253605West South CentralGov NonFedPsychiatric700 0131476210014295012871002898413442258West South CentralOther NonprofitRehab200 01484757103421885103410169638179155West South CentralInvestorOwned ForProfitPsychiatric700 0161475260155651621302142110239174West South CentralInvestorOwned ForProfitRehab200 0165475762707350013188739386West South CentralInvestorOwned ForProfitPsychiatric700 NonGvmtNonPr & OtherNonPr Hospital NumberStateRegion NumberControl NumberService NumberBedsAdmissionsCensusOutpatient VisitsBirthsTotal ExpensePayroll ExpensePersonnelRegion Control Control_CodeService Service_CodeGen Med & Surg or NotBirths or Not 0001164124711801144120979111114758753436947East South CentralNonGov NonProfit4Gen Med & Surg11 0002166169308629895684556615025627467East South CentralOther Nonprofit6Gen Med & Surg11 0006164129714081227105526266203360791821459East South CentralNonGov NonProfit4Gen Med & Surg11 00071661328150572301285661074210436682381089East South CentralOther Nonprofit6Gen Med & Surg11 00111661115655864919507519355435401837East South CentralOther Nonprofit6Gen Med & Surg11 001216676614653514087595141237East South CentralOther Nonprofit6Psychiatric700 00241641236732188754547598841128799582East South CentralNonGov NonProfit4Gen Med & Surg11 0025166460881200046692400101East South CentralOther Nonprofit6Children's00 00261641349142712061417141664194730670561594East South CentralNonGov NonProfit4Gen Med & Surg11 00331661251123831651486501332167909624211305East South CentralOther Nonprofit6Gen Med & Surg11 0034166140108712364300198326678133East South CentralOther Nonprofit6Gen Med & Surg10 0035166140218626436910252438994188East South CentralOther Nonprofit6Gen Med & Surg10 004029612175137128314245116420935081309998PacificOther Nonprofit6Gen Med & Surg11 0043294150136630348462236182427145409PacificNonGov NonProfit4Gen Med & Surg11 004429612573622237311733509117860253PacificOther Nonprofit6Gen Med & Surg11 004729611172951768460645911142549283651PacificOther Nonprofit6Gen Med & Surg11 00493861223423148782128566090126MountainOther Nonprofit6Gen Med & Surg11 005038611436843603902061810789161MountainOther Nonprofit6Gen Med & Surg10 005138612431797818716141636912986981235691671MountainOther Nonprofit6Gen Med & Surg11 005238611104487509698259713083050750674MountainOther Nonprofit6Gen Med & Surg11 00533861267137511706759012873185001177601590MountainOther Nonprofit6Gen Med & Surg11 0054386121212992125908392877206568805821139MountainOther Nonprofit6Gen Med & Surg11 0056386125175716497052863647115949245MountainOther Nonprofit6Gen Med & Surg11 00583841251337834937726230409507145MountainNonGov NonProfit4Gen Med & Surg11 00593861255696275390225999315180MountainOther Nonprofit6Gen Med & Surg10 00623861268121471684544403947871232673707MountainOther Nonprofit6Gen Med & Surg10 006338643631285720821612106268692540263012MountainOther Nonprofit6Children's00 006438615863022240347268447088886653505404265MountainOther Nonprofit6Gen Med & Surg11 0065386113469987073441016730462244955MountainOther Nonprofit6Gen Med & Surg10 006638671675814003775203531MountainOther Nonprofit6Psychiatric700 00673861724185314745910394978424466416MountainOther Nonprofit6Gen Med & Surg11 00693861532516193011210305749216770290MountainOther Nonprofit6Gen Med & Surg11 00703861373161381941066561687232441849041445MountainOther Nonprofit6Gen Med & Surg11 0071386173244228776354450143919737331028MountainOther Nonprofit6Gen Med & Surg11 00723841486164142161444292537247813901431429MountainNonGov NonProfit4Gen Med & Surg11 00733841262111251421866990187411696261131MountainNonGov NonProfit4Gen Med & Surg10 007738615913065435114787656024194011697282912MountainOther Nonprofit6Gen Med & Surg11 007838611617249110206776013716950660978MountainOther Nonprofit6Gen Med & Surg10 007938614792308236247925918826444052126673710MountainOther Nonprofit6Gen Med & Surg11 008138614061656018316888833493048911162421615MountainOther Nonprofit6Gen Med & Surg11 008247612512391327295370194508133146West South CentralOther Nonprofit6Gen Med & Surg11 008347612108039116217948740153651569081131West South CentralOther Nonprofit6Gen Med & Surg11 00854761113567372730025608057139144602West South CentralOther Nonprofit6Gen Med & Surg11 00864741258148287460163038082176West South CentralNonGov NonProfit4Gen Med & Surg10 008747612537441480909526390278West South CentralOther Nonprofit6Gen Med & Surg10 00884761255246345407273321172West South CentralOther Nonprofit6Gen Med & Surg10 0089476165210418310182203364415597397West South CentralOther Nonprofit6Gen Med & Surg11 0090476180243028381674193164714511339West South CentralOther Nonprofit6Gen Med & Surg11 009147611547871851069211827130843481611060West South CentralOther Nonprofit6Gen Med & Surg11 0093476133117216784051672425811529201West South CentralOther Nonprofit6Gen Med & Surg11 0094476141209315240100184978556197West South CentralOther Nonprofit6Gen Med & Surg10 0095476185389518865091774828160West South CentralOther Nonprofit6Gen Med & Surg10 009647612587183460491134166274144West South CentralOther Nonprofit6Gen Med & Surg11 01044761270122211371439271108191789728231850West South CentralOther Nonprofit6Gen Med & Surg11 0107474102524318007986303557West South CentralNonGov NonProfit4Long-term Acute00 01094741374134231811553521803222260663641515West South CentralNonGov NonProfit4Gen Med & Surg11 011347611274368391274897617366829860728West South CentralOther Nonprofit6Gen Med & Surg11 01144761257667303650184896063135West South CentralOther Nonprofit6Gen Med & Surg10 0118474102618413005987218948West South CentralNonGov NonProfit4Long-term Acute00 011947675012841917409078544421104West South CentralOther Nonprofit6Psychiatric700 0120474128212220163165910939177930649961271West South CentralNonGov NonProfit4Gen Med & Surg11 01224761100671471444488019390033731717West South CentralOther Nonprofit6Gen Med & Surg11 01234741380171081952355871329253280853551935West South CentralNonGov NonProfit4Gen Med & Surg11 012447612510651119235105162577581142West South CentralOther Nonprofit6Gen Med & Surg11 012647643381484522234399304814782038213644West South CentralOther Nonprofit6Children's00 01294761037297230011923449187West South CentralOther Nonprofit6Long-term Acute00 013047616882869243414599032234286381373642497West South CentralOther Nonprofit6Gen Med & Surg11 0131476210014295012871002898413442258West South CentralOther Nonprofit6Rehab200 013347414472014527914773915673627361363711857West South CentralNonGov NonProfit4Gen Med & Surg11 01364761722210243229502073910322300West South CentralOther Nonprofit6Gen Med & Surg10 0137476460130254842290157467478132West South CentralOther Nonprofit6Children's00 013847612528736935089824220103West South CentralOther Nonprofit6Gen Med & Surg10 0140476149245419201723052636111180260West South CentralOther Nonprofit6Gen Med & Surg11 01414741257348281240150516127111West South CentralNonGov NonProfit4Gen Med & Surg10 01424761209898710398943626153916608901244West South CentralOther Nonprofit6Gen Med & Surg11 01434761258669195421141545194109West South CentralOther Nonprofit6Gen Med & Surg11 01444761205536278920140185831127West South CentralOther Nonprofit6Gen Med & Surg10 0147476122512197131121750151216261756567999West South CentralOther Nonprofit6Gen Med & Surg11 014947412533841167609560362851West South CentralNonGov NonProfit4Gen Med & Surg10 0150476112544232581148875185874925991541West South CentralOther Nonprofit6Gen Med & Surg11 015147411618221212007616318946West South CentralNonGov NonProfit4Gen Med & Surg10 0153476133392161462030531023179928783591400West South CentralOther Nonprofit6Gen Med & Surg11 015447614679612195070164987911129West South CentralOther Nonprofit6Gen Med & Surg10 015547411471098088190838132714213943805963West South CentralNonGov NonProfit4Gen Med & Surg11 0158476102718114006848283452West South CentralOther Nonprofit6Long-term Acute00 0159476128611941151902791224175492781631233West South CentralOther Nonprofit6Gen Med & Surg11 0160474158175817261170259238694136West South CentralNonGov NonProfit4Gen Med & Surg10 016447614915601425746206247389100212West South CentralOther Nonprofit6Gen Med & Surg11 0167474124340426773010196389739West South CentralNonGov NonProfit4Gen Med & Surg10 016947613314461546720160209048685206West South CentralOther Nonprofit6Gen Med & Surg11 01704741156567175080135085487132West South CentralNonGov NonProfit4Gen Med & Surg10 017259611367545757941297617280258133770PacificOther Nonprofit6Gen Med & Surg11 01735941208166291741417392570265718921891555PacificNonGov NonProfit4Gen Med & Surg11 01745961335166202096589018232720771157291677PacificOther Nonprofit6Gen Med & Surg11 017559616726323363224907017323422299PacificOther Nonprofit6Gen Med & Surg10 017659617237843498219010784335005405PacificOther Nonprofit6Gen Med & Surg10 017759412551791020016296830633360151236591920PacificNonGov NonProfit4Gen Med & Surg11 018059614411930628417608570716866981844981931PacificOther Nonprofit6Gen Med & Surg11 018359613201408916032408719604859421434081575PacificOther Nonprofit6Gen Med & Surg11 0184596113085509566350125028100091305897PacificOther Nonprofit6Gen Med & Surg11 018559613431460626810910727043059571251901473PacificOther Nonprofit6Gen Med & Surg11 01865941251368141497121906746423778356PacificNonGov NonProfit4Gen Med & Surg11 01885961183937811018894403725041398701039PacificOther Nonprofit6Gen Med & Surg10 0189596118127001225376107835535154431PacificOther Nonprofit6Gen Med & Surg10 019059613262530328715324641003570281193781590PacificOther Nonprofit6Gen Med & Surg11 0191596149227920412553416640522091373PacificOther Nonprofit6Gen Med & Surg11 0192594142368732361927026013033441323801060PacificNonGov NonProfit4Gen Med & Surg11 01935961483373234169214088022626304328PacificOther Nonprofit6Gen Med & Surg11 0194596119911037121933341324179064733341033PacificOther Nonprofit6Gen Med & Surg11 019559612186599716418964206843102343813041PacificOther Nonprofit6Cancer00 019759611589404109677141706214357824201011PacificOther Nonprofit6Gen Med & Surg11 0199594115362797817166057418579053610955PacificNonGov NonProfit4Gen Med & Surg11 02005961170882610122750713683781591632861295PacificOther Nonprofit6Gen Med & Surg11 GovNonFed & InvOwned Hospital NumberStateRegion NumberControl NumberService NumberBedsAdmissionsCensusOutpatient VisitsBirthsTotal ExpensePayroll ExpensePersonnelRegion Control Control_CodeService Service_CodeGen Med & Surg or NotBirths or Not 000316111014076431224334756300226426749East South CentralGov NonFed1Gen Med & Surg11 00041611236734211319602553410460142704968East South CentralGov NonFed1Gen Med & Surg11 000516521002538901189702911315460328East South CentralInvestorOwned ForProfit5Rehab200 00081611106271339931449155408712115184483797525East South CentralGov NonFed1Gen Med & Surg11 0009161149188219447792842595810319229East South CentralGov NonFed1Gen Med & Surg11 001016514591712202270171085357137East South CentralInvestorOwned ForProfit5Gen