Hi! Help me with these questions please!
Return to question 5 Use the Excel output in the below table to do (1) through (6) for each ofo, 131, z, and 133. y=o+1x1+2x2+3X3+e df=n(k+1)= 16(3+1) =12 22: Excel output for the hospital labor needs case (sample size: n =16) pom s Coefficients Standard Error 1: Stat pvalue Lower 95% Upper 95% Intercept 1946.8020 504.1819 3.8613 0.0023 848.2840 3045.3201 XRay (x1) 0.0386 0.0130 2.9579 0.0120 0.0102 0.0670 BedDays (x2) 1.0394 0.0676 15.3857 2.91309 0.8922 1.1866 Lengthstay (x3) -413.7578 98.5983 -4.1964 0.0012 -628.5850 -198.9306 (1) Find bj, sbj, and the tstatistic for testing H0 : [31- = 0 on the output and report their values. (Round your t value answers to 3 decimal places and other answers to 4 decimal places. Negative values should be indicated by a minus sign.) 0 Answer Is complete and correct. b] sh] t H0: 130 = 0 1,946.8020 9 504.1819 9 3.861 9 H0: 61 = 0 0.0386 9 0.0130 9 2.958 9 H0: 82 = 0 1.0394 9| 0.0676 9 15.386 9 H0: 133 = 0 (413.7578) 0 | 98.5983 0 (4.196) 9 (4) Find the p-value for testing Ho : Bj = 0 versus Ha: Bj * 0 on the output. Using the p-value, determine whether we can reject Ho by setting a equal to .10, .05, .01, and .001. What do you conclude about the significance of the independent variables in the model? (Round your answers to p-value at 3 2 = 0 and 83 = 0 to 4 decimal places. Round other answers to 3 decimal places.) x Answer is complete but not entirely correct. HO: B1 = 0 is 0.012 ; Reject HO at a 0.05 HO: 32 = 0 is 2.9019 X ; Reject HO at a 0.001 HO: 33 = 0 is 0.0012 ; Reject HO at a 0.01(6) Calculate the 99 percent condence interval for j. (Round your answers to 3 decimal places. Negative values should be indicated by a minus sign.) 9 Answer is complete but not entirely correct. so [ 406.526 9 ] Bl [ (0-001) 0 1 [32 [ 0.833 9 1 33 [ (628.585) , (193.931)Q 1