Question: 1. Consider the enrollment data for Business Week's top 3i! U.S. graduate business programs in the file HW_Ei.xlsit. Use the data to estimate a multiple

1. Consider the enrollment data for Business Week's top 3i! U.S. graduate business programs in the file HW_Ei.xlsit. Use the data to estimate a multiple regression equation to assess whether there is a relationship between the total number of full-time students (Enrollment) and the following independent variables: a) the proportion of female students, b} the proportion of minorityr students, and c} the proportion of inten'iational students enrolled at these business schools. a. Interpret the coefficients of the estimated regression equation (please follow the rigid interpretation approach in our textbook). Do an],r of these results surprise you? Explain. b. How well does the estimated regression equation fit the given data? c. If we add another independent variable, type of schools {Column D} in the above- developed multiple regression model, what's the new multiple regression equation? How are you going to interpret the difference between private school and public school on enrollment in the new regression equation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
