I need help with questions 4 and 5

Use the Excel output in the below table to do ($) through (6) for each of Ap. #1. 82. and #3. y = Bo * 81x * Pzay + Ayay + df = n - (* * 1) = 16 - (3 + 1] = 12 Excel output for the hospital labor needs case (sample size: n = 16) Coofficianta Standard Error t Stat p-Talus Lower 94% Uppar 134 Intercept 1946. 8020 504- 1819 3.1413 0. DD23 848 -2840 3045 . 3201 XRay (21) D. DJ.46 2.1379 0. 0120 0-0102 D. DET DadDaya [x2] 1. D394 D.9476 15.3457 2.918-09 4-1922 1. 1BE Lengthstay (x3) -413. 1578 -4.1964 0 . DD12 -624 -3850 -198 . 9304 (1) Find by, aby and the statistic for testing wp: py = D 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.) HD. PO = 0 1,848.8220 504.1819 3.851 HD. B1 = 0 0.0386 0.0130 2.958 HO. B2 = 0 1.0334 0.0676 15.356 HO: B3 = 0 (413 7580] 98.5983 (4.196 (2) Using the statistic and appropriate critical values, test ly: 8j = a versus ,: #y . D by setting a equal to 05. Which independent variables are significantly related to yin the model with a =.05? (Round your answer to 3 decimal places.) 1025 2.145 HO: PO = 0, Reject HO HO: 81 = 0, Reject HO HO HOT B3 = 0, Reject HO (3) Using the f statistic and appropriate critical values, test : By - o versus w,: By . s by setting a equal to .01 Which independent variables are significantly related to win the model with a =.Of? (Round your answer to 3 decimal places.) 1.005 2.977 HO PO = 0 Reject HO HO. B1 = 0 Do not reject HO HO. B2 = 0, Reject HO HO: 83 = 0, Reject HP (4) Find the pivalue for testing Ip: #j = D versus II : Aj . a on the output. Using the pvalue, determine whether we can reject My 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 pivalue at $ 2 = 0 and #3 = 0 to 4 decimal places. Round other answers to 3 decimal places.) Ho B1 = 0 is : Reject HO at a = HO B2 = 0 6 : Reject HO at a = HO. 83 = 0 is Flajoct HO at a = (5) Calculate the 95 percent confidence interval for By. (Round your answers to 3 decimal places. Negative values should be Indicated by a minus sign.) 15% C.I. (6) Calculate the 99 percent confidence interval for 8;_ (Round your answers to 3 decimal places. Negative values should be Indicated by a minus sign.) 19% C.I. 405. 528 3,487.078 1 (0.001] 0.078 0.833 1.246 (714.976) . (112.540] 1(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.) HO: 31 = 0 is ; 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 confidence interval for Bj. (Round your answers to 3 decimal places. Negative values should be indicated by a minus sign.) 95% C.I. BO 31 32 33