CS 5.1 3.5 2.4 4 1.7 2 5 3.2 5.2 4.3 2.9 1.1 2.6 4 5.3 4.9 5 3.9 SE 4 4 2 6 2 2 4 2 6 6 2 2 4 6 4 6 6 4 Profit 2 3.5 8.5 4.5 7 7 2 5 8 5 6 7.5 4 4 1 5 6.5 1.5 APL 15.57 44.02 20.42 18.74 29.2 44.92 55.48 59.28 94.39 128.02 96 131.42 127.21 252.9 409.2 463.7 510.22 XE OBD 2463 472.92 2048 1339.75 3940 620.25 6505 568.33 5723 1497.6 11520 1365.83 5779 1687 5969 1639.92 8461 2872.33 20106 3655.08 13313 2912 10771 3921 15543 3865.67 36194 7684.1 34703 12446.33 39204 14098.4 86533 15524 EP 18 9.5 12.8 36.7 35.7 24 43.3 46.7 78.7 180.5 60.9 103.7 126.8 157.7 169.4 331.4 371.6 Stay 4.45 6.92 4.28 3.9 5.5 4.6 5.62 5.15 6.18 6.15 5.88 4.88 5.5 7 10.78 7.05 6.35 LH 566.52 696.82 1033.15 1603.62 1611.37 1613.27 1854.17 2160.55 2305.58 3503.93 3571.89 3741.4 4026.52 10343.81 11732.17 15414.94 18854.45 Question 2: Data of six variables from a hospital are recorded in the excel file [which is posted on the course website with the tab \"Question 2\"]. APL denotes average daily patient load X E denotes monthly Xray exposures OED denotes monthly occupied bed days EF denotes eligible population in the area [divided by 1000] Stay denotes average length of patients' stay in days LH denotes monthly labor hours One of the aim is to forecast LH from the other yaraihles. a. The researcher is going to use a multiple linear regression model. Il'i'learly state the model with all the necessary amumptions. b. Use any statistical software to do the calculations and report the predicted model. c. Report the ooeicient of determination for the model stated in part [a]. 1What does this value tell you about the model? d. Estimate the population 1warianoe based on the model stated in part {a}