The file P10_14.xlsx includes data on the 50 top graduate programs in the United States, according to a recent U.S. News & World Report survey. Columns B, C, and D contain ratings: an overall rating, a rating by peer schools, and a rating by recruiters. The other columns contain data that might be related to these ratings.

b. Run four separate regressions, each using the Overall rating as the dependent variable and GMAT, Accept Rate, Salary, and Enrollment, respectively, as a single independent variable. Interpret these equations.

Round your answers to four decimal places, if necessary. If your answer is negative number, enter "minus" sign.

Equation for GMAT:

= ____+______ GMAT

Equation for Accept Rate:

= ___+___ Accept Rate

Equation for Salary:

= ____ +____ Salary

Equation for Enrollment:

= ____ +____ Enrollment

What does the standard error of estimate indicate?

About _______ of the predictions of the ______, made only from one _______ 12 variable, will be ______ one standard error of the actual ______.

c. Run four separate regressions, each using the Peers rating as the dependent variable and GMAT, Accept Rate, Salary, and Enrollment, respectively, as a single independent variable. Interpret these equations.

Round your answers to four decimal places, if necessary. If your answer is negative number, enter "minus" sign.

Equation for GMAT:

=____ +_____ GMAT

Equation for Accept Rate:

=____ +_____Accept Rate

Equation for Salary:

=____ +_____Salary

Equation for Enrollment:

=____ +_____Enrollment

What does the standard error of estimate indicate?

About ______ of the predictions of the ______ , made only from one ______ variable, will be ________ one standard error of the actual _______ .

d. Run four separate regressions, each using the Recruiters rating as the dependent variable and GMAT, Accept Rate, Salary, and Enrollment, respectively, as a single independent variable. Interpret this equation.

Round your answers to four decimal places, if necessary. If your answer is negative number, enter "minus" sign.

Equation for GMAT:

=____ +_____GMAT

Equation for Accept Rate:

=____ +_____Accept Rate

Equation for Salary:

=____ +_____Salary

Equation for Enrollment:

= ____ +_____Enrollment

What does the standard error of estimate indicate?

About _______of the predictions of the _________ , made only from one _______variable, will be _________ one standard error of the actual ____________

https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fcnow.apps.ng.cengage.com%2Filrn%2Fbooks%2Falba07h%2Fdatafile%2Fresource%2Fch10%2FP10_14.xlsx&wdOrigin=BROWSELINK