UNIVERSITY OF ROCHESTER

William E. Simon Graduate Schoolof Business Administration

APS 425 Professor G. William Schwert

Advanced Managerial Data Analysis CS3-110L, 585-275-2470

Fall 2015 Fax: 585-461-5475

email: schwert@schwert.simon.rochester.edu

Midterm Exam: November 3, 2015

1.      Simon School Academic and Placement Data (a425_midterm15.wf1)

The Excel spreadsheet a425_midterm15.xlsx contains data for 1,104 Simon School MBA students who graduated from 2000-2004. For a subset of 338 students, there are also data available on post-MBA compensation. The data have been cleansed so that the confidentiality of student records is assured, yet there are many measurable attributes that the School administration would like to use to help the School manage admissions and placement activities to improve the school in the future.

There are three sets of attributes in the dataset. The first includes student characteristics that the admissions office can observe when evaluating applications:

Variable

Description

grad

graduation year (2000,2004)

age

age at admittance

exper

experience at admittance

econ

undergrad econ major

engin

undergrad engineering major

sci

undergrad science major

acc_bus

undergrad accting/bus major

male

=1 if male

SoAm

=1 if from South America

Asia_Afr

=1 if from Asia/Africa

Eur

=1 if from Europe

US

=1 if from US

Oth

=1 if from Other

ugpa

undergrad GPA

GMAT

GMAT

Q

quant score on GMAT

V

verbal score on GMAT

TW

=1 if partial or full tuition waiver

 

The second set of characteristics reflects choices made by the students during the MBA program:

 

Variable

Description

SGPA

Simon GPA

FIN

=1 if FIN concentration

ACC

=1 if ACC concentration

STR

=1 if STR concentration

MKT

=1 if MKT concentration

OMG

=1 if OMG concentration

CIS

=1 if CIS concentration

ENT

=1 if ENT concentration

HSM

=1 if HSM concentration

ITL

=1 if ITL concentration

 

The third set of characteristics reflects placement outcomes for students:

Variable

Description

ALU

=1 if job offer from alumni contact

CAR

=1 if job offer from CAR contact

PER

=1 if job offer from personal contact

OCR

=1 if job offer from OCR contact

salary

Salary

bonus

Bonus

comp

Total compensation

NumOff

Number of offers

 

Attached at the end of the exam is a short article published in the Chronicle of Higher Education on July 14, 2015, by Prof. Bernard Garrette, who is the Dean of the MBA Program and a management professor at HEC Paris. He argues that females are under-represented in business because they get paid substantially less than their male counterparts for the same job and experience. Dean Ainslie would like you to analyze the data from the Simon School and give him some advice.

  1. Is there any evidence that the admissions office uses different standards for admitting females? If so, what is it?
  2. Does the admissions office seem to go out of its way to attract females using financial aid awards? Explain.
  3. Is there any evidence that female students focus on certain Simon School concentrations? Explain.
  4. How do female students perform in their Simon classwork? Explain.
  5. Is there any evidence that Prof. Garrette is right and that females are under-paid? Explain.
  6. What additional data, if any, would you suggest that the Simon School collect to try to understand the structure of compensation offered to Simon students?

 


A full-text version of this exam is available in Acrobat's portable data format (.pdf). The file is about 15K and can only be viewed (and printed) using a copy of Acrobat Reader.

If you want the current version of the Adobe Acrobat Reader for other platforms, visit Adobe's web page by clicking the image below.

Click here to download this exam.


Click here to view a Powerpoint presentation showing a possible answer to this exam.

An example of a good exam answer is available in Acrobat's portable data format (.pdf). The file is about 15K and can only be viewed (and printed) using a copy of Acrobat Reader.

Click here to download this answer.


Click here to see the histogram showing the grades for this exam.

A histogram showing the grades for this exam is available in Acrobat's portable data format (.pdf). The file is about 4K and can only be viewed (and printed) using a copy of Acrobat Reader.

Click here to download this graph.


Return to APS 425 Home Page

© Copyright 2001-2015, G. William Schwert

Last Updated on 10/12/2015