Question

In: Statistics and Probability

Consider the following data for a dependent variable y and two independent variables, x1 and x2.

You may need to use the appropriate technology to answer this question.

Consider the following data for a dependent variable y and two independent variables,

x1 and x2.

x1

x2

y
30 12 93
47 10 108
25 17 112
51 16 178
40 5 94
51 19 175
74 7 170
36 12 117
59 13 142
76 16 211

The estimated regression equation for these data is

ŷ = −18.89 + 2.02x1 + 4.74x2.

Here, SST = 15,276.0, SSR = 14,134.9,

sb1 = 0.2482,

and

sb2 = 0.9528.

(a)

Test for a significant relationship among

x1, x2, and y.

Use α = 0.05.

State the null and alternative hypotheses.

H0: β1 ≠ 0 and β2 ≠ 0
Ha: One or more of the parameters is equal to zero.H0: β1 < β2
Ha: β1β2    H0: β1 ≠ 0 and β2 = 0
Ha: β1 = 0 and β2 ≠ 0H0: β1 = β2 = 0
Ha: One or more of the parameters is not equal to zero.H0: β1 > β2
Ha: β1β2

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

State your conclusion.

Reject H0. There is sufficient evidence to conclude that there is a significant relationship among the variables.

Reject H0. There is insufficient evidence to conclude that there is a significant relationship among the variables.    

Do not reject H0. There is insufficient evidence to conclude that there is a significant relationship among the variables.

Do not reject H0. There is sufficient evidence to conclude that there is a significant relationship among the variables.

(b)

Is

β1

significant? Use α = 0.05.

State the null and alternative hypotheses.

H0: β1 ≠ 0
Ha: β1 = 0H0: β1 < 0
Ha: β1 ≥ 0    H0: β1 = 0
Ha: β1 > 0H0: β1 > 0
Ha: β1 ≤ 0H0: β1 = 0
Ha: β1 ≠ 0

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

State your conclusion.

Do not reject H0. There is sufficient evidence to conclude that β1 is significant.

Reject H0. There is sufficient evidence to conclude that β1 is significant.    

Do not reject H0. There is insufficient evidence to conclude that β1 is significant.

Reject H0. There is insufficient evidence to conclude that β1 is significant.

(c)

Is

β2

significant? Use α = 0.05.

State the null and alternative hypotheses.

H0: β2 < 0
Ha: β2 ≥ 0H0: β2 > 0
Ha: β2 ≤ 0    H0: β2 = 0
Ha: β2 ≠ 0H0: β2 ≠ 0
Ha: β2 = 0H0: β2 = 0
Ha: β2 > 0

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

State your conclusion.

Reject H0. There is insufficient evidence to conclude that β2 is significant.

Reject H0. There is sufficient evidence to conclude that β2 is significant.    

Do not reject H0. There is insufficient evidence to conclude that β2 is significant.

Do not reject H0. There is sufficient evidence to conclude that β2 is significant.

Solutions

Expert Solution

Solution:

Given:

n = 10 observation

K = 2 number of independent variables .

.

. And.

SST = 15276.0

SSR = 14134.9

SST = SSR + SSE

SSE = SST - SSR

SSE = 15276.0 - 14134.9

SSE = 1141.1

a) Test for overall significance

To test the hypothesis

Vs

Ha: one or more of the parameters is not equal to zero.

Test statistic

F = 43.354790

Test statistic F = 43.35

P Value = 0.000114 from online P value calculator

P Value = 0.000

Decision : P Value

Reject Ho.

Conclusion : Reject Ho, there is sufficient evidence to conclude that there is significant relationship among the variables.

Option A is correct

b) Test for significance of

To test the hypothesis

. Vs.   

Test statistic

t = 8.1385979

Test statistic t = 8.14

P Value = 0.000082 from online P value calculator

P value = 0.000

Decision: P Value

Reject Ho.

Conclusion: Reject Ho, there is sufficient evidence to conclude that is significant.

Option B is correct.

c) Test for significance of

To test the hypothesis

. Vs.   

Test statistic

t = 4.9748110

Test statistic t = 4.97

P Value = 0.00161 from online P value calculator

P Value = 0.002

Decision : P Value

Reject Ho

Conclusion : Reject Ho, there is sufficient evidence to conclude that is significant.

Option B is correct.


Related Solutions

Consider the following data for a dependent variable y and two independent variables, x2 and x1....
Consider the following data for a dependent variable y and two independent variables, x2 and x1. x1 x2 y 30 12 94 46 10 109 24 17 113 50 17 179 41 5 94 51 19 175 75 8 171 36 12 118 59 13 143 77 17 212 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to x1 . Predict y if x1=45....
Consider the following data for a dependent variable y and two independent variables, x1 and x2....
Consider the following data for a dependent variable y and two independent variables, x1 and x2. x1 x2 y 30 12 94 47 10 108 25 17 112 51 16 178 40 5 94 51 19 175 74 7 170 36 12 117 59 13 142 76 16 209 The estimated regression equation for these data is ŷ = −17.02 + 1.99x1 + 4.70x2. Here, SST = 14,902.9, SSR = 13,773.1, sb1 = 0.2470, and sb2 = 0.9480. (1a) Test...
Consider the following data for a dependent variable y and two independent variables, x1 and x2....
Consider the following data for a dependent variable y and two independent variables, x1 and x2. x1 x2 y 30 13 95 46 10 108 25 18 113 50 16 179 40 5 95 51 20 176 74 7 170 36 12 117 59 13 142 77 16 211 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to x1. ŷ =_________ +___________ x1 Predict...
Consider the following data for a dependent variable y and two independent variables, x1 and x2....
Consider the following data for a dependent variable y and two independent variables, x1 and x2. x1 x2 y 30 12 95 47 10 108 25 17 112 51 16 178 40 5 94 51 19 175 74 7 170 36 12 117 59 13 142 76 16 212 The estimated regression equation for these data is ŷ = −18.52 + 2.01x1 + 4.75x2. Here, SST = 15,234.1, SSR = 14,109.8, sb1 = 0.2464, and sb2 = 0.9457. (a)Test for...
Consider the following data for a dependent variable y and two independent variables, x1and x2. x...
Consider the following data for a dependent variable y and two independent variables, x1and x2. x 1 x 2 y 29 13 94 47 10 109 24 17 113 50 16 178 40 6 95 52 20 176 75 7 171 37 13 118 59 14 142 77 17 211 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to x1. ŷ =  +  x1 Predict y...
Consider the following data for a dependent variable and two independent variables, and . x1= 30...
Consider the following data for a dependent variable and two independent variables, and . x1= 30 46 24 50 41 51 74 36 60 77. x2 = 13 11 17 17 6 20 8 12 13 16. y = 95 109 112 178 94 176 170 117 142 212 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating to y to x1 . Predict y if...
Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and...
Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and X3) in the data file. Select and use one independent variable throughout this analysis. Use Excel to perform the regression and correlation analysis to answer the following. Generate a scatterplot for the specified dependent variable (Y) and the selected independent variable (X), including the graph of the "best fit" line. Interpret. Determine the equation of the "best fit" line, which describes the relationship between...
Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and...
Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and X3) in the data file. Select and use one independent variable throughout this analysis. Use Excel to perform the regression and correlation analysis to answer the following. The week 6 spreadsheet can be helpful in this work. 1. Generate a scatterplot for the specified dependent variable (Y) and the selected independent variable (X), including the graph of the "best fit" line. Interpret. 2 Determine...
5. Consider the following set of dependent and independent variables. y   x1   x2 10   1   17...
5. Consider the following set of dependent and independent variables. y   x1   x2 10   1   17 11   5   9 14   5   13 14   8   10 21   6   3 24   10   8 26   16   7 33   20   3 a. Using​ technology, construct a regression model using both independent variables. y=___+___x1+___x2 ​(Round to four decimal places as needed.) b. Test the significance of each independent variable using a=0.05 Test the significance of x1, Identify the null and alternative hypothesis c. Calculate the...
Consider a binary response variable y and two explanatory variables x1 and x2. The following table...
Consider a binary response variable y and two explanatory variables x1 and x2. The following table contains the parameter estimates of the linear probability model (LPM) and the logit model, with the associated p-values shown in parentheses. Variable LPM Logit Constant −0.40 −2.20 (0.03 ) (0.01 ) x1 0.32 0.98 (0.04 ) (0.06 ) x2 −0.04 −0.20 (0.01 ) (0.01 ) a. At the 5% significance level, comment on the significance of the variables for both models. Variable LPM Logit...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT