# Question

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 S02_30.xlsx.

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 given total direct compensation figures. For the

50% of the executives that do not fall into this middle 50% range, is there more variability in total direct compensation to the right than to the left? Explain.

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 given total direct compensation figures. For the

50% of the executives that do not fall into this middle 50% range, is there more variability in total direct compensation to the right than to the left? Explain.

## Answer to relevant Questions

The file S02_41.xlsx contains monthly returns on Barnes and Noble stock for several years. As the formulas in the file indicate, each return is the percentage change in the adjusted closing price from one month to the next. ...Recall that the file Baseball Salaries 2009.xlsx contains data on 818 MLB players as of May 2009. Using this data set, answer the following questions:a. Find the mean and median of the salaries of all shortstops. Are any of ...The file S02_56.xlsx contains monthly values of indexes that measure the amount of energy necessary to heat or cool buildings due to outside temperatures. These are reported for each state in the U.S. and also for several ...In the smoking/drinking example in this section, we used the function COUNTIFS function (new to Excel 2007) to find the counts of the joint categories. Without using this function (or pivot tables), devise another way to get ...Recall that the file Golf Stats.xlsx contains data on the 200 top golfers each year from 2003 to 2009. The question to be explored in this problem is what drives earnings, and whether this is consistent from year to year.a. ...Post your question

0