USING EXCEL
1. Copy the second sheet in QMB3200-Homework#8Data.xlsx called “Top 50 MBA Programs” to your file. This data is according to US News and World Report, 2009 survey.
a. Which of the variables in columns E through J are most highly correlated with Overall Rating? (Use the Excel function =CORREL( ) as shown in the chapter word document to find correlation coefficient between two variables).
b. Run a simple regression with the variable identified above and Overall Rating.
c. What percent of variation in overall rating explained by the variable identified in a?
d. Which of the remaining variables in columns E through J is most highly correlated to Overall Rating?
e. Run a regression with the second most correlated variable as independent variable to predict the Overall rating.
f. What percent variation is explained by the variable identified above?