Question

Use the Excel output in the below table to do (1) through (6) for each ofβ0,...

Use the Excel output in the below table to do (1) through (6) for each ofβ0, β1, β2, and β3.

y = β0 + β1x1 + β2x2 + β3x3 + ε     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.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
LengthSt(x3) -413.7578 98.5983 -4.1964 0.0012 -628.5850 -198.9306


(1) Find bj, sbj, and the t statistic for testing H0: βj = 0 on the output and report their values. (Round your t value answers to 3 decimal places and other answers to 4 decimal places.)

bj sbj t
H0: β0 = 0
H0: β1 = 0
H0: β2 = 0
H0: β3 = 0


(2) Using the t statistic and appropriate critical values, test H0: βj = 0 versus Ha: βj ≠ 0 by setting α equal to .05. Which independent variables are significantly related to y in the model with α = .05? (Round your answer to 3 decimal places.)


t.025                             

H0: β0 = 0; (Click to select)Do not rejectReject H0
H0: β1 = 0; (Click to select)Do not rejectReject H0
H0: β2 = 0; (Click to select)RejectDo not reject H0
H0: β3 = 0; (Click to select)Do not rejectReject H0


(3) Using the t statistic and appropriate critical values, test H0: βj = 0 versus Ha: βj ≠ 0 by setting α equal to .01. Which independent variables are significantly related to y in the model with α = .01? (Round your answer to 3 decimal places.)


t.005                          

H0: β0 = 0; (Click to select)Do not rejectReject H0
H0: β1 = 0; (Click to select)RejectDo not reject H0
H0: β2 = 0; (Click to select)RejectDo not reject H0
H0: β3 = 0; (Click to select)Do not rejectReject H0


(4) Find the p-value for testing H0: βj = 0 versus Ha: βj ≠ 0 on the output. Using the p-value, determine whether we can reject H0 by setting α 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 = 0 and β3 = 0 to 4 decimal places. Round other answers to 3 decimal places.)

H0: β1 = 0 is ; Reject H0at α = (Click to select)0.050.0010.01
H0: β2 = 0 is ; Reject H0at α = (Click to select)0.0010.000010.00005
H0: β3 = 0 is ; Reject H0at α = (Click to select)0.0010.010.05


(5) Calculate the 95 percent confidence interval for βj. (Round your answers to 3 decimal places.)

95% C.I.
β0 [, ]
β1 [, ]
β2 [, ]
β3 [, ]


(6) Calculate the 99 percent confidence interval for βj. (Round your answers to 3 decimal places.)

95% C.I.
β0 [, ]
β1 [, ]
β2 [, ]
β3 [, ]
0 0
Add a comment Improve this question Transcribed image text
Answer #1

ANSWER:

Given that,

1)

bj sbj t
H0: β0 = 0 1946.8020 504.1819 0.0023
H0: β1 = 0 0.0386 0.0130 0.0120
H0: β2 = 0; 1.0394 0.0676 2.91E-09
H0: β3 = 0 -413.7578 98.5983 -4.1964


2)

Using the t statistic and appropriate critical values, test H0: βj = 0 versus Ha: βj ≠ 0 by setting αequal to .05. Which independent variables are significantly related to y in the model with α =.05

t critical Decision
H0: β0 = 0 2.179 REJECT H0
H0: β0 = 0 2.179 REJECT H0
H0: β0 = 0 2.179 REJECT H0
H0: β0 = 0 2.179

REJECT H0

3)

Using the t statistic and appropriate critical values, test H0: βj = 0 versus Ha: βj ≠ 0 by setting αequal to .01. Which independent variables are significantly related to y in the model with α = .01

t critical Decision
H0: β0 = 0 3.054 REJECT H0
H0: β1 = 0 3.054 FAIL TO REJECT H0
H0: β2 = 0 3.054 REJECT H0
H0: β3= 0 3.054 REJECT H0

4)

H0: β1 = 0: REJECT H0 AT 0.05

H0: β2 = 0 ; REJECT H0 AT 0.000005

H0: β3 = 0; REJECT H0 0.05

95% C.I
β0 [848.284,3045.320]
β1 [0.010,0.067]
β2 [0.892,1.187]
β2 [-628.585,-198.931]

5)

bj sbj Lower 95% Upper 95%
β0 1946.802 504.1819 848.284 3045.32
β1 0.0386 0.013 0.0102 0.067
β2 1.0394 0.0676 0.8922 1.1866
β3 -413.7578 98.5983 -628.585 -198.931

6)

bj sbj Lower 99% Upper 99%
1946.802 504.1819 406.758428 3486.846
0.0386 0.013 -0.00110901 0.078309
1.0394 0.0676 0.83291312 1.245887
-413.7578 98.5983 -714.93021 -112.585
Add a comment
Know the answer?
Add Answer to:
Use the Excel output in the below table to do (1) through (6) for each ofβ0,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You may need to use the appropriate technology to answer this question. In a regression analysis ...

    You may need to use the appropriate technology to answer this question. In a regression analysis involving 27 observations, the following estimated regression equation was developed. ŷ = 25.2 + 5.5x1 For this estimated regression equation SST = 1,550 and SSE = 550. (a) At α = 0.05, test whether x1 is significant. State the null and alternative hypotheses. H0: β1 = 0 Ha: β1 ≠ 0H0: β0 = 0 Ha: β0 ≠ 0     H0: β1 ≠ 0 Ha: β1...

  • Consider the data. xi 2 6 9 13 20 yi 9 18 8 25 21 a....

    Consider the data. xi 2 6 9 13 20 yi 9 18 8 25 21 a. What is the value of the standard error of the estimate? (Round your answer to three decimal places.) (b) Test for a significant relationship by using the t test. Use α = 0.05. State the null and alternative hypotheses. H0: β1 = 0 Ha: β1 ≠ 0 H0: β0 ≠ 0 Ha: β0 = 0 H0: β1 ≠ 0 Ha: β1 = 0 H0:...

  • A statistical program is recommended. Data showing the values of several pitching statistics for a random...

    A statistical program is recommended. Data showing the values of several pitching statistics for a random sample of 20 pitchers from the American League of Major League Baseball is provided. Player Team W L ERA SO/IP HR/IP R/IP Verlander, J DET 24 5 2.40 1.00 0.10 0.29 Beckett, J BOS 13 7 2.89 0.91 0.11 0.34 Wilson, C TEX 16 7 2.94 0.92 0.07 0.40 Sabathia, C NYY 19 8 3.00 0.97 0.07 0.37 Haren, D LAA 16 10 3.17...

  • For a sample of 20 New England cities, a sociologist studies the crime rate in each...

    For a sample of 20 New England cities, a sociologist studies the crime rate in each city (crimes per 100,000 residents) as a function of its poverty rate (in %) and its median income (in $1,000s). A portion of the regression results is shown in the accompanying table. Use Table 2 and Table 4.   ANOVA df SS MS F Significance F   Regression 2    2,517.3     1,258.6     7.49E-01      Residual 17    72,837.53 4,284.56   Total 19    75,354.80 Coefficients...

  • What do we conclude about xj if we can reject H0: βj = 0 in favor of Ha: βj ≠ 0 by setting (a) α equal to .05? (b...

    What do we conclude about xj if we can reject H0: βj = 0 in favor of Ha: βj ≠ 0 by setting (a) α equal to .05? (b) α equal to .01? xj significantly related to y with (a) (Click to select)nonevery strongstrongsomeextremely strong or (b) (Click to select)somevery strongextremely strongstrongnone evidence.

  • In an article in the Journal of Advertising, Weinberger and Spotts compare the use of humor...

    In an article in the Journal of Advertising, Weinberger and Spotts compare the use of humor in television ads in the United States and in the United Kingdom. Suppose that independent random samples of television ads are taken in the two countries. A random sample of 400 television ads in the United Kingdom reveals that 142 use humor, while a random sample of 500 television ads in the United States reveals that 124 use humor. (a) Set up the null...

  • In an article in the Journal of Advertising, Weinberger and Spotts compare the use of humor...

    In an article in the Journal of Advertising, Weinberger and Spotts compare the use of humor in television ads in the United States and in the United Kingdom. Suppose that independent random samples of television ads are taken in the two countries. A random sample of 400 television ads in the United Kingdom reveals that 143 use humor, while a random sample of 500 television ads in the United States reveals that 125 use humor. (a) Set up the null...

  • The following regression output was obtained from a study of architectural firms. The dependent variable is...

    The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 7.987 2.967 2.690 0.010 x1 0.122 0.031 3.920 0.000 x2 − 1.120 0.053 − 2.270 0.028 x3 − 0.063 0.039 − 1.610 0.114 x4 0.523 0.142 3.690 0.001 x5 − 0.065 0.040 − 1.620 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 371000 742...

  • The following regression output was obtained from a study of architectural firms. The dependent variable is...

    The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. Predictor Coefficient SE Coefficient t p-value Constant 9.048 3.135 2.886 0.010 x1 0.284 0.111 2.559 0.000 x2 − 1.116 0.581 − 1.921 0.028 x3 − 0.194 0.189 − 1.026 0.114 x4 0.583 0.336 1.735 0.001 x5 − 0.025 0.026 − 0.962 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,895.93 379.2...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT