The following data reflect information from 17 U.S. Navy

Chapter , Problem 7.58

(choose chapter or problem)

The following data reflect information from 17 U.S. Navy hospitals at various sites around the world. The regressors are workload variables, that is, items that result in the need for personnel in a hospital. A brief description of the variables is as follows: y = monthly labor-hours, x1 = average daily patient load, x2 = monthly X-ray exposures, x3 = monthly occupied bed-days, x4 = eligible population in the area/1000, x5 = average length of patients stay, in days. Site x1 x2 x3 x4 x5 y 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 15.57 44.02 20.42 18.74 49.20 44.92 55.48 59.28 94.39 128.02 96.00 131.42 127.21 252.90 409.20 463.70 510.22 2463 2048 3940 6505 5723 11,520 5779 5969 8461 20,106 13,313 10,771 15,543 36,194 34,703 39,204 86,533 472.92 1339.75 620.25 568.33 1497.60 1365.83 1687.00 1639.92 2872.33 3655.08 2912.00 3921.00 3865.67 7684.10 12,446.33 14,098.40 15,524.00 18.0 9.5 12.8 36.7 35.7 24.0 43.3 46.7 78.7 180.5 60.9 103.7 126.8 157.7 169.4 331.4 371.6 4.45 6.92 4.28 3.90 5.50 4.60 5.62 5.15 6.18 6.15 5.88 4.88 5.50 7.00 10.75 7.05 6.35 566.52 696.82 1033.15 1003.62 1611.37 1613.27 1854.17 2160.55 2305.58 3503.93 3571.59 3741.40 4026.52 10,343.81 11,732.17 15,414.94 18,854.45 The goal here is to produce an empirical equation that will estimate (or predict) personnel needs for naval hospitals. Estimate the multiple linear regression equation Y |x1,x2,x3,x4,x5 = 0 + 1x1 + 2x2 + 3x3 + 4x4 + 5x5.