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.
- 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)
- Find the annual salary below which 75% of all given CEO salaries fall. (Hint: use the third quartile)
- Find the annual bonus above which 55% of all given CEO bonuses fall. (Hint: use =percentile(range,0.55)
- 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
