Question: The Wall Street Journal CEO Compensation Study analyzed CEO pay from many US companies with fiscal year 2008 revenue of at least $5B that filed

TheWall Street Journal CEO Compensation Study analyzed CEO pay from many US companies with fiscal year 2008 revenue of at least $5B that filed their proxy statements between October 2008 and March 2009. The data are in fileP02_30.xlsx.

  1. 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? (hint: there should be a histogram for salaries and one for bonuses)
  2. Find the annual salary below which 75% of all given CEO salaries fall. (Hint: use the third quartile)
  3. Find the annual bonus above which 55% of all given CEO bonuses fall. (Hint: use =percentile(range,0.55)
  4. Determine the range of the middle 50% of all given total direct compensation figures. For the 50% of the executives that do not fall in this middle 50% range, is there more variability in total direct compensation to the right than to the left? Explain. (Hint: quartile range is Q3 - Q1)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!