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)
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 Solution
3.40 Rating (172 Votes )
There are 3 Steps involved in it
Required Information Company Bonus Compensation Stock Price Mean 10094432 3M 2844074 12182410 30 Median 7490341 Abache 500000 37226369 30 Q1 4874174 Abbott Laboratories 4200000 25104085 2 Q3 11970932 ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
1368-B-M-A-V-C(1640).xlsx
300 KBs Excel File
