10 9.09 10 points eBook Print References We would like to estimate a model to predict the number of people a hospital will admit. Estimate the equation: Admissions o + BOutpat + BTotExp + B3PayrollExp + Paersonnel + BsBeds +B6Service where Admissions = number of patients admitted Outpat. number of patients treated that were not admitted to the hospital but treated at the hospital Tot Exp = total expenditures for the hospital ($ millions) Payroll Exp total payroll expenditures for the hospital Personnel number of employees Beds number of beds Service the type of hospital = 1 if general medical hospital and O if psychiatric hospital Click here for the Excel data file a. Estimate the equation and enter the coefficients below: Variable Intercept Outpatient Visits Total Expenditure Payroll Expenditure Personnel Number of Beds Service Coefficient c. Select the variables that are individually significant at the 5% significance level. outpatient visits total expenditure payroll expenditure personnel beds service d. Select the variables that provide evidence for multicollinearity. outpatient visits total expenditure payroll expenditure personnel beds e. Based on your answers to c and d, decide which variables should be removed from the model and re-estimate the equation without them. Enter the coefficients below. If you removed the variable, enter O for the coefficient. Variable Intercept Outpatient Visits Total Expenditure Payroll Expenditure Personnel Number of Beds Service Coefficient f. Select the violations that are occurring in the model calculated in parte. Nonlinear patterns Changing variability Correlated Observations Calibri (Body) 11 A A Paste BIU AA K12 Office Update To keep up-to-date with security updates, fixes, and improvements, choose C fx A C D E F G H 1 Hospital Admissions Outpat. Vis Tot. Exp. Payroll Exp Personnel Beds Service 2 1 7713 86982 56831 22061 792 210 1 3 2 16065 149222 127223 55799 1762 347 1 4 3 23028 222565 157093 61326 2310 511 1 5 4 4338 36710 24462 10503 328 142 1 6 5 905 13350 13730 6368 181 40 1 7 6 15563 88721 93257 33920 1077 220 1 8 7 5347 188885 45458 26919 742 137 1 9 8 636 10209 6151 2768 131 80 1 10 9 15954 77343 98992 40956 1594 440 I 11 10 1827 33977 11569 5664 233 48 1 12 11 1617 17925 11356 5084 241 56 1 13 12 2954 27170 15200 7085 203 46 1 14 13 2805 30263 20848 9709 325 109 1 15 14 9871 43128 62778 28958 676 306 1 16 15 756 96000 20300 12300 347 7 1 17 16 342 7217 3836 2015 79 16 1 18 17 8426 66073 41417 20633 505 167 1 19 18 18258 170223 144966 61667 1543 444 1 20 19 8280 31022 67997 31285 755 236 1 21 201 5449 44425 123175 41899 959 247 1 22 21 5247 29551 28318 12589 325 93. 1 23 22 11301 90178 88080 32191 954 236 1 24 23 9466 172146 107313 38668 1091 220 1 25 24 10444 95649 116486 49017 671 228 1 26 25 2648 15507 20625 3009 300 83 1 27 26 9249 51102 67519 28066 753 273 1 28 27 7763 91654 60080 21944 607 225 1 29 28 10688 68482 94401 38757 929 236 1 30 29 6671 35221 26094 13464 354 80 1 31 30 7761 37370 38825 15951 408 78 1 32 31 9553 153994 105672 46710 1251 197 1 33 32 2730 16060 29444 12583 386 60 1 34 33 1112 36735 8496 3918 144 31 1 35 34 13395 267091 153844 86780 2047 264 1 36 35 12264 140152 128312 63615 1343 246 1 37 36 12811 68330 122809 63516 1723 556 1 38 37 860 39 38 5502 40 39 26547 41 40 12260 42 41 4147 5778 36461 294682 367706 165344 81885 85696 47636 29699 12391 7079 3202 96 56 O 50823 20346 529 120 1 3694 674 1 34117 1042 414 1 1071 320 Chants L J AutoSave Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) -11 AA BIU Paste O Office Update To keep up-to-date with security updates, fixes, and improvements, choose x1fx K12 A B c D F G 1 J 43 42 12804 924581 43575 1525 315 1 44 41 36539 185313 143031 56421 1983 344 3 45 44 7566 66309 56207 22128 670 166 1 46 45 15853 93373131297 52366 1659 315 I 47 46 2662 6533 9617 4735 167 0 48 7 8733 78773 63442 28088 793 245 1 49 48 15196 115155 309394 47744 841 311 1 50 49 1466 1859 5840 5593 316 233 1 51 50 812 4417 2455 93 46 1 52 $1 2312 30661 31628 10847 373 103 1 53 52 2305 35400 20848 1038 263 1 54 53 30541 76176 56385 24373 543 146 1 55 54 4469 57104 43406 21388 605 177 56 55 5094 111901 40014 17450 556 149 I 57 56 31142 173353 75810 33620 1161 286 + 58 53 508 36296 21070 568 488 0 59 58 5632 37461 57236 21461 507 243 3 60 59) 5511 37808 30063 14717 479 128 4 19 60 325 24679 7947 WEE 136 33 1 62 13780 146454 34311 54630 255 1 53 28390 794525 270044 113093 481 1 64 " 3659 85986 81223 38537 191 1 65 S4 M 1343 3555 20151 343 60 D 66 65 105523 40048 1001 255 1 67 M 31452 234900 323725 143991 3305 626 1 T 67 1456 47152 15701 3478 105 1 LE 4706 www 252105 33014 6273 1193 59 70 19 9950 www 131004 35549 1101 2581 3 H 71 1940 1940 45057 22274 31191 123 47 72 " 1241 1343 10000 5543 183 22 73 72 1425 43357 14830 6634 309 53 24 5733 303595 71401 33804 1234 244 S 110754 155097 61771 1704 352 n 7284 183430 55906 34520 RES 366 3 77 76 1356 48413 42104 17721 212 THE 354 978 26 77 458 36370 6438 156 309 79 11634 59915 127796 56476 1769 285 BOND 200048 875 375 3259 . 28346 750 342 82 1 2876 3192 22324 140 404 13468 2547 1335 20 50 esc LB B I ! 1 2 @ 4 #3 $ Q W E Home Insert Draw Page Layout ormulas G X Calibri (Body) 11 BIU 101 100 Paste K12 Office Update To keep up-to-date with security updates, fixes, and improvements, choc A x fx B C D E G H 84 83 794 0 21517 13795 494 214 0 85 84 746 10074 4861 2591 111 80 86 85 6122 179676 114160 69051 1618 467 1 87 86 823 10409 8086 3623 2441 80 1 88 87 6584 91769 45492 18955 525 160 1 89 88 3870 53424 24529 9420 472 106 1 90 89 859 2251 4663 2569 94 40 0 91 90 3313 30814 16296 7925 297 99 1 92 91 6306 172253 55663 22064 847 133 1 93 92 2764 17907 32936 10177 234 138 1 94 93 4112 85800 29164 13663 401 88 1 95 94 26392 121321 329667 128158 3928 573 1 96 95 1497 35357 17714 7700 198 44 1 97 96 8187 89248 84347 45164 1231 225 1 98 97 6251 103225 43323 17837 545 105 1 99 98 5335 172105 53578 28592 663 100 1 100 99 8184 87453 76537 33789 820 186 1 101 100 21169 331478 188190 86172 2581 375 1 102 101 4112 109270 103822 58336 1298 485 0 103 102 1785 7749 8723 4871 126 64 0 104 103 21327 312733) 231187 100456 2534 495 1 105 104 538 0 16083 7789 251 114 1 106 105 883 5850 5283 2637 85 62 107 106 1897 69776 34946 23156 432 149 1 108 107 592 53604 34280 864 427 109 108 1049) 0 4479 2171 66 40 o 110 109 9507 64109 58597 22611 556 129 1 111 110 1589 13721 14738 7040 347 149 1 112 111 617 48469 7934 4130 239 71 1 113 112 7203 107440 88779 43895 973 256 1 114 113 6156 4170 35543 13390 439 153 1 115 114 1407 5551 73334 47273 1849 1297 D 116 115 1609 14630 4937. 3172 102 70 70 117 116 1666 6376 14307 7260 262 69 118 117 3477 238060 53307 22512 885 71 119 118 5667 161912 43013 20808 549 243 1001 120 119 1499 21260 14755 611 206 121 120 1256 68886 29581 13762 330 62 1 122 121 9275 42058 160226 72855 1471 219 1 123 122 143 3224 3043 1637 75 54 1 124 123 1503 105101 136 1964 21939 17205 9481 262 24 3 COM Cheelt Home Insert Draw Page Layout Formulas Data Review View X - Calibri (Body) 11 A A Paste BIU A Office Update To keep up-to-date with security updates, fixes, and improvements, ch K12 fx A B C D E F G H 124 123 1503 105101 21939 9481 262 24 1 125 124 1764 27889 17395 6604 328 151 1 126 125 3228 29179 26343 11304 377 160 1 127 126 3689 57144 36112 18621 575 262 1 128 127 14018 139741 156543 58378 1916 296 1 129 128 37375 119462 239458 100322 2620 671 1 130 129 7699 53313 56221 18421 571 184 1 131 130 7931 88869 45034 24427 703 249 1 132 131 2018 102547 46804 22395 535 157 1 133 132 510 935 2082 1533 160 100 0 134 133 2271 13405 17874 7685 202 100 135 134 11821 184144 102559 47925 1330 375 1 136 135 4093 137 136 16987 36172 36922 304839 15160 370 123 1 322786 170956 3123 457 1 138 137 19776 362424 196619 81345 2745 263 1 139 138 7798 87511 68084 30310 815 160 1 140 139 2814 64651 35452 18210 576 69 1 141 140 3611 69833 24702 12706 502 153 1 142 141 163 56662 50850 35000 808 260 0 143 142 213 4861 2032 50 34 144 143 262583 4848 55313 24742 728 479 1 145 144 24753 339009 343160 188865 4087 973 1 146 145 21004 550588 275305 147417 3012 440 1 147 146 111 1257 2435 1053 68 51 1 148 147 19026 287498 180781 83474 3090 347 1 149 148 3378 129088 104009 55542 1358 612 0 150 149 4080 54460 31187 15242 576 141 1 151 150 2030 32678 13706 5352 284 115 1 152 151 944 14995 6885 3841 145 50 1 153 152 10112 86607 155709 78535 2312 261 1 154 153 4410 109111 80088 43948 1124 334 0 155 154 515 0 27911 17394 336 228 0 156 155 3233 67906 26229 12487 415 85 1 157 156 14900 279079 143322 72409 1779 357 1 158 157 1076 0 27683 17784 338 189 0 159 158 4014 59061 36847 10861 453 139 1 160 159 3108 202739 27790 14969 437 60 1 161 160 1132 42432 12990 7256 261 164 162 161 7528 98805 48914 23004 609 105 1 163 162 6685 27365 48855 24584 647 114 1 164 163 568 11443 6148 2917 61 73 1 165 164 8408 289471 176241 86574 2074 314 healt L G X Calibri (Body) 11 Paste BI U V AA H Office Update To keep up-to-date with security updates, fixes, and improvements, choo K12 fx A B C D E F G H J 166 165 17484 196534 173817 80414 2232 350 1 167 166 570 0 62703 38412 948 602 0 168 167 1426 85674 41680 16082 409 74 1 169 168 1963 848 6584 4779 153 53 0 170 169 5373 65824 38863 16583 741 152 1 171 170 14275 162753 131696 70732 1625 317 1 172 171 1438 287501 43490 25993 538 43. 1 173 172 11508 172047 84731 28639 789 269 1 174 173 4044 83963 39452 11190 395 79 1 175 174 3217 169698 71806 39192 956 181 1 176 175 2938 65898 26355 10272 362 122 1 177 176 3246 51167 14183 7723 144 65 0 178 177 2481 62150 15241 6424 229 97 1 179 178 5348 64834 38483 11568 396 169 1 180 179 16466 134581 148287 54588 2256 407 1 181 180 6504 30246 54167 21347 731 160 1 182 181 12209 813369 118076 51986 1477 117 1 183 182 1266 3813 6026 3084 102 80 0 184 183 767 5742 6390 2695 106 100 0 + 185 184 8974 53406 80866 30372 939 370 1 186 185 4085 56073 31770 10260 392 123 1 187 186 16647 31412 241842 98138 3516 380 1 188 187 8479 209595 56095 21266 785 149 1 189 188 7260 163261 43977 21292 607 112 1 190 189 2730 59584 23025 9410 273 61 1 191 190 2161 14923 31366 18090 630 219 0 192 191 13943 138404 97659 42580 1379 260 1 193 192 12132 100323 96458 45898 1108 350 1 194 193 7894 85585 46491 21744 583 121 1 195 194 4567 107027 39836 20671 514 206 1 196 195 2089 24369 17257 7425 216 70 1 197 196 15696 102641 168045 78118 1593 334 1 198 197 6395 244254 79859 33639 1055 190 1 199 198 441 0 15321 8878 399 122 0 200 199 7244 167454 58247 25018 834 170 1 201 200 352 9714 4565 2228 104 73 1 202 203