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?