Financial Database Hospital Database The financial database contains observations on eight variables for 100 companies. The variables are Type of Industry, To Revenues ($ millions), Total Assets ($ millions), Return on Equity (%), Earnings per Share ($), Average Yield (%), Dividend per Share ($), and Average Price per Earnings (P/E) ratio. The data were gathered from Moody's Handbook of Common Stocks. The companies represent seven different types of industries. The variable "Type" displays a company's industry ty as: 1 = apparel 2 = chemical 3 = electric power 4 = grocery 5 = healthcare products 6 = insurance 7 = petroleum This database contains observations for 11 variables on U.S. hospitals. These variables include Geographic Region, Cont Service, Number of Beds, Number of Admissions, Census, Number of Outpatients, Number of Births, Total Expenditures, P Expenditures, and Personnel. Information for these databases is taken from the American Hospital Association Guide to th Health-Care Field, published in Chicago, Illinois. The region variable is coded from 1 to 7, and the numbers represent the following regions. South 2 = Northeast 3 = Midwest 4 = Southwest 5 = Rocky Mountain 6 = California 7 = Northwest Control is a type of ownership. Four categories of control are included in the database: 1 = government, nonfederal 2 = nongovernment, not-for-profit 3 = for-profit 4 = federal government Service is the type of hospital. The two types of hospitals used in this database are: 1 = general medical 2 = psychiatric The total expenditures and payroll variables are in units of $1,000. 1= on, Control, nditures, Payroll Guide to the Company AFLAC Albertson's Allstate Amerada Hess American General American Stores Amoco Arco Chemical Ashland Atlantic Richfield Bausch & Lomb Baxter International Bristol-Myers Squibb Burlington Coat Central Maine Power Chevron CIGNA Cinergy Dayton Hudson Dillard's Dominion Resources Dow Chemical DPL E. I. DuPont DeNemours Eastman Chemical Edison International Engelhard Entergy Equitable Ethyl Exxon FPL Group The GAP Georgia Gulf GIANT Food A&P Great Lakes Chemicals Green Mountain Power Company Hannaford Bros. Hercules Houston Industries Jefferson-Pilot Johnson & Johnson Liberty The Limited Lincoln National Lubrizol Lyondell Petrochemical Mallinkrodt May Department Stores McKesson Mercantile Stores Merck Type Total Revenues Total Assets Return on Equity 6 7251 29454 17.1 4 14690 5219 21.4 6 20106 80918 20.1 7 8340 7935 0.2 6 3362 80620 7.1 4 19139 8536 12.2 7 36287 32489 16.7 2 3995 4116 6.2 7 14319 7777 9.5 7 19272 25322 21.8 5 1916 2773 6 5 6138 8707 11.5 5 16701 14977 44.4 1 1777 775 12.3 3 954 2299 2.4 7 41950 35473 18.6 6 14935 108199 13.7 3 4353 8858 13.3 1 27757 14191 18 1 6817 5592 9.2 3 7678 20193 7.9 2 20018 24040 23.6 3 1356 3585 13.9 2 46653 42942 21.3 2 4678 5778 16.3 3 9235 25101 12.3 2 3631 2586 6.1 3 9562 27001 4.2 6 9666 151438 12.3 7 1064 1067 53.6 7 137242 96064 19.4 3 6369 12449 12.2 1 6508 3338 33.7 2 966 613 228 4 4231 1522 7.9 4 10262 2995 6.9 2 1311 2270 5.5 3 179 326 8.3 4 3226 1227 9.9 2 1866 2411 47 3 6873 18415 8 6 2578 23131 14.5 5 22629 21453 26.7 6 660 3185 11.1 1 9189 4301 10.6 6 4899 77175 0.4 2 1674 1462 19 7 3010 1559 46.2 5 1868 2988 14.8 1 12685 9930 20.5 5 20857 5608 11 1 3144 2178 7.9 5 23637 25812 36.6 Millennium Chemicals Mobil Monsanto Morton Murphy Oil Mylan Laboratories NALCO Chemical Nevada Power NIPSCO Olin Orion Capital Owens & Minor Pacific Corporation J. C. Penney Pennzoil Pfizer Pharmacia & Upjohn Phillips Petroleum Poe & Brown PPG PP&L Resources Progressive Rohm & Haas Ruddick Schering-Plough Sears, Roebuck Stryker Sun Sunamerica Texaco The TJX Companies Torchmark Tosco Travelers Ultramar Diamond Shamrock Union Carbide United States Surgical Corporation UNOCAL UNUM USX-Marathon Valero Energy Warner-Lambert WEIS Markets Wellman Winn-Dixie Stores WITCO Zenith Nation Insurance 2 7 2 2 7 5 2 3 3 2 6 5 3 1 7 5 5 7 6 2 3 6 2 4 5 1 5 7 6 7 1 6 7 6 7 2 5 7 6 7 7 5 4 2 4 2 6 3048 65906 7514 2388 2138 555 1434 799 2587 2410 1591 3117 6278 30546 2654 12504 6710 15424 129 7379 3049 4190 3999 2300 6778 41296 980 10531 2114 46667 7389 2283 13282 37609 10882 6502 1172 6064 4077 15754 5756 8180 1819 1083 13219 2187 601 4326 43559 10774 2805 2238 848 1441 2339 4937 1946 3884 713 13880 23493 4406 15336 10380 13860 194 6868 9485 7560 3900 885 6507 38700 985 4667 35637 29600 2610 10967 5975 386555 5595 6964 1726 7530 13200 10565 2493 8031 972 1319 2921 2298 1252 12.6 16.8 7.2 12.3 12.3 13.5 25 10.1 14.1 17.4 16 9.4 5.2 7.7 15.8 27.9 5.8 19.9 25.1 28.5 11.4 18.7 19.8 12.5 51.2 20.3 20.5 18 14.7 20.9 26.3 17.5 10.9 14.9 9.5 28.8 7.5 28.9 15.2 12.6 9.6 30.7 9.2 4.8 15.3 14 7.8 Earnings per Share Average Yield Dividends per Share Average P/E Ratio 2.08 0.9 0.22 11.5 2.08 1.6 0.63 19 3.56 1 0.36 10.6 0.08 1.1 0.6 698.3 2.19 3 1.4 21.2 1.01 1.4 0.34 23.5 2.76 3.1 1.4 16.1 1.14 6.1 2.8 40.4 3.8 2.3 1.1 12.4 5.41 3.8 2.83 3.8 0.89 2.6 1.04 2.6 1.06 2.3 1.13 47.2 3.14 2 1.52 24.1 1.18 0.1 0.02 12.9 0.16 7.8 0.9 79.6 4.95 3 2.28 15.2 4.88 2 1.1 11.4 1.59 5.1 1.8 22.4 1.7 1.2 0.33 16.2 2.31 0.4 0.16 15.7 2.15 6.8 2.58 17.7 7.7 3.6 3.24 11.6 1.2 5.3 0.91 14.3 2.08 2.1 1.23 27.9 3.63 3 1.76 16 1.73 4.2 1 13.6 0.33 1.9 0.38 61.8 1.03 6.9 1.8 25.4 2.86 0.5 0.2 13.4 0.71 5.6 0.5 12.6 3.37 2.8 1.63 17.1 3.57 3.7 1.92 14.4 1.3 0.7 0.2 22 2.39 1.1 0.32 11.8 1.18 2.4 0.78 26.9 1.66 1.2 0.35 17.8 1.19 1.3 0.62 40.5 1.57 7.3 1.61 14 1.4 1.5 0.54 26.6 3.18 2.2 1 14.5 1.66 6.6 1.5 13.7 3.47 2.3 1.04 13.3 2.41 1.5 0.85 24.1 3.34 1.8 0.77 12.7 0.79 2.3 0.48 26.7 0.21 3.1 1.96 300.2 2.66 2.6 1.01 14.5 3.58 3.9 0.9 6.4 2.47 1.7 0.66 16 3.11 2.4 1.2 16.2 1.59 1.2 0.5 26 3.53 2.1 1.19 16.3 3.74 1.7 1.69 26.6 2.47 4.01 0.48 1.48 2.94 0.82 2.1 1.65 1.53 3 4.15 0.6 0.68 2.1 3.76 1.7 0.61 3.61 1.48 3.94 1.8 5.31 2.13 1.02 1.95 2.99 1.28 2.7 1.8 4.87 1.75 2.39 1.37 2.54 1.94 4.53 1.21 2.65 2.59 1.58 2.03 1.04 1.87 0.97 1.36 1.55 1.57 2.9 3.1 1.1 1 2.6 0.9 2.6 6.8 4.1 2.8 1.5 1.4 4.6 3.8 1.6 1.1 3.1 3 1.5 2.3 7.7 0.3 2.2 1.8 1.5 1.8 0.3 2.8 0.9 3.1 0.6 1.7 0.8 0.9 3.5 1.6 0.5 2 1.3 2.4 1.2 1.4 3 1.8 2.7 2.9 3.7 0.6 2.12 0.5 0.36 1.35 0.16 1 1.6 0.9 1.2 0.6 0.18 1.08 2.13 1 0.68 1.08 1.34 0.35 1.33 1.67 0.24 0.63 0.32 0.74 0.92 0.11 1 0.3 1.75 0.09 0.59 0.24 0.4 1.1 0.79 0.16 0.8 0.56 0.76 0.42 0.51 0.94 0.35 0.98 1.12 1 8.3 17.2 90.7 25.2 18 22.4 18.3 14.2 14.4 14.5 9.8 21.7 34.2 26.9 17.1 35.4 56.2 12.4 16.3 14.7 12 17 13.4 17 24.6 17.4 27.2 13 19.5 11.5 8.2 14.2 23 17 16.1 10.7 29 15.5 17 19.8 17.2 35.7 16.9 20.5 27.2 24.9 17 Hospital Geog. Region Control Service Beds Admissions Census Outpat. Visits Births Tot. Exp. 1 1 2 1 210 7713 107 86982 312 56831 2 1 1 1 347 16065 198 149222 1077 127223 3 1 2 1 511 23028 356 222565 1027 157093 4 1 1 1 142 4338 100 36710 355 24462 5 7 1 1 40 905 9 13350 168 13730 6 4 2 1 220 15563 159 88721 3810 93257 7 4 4 1 137 5347 65 188885 735 45458 8 4 2 1 80 636 48 10209 1 6151 9 1 2 1 440 15954 253 77343 1733 98992 10 1 1 1 48 1827 21 33977 257 11569 11 1 1 1 56 1617 27 17925 169 11356 12 6 3 1 46 2954 30 27170 430 15200 13 6 3 1 109 2805 43 30263 0 20848 14 6 2 1 306 9871 233 43128 2049 62778 15 6 4 1 7 756 2 96000 211 20300 16 6 1 1 16 342 11 7217 16 3836 17 6 3 1 167 8426 84 66073 2648 41417 18 6 2 1 444 18258 219 170223 2450 144966 19 6 3 1 236 8280 112 31022 1465 67997 20 6 3 1 247 5449 124 44425 0 123175 21 6 3 1 93 5247 50 29551 1993 28318 22 6 2 1 236 11301 142 90178 2275 88080 23 6 2 1 220 9466 111 172146 1494 107313 24 6 1 1 228 10444 140 95649 1313 116486 25 6 3 1 83 2648 28 15507 451 20625 26 6 2 1 273 9249 154 51102 1689 67519 27 6 2 1 225 7763 150 91654 1583 60080 28 6 3 1 236 10688 144 68482 2017 94401 29 6 3 1 80 6671 42 35221 995 26094 30 6 2 1 78 7761 77 37370 2045 38825 31 5 2 1 197 9553 119 153994 1686 105672 32 5 2 1 60 2730 27 16060 503 29444 33 5 2 1 31 1112 15 36735 126 8496 34 2 2 1 264 13395 179 267091 2026 153844 35 2 2 1 246 12264 175 140152 1412 128312 36 2 2 1 556 12811 461 68330 1517 122809 37 1 3 2 56 860 32 5778 0 7079 38 1 2 1 120 5502 74 36461 0 50823 39 1 1 1 674 26547 414 294682 2719 367706 40 1 2 1 414 12260 253 81885 1074 85696 41 1 3 1 320 4147 180 47636 1421 29699 42 1 1 1 315 12804 184 92458 762 108848 43 1 2 1 344 16539 243 185313 3194 141031 44 1 2 1 168 7566 115 66309 496 56207 45 1 1 1 315 15853 215 93373 1442 131297 46 1 3 2 88 2662 48 6533 0 9617 47 1 3 1 245 8733 124 78773 1107 63442 48 1 2 1 311 15196 189 115155 2989 109394 49 1 1 1 233 1466 181 18659 113 9840 50 1 1 1 46 812 9 11519 0 4417 51 1 3 1 103 2312 28 30661 0 31628 52 1 2 1 331 2305 288 35600 173 20848 53 1 1 1 186 10541 108 76176 1064 56185 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 1 7 7 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 2 2 3 1 3 2 2 2 2 2 3 2 2 2 4 2 2 1 3 1 2 2 2 1 2 2 1 3 1 1 3 4 1 2 3 3 2 1 3 2 2 2 2 2 2 1 2 4 2 1 3 3 4 1 1 1 1 2 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 2 2 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 2 2 1 1 2 1 2 177 149 286 488 242 128 33 255 481 191 60 155 626 105 59 258 47 22 53 244 352 366 194 109 285 175 342 140 50 214 80 467 80 160 106 40 99 133 138 88 573 44 225 105 100 186 375 485 64 495 114 62 149 427 4469 5994 11142 508 5682 5511 925 13780 28390 9899 1247 9893 31452 1456 4706 9950 1940 1241 1475 9731 14974 7284 5356 458 11624 8080 1259 2876 404 794 746 6122 823 6584 3870 859 3313 6306 2764 4112 26392 1497 8187 6251 5335 8184 21169 4112 1785 21327 538 883 1897 592 154 76 165 295 101 69 12 185 378 114 49 106 460 43 29 125 17 10 14 173 207 223 82 64 139 109 298 52 34 168 21 390 47 80 50 113 45 76 129 60 418 17 138 64 62 131 265 456 40 310 72 19 112 375 57104 111901 173393 0 37461 37898 24679 146454 796525 85986 35955 192386 236900 47152 292105 121004 45057 31833 43357 103595 110754 181430 48413 26770 599315 200048 0 3192 13468 0 10074 179676 10409 91769 53424 2251 30814 172253 17907 85800 121321 35357 89248 103225 172105 87453 331478 109270 7749 312733 0 5850 69776 0 759 1317 1751 0 0 714 99 2243 3966 1308 0 2514 3714 126 556 1327 415 216 339 1217 2641 790 520 35 1168 793 0 0 14 0 0 0 0 776 451 0 145 1284 1 319 2154 295 496 589 806 701 3968 0 0 3655 0 0 0 0 43406 40014 75810 26298 57236 30063 7947 143118 270244 83223 20151 105523 323725 15701 33014 88222 22274 10900 14830 71691 155097 55926 42104 6428 127796 65083 28246 22324 2547 21517 4861 114160 8086 45492 24529 4663 16296 55663 32936 29164 329667 17714 84347 43323 53578 76537 188190 103822 8723 231187 16083 5283 34946 53604 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 3 3 3 3 3 1 1 1 3 3 3 3 3 5 5 5 5 3 3 3 5 5 5 2 2 2 2 2 2 5 5 5 2 2 2 2 2 2 1 1 1 1 1 3 3 3 3 3 3 3 3 3 3 7 3 2 1 2 2 3 1 1 1 4 3 1 4 2 1 4 2 3 1 2 3 3 1 4 3 3 2 2 1 1 2 2 2 1 3 2 2 1 2 1 4 1 2 2 2 4 1 2 2 1 3 4 1 2 2 40 1 129 1 149 1 71 1 256 1 153 2 1297 1 70 2 69 1 71 1 243 2 206 1 62 1 219 1 54 1 24 1 151 1 160 1 262 1 296 1 671 1 184 1 249 1 157 2 100 2 100 1 375 1 123 1 457 1 263 1 160 1 69 1 153 2 260 2 34 1 479 1 973 1 440 1 51 1 347 2 612 1 141 1 115 1 50 1 261 2 334 2 228 1 85 1 357 2 189 1 139 1 60 2 164 1 105 1049 9507 1589 617 7203 6156 1407 1609 1666 3477 5667 1499 1256 9275 143 1503 1764 3228 3689 14018 37375 7699 7931 2018 510 2271 11821 4093 16987 19776 7798 2814 3611 163 213 4848 24753 21004 111 19026 3378 4080 2030 944 10112 4410 515 3233 14900 1076 4014 3108 1132 7528 15 78 123 54 96 82 1106 30 56 36 127 180 59 127 37 13 100 47 194 172 516 120 179 140 78 68 186 91 340 254 108 61 174 306 28 395 923 335 46 316 416 74 86 38 147 232 138 38 245 171 51 28 797 56 0 64109 13721 48469 107440 4170 5551 14630 6376 238060 161912 0 68886 42058 3224 105101 27889 29179 57144 139741 119462 53313 88869 102547 935 13405 184144 36172 304839 362424 87511 64651 69833 56662 0 262583 339009 550588 1257 287498 129088 54460 32678 14995 86607 109111 0 67906 279079 0 59061 202739 42432 98805 0 3063 169 66 827 570 0 0 0 342 494 0 0 0 0 286 235 339 398 1275 5699 1364 714 0 0 0 779 0 2202 3346 1071 352 254 0 0 699 2462 3311 0 4207 0 339 130 91 1143 0 0 509 1026 0 447 1161 0 922 4479 58597 14738 7934 88779 35543 73334 4937 14307 53307 43013 21260 29581 160226 3043 21939 17395 26343 36112 156543 239458 56221 45034 46804 2082 17874 102559 36922 322786 196619 68084 35452 24702 50850 4861 55313 343160 275305 2435 180781 104009 31187 13706 6885 155709 80088 27911 26229 143322 27683 36847 27790 12990 48914 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 7 7 7 7 2 2 2 2 2 1 1 1 3 3 1 1 1 1 1 1 1 1 1 5 5 5 5 2 2 1 1 1 7 7 7 7 5 5 5 1 1 4 2 1 4 2 2 2 4 3 3 4 2 2 3 3 2 3 4 3 3 3 3 1 2 2 2 2 1 2 3 2 1 2 2 1 1 1 1 1 1 1 2 1 2 1 1 1 1 1 1 1 2 1 1 1 1 1 2 2 1 1 1 1 1 1 2 1 1 1 1 1 1 1 2 1 1 114 73 314 350 602 74 53 152 317 43 269 79 181 122 65 97 169 407 160 117 80 100 370 123 380 149 112 61 219 260 350 121 206 70 334 190 122 170 73 6685 568 8408 17484 570 1426 1963 5373 14275 1438 11508 4044 3217 2938 3246 2481 5348 16466 6504 12209 1266 767 8974 4085 16647 8479 7260 2730 2161 13943 12132 7894 4567 2089 15696 6395 441 7244 352 69 40 163 231 523 31 43 66 231 11 144 43 185 82 49 24 63 274 93 86 28 25 181 39 302 80 63 31 170 203 296 83 84 29 187 77 104 85 47 27365 11443 289471 196534 0 85674 848 65824 162753 287501 172047 83963 169698 65898 51167 62150 64834 134581 30246 813369 3813 5742 53406 56073 31412 209595 163261 59584 14923 138404 100323 85585 107027 24369 102641 244254 0 167454 9714 562 78 0 2122 0 0 0 710 1165 466 1106 376 0 637 0 352 447 1227 963 3038 0 0 868 1189 2849 1728 2171 364 0 2993 0 1964 601 387 1946 545 0 838 51 48855 6148 176241 173817 62703 41680 6584 38863 131696 43490 84731 39452 71806 26355 14183 15241 38483 148287 54167 118076 6026 6390 80866 31770 241842 56095 43977 23025 31366 97659 96458 46491 39836 17257 168045 79859 15321 58247 4565 Payroll Exp. Personnel 22061 792 55799 1762 61326 2310 10503 328 6368 181 33920 1077 26919 742 2768 131 40956 1594 5664 233 5084 241 7085 203 9709 325 28958 676 12300 347 2015 79 20633 505 61667 1543 31285 755 41899 959 12589 325 32191 954 38668 1091 49017 671 3009 300 28066 753 21944 607 38757 929 13464 354 15951 408 46710 1251 12583 386 3918 144 86780 2047 63615 1343 63516 1723 3202 96 20346 529 165344 3694 34117 1042 12391 1071 43575 1525 56421 1983 22128 670 52366 1653 4735 167 28088 793 47744 841 5593 316 2455 93 10847 373 10389 263 24373 943 21388 17450 32620 21070 21461 14717 3388 56630 113093 38537 8139 40048 143991 7478 6272 35949 11191 5542 6624 33804 61771 24520 17721 3280 56476 28006 18783 9346 1235 13795 2591 69051 3623 18955 9420 2569 7925 22064 10177 13663 128158 7700 45164 17837 28592 33789 86172 58336 4871 100456 7789 2637 23156 34280 605 596 1165 568 507 479 136 1456 3486 885 243 1001 3301 337 1193 1161 322 185 205 1224 1704 815 712 156 1769 875 790 308 70 494 111 1618 244 525 472 94 297 847 234 401 3928 198 1231 545 663 820 2581 1298 126 2534 251 85 432 864 2171 22611 7040 4130 43895 13390 47273 3172 7260 22512 20808 14755 13762 72855 1637 9481 6604 11304 18621 58378 100322 18421 24427 22395 1533 7685 47925 15160 170956 81345 30310 18210 12706 35000 2032 24742 188865 147417 1053 83474 55542 15242 5352 3841 78535 43948 17394 12487 72409 17784 10861 14969 7256 23004 66 556 347 239 973 439 1849 102 262 885 549 611 330 1471 75 262 328 377 575 1916 2620 571 703 535 160 202 1330 370 3123 2745 815 576 502 808 50 728 4087 3012 68 3090 1358 576 284 145 2312 1124 336 415 1779 338 453 437 261 609 24584 2917 86574 80414 38412 16082 4779 16583 70732 25993 28639 11190 39192 10272 7723 6424 11568 54588 21347 51986 3084 2695 30372 10260 98138 21266 21292 9410 18090 42580 45898 21744 20671 7425 78118 33639 8878 25018 2228 647 61 2074 2232 948 409 153 741 1625 538 789 395 956 362 144 229 396 2256 731 1477 102 106 939 392 3516 785 607 273 630 1379 1108 583 514 216 1593 1055 399 834 104