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)?
Step by Step Answer:
Statistics For Managers Using Microsoft Excel
ISBN: 772
7th Edition
Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat