18 Use the Excel output in the below table to do (1) through (6) for each of Bo, B1, $2, and B3. y = Bo + B1x1 + B2x2 + 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 95% Upper 95% 20 Intercept 1946. 8020 504. 1819 3. 8613 0. 0023 848. 2840 3045.3201 points 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 eBook (1) Find bj, sbj, and the t statistic for testing Ho: By = 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.) bj sbj HO: BO = 0 HO: B1 = 0 HO: B2 = 0 HO: 63 = 0 (2) Using the t statistic and appropriate critical values, test Ho: Bj = 0 versus Ha: Bj x 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: BO = 0; HO HO: B1 = 0; HO HO: B2 = 0; HO HO: B3 = 0; HO18 (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.) 20 t.005 points Book HO: BO = 0; HO HO: B1 = 0 HO HO: 32 = 0; HO HO: 83 = 0; HO (4) Find the p-value for testing Ho: Bj = ( versus Ha: Bj 2 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: B1 = 0 is ; Reject HO at a = HO: 82 = 0 is ; Reject HO at a = HO: B3 = 0 is ; Reject HO at a =ent Chapter 15 i Saved (4) Find the p-value for testing He: 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 B 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: 82 = 0 is Reject HO at a = HO: B3 = 0 is ; Reject HO at a = (5) Calculate the 95 percent confidence interval for Bj . (Round your answers to 3 decimal places. Negative values should be indicated by a minus sign.) 95% C.I. BO B1 + B3