Solution Found!
The following data reect information from 17 U.S. Naval
Chapter 12, Problem 12.12(choose chapter or problem)
The following data reect information from 17 U.S. Naval 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.
Questions & Answers
QUESTION:
The following data reect information from 17 U.S. Naval 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.
ANSWER:Step 1 of 2
Given:
The data for 17 U.S. Naval hospitals at various sites around the world is provided.
The variables are as follows,
y = monthly labor-hours,
= average daily patient load,
= monthly X-ray exposures,
= monthly occupied bed-days,
= eligible population in the area/1000,
= average length of patient’s stay, in days.