Many people ask, Are executives worth their very high pay? As noted in the chapter, this is

Many people ask, €œAre executives worth their very high pay?€ As noted in the chapter, this is a difficult question to answer because the benefits an effective executive brings to the company are hard to measure. One thing we can do, however, is to see if changes in executive pay are correlated with changes in company performance. If pay increases when company performance increases, and vice versa, then this would be an indication that pay practices are aligned with the interests of shareholders. To study this question, we have data (from The New York Times, May 26, 2017) for 30 of the highest paid chief executive officers (CEOs) in the United States in 2016 (these are not the 30 highest paid CEOs because some have been omitted due to insufficient data):

In the above table, the change in compensation is measured as the percentage change in total compensation from 2015 to 2016; total return (a measure of company performance) is measured by the percentage change in stock price plus dividends.

Required

1. Using Excel, find the correlation between the change in executive pay and company performance. Round your answer to 5 decimal places.

2. Using Excel, conduct regression analysis with company performance as the dependent variable and the change in CEO pay as the independent variable. What is the p-value for the coefficient on the change in CEO pay? Round your answer to 5 decimal places.

3. Comment briefly on the findings. Does it appear that the change in CEO pay is significantly related to the change in company performance?

Transcribed Image Text:

% Change from 2015 to 2016 Total Total CEO Company Compensation Return CBS Leslie Moonves 22 36 Fabrizio Freda Estée Lauder 196 Mark Parker Nike 183 Robert Iger David Zaslav Disney Discovery -6 -8 15 Robert Kotick Activision 358 -6 Meg Whitman Jeffrey Bewkes Virginia Rometty Joshua Sapan НР 93 54 Time Warner IBM 3 52 63 25 AMC Networks 72 -30 Brian Roberts Comcast 4. 25 -40 -32 Leonard Schleifer Regeneron Wynn Resorts Microsemi Stephen Wynn James Peterson 36 28 277 28 Marissa Mayer Yahoo! -24 16 JPMorgan Chase Scripps Networks Roper Technologies James Dimon 49 33 Kenneth Lowe 234 31 Brian Jellison 13 -3 John Wren Laurence Fink Omnicom 10 15 BlackRock -1 14 Indra Nooyi Rex Tillerson Randall Stephenson PepsiCo 13 ExxonMobil 4. 20 AT&T 11 29 Hock Tan Broadcom 513 40 Evan Greenberg Martin Barrington Reed Hastings Mary Barra Henry Fernandez Bradley Jacobs Chubb 20 15 Altria 126 20 Netflix GM 39 8. -22 MSCI 245 11 XPO Logistics 281 58