The MBA program at Westmore University has undergone several dramatic changes over the past five years. During this time, the goal of the business school was to recruit as many students as possible into the MBA program in order to build up their student base and credit hour production. A massive campaign was launched five years ago in order to attract more applicants to the program.
Assignment
Wayne McDonald€™s assistant gathered the data for the past two years of experience with the Westmore MBA program and the information is stored in the WESTMORE data file. The Data Description section provides a partial listing of the data along with definitions of the variables. Using this data set and other information given in the case, help Wayne McDonald and the MBA Admissions Committee in their quest to develop better admissions guidelines for the Westmore MBA program. The case questions will assist you in your analysis of the data. Use important details from your analysis to support your recommendations.
Data Description
The data for the Westmore MBA admissions case are contained in the WESTMORE data file. The file contains data for the 202 students who completed their first year in the MBA program over the past two years. A partial listing of the data is shown below.

Undergraduate School Rating is a qualitative measure broken down into four variables:

Case Questions
1. The committee wishes to use first-year MBA grade point average as its measure of the quality of a student. As a first step in assisting committee members, construct a correlation matrix and briefly discuss the information it contains that could be of help to the committee members. If they were to choose only one variable in predicting the first-year MBA GPA, which variable would you recommend? Do you think it would be a good idea to evaluate applicants on the basis of only this one variable?

Transcribed Image Text:

The variables are defined as follows: ID No Student identification number GPA Yri: Grade point average for the first year of GMAT Score on the GMAT test. UG GPA: Undergraduate grade point average. courses in the Westmore MBA program Undergraduate Major is a qualitative measure broken down into two variables: UG_Bus 1 for undergraduate business major, otherwise0. UG Tech1 for undergrad science, engineering, or other technical field, otherwise 0 Note: A student with an undergraduate degree in a nonbusiness and nontechni cal field is the "baseline" and will have both UG-Bus = 0 and UG-Tech 0.) UG-İstSth 1 if student is from the top 20% of undergraduate schools, otherwise 0. UG_2nd5th 1 if student is from the second 20% of undergraduate schools, otherwise 0 UG_3rd5th-1 if student is from the third 20% of undergraduate schools, otherwise 0. UGAth5th-1 if student is from the fourth 20% of undergraduate schools, otherwise 0 (Note: A student with a degree from a school in the bottom fifth of undergrad- uate schools is the "basi and will have a 0 value for all four of the vari ables shown above.) Age of the student, in years. Age: US Cit: 1, if student is a U.S. citizen, 0 if other wise. UG UG UG UG UG UG UG 2nd 3rd 4th ID No Yr GMAT GPA Bus Tch 5th 5th 5th 5th Age Cit 4001 3.20 540 2.974 1 4002 2.964 540 2.529 1 4003 3.745 510 3.727 0 4004 3.290 570 2.9051 4005 3.028 640 2.6411 GPA US 0 25 0 23 0 25 0 23 1 0 23