I Only need Question 4 and 5

Use the Excel output in the below table to do (1) through (6) for each of 80, 61, 62, and 63. y = 60 + 61*1 + 62x2 + 83X3 + = 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. 8028 504. 1819 3.8613 9. 0923 848 . 2848 3845. 3201 XRay (x1) 0.0386 0.0138 2.9579 9.0129 e. 6102 8. 0678 BedDays (x2) 1.9394 0.0676 15.3857 2.91E-09 9.8922 1. 1856 LengthStay (x3) -413.7578 98. 5983 -4.1964 9. 9812 -628.5850 -198.9306 (1) Find by. sby. and the t statistic for testing Me: 6. = e 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 t HO: 80 = 0 1,046.8020 604.1819 3.861 HO: 81 = 0 0.0386 0.0130 2.969 HO: 82 = 0 1.0394 0.0876 15.376 HO: 83 = 0 (413.7578) 98.5083 4.196) (2) Using the t statistic and appropriate critical values, test Ng: 6% = 0 versus My: 6% > @ by setting a equal to .05. Which independent variables are significantly related to y in the model with d =.05? (Round your answer to 3 decimal places.) 1.025 2.131 HO: 80 = 0; Do not reject HO HO: 81 = 0; Do not reject HO HO: 82 = 0; Do not reject HO HO: 83 = 0; Do not reject HO(4) Find the p-value for testing My: 8, =@ versus Hy: 6, # @ 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: 81 = 0 is : Reject HO at o = HO: 82 = 0 is Reject HO at o = HO: 83 = 0 is : Reject HO at 0 = (5) Calculate the 95 percent confidence interval for 6,, (Round your answers to 3 decimal places. Negative values should be Indicated by a minus sign.) 95% C.I. 80 81 B3