Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started