Use the Excel output in the below table to do (1) through (6) for each of Bo, B1, B2, and B3. y = Bo + 81x1 + $2x2 + $3x3 + & df = n - (k + 1) = 16 - (3 + 1) = 12 Excel output for the hospital labor needs case (sample size: n = 16) Coefficients Standard Error t Stat p-value 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.91E-09 0 . 8922 1 . 1866 LengthStay (x3) -413 . 7578 98 . 5983 -4. 1964 0 . 0012 -628. 5850 -198. 9306 (1) Find bj, sbj, and the t statistic for testing Ho : Bj = 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.)(2) Using the tstatistic and appropriate critical values, test Ho: j = 0 versus Ha: j =2 o by setting 0 equal to .05. Which independent variables are signicantly related to yin the model with a = .05? (Round your answer to 3 decimal places.) ' 6 Answer is complete but not entirely correct. |t.025 3.055 0 (3) Using the t statistic and appropriate critical values, test Ho : Bj = 0 versus Ha: Bj * 0 by setting a equal to .01. Which independent variables are significantly related to y in the model with a = .01? (Round your answer to 3 decimal places.) t.005(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 B3 = 0 to 4 decimal places. Round other answers to 3 decimal places.) HO: 31 = 0 is 0.002 ; Reject HO at a = HO: 32 = 0 is ; Reject HO at a = HO: 33 = 0 is ; Reject HO at a =(5) Calculate the 95 percent condence interval for ,Bj. (Round your answers to 3 decimal places. Negative values should be indicated by a minus sign.) _ (6) Calculate the 99 percent condence interval for ,Bj, (Round your answers to 3 decimal places. Negative values should be indicated by a minus sign.) BO B1 [32 53 99% C.l