#5240 1 Pg within 12 hrs Final Project, Part III

profileltdprinwival
5239Topic_FinalProject_PartII.xlsx
Home>Nursing homework help>#5240 1 Pg within 12 hrs Final Project, Part III

Regression output

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9843456944
R Square 0.968936446
Adjusted R Square 0.9629091893
Standard Error 28586541.0968799
Observations 81
ANOVA
df SS MS F Significance F
Regression 13 1.70782030345457E+18 1.31370792573429E+17 160.7591125933 3.67111046310822E-45
Residual 67 5.47517522362014E+16 817190331883602
Total 80 1.76257205569077E+18
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -1267666.15729186 16544024.4522546 -0.0766238082 0.9391511717 -34289676.786641 31754344.4720573 -34289676.786641 31754344.4720573
Staffed beds_05 178512.219683933 62107.3913579985 2.8742508062 0.0054221156 54545.3491377837 302479.090230082 54545.3491377837 302479.090230082
Medicare Days_05 -1117.1572681524 340.0678919848 -3.2851006945 0.0016237522 -1795.9356135443 -438.3789227606 -1795.9356135443 -438.3789227606
Medicaid Days_05 -352.8893250581 346.549894718 -1.0182929801 0.312201779 -1044.6058019046 338.8271517885 -1044.6058019046 338.8271517885
Total Surgeries_05 1935.2326389329 946.9116816757 2.0437308741 0.0449146663 45.1890339085 3825.2762439572 45.1890339085 3825.2762439572
RN FTE_05 333072.731688469 35662.9209863891 9.3394686267 0 261889.244303954 404256.219072985 261889.244303954 404256.219072985
Occupation 3752420.24512574 11798790.2051713 0.3180343222 0.751448068 -19798063.2961102 27302903.7863617 -19798063.2961102 27302903.7863617
Ownership -15595326.2498098 9068446.90143333 -1.7197350792 0.0900972222 -33696021.8112219 2505369.31160239 -33696021.8112219 2505369.31160239
System Membership 7469768.96556987 7792474.59237192 0.9585875292 0.3412130268 -8084075.23726377 23023613.1684035 -8084075.23726377 23023613.1684035
Rural/Urban -6828203.67168277 8866155.32399369 -0.7701425728 0.4439223826 -24525123.559303 10868716.2159375 -24525123.559303 10868716.2159375
Teaching Affiliation -17012822.2950106 10646736.3503386 -1.5979377844 0.1147627219 -38263796.744631 4238152.15460978 -38263796.744631 4238152.15460978
Age 65 Plus 2005 -479.5243856057 1192.6250940889 -0.4020747073 0.688908865 -2860.0140087617 1900.9652375504 -2860.0140087617 1900.9652375504
Crime rate/100,000 population (2005) -125.9836696853 791.1808377328 -0.1592349861 0.8739627809 -1705.1872128589 1453.2198734882 -1705.1872128589 1453.2198734882
Uninsured 2005 523.3683570396 952.5000563132 0.5494680589 0.5845111449 -1377.8296903161 2424.5664043954 -1377.8296903161 2424.5664043954
Regression equation is
-1267666.157 + 178512.21*Staffed beds_05 - 1117.15*Medicare days_05 - 352.889*medicaid days_05 + 1935.23*total surgeries_05 + 333072.73*RN FTE_05+3752420.245*occupation - 15595326.25*ownership + 7469768.966*system membership - 6828203.672*Rural/urban - 17012822.3*teaching affiliation - 479.524*Age 65 plus_05 - 125.98*crime rate + 523.368*uninsured 2005

Descriptive statistics

Total operating expense_05 Staffed beds_05 Medicare Days_05 Medicaid Days_05 Total Surgeries_05 RN FTE_05 Crime rate/100,000 population (2005)
Mean 127421693.25 216.59 25092.15 10467.28 8979.78 309.17 6779.72
Standard Deviation 148432310.15 190.36 23417.92 13362.20 9415.53 371.65 5083.50
Occupation Ownership System Membership Rural/Urban Teaching Affiliation Age 65 Plus 2005 Uninsured 2005
Mean 1.062 0.198 0.642 0.296 0.222 14199.506 17508.975
Standard Deviation 0.330 0.401 0.482 0.459 0.418 18511.493 23327.551

Data

Total operating expense_05 Staffed beds_05 Medicare Days_05 Medicaid Days_05 Total Surgeries_05 RN FTE_05 Occupation Ownership System Membership Rural/Urban Teaching Affiliation Age 65 Plus 2005 Crime rate/100,000 population (2005) Uninsured 2005
62,534,771 135 14225 1950 8067 187 1 0 0 0 0 8,486 2,382 7,722
197,900,897 329 34074 10236 11795 468 1 0 1 0 0 12,965 6,542 16,360
120,100,414 233 30169 4943 8178 247 1 0 1 0 0 12,965 6,542 16,360
48,193,723 164 260 805 3279 44 1 1 1 0 0 18,069 6,233 23,062
204,292,690 334 40875 11024 11890 445 1 1 0 0 1 18,069 6,233 23,062
18,071,877 50 7898 25699 1663 65 1 0 1 0 0 8,874 3,736 8,293
26,819,725 60 4760 2764 2520 71 1 0 1 1 0 5,793 2,850 6,995
60,993,026 146 12414 2441 7417 121 1 1 1 0 0 7,571 2,047 12,958
141,958,000 176 17869 1751 6606 319 1 0 0 0 0 11,068 5,323 11,080
669,905,029 574 56347 36849 47475 1615 1 0 0 0 1 11,068 5,323 11,080
183,146,951 310 44366 8149 11108 540 1 0 0 0 0 21,094 26 27,174
9,118,595 25 2480 363 71 19 1 1 1 1 0 2,474 1,598 2,890
48,484,242 70 5810 3373 3212 110 1 0 0 0 0 4,776 1,224 5,573
141,522,635 290 42890 10312 8988 242 1 0 1 0 0 9,048 10,770 7,543
31,335,546 80 18750 6557 3697 128 1 1 1 1 1 1,106 18,716 899
146,191,133 160 16349 2794 13161 350 1 0 1 0 0 95,466 2,231 113,696
723,306,075 786 80170 35287 43409 1630 1 0 1 0 1 95,466 2,231 113,696
37,158,823 116 8620 2153 4222 104 1 0 0 1 0 2,777 804 3,068
135,566,454 226 33999 3890 16545 384 1 0 0 0 0 9,531 2,709 8,782
29,468,191 90 25366 10077 3042 153 1 0 1 1 1 7,862 2,024 7,030
291,203,157 412 48109 9280 8115 546 1 0 0 0 0 2,778 10,500 2,988
35,810,562 76 11008 27969 3290 96 1 0 1 0 0 4,432 1,777 4,670
44,059,756 141 10013 2787 5500 171 1 0 0 1 0 1,309 12,722 1,025
26,823,697 67 7576 496 1667 81 1 0 1 0 0 4,905 3,606 4,964
34,934,629 134 7982 1609 1504 75 1 0 0 1 0 3,394 4,045 4,441
165,952,219 194 34202 6991 9912 394 1 0 1 0 1 16,190 8,593 20,039
176,196,924 270 30249 4052 19955 426 1 0 0 0 0 3,751 7,060 6,605
76,050,273 147 35952 14282 6816 172 1 1 1 0 0 3,257 14,141 3,505
9,296,730 25 2609 88 269 17 1 0 0 1 0 927 1,380 693
29,238,618 76 6397 403 2992 89 1 0 0 1 0 3,447 2,207 1,831
30,055,592 78 7322 2577 1224 68 1 1 1 1 0 4,336 2,023 4,743
120,379,501 145 18899 3315 12362 314 1 0 1 0 0 14,645 3,491 26,293
28,612,831 25 3673 398 2351 82 1 0 1 1 0 1,134 3,467 920
39,390,350 190 13931 1663 5287 76 1 1 1 1 0 3,011 3,193 2,315
15,536,027 54 1561 310 1569 28 1 0 0 1 0 3,954 2,194 3,609
276,033,215 525 109473 51596 24854 1093 1 0 0 0 1 10,659 9,759 9,529
140,709,871 170 13434 8227 6088 226 1 0 0 0 0 2,546 9,044 4,589
37,443,913 154 33975 12870 7353 206 1 0 0 1 1 5,572 2,876 5,128
84,634,766 237 24913 3223 10181 148 1 0 1 0 0 3,160 12,089 2,477
165,572,469 225 34435 2618 9098 296 1 0 1 0 0 11,620 2,994 10,982
46,316,799 130 18900 2900 2394 139 1 0 0 1 0 2,722 3,901 2,282
79,188,586 110 17543 29629 5568 129 1 0 1 0 0 18,934 10,942 27,247
256,234,624 570 36113 12524 12629 571 1 0 1 0 1 18,934 10,942 27,247
111,349,023 214 32433 4459 10162 179 1 0 1 0 0 23,462 10,990 38,113
156,215,256 123 212 25560 10239 249 3 0 0 0 0 23,462 10,990 38,113
17523 231 20382 53163 0 35 2 0 0 0 0 23,462 10,990 38,113
147,461,381 250 38071 5117 15854 367 1 0 1 0 0 23,462 10,990 38,113
441,903,541 569 70291 31711 18936 981 1 0 1 0 1 23,462 10,990 38,113
32,846,082 89 13188 6217 3160 117 1 0 1 1 1 2,842 666 2,488
45,686,209 129 9425 4956 3143 90 1 0 1 1 1 633 10,190 685
16,560,233 25 5296 225 1289 51 1 0 1 0 0 3,836 3,423 4,326
18,944,759 80 4719 2740 1566 52 1 0 1 1 0 5,164 17,339 5,413
129,017,834 388 34677 13775 7252 477 1 1 1 0 1 5,164 17,339 5,413
179,236,801 346 52704 31473 18649 285 1 0 1 0 0 13,052 13,163 14,990
35,146,394 135 10454 774 3774 67 1 1 1 0 0 5,708 2,641 5,082
140,281,066 160 14574 2290 13442 263 1 1 1 0 0 95,466 2,231 113,696
44,297,563 188 15037 4449 5159 133 1 1 1 0 0 7,313 3,427 7,276
256,601,638 391 49517 9754 23950 649 1 0 1 0 0 25,702 15,888 30,683
29,084,726 104 9129 5495 878 41 1 0 1 0 0 25,702 15,888 30,683
20,305,813 36 4367 1249 262 54 3 0 0 0 0 25,702 15,888 30,683
433,115,796 758 96246 28373 37648 1200 1 1 1 0 1 25,702 15,888 30,683
311,804,881 540 54608 21693 16373 742 1 1 1 0 0 25,702 15,888 30,683
58,182,577 227 16656 5825 5642 138 1 1 1 0 1 25,702 15,888 30,683
613,750,980 805 50023 51590 24135 1631 1 0 0 0 1 25,702 15,888 30,683
485,582,557 765 92482 33700 32939 1266 1 0 1 0 1 14,864 11,497 14,242
26,116,498 37 5193 1227 1988 88 1 0 1 0 0 7,862 2,024 7,030
163,994,792 521 68534 27225 13613 604 1 1 1 0 1 4,137 6,024 3,101
51,973,456 173 19175 4152 3649 119 1 0 0 1 0 6,593 2,028 5,719
51,237,628 123 20523 45174 5131 126 1 0 0 1 0 6,230 2,781 5,146
8,588,108 25 4427 7423 495 25 1 0 0 1 0 3,480 4,042 3,051
100,309,440 138 22410 4460 7245 141 1 0 0 0 0 8,672 7,226 11,560
25,033,045 67 7674 570 1146 64 1 0 1 1 0 1,813 2,036 1,547
12,498,632 56 3698 404 711 36 1 0 1 0 0 7,313 3,427 7,276
73,918,889 158 13721 1470 6600 159 1 0 1 0 0 42,482 7,483 58,144
187,552,167 274 39936 6315 12615 517 1 0 1 0 0 42,482 7,483 58,144
86,170,516 86 10341 980 4163 151 1 0 0 0 0 7343 3689 7694
96,155,065 139 15571 2032 6124 196 1 0 1 0 0 10173 5142 6787
291,855,323 411 57690 9675 10083 648 1 0 1 0 0 7845 4694 8579
123,165,763 153 13374 9035 14592 265 1 0 0 0 0 20857 5798 40669
30,610,227 25 3691 802 3288 41 1 0 1 1 0 6855 2382 5179
38,841,065 96 6055 1094 4144 111 1 0 1 1 0 4612 2326 4199

Sheet2

Sheet3