# Statistical Analysis

1190 Words5 Pages
MBA Business Statistics Homework 1 Reminders: 1. Due date: Jan-14-2012 (Saturday) in class. 2. Please submit only the hardcopy. 3. Please show the names and ID numbers of all your group members on the cover page. Please also indicate your session (DSME5110W). 1. Problem 2.1 (p. 33) The file P02_01.xlsx indicates the gender and nationality of the MBA incoming class in two successive years at the Kelley School of Business at Indiana University. a. For each year, create tables of counts of gender and of nationality. Then create column charts of these counts. Do they indicate any noticeable change in the composition of the two classes? b. Repeat part a for nationality, but recode this variable so that all nationalities that…show more content…
Defend your choice. e. As an admissions officer of this MBA program, how would you proceed to use these findings to market the program to prospective students? 7. Problem 2.24 (p. 63) Is educational attainment in the United States on the rise? Explore this question by creating time series graphs for each of variables in the file P02_24.xlsx. Comment on any observed trends in the annual educational attainment of the general U.S. population over the given period. 8. Problem 2.42 (p. 78) The Wall Street Journal CEO Compensation Study analyzed CEO pay from many U.S. companies with fiscal year 2008 revenue of at least \$5 billion that filed their proxy statements between October 2008 and March 2009. The data are in the file P02_30.xlsx. (Note: This data set is a somewhat different CEO compensation data set from the one used as an example in the next chapter.) a. Create histograms to gain a clearer understanding of the distributions of annual base salaries and bonuses earned by the surveyed CEOs in fiscal 2008. How would you characterize these histograms? b. Find the annual salary below which 75% of all given CEO salaries fall. c. Find the annual bonus above which 55% of all given CEO bonuses fall. d. Determine the range of the middle 50% of all