Question

13. The Wall Street Journal CEO Compensation Study analyzed chief executive officer (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) Create a new variable Total 2008, the sum of Salary 2008 and Bonus 2008. (Actually, this is not “total” compensation because it omits the very lucrative compensation from stock options.) Also, recode Company Type so that the Technology and Telecommunications are collapsed into a Tech/ Telecomm category.
b) Find the mean, median, and standard deviation of Total 2008, broken down by the recoded Company Type. Also, create side-by-side box plots of Total 2008, again broken down by the recoded Company Type. What do the results tell you about differences in level or variability across company types? Please complete work in Excel spreadsheet.

Figure 2.30 Violent and Property Crime Rates Time Series 6000 5000 4000 E 500 3000 C 400 300 2000 O 200 1000 a Violent crime rate/Crime Data 100 Property crime rate/Crime Data 2 2 2 2

Answer 1

The data table is gien he loc Salaay Boos Bonus 2008 Ne salay 1120,000$2,644,3 6, loo 紀 ao, oco | 3,959,900 | | .te,asa,eo o $256,100 $856,700 56, 5c0$200c,00o 2,7s6, 506 $999,000 | $1,756,200 | 3275, ao e sum of salary and Gous create a Box plat fos Net s H. Firally click ok 41, Boxplot of Net sal ojaeo,oF CS Scan CamScanner

h select the enitise dta and ce ate a haw dubset gennteみe man, vedan vrriale 透24833 28.57 |覤チ$712G. 09 Median | $8583000.00 | $21682co.col -y 35306 So age 2313 cchiskers to: Pann ta ame grafh.仆can he .seen-tratte "iner He mild outler, are those colichawerado 34702 50 And ndt abae e given value of ntes vooftle cS

nte qucatiles value but the cels ahoase exbere table ne clooney 9,35,0cco 0,385,ooO Vi a con 3,535, 000 CS