Given the following regression output, Predictor Co-eff SE Co-eff t p-value Constant 84.998 1.863 45.62 0.000 X
Question:
Given the following regression output, |
Predictor | Co-eff | SE Co-eff | t | p-value | ||||
Constant | 84.998 | 1.863 | 45.62 | 0.000 | ||||
X1 | 2.391 | 1.200 | 1.99 | 0.051 | ||||
X2 | -0.409 | 0.172 | -2.38 | 0.021 | ||||
Analysis of Variance | ||||||||||
Source | DF | SS | MS | F | p-value | |||||
Regression | 2 | 77.907 | 38.954 | 4.138 | 0.021 | |||||
Residual Error | 62 | 583.693 | 9.414 | |||||||
Total | 64 | 661.600 | ||||||||
Answer the following questions: |
a. | Write the regression equation. (Round your answers to 3 decimal places. Negative amounts should be indicated by a minus sign.) |
Ŷ = + X1 + X2 |
b. | If X1 is 4 and X2 is 11, what is the expected or predicted value of the dependent variable? (Round your answer to 3 decimal places.) |
Dependent variable is |
c. | How large is the sample? How many independent variables are there? |
Sample n | |
Independent variables k | |
d-1. | State the decision rule for .05 significance level: H0: β1 = β2 = 0; H1: Not all β's are 0. (Round your answer to 2 decimal places.) |
Reject H0 if F > |
d-2. | Compute the value of the F statistic. (Round your answer to 2 decimal places.) |
Computed value of F is |
d-3 | What is the conclusion? Use the .05 significance level. |
(Click to select)Reject Do not Reject H0. (Click to select)Not allAll net regression coefficients equal zero. |
e-1. | State the decision rule for .05 significance level: (Round your answers to 3 decimal places. Negative amounts should be indicated by a minus sign.) |
Reject H0 if t < or t > |
e-2. | Compute the value of the test statistic. (Round your answers to 2 decimal places. Negative amounts should be indicated by a minus sign.) |
t-value | |
For X1 | |
For X2 | |
e-3. | Which variable would you consider eliminating? |
Delete variable (Click to select)X1X2 and keep (Click to select)X1X2. |
f. | Outline a strategy for deleting independent variables in this case. |
The regression analysis should be repeated with only (Click to select)X2X1 as the independent variable. |
Statistical Techniques in Business and Economics
ISBN: 978-1259666360
17th edition
Authors: Douglas A. Lind, William G Marchal