Question: Hi! Help me with these questions please! Return to question 5 Use the Excel output in the below table to do (1) through (6) for

Hi! Help me with these questions please!

Hi! Help me with these questions please! Return to question 5 Usethe Excel output in the below table to do (1) through (6)for each ofo, 131, z, and 133. y=o+1x1+2x2+3X3+e df=n(k+1)= 16(3+1) =12 22:

Return to question 5 Use the Excel output in the below table to do (1) through (6) for each ofo, 131, z, and 133. y=o+1x1+2x2+3X3+e df=n(k+1)= 16(3+1) =12 22: Excel output for the hospital labor needs case (sample size: n =16) pom s Coefficients Standard Error 1: Stat pvalue 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.91309 0.8922 1.1866 Lengthstay (x3) -413.7578 98.5983 -4.1964 0.0012 -628.5850 -198.9306 (1) Find bj, sbj, and the tstatistic for testing H0 : [31- = 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.) 0 Answer Is complete and correct. b] sh] t H0: 130 = 0 1,946.8020 9 504.1819 9 3.861 9 H0: 61 = 0 0.0386 9 0.0130 9 2.958 9 H0: 82 = 0 1.0394 9| 0.0676 9 15.386 9 H0: 133 = 0 (413.7578) 0 | 98.5983 0 (4.196) 9 (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.) x Answer is complete but not entirely correct. HO: B1 = 0 is 0.012 ; Reject HO at a 0.05 HO: 32 = 0 is 2.9019 X ; Reject HO at a 0.001 HO: 33 = 0 is 0.0012 ; Reject HO at a 0.01(6) Calculate the 99 percent condence interval for j. (Round your answers to 3 decimal places. Negative values should be indicated by a minus sign.) 9 Answer is complete but not entirely correct. so [ 406.526 9 ] Bl [ (0-001) 0 1 [32 [ 0.833 9 1 33 [ (628.585) , (193.931)Q 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!