Question: (Weight 50 Points). The data below represents the need for labor in 16 U.S. Navy hospitals, where:

y = monthly labor hours required

X1 = monthly x-ray exposures

X2 = monthly occupied bed days

X3 = average length of patient stay ( in days)

Monthly Labor Hrs X-Ray exposures Occupied Bed Days Length of Stay

566.2 2463 472.92 4.45

696.82 2048 1339.75 6.92

1033.15 3940 620.25 4.28

1603.62 6505 568.33 3.90

1611.37 5723 1497.6 5.50

1613.27 11520 1365.83 4.60

1854.17 5779 1687.00 5.62

2160.55 5969 1639.92 5.15

2305.58 8461 2872.33 6.18

3503.93 20106 3655.08 6.15

3571.89 13313 2912.00 5.88

3741.40 10771 3921.00 4.88

4026.52 15543 3865.67 5.50

11732.17 34703 12446.33 10.78

15414.94 39204 14098.40 7.05

18854.45 86533 15524.00 6.35

1. Find and interpret b0, b1, b2 and b3.
2. Forecast Labor hours, for XRay = 56,194, BedDays = 14,077.88 and LengthStay = 6.89.
3. Report R-Sq and Adj R-SQ. Explain their differences and explain their meaning in the context of this problem.
4. Calculate the F-value. Verify this value on your printout.
5. Test the entire Model for significance. Let alpha equal .05.
6. Test the entire Model for significance. Let alpha equal .01.

Price: $2.99

Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document