DATA SET:

Columns

1. salary1990 salary, thousands $

2. pcsalary% change salary, 89-90

3. sales1990 firm sales, millions $

4. roereturn on equity, 88-90 avg

5. pcroe% change roe, 88-90

6. rosreturn on firm's stock, 88-90

7. indus=1 if industrial firm

8. finance=1 if financial firm

9. consprod=1 if consumer product firm

10. utility=1 if transport. or utilties

11. lsalarynatural log of salary

12. lsalesnatural log of sales

1. For the population of chief executive officers, let Y be the annual salary in thousands of dollars, X is the average return on equity for the CEO's firm for the previous three years Return on equity is defined in terms of net income as a percentage of common equity. For example, if roe=10, then average return on equity is 10%. Please use the data set and Excel to analyze the relationship between the firm performance and CEO compensation.

Please provide the Excel results and interpret the estimated intercept and estimated slope coefficient.