The file includes the total compensation (in $millions) of CEOs of 194 large public companies and the

Question:

The file includes the total compensation (in $millions) of CEOs of 194 large public companies and the investment return in 2011.
Source: Data extracted from nytimes.com/2012/06/17/business/ executive-pay-still-cIimbing-despite-a-shareholder-din.html.
a. Compute the mean, median, first quartile, and third quartile.
b. Compute the range, interquartile range, variance, standard deviation, and coefficient of variation.
c. Construct a box plot. Are the data skewed? If so, how?
d. Based on the results of (a) through (c), what conclusions can you reach concerning the total compensation (in $millions) of CEOs?
e. Compute the correlation coefficient between compensation and the investment return in 2011.
f. What conclusions can you reach from the results of (e)?
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: 9780133130805

7th Edition

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

Question Posted: