I have a research report where I have already done the research and I just need the data analyzed and results presented. Everything is based on a regression analysis and the following questions need to be addressed. Charts and tables must be in excel and written results in word. I have attached my report showing the variables that need to be analyzed.
Presentation and Interpretation of Results
6) Write the regression (prediction) equation:
Dep_Var = Intercept + c1 * Ind_Var_1 + c2 * Ind_Var_2 + c3 * Ind_Var_3
7) Identify and interpret the adjusted R2 (one paragraph):
< Define “adjusted R2.”
< What does the value of the adjusted R2 reveal about the model?
< If the adjusted R2 is low, how has the choice of independent variables created this result?
8) Identify and interpret the F test (one paragraph):
< Using the p-value approach, is the null hypothesis for the F test rejected or not rejected? Why or why not?
< Interpret the implications of these findings for the model.
9) Identify and interpret the t tests for each of the coefficients (one separate paragraph for each variable, in numerical order):
< Are the signs of the coefficients as expected? If not, why not?
< For each of the coefficients, interpret the numerical value.
< Using the p-value approach, is the null hypothesis for the t test rejected or not rejected for each coefficient? Why or why not?
< Interpret the implications of these findings for the variable.
< Identify the variable with the greatest significance.
10) Analyze multicollinearity of the independent variables (one paragraph):
< Generate the correlation matrix.
< Define multicollinearity.
< Are any of the independent variables highly correlated with each other? If so, identify the variables and explain why they are correlated.
After working on your question, I... View the full answer