0 $405000.00 50 100 $1215000.00 Frequency 150 $2025000.00 200 $2835000.00 250 $3645000.00 300 $4455000.00 (iii) 0 $405000.00 50 Frequency 100 $1215000.00 150 $2025000.00 200 $2835000.00 250 $3645000.00 Histogram of Salary 2008 / Data Set #1 350 $5265000.00 $6075000.00 $6885000.00 $7695000.00 0 $405000.00 50 (i) 350 300 $4455000.00 $5265000.00 Frequency 100 $1215000.00 150 $2025000.00 200 $2835000.00 Histogram of Salary 2008 / Data Set #1 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. a. Select the appropriate histogram to gain a clearer understanding of the distributions of annual base salaries. $6075000.00 250 $3645000.00 $6885000.00 300 $4455000.00 $7695000.00 (iv) 350 $5265000.00 $6075000.00 $6885000.00 0 $405000.00 50 Frequency 100 $1215000.00 150 $2025000.00 200 $2835000.00 250 $3645000.00 (ii) 350 300 $4455000.00 Histogram of Salary 2008 / Data Set #1 $7695000.00 $5265000.00 $6075000.00 $6885000.00 Histogram of Salary 2008 / Data Set #1 $7695000.00 $857475.00 $2572425.00 $4287375.00 $6002325.00 $7717275.00 $9432225.00 Frequency $11147175.00 $12862125.00 $14577075.00 200 010 $16292025.00 250 $857475.00 $2572425.00 (iii) $857475.00 $2572425.00 $4287375.00 $6002325.00 Histogram of Bonus 2008 / Data Set #1 300 50 $4287375.00 $6002325.00 Frequency 8 100 150 $7717275.00 $9432225.00 $11147175.00 $12862125.00 $14577075.00 $16292025.00 $7717275.00 Frequency $9432225.00 $11147175.00 $12862125.00 $14577075.00 200 90 $16292025.00 250 $857475.00 $2572425.00 00 50 $4287375.00 (iv) 300 Histogram of Bonus 2008/ Data Set # 1 Graph (iv) v Select the appropriate histogram r bonuses earned by the surveyed CEOs in fiscal 2008. (i) Histogram of Bonus 2008/ Data Set #1 (ii) $6002325.00 $7717275.00 Frequency 100- $9432225.00 $11147175.00 150 $12862125.00 $14577075.00 $16292025.00 200 250 300 Histogram Bonus 2008/ Data Set #1 Graph (ii) How would you characterize these histograms? Select For the next three questions, make sure to use the PERCENTILE.INC Excel function. b. Find the annual salary below which 75% of all given CEO salaries fall. c. Find the annual salary above which 55% of all given CEO bonuses fall. d. Determine the range of the middle 50% of all given total direct compensation figures. IQR $ 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. The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank