Question: Question 1) Answer the following questions based on the given Excel regression results. SUMMARY OUTPUT AN/A (a) Write down the regression equation. (b) Estimate the

Question 1) Answer the following questions based on the given Excel regression results. SUMMARY OUTPUT AN/A (a) Write down the regression equation. (b) Estimate the value of the response variable when X is 10 . (c) Interpret the coefficient of X in the regression equation. (d) What is the 95% confidence interval for the coefficient of X ? Interpret this interval. (e) What percent of the total variation in the response variable does this model predict? (f) What is the correlation coefficient between the explanatory variable and the response variable? (g) What is the correlation coefficient between the response variable and the estimations of the response variable? (h) Test the following hypothesis (H0: 1=0 vs. H1:1=0 ). What is your conclusion? Interpret this conclusion. (i) What is the variance of regression errors? (j) What is the sample size used in this regression model
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
