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?

Found something interesting ?

• On-time delivery guarantee
• PhD-level professional writers
• Free Plagiarism Report

• 100% money-back guarantee
• Absolute Privacy & Confidentiality
• High Quality custom-written papers

Related Model Questions

Feel free to peruse our college and university model questions. If any our our assignment tasks interests you, click to place your order. Every paper is written by our professional essay writers from scratch to avoid plagiarism. We guarantee highest quality of work besides delivering your paper on time.

Grab your Discount!

25% Coupon Code: SAVE25
get 25% !!