The file P3_85.XLS contains 1993 compensation data on the top 200 CEOs. The data include the CEOs

Question:

The file P3_85.XLS contains 1993 compensation data on the top 200 CEOs. The data include the CEO’s name, company, total compensation, and the company’s 5-year total return to shareholders (expressed as an annual rate). The data are sorted in descending order according to the 5-year return.

a. How large must a total compensation be to qualify as an outlier on the high side according to the boxplot definition of outliers? In column A of the spreadsheet, highlight the names of all CEOs whose total compensations are outliers. (You can highlight them by making them boldface, italicizing them, or painting them a different color, for example.)

b. Form a scatterplot of total compensation versus 5-year return. (Put total compensation on the horizontal axis.) Do the CEOs in this database appear to be worth their pay?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Statistics

ISBN: 9780534389314

1st Edition

Authors: S. Christian Albright, Wayne L. Winston, Christopher Zappe

Question Posted: