1 Find the predicted GMAT score given that UGPA350 and EXPER

1. Find the predicted GMAT score given that UGPA=3.50 and EXPER=10 months for male students after removing UMAJOR variable

2. Determine the coefficient of multiple determination (R-square) and explain its meaning.

3. Test the hypothesis whether the business experience(EXPER) adds any additional explanatory power to the equation over that GMAT score (GMAT) provides at a 5 percent significance level. If yes, why? If no, why?

4.Examine whether the MBA students with a higher undergraduate GPA (UGPA) in GSC produce a higher score in GMAT (GMAT) at the 5 percent confidence level. If yes, why?

5. Which two independent variables are most strongly correlated with dependent variable(GMAT) regardless of different signs in its direction? Show it.

6.What’s the computed t-value for the Undergraduate GPA (UGPA) and how it is computed (show it directly from the computer output) ?

7. Is there sufficient evidence to indicate that the multiple regression model contributes information for predicting the GMAT score that will be related? If yes, at what percent level of significance? Prove it by your calculation.

8. Use the model to predict(estimate) the mean GMAT score for all students with 5 months business experience after holding all other variable constant.

9. Explain the partial correlation R (GMAT UGPA. SEX EXPER) =0.8089. What does this value stand for?

10. Would you explain how is GMAT score influenced by SEX? Why?

11. Is there any implication of multicollinearity problem in this model? If yes, explain it using your criteria

12. Run the regression again, using only the independent variables that are significant at least at the 5 percent level of significance. Does it make a difference whether our MBA student has a business major in the undergraduate or not ? If it does, how much more point in GMAT does a business background in UMAJOR have than a non-business background in UMAJOR?

Developed a multiple regression model to predict GMAT scores from grade point average(UGPA) and months of business experience(EXPER) by sex. Data were collected for ten students and are presented in the accompanying table.

The last two independent variables (SEX and UMAJOR) are as follows: SEX = 1 if male, SEX = 0 if female and . UMAJOR = 1 if business background in undergraduate, UMAJOR=0 if not.

SHOULD YOU EXCLUDE UMAJOR FROM THE SPSS OR EXCEL OUTPUT????

Solution