Use the Excel output in the below table to do (1) through (6) for each of Bor Bi, B2, and B3. y = Bo + 81X1 + 82x2 + 83x3 + E 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 958 Upper 958 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 by, sby, and the t statistic for testing Ho: ; = o 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.) bj sbj HO: BO = 0 HO: 31 = 0 HO: 32 = 0 HO: 83 = 0 (2) Using the t statistic and appropriate critical values, test Ho : Bj = 0 versus Ha: By * 0 by setting a equal to .05. Which independent variables are significantly related to y in the model with a =.05? (Round your answer to 3 decimal places.) t.025 HO: 30 = 0; HO HO: 31 = 0; HO HO: 32 = 0; HO HO: 83 = 0; HO (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(3) Using the t statistic and appropriate critical values, test H : 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 HO: BO = 0; HO HO: 31 = 0; HO HO: 32 = 0; HO HO: 83 = 0; HO (4) Find the p-value for testing Ho: Bj = 0 versus Ha: By * 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 8 2 = 0 and 83 = 0 to 4 decimal places. Round other answers to 3 decimal places.) HO: 31 = 0 is Reject HO at a = HO: 32 = 0 is Reject HO at a = HO: 83 = 0 is Reject HO at a = (5) Calculate the 95 percent confidence interval for j. (Round your answers to 3 decimal places. Negative values should be indicated by a minus sign.) 95% C.I. BO B1 B2 B3{4} Find the pvalue for testing Ho : j - 0 versus Ha: j - a on the output. Using the pvalue, determine whether we can reject Ho by setting Cl 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 2 = O and 33 = O to 4 decimal places. Round other answers to 3 decimal places.) Hmm=0is _:Re:ecmom= _ Hummus _:Re:ecmom= _ H0253=0is _:Re:ecmom= _ {5} Calculate the 95 percent confidence interval for 5 j. {Round your answers to 3 decimal places. Negative values should be indicated by a minus sign.) 95% OJ. [30 B1 [32 B3 {6} Calculate the 99 percent confidence interval for 3 j. {Round your answers to 3 decimal places. Negative values should be indicated by a minus sign.) 89% OJ. [30 B1 [32 B3