A multiple regression model is estimated with Excel and produces the following output: Dependant Variable: K Rs-qauare F-ratio p-value on f Observations: 23 0.5448 7.58 0.00157 Variable Parameter estimate Standard error t-ratio p-value Intercept -220.0 68.25 -3.22 0.0045 x -11.340 3.670 -3.09 0.0060 y 0.3875 0.0625 6.20 0.0001 z 4.26 2.350 1.81 0.0857 A. Write the regression equation based on the output. B. If X equals 50, Y equals 200, and Z equals 45, what value do you predict K will take? If X, Y, and Z are all equal to 0? C. At the 5 percent significance level, which one of the three estimated coefficients of X, Y and Z is (are) statistically significant? D. How much of the total variation is explained by this regression equation? E. Is the overall regression equation statistically significant at the 1 percent level of significance?
- A multiple regression model is estimated with Excel and produces the following output:
Dependant Variable: |
K |
Rs-qauare |
F-ratio |
p-value on f |
|
Observations: |
23 |
0.5448 |
7.58 |
0.00157 |
|
Variable |
Parameter estimate |
Standard error |
t-ratio |
p-value |
|
Intercept |
-220.0 |
68.25 |
-3.22 |
0.0045 |
|
x |
-11.340 |
3.670 |
-3.09 |
0.0060 |
|
y |
0.3875 |
0.0625 |
6.20 |
0.0001 |
|
z |
4.26 |
2.350 |
1.81 |
0.0857 |
A. Write the regression equation based on the output.
B. If X equals 50, Y equals 200, and Z equals 45, what value do you predict K will take? If X, Y, and Z are all equal to 0?
C. At the 5 percent significance level, which one of the three estimated coefficients of X, Y and Z is (are) statistically significant?
D. How much of the total variation is explained by this regression equation?
E. Is the overall regression equation statistically significant at the 1 percent level of significance?

Comment: As per the our company guidelines we are supposed to answer only three subparts. Kindly repost other parts in the next question.
Given information:
Dependent variable: K
Independent variables: X,Y,and Z
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images









