Data is given in the second sheet which includes includes the total compensation (in $) of CEOs

Question:

Data is given in the second sheet which includes includes the total compensation (in $) of CEOs of the large public companies in 2008.

a) Compute the mean, median, first quartile, and the third quartile.

b) Compute the range, interquartile range, variance, standard deviation, and coefficient of variation.

c) Construct a boxplot. Are the data skewed? If so, how?

d) Based on the results of (A) through (C), what conclusions can you reach concerning the total compensations (in $millions) of CEOs?

e) Compute the correlation coefficient between compensation and the amount of the bonus.

f) Compute the correlations coefficient between compensation and the change in stock price in 2008.

g) What conclusions can you reach from the results of (E) and (F)?

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

Step by Step Answer:

Related Book For  book-img-for-question

Statistics For Managers Using Microsoft Excel

ISBN: 772

7th Edition

Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat

Question Posted: